registbean.java

职员问答管理系统(java).rar

package mypackage;

import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;

public class RegistBean extends InfoBean
{
	private String PurviewID="";
	
	
	//**************设置属性的get/set方法**************//
	
	public String getUserID()
	{
		return UserID;
	}
	public void setUserID(String newUser)
	{
		UserID=toChinese(newUser);
	}
	
	
	public String getPassword()
	{
		return Password;
	}
	public void setPassword(String newPassword)
	{
		Password=newPassword;
	}
	
	
	public String getUsername()
	{
		return Username;
	}
	public void setUsername(String newName)
	{
		Username=newName;
	}
	
	
	public String getCompany()
	{
		return Company;
	}
	public void setCompany(String newCompany)
	{
		Company=newCompany;
	}
	
	
	public String getAddress()
	{
		return Address;
	}
	public void setAddress(String newAddress)
	{
		Address=newAddress;
	}
	
	
	public String getTel()
	{
		return Tel;
	}
	public void setTel(String newTel)
	{
		Tel=newTel;
	}
	
	
	//取出登录用户的权限
	public String getPurviewID()
	{
		return PurviewID;
	}
	
	
	//检查用户名是否存在
	public boolean CheckUser()
	{
		boolean bCheck=false;
		try
		{
			String sql="select * from UserInfo where UserID='"+UserID+"'";
			
			if(executeQuery(sql).next())
			{
				bCheck=false;
			}
			else
			{
				bCheck=true;
			}
		}
		catch(Exception e)
		{
			System.err.println("CheckUser:"+e.getMessage());
		}
		finally
		{
			return bCheck;
			
		}
	}
			
				

    //添加新的注册用户		
	public boolean AddNewUser()
	{
		boolean bAdd=false;
		try
		{
			String sql="insert into UserInfo(UserID,Password,Username,Company,Address,Tel) values('"+UserID+"','"+Password+"','"+Username+"','"+Company+"','"+Address+"','"+Tel+"')";
			
			if(executeUpdate(sql))
			{
				bAdd=true;
			}
		}
		catch(Exception e)
		{
			System.err.println("AddNewUser:"+e.getMessage());
		}
		finally
		{
			return bAdd;
		}
	}
	
	
	//检查用户登录
	public boolean CheckLogin()
	{
		boolean bCheck=false;
		ResultSet rs=null;
		try
		{
			String sql="select * from UserInfo where UserID='"+UserID+"' and Password='"+Password+"'";
			rs=executeQuery(sql);
			if(rs.next())
			{
				bCheck=true;
				PurviewID=rs.getString("PurviewID");
			}
			
		}
		catch(Exception e)
		{
			System.err.println("CheckLogin:"+e.getMessage());
		}
		finally
		{
			return bCheck;
		}
	}
	
	
	
	//修改密码
	public boolean UpdatePassword()
	{
		boolean bUpdate=false;
		try
		{
			String sql="update UserInfo set Password='"+Password+"' where UserID='"+UserID+"'";
			if(executeUpdate(sql))
			{
				bUpdate=true;
			}
		}
		catch(Exception e)
		{
			System.err.println("UpdatePassword:"+e.getMessage());
		}
		finally
		{
			return bUpdate;
		}
	}
	
	public void release()
	{
		closeConnection();
	}
	
}