我在做一个用户修改自己密码窗口的时候出现了点问题,症状:输入正确的用户名、密码、新密码后,没有任何反应,数据源我已经配置好了,且在另一个用户登录窗口中,此用户名、密码可以正常登录。
下面是“确定按钮”中的代码:
void jButton2_actionPerformed(ActionEvent e) {
try
{
Check();
}
catch(SQLException ee){}
} public void Check()throws SQLException
{
String username,password;
Connection con;Statement sql; ResultSet rs;try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ JOptionPane.showMessageDialog(this,"连接数据库失败!","警告!",
JOptionPane.WARNING_MESSAGE);
}
con=DriverManager.getConnection("jdbc:odbc:note","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM 用户表");
boolean boo=false;
if(jPasswordField2.getText().trim().equals(jPasswordField3.getText().trim()))
{
while((boo=rs.next()==true))
{
username=rs.getString("用户名");
password=rs.getString("密码");
if(username.equals(jTextField1.getText().trim())&&password.equals(jPasswordField1.getText().trim()))
{
String s1="'"+jTextField1.getText().trim()+"'";
String s2="'"+jPasswordField3.getText().trim()+"'";
String temp="UPDATE 用户表 SET 密码 ="+s2+" WHERE 用户名 ="+s1;
sql.executeUpdate(temp);
JOptionPane.showMessageDialog(this,"修改密码成功!","修改成功!",
JOptionPane.WARNING_MESSAGE);
dispose();
con.close();
break;
}
}
if(boo==false)
{
JOptionPane.showMessageDialog(this,"用户名或密码错误","修改失败!",
JOptionPane.WARNING_MESSAGE);
con.close();
}
}
else
{
JOptionPane.showMessageDialog(this,"修改失败,两次密码输入不同,请重新输入!","失败!",
JOptionPane.WARNING_MESSAGE);
con.close();
}
}
下面是“确定按钮”中的代码:
void jButton2_actionPerformed(ActionEvent e) {
try
{
Check();
}
catch(SQLException ee){}
} public void Check()throws SQLException
{
String username,password;
Connection con;Statement sql; ResultSet rs;try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ JOptionPane.showMessageDialog(this,"连接数据库失败!","警告!",
JOptionPane.WARNING_MESSAGE);
}
con=DriverManager.getConnection("jdbc:odbc:note","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM 用户表");
boolean boo=false;
if(jPasswordField2.getText().trim().equals(jPasswordField3.getText().trim()))
{
while((boo=rs.next()==true))
{
username=rs.getString("用户名");
password=rs.getString("密码");
if(username.equals(jTextField1.getText().trim())&&password.equals(jPasswordField1.getText().trim()))
{
String s1="'"+jTextField1.getText().trim()+"'";
String s2="'"+jPasswordField3.getText().trim()+"'";
String temp="UPDATE 用户表 SET 密码 ="+s2+" WHERE 用户名 ="+s1;
sql.executeUpdate(temp);
JOptionPane.showMessageDialog(this,"修改密码成功!","修改成功!",
JOptionPane.WARNING_MESSAGE);
dispose();
con.close();
break;
}
}
if(boo==false)
{
JOptionPane.showMessageDialog(this,"用户名或密码错误","修改失败!",
JOptionPane.WARNING_MESSAGE);
con.close();
}
}
else
{
JOptionPane.showMessageDialog(this,"修改失败,两次密码输入不同,请重新输入!","失败!",
JOptionPane.WARNING_MESSAGE);
con.close();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货