
Connection con = DriverManager.getConnection(url, name, pass);
String sqlStr ="use JavaStudent;select * from Login";//执行语句
java.sql.Statement stmt =con.createStatement();
boolean s=true;
ResultSet rs =stmt.executeQuery(sqlStr);
while(rs.next()) { //结果集往下移一行,如果结果是真,返回true,如果没有下一行返回false
String in1 =rs.getString("name").trim();
in3=in1;
String in2 =rs.getString("pwb").trim(); //.trim去除空格防止因为格式出现错误
in4=in2;
in =codeText.getText().trim(); //获得验证码框中的用户输入数据
String yonghuming=jta_yonghuming.getText();
//一定要放对位置啊~!!!! 当鼠标点击的时候才获得文本框中的内容
char[] password=jpw_pass.getPassword(); //密码以char保存
String password1=String.valueOf(password); //强制转换
if(in3.equals(yonghuming.trim())&& in4.equals(password1.trim())&&(in.equals(imageCode.getNum()))){
s=false;
break; //...............
}
}
if(s==false){
JOptionPane.showMessageDialog(JOptionPane.getRootFrame(), "登陆成功!","欢迎~",JOptionPane.INFORMATION_MESSAGE);
//Userin=new UserIn();
new Dologin(StudentAttendanceSystem.this).setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null,"用户名或者是密码错误,也请注意验证码大小写.请重新输入!","错误",
JOptionPane.ERROR_MESSAGE);
}
// lab_fail.setSize(140,27);
// lab_fail.setLocation(180,130); }
stmt.close();
con.close();
