登陆窗口的数据库连接与验证
小第初学java,用JBuilder的GUI创建一个登陆窗口时不知道应该怎样进行验证,请大哥大姐们指点一下啊!
public void jButton1_actionPerformed(ActionEvent e) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
System.out.println(ex);
}
String url="jdbc:odbc:users";
try {
Connection con = DriverManager.getConnection(url, "sa", "sa");
Statement stmt =con.createStatement();
String str1=jTextField1.getText();
ResultSet rs=stmt.executeQuery("select * from users where uid='"+str1+"'");
if(rs.next()){
String str2=jTextField2.getText();
ResultSet rt=stmt.executeQuery("select * from users where pwd='"+str2+"'");
if(rt.next()){
Frame2 f2 = new Frame2();
f2.setSize(400,500);
f2.show();
}else{
JOptionPane.showMessageDialog(this,"密码错误");
}
}else{
JOptionPane.showMessageDialog(this,"帐号不存在");
}
} catch (SQLException ex1) {
System.out.println(ex1);
}
}
}
总感觉上面的代码有问题,不能达到验证效果!
虚心请教ing.........