userbean.java

图书

package thizlinux.linuxhr;
import java.sql.*;
public class userbean
{
	private String userid="";
	private String username="";
	private String password="";
	private String usertype="";
	private String oldpass="";
	private String newpass1="";
	private String newpass2="";
	private String error="";
	private ResultSet rs=null;
	public boolean loginstatus=false;
	private String sql;
	
	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 setUserid(String userid){
		this.userid=userid;
	}
	public String getUserid(){
		return this.userid;
	}

	public void setUsername(String username){
		if(username!=null)
			this.username=username;
		else
			this.username="";
	}
	public String getUsername(){
		return this.username;
	}

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

	public void setUsertype(String usertype){
		this.usertype=usertype;
        }
	public String getUsertype(){
		return this.usertype;
	}

	public boolean login()
	{
		loginstatus=false;
		DBconnect db=new DBconnect();
		try{
			sql="select * from tbl_user where loginid='"+this.username+"' and 						password='" + this.password + "' and usertype=" + usertype + " and 						enabled=1";
			rs=db.executeQuery(sql);
			if(rs.next()){
				loginstatus=true;
				setUserid(rs.getString("uid"));
			}
		}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();
		try{
			sql="update tbl_user set password='"+this.newpass1+"' where uid='"+this.userid+"'";
			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(){
		setUsername("");
		setPassword("");
		setUsertype("");		
		setUserid("");
		setOldpass("");
		setNewpass1("");
		setNewpass2("");
		loginstatus=false;
	}
}