reworkpassworddate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;

public class ReworkPasswordDate {
    public ReworkPasswordDate() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //判断密码，帐号是否相同
    public boolean istrue(String cardId,String pass){
    boolean avaiable=false;
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from Manager");
    //System.out.println("好的"+cardId+pass);
    while(rs.next()){
       // System.out.println("值"+rs.getString(1)+rs.getString(2));
    if(cardId.equals(rs.getString(1))&&pass.equals(rs.getString(2))){
        avaiable=true;
        break;
    }
    else
        avaiable=false;
    }
    //System.out.println("正确"+avaiable);
    }catch(SQLException ee){
    avaiable=false;
    }
    return avaiable;
    }
    //更改密码
    public void reworkpasswordOfManager(String cardId,String pass){
        SQLDate.sqldate();
       try{
       Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
       Statement st=con.createStatement();
       st.executeUpdate("update Manager set Password='"+pass+"' where Id='"+cardId+"'");
       st.close();
       con.close();
       }catch(SQLException ee){
       }
    }
    //判断用户的密码,卡号是否正确
    public boolean istrueofUser(String cardId,String pass){
    boolean avaiable=false;
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from Card");
    //System.out.println("好的"+cardId+pass);
    while(rs.next()){
       // System.out.println("值"+rs.getString(1)+rs.getString(2));
    if(cardId.equals(rs.getString(1))&&pass.equals(rs.getString(2))){
        avaiable=true;
        break;
    }
    else
        avaiable=false;
    }
    //System.out.println("正确"+avaiable);
    }catch(SQLException ee){
    avaiable=false;
    }
    return avaiable;
    }
    //更改用户密码
    public void reworkpasswordOfUser(String cardId,String pass){
        SQLDate.sqldate();
       try{
       Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
       Statement st=con.createStatement();
       st.executeUpdate("update Card set Password='"+pass+"' where Id='"+cardId+"'");
       st.close();
       con.close();
       }catch(SQLException ee){
       }
    }



    private void jbInit() throws Exception {
    }
}