applet连接SQL数据库出现异常?
在applet程序中,我用jdbc-odbc桥连接数据库,部分程序如下:
class Listener implements ActionListener {
ResultSet result;
public void actionPerformed(ActionEvent e) {
Object obj=e.getSource();
if(obj==buttonAccept) { //if1
String id=textID.getText();
if(id.length()==0) { //if2
JOptionPane.showMessageDialog(null,"the user name cannot be empty!");
return;
}//end of if2
else { //else2
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con;
con=DriverManager.getConnection("jdbc:odbc:HRsystem","sa","1");
PreparedStatement stat=con.prepareStatement("select * from ClientData where cID=? and cPassword=?");
stat.setString(1,textID.getText());
stat.setString(2,passwd.getText());
result=stat.executeQuery();
while(result.next()) {
System.out.println(result.getString(2));
}//end of while
}//end of try
catch(Exception exception) {
System.out.println("Could not execute the query: "+exception);
}//end of catch
