代码:
  public class AdminApplet extends JApplet
{
         Connection theConnection;
Statement theStatement;
ResultSet theResult;
ResultSetMetaData theMetaData;
PreparedStatement thePreStatement;           .
           .
         public void init()
{           .
            .
         openConnection();
execSQLCommand("select * from AdminApplet ");
}
           .
           .
         public void openConnection()//打开数据库
{

String AdminOperateInfoURL="jdbc:odbc:AdminApplet";
String theUserName="";
String thePassword=""; try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
theConnection=DriverManager.getConnection
                                  (AdminOperateInfoURL,theUserName,thePassword);
}
catch (Exception e)
{
jtfStatus.setText(" 打开数据库出错:"+e.getMessage());
}
}



public void execSQLCommand(String command)
{
try
{

theStatement=theConnection.createStatement();
theResult=theStatement.executeQuery(command);
theMetaData=theResult.getMetaData();
while (theResult.next())
{
jtabDataUserName=theResult.getString("userName");
jtabDataUserUserType=theResult.getString("userType");
jtabDataUserOperateRequire=theResult.getString("operateRequest");
jtabDataUserTryTime=theResult.getString("tryTime");
String[] rowData={jtabDataUserName,jtabDataUserUserType,jtabDataUserOperateRequire,jtabDataUserTryTime};
modelOperate.addRow(rowData);
}
}
catch (Exception e)
{
jtfStatus.setText("读取数据出错:"+e.getMessage());
}
}
}