import java.awt.*;
import java.applet.*;
import java.sql.*;
public class Applet1 extends Applet
{
public void paint(Graphics g)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
g.drawString("Fehler bei ODBC-JDBC-Bridge!",10,10);
}
Connection dbConn;
Statement sqlstmt;
ResultSet rSet;
try
{
String URL="jdbc :odbc://webserver/workgroup";
dbConn = DriverManager.getConnection(URL,"sa","");
//dbConn.setReadOnly(true);
sqlstmt = dbConn.createStatement();
String strSQL = "Select * from users";
rSet = sqlstmt.executeQuery(strSQL);
}
catch (Exception e)
{
g.drawString("Fehler bei DB Zugriff!",10,30);
return;
}
try
{
while (rSet.next())
{
//g.drawString(rSet.getString(1) + "\n" + getString(2) + "\n", 10,50);
}
sqlstmt.close();
dbConn.close();
}
catch (Exception e)
{
g.drawString("Fehler bei Tabellenabfrage!",10,70);
return;
}
}
} :mad:
[ 30. Mai 2001: Beitrag editiert von: JJKK ]