jdbcconn.java~1~

成绩管理系统可以对学生、课程、选课、成绩的录入、班级、用户的信息进行管理等

 public void Btn_Login_actionPerformed(ActionEvent e) {

      String password_text=PassWord_Text.getText();
      String username_text=UserName_Text.getText();
       if(username_text.equals("")|| password_text.equals(""))
       {
            JOptionPane.showMessageDialog(null,"用户名或密码不能为空！");
        }else{

          try{
          //建立数据库连接对象
          Jdbcconn conn = new Jdbcconn();
          //连接数据库
          conn.OpenConn("student","sa","yaya");         
          String strSQL="select * from student where Uno='"+username_text+"'";
          //得到记录；
          try {
              ResultSet rs = conn.getResults(strSQL);
              rs.first();
              String PassWord = rs.getString("Upwd"); //得到数据库中对应用户名的密码
              if (PassWord.equals(password_text)) {
                  JOptionPane.showMessageDialog(null, "成功登陆！");
              } else {
      
                  JOptionPane.showMessageDialog(null, "密码错误，请重输！");
                  PassWord_Text.setText("");
              }
      
          } catch (Exception ex) {
              JOptionPane.showMessageDialog(null, "用户名或密码错误！");
              UserName_Text.setText("");
              PassWord_Text.setText("");
              System.out.print(ex.getMessage());
              
      
          }
            
          
          }catch(Exception ex)
          {
          System.out.print(ex.getMessage());
          }



           System.out.println("username_text:"+username_text);
           System.out.println("password_text:"+password_text);

        }
    }
}