operatormodel.java

来自「一个企业小型固定资产系统的源代码。发布出来让刚学习java的人研究。」· Java 代码 · 共 92 行

package project;
import java.sql.*;

public class OperatorModel {
  public  boolean verify;
   DbConn dbc ;
  Connection conn;

  String UserID="";
  String UserPassword="";
   String operator = "";
     String username ="";
      int condition;
int useid;


 public OperatorModel(){

  }
 public OperatorModel(String selID, String selP){

     UserID=selID;
   UserPassword=selP;

 }






  public void loginverify(){
    try {
        dbc = new DbConn();
      conn = dbc.getConnection();
    Statement stmt = conn.createStatement();
    String sql="SELECT * FROM UserInfo WHERE U_ID= '"+ UserID;
    sql=sql+"' AND U_Password = '"+UserPassword+"'";
    ResultSet rset = stmt.executeQuery (sql);
    while (rset.next()) {
        useid=rset.getInt(1);
     operator = rset.getString(2);
     username =rset.getString(3);
     condition= rset.getInt(6);
         }
if(  operator.equals(UserID)){
    verify=true;
}else{verify=false;}

         } catch (SQLException s) {
    System.out.println("exception: " + s.getMessage());}
    }



  public void update(){

      try {
          dbc = new DbConn();
      conn = dbc.getConnection();
        String sql="UPDATE UserInfo SET U_Password= (?) WHERE U_ID= (?) ";
       PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, UserPassword);
        pstmt.setString(2, UserID);
        pstmt.executeUpdate();
        pstmt.close();
        conn.close();

      } catch (SQLException s) {

      System.out.println("exception: " + s.getMessage());}
      }

      public  boolean verify(){

       return verify;
   }
   public String getuserID() {
            return operator;
       }
       public String getusername() {
               return username;
       }
       public int getcondition() {
              return condition;
      }
      public int getuseno() {
        return useid;
      }
}