我在做一个用户修改自己密码窗口的时候出现了点问题,症状:输入正确的用户名、密码、新密码后,没有任何反应,数据源我已经配置好了,且在另一个用户登录窗口中,此用户名、密码可以正常登录。
下面是“确定按钮”中的代码:
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();
  }
}