kostenloser Webspace werbefrei: lima-city

in: Datenbankabfrage per Applet

geschrieben von dashboard

import java.awt.*; 
import java.awt.event.*; 
import java.io.*;
import java.sql.*;
import java.applet.Applet;

public class MyApplication extends Frame implements WindowListener {

static MyApplication myapp;

public static void main(String args[]) {
 String test = null;
 BufferedReader in = new BufferedReader(
 new InputStreamReader( System.in ) );

try {
 System.out.println( "Firmenname:" );
 test = "'%" + in.readLine() + "%'";
}
catch( IOException ex ) {
 System.out.println( ex );
}

try { 
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 

      myapp = new MyApplication(); 
      myapp.setLayout(new GridLayout()); 
      List list1 = new List(4); 
      List list2 = new List(4);
      List list3 = new List(4);
      List list4 = new List(4);
      List list5 = new List(4);
      List list6 = new List(4);
      myapp.add(list1); 
      myapp.add(list2); 
      myapp.add(list3);
      myapp.add(list4);
      myapp.add(list5);
      myapp.add(list6);
      myapp.setSize(400, 120); 
      myapp.addWindowListener(myapp); 
      myapp.setVisible(true); 
      myapp.setTitle("Ergebnis");
      myapp.setAlwaysOnTop(true);

String url = "jdbc:microsoft:sqlserver://xxx.xxx.xxx.xxx:xxxx"; 
Connection con = DriverManager.getConnection(url,"xxx","xxxxxxx");

Statement stmt = con.createStatement();
String sql = "SELECT Kunden.Name,Kunden.Fon,Kunden.KdEMail,Anschrif.Straße,Anschrif.PLZ,Anschrif.Ort FROM Kunden INNER JOIN Anschrif ON Kunden.I3D=Anschrif.Kunde WHERE Name LIKE " + test;
ResultSet rst = stmt.executeQuery(sql);

while (rst.next()) { 
        list1.add(rst.getString("Name")); 
        list2.add(rst.getString("Fon"));
        list3.add(rst.getString("KdEmail"));
        list4.add(rst.getString("Straße"));
        list5.add(rst.getString("PLZ"));
        list6.add(rst.getString("Ort"));
      }

      rst.close();
      stmt.close();      
      con.close(); 
    }

   catch (Exception ex) { 
      System.out.println(ex.toString()); 
      System.exit(1); 
    } 
  } 

  public void windowClosing(WindowEvent ev) { 
    myapp.setVisible(false); 
    myapp.dispose();  
  }

public void windowActivated(WindowEvent ev) { } 
  public void windowClosed(WindowEvent ev) { } 
  public void windowDeactivated(WindowEvent ev) { } 
  public void windowDeiconified(WindowEvent ev) { } 
  public void windowIconified(WindowEvent ev) { } 
  public void windowOpened(WindowEvent ev) { } 
}