sysuserbean.java

图书

package thizlinux.linuxhr;
import java.sql.*;
public class sysuserbean
{	
	private String name="";
	private String password="";
	private String uid="";
	private String role="";
	private int institute=0;
	private String oldpass="";
	private String newpass1="";
	private String newpass2="";
	private String error="";
	private ResultSet rs=null;
	public boolean loginstatus=false;
		
	public void setUid(String value){
		this.uid=value;
	}
	public String getUid(){
		return this.uid;
	}

	public void setError(String value){
		this.error=value;
	}
	public String getError(){
		return this.error;
	}
	public void setOldpass(String value){
		this.oldpass=value;
	}
	public String getOldpass(){
		return this.oldpass;
	}
	public void setNewpass1(String value){
		this.newpass1=value;
	}
	public String getNewpass1(){
		return this.newpass1;
	}
	public void setNewpass2(String value){
		this.newpass2=value;
	}
	public String getNewpass2(){
		return this.newpass2;
	}
	public void setName(String name){
		if(name!=null)
			this.name=name;
		else
			this.name="";
	}
	public String getName(){
		return this.name;
	}

	public void setPassword(String password){
		if(password!=null)
			this.password=password;
		else
			this.password=""; 		
    }
	public String getPassword(){
		return this.password;
    }

	public void setRole(String role){
		this.role=role;
        }
	public String getRole(){
		return this.role;
	}
	public void setInstitute(int value){
		this.institute=value;
        }
	public int getInstitute(){
		return this.institute;
	}
	 public boolean login()
        {
             loginstatus=false;
             DBconnect db=new DBconnect();
		String sql="";
		try{
			sql="select uid,role,instituteid from tbl_sysuser where loginid='"+this.name+"' and  password='" + this.password + "'";
                   rs=db.executeQuery(sql);
			if(rs.next()){
				if(rs.getString("role")!=null){
					loginstatus=true;
		   			setUid(rs.getString("uid"));
		   			setRole(rs.getString("role"));
		   			setInstitute(rs.getInt("instituteid"));
				}
                        }
                }catch(Exception e){
			System.out.println(e+",sql="+sql);
                }finally{
                        try{
                                if(rs!=null)rs.close();
                                if(db!=null)db.close();
                        }catch(Exception e){
				System.out.println(e);
			}
                }
                return loginstatus;
        }


	public boolean isLogin(){
		return loginstatus;
	}
	public boolean change(){
		if(!oldpass.equalsIgnoreCase(password)){
			oldpass="";
			return false;
		}
             if(!newpass1.equalsIgnoreCase(newpass2)){
			newpass1="";
			newpass2="";
			return false;
		}
			
		DBconnect db=new DBconnect();
		String sql="";
		try{
			sql="update tbl_sysuser set password='"+this.newpass1+"' where uid='"+this.uid+"'";
			db.executeUpdate(sql);
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
			return false;
		}finally{
			try{
				if(db!=null)db.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}
		oldpass="";
		newpass1="";
		newpass2="";
		return true;
	}
	public void logout(){
		setName("");
		setPassword("");
		setRole("");		
		setUid("");
		setInstitute(0);
		setOldpass("");
		setNewpass1("");
		setNewpass2("");
		loginstatus=false;
	}
}