person.java

JAVA邮件系统

/**
 * 
 *
 * 用户的信息和一些与用户有关的函数
 * @author Zhu Jian Min
 */
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
/**
 * 
 *	Person.java
 * @author Zhu Jian Min
 * 2000.7.20
 */

public class Person
{
	Person(){
	}
		   
	String username;
	String password,password2,firstname,question,answer,email,gender;
	String birthYear,birthMonth,birthDay,education,jobfunction,state,phone,mobile,BP,city;
	String zip,id_type,passid,address;
	int ID,awoke;
	public void setName(String nm) { username = nm; }
	public String getName() { return username; }
	public void setPassword(String pas) { password = pas; }
	public String getPassword() { return password; }
	public void setPassword2(String pas2) { password2 = pas2; }
	public String getPassword2() { return password2; }
	public void setFirstname(String fir) { firstname = fir; }
	public String getFirstName() { return firstname; }
	public void setQuestion(String que) { question=que; }
	public String getQuestion() { return question; }
	public void setAnswer(String ans) { answer=ans;}
	public String getAnswer() { return answer; }
    public void setEmail(String em) { email=em; }
	public String getEmail() { return email; }
	public void setBirthMonth(String bm) { birthMonth=bm; }
	public String getBirthMonth() { return birthMonth; }
	public void setBirthYear(String by) { birthYear=by; }
	public String getBirthYear() { return birthYear; }
	public void setBirthDay(String bd) { birthDay=bd; }
	public String getBirthDay() { return birthDay; }
	public void setGender(String gen) { gender=gen; }
	public String getGender() { return gender; }
	public void setEducation(String edu) { education=edu; }
	public String getEducation() { return education; }
	public void setJobfunction(String job) { jobfunction=job; }
	public String getJobfunction() { return jobfunction; }
	public void setState(String stat) { state=stat; }
	public String getState() { return state; }
	public void setPhone(String ph) { phone=ph; }
	public String getPhone() { return phone; }
	public void setMobile(String ph) { mobile=ph; }
	public String getMobile() { return mobile; }
	public void setBP(String bp) { BP=bp; }
	public String getBP() { return BP; }
	public void setCity(String Cit) { city=Cit; }
	public String getCity() { return city; }
	public void setZip(String Zip) { zip=Zip; }
	public String getZip() { return zip; }
	public void setID_type(String id) { id_type=id; }
	public String getID_type() { return id_type; }
	public void setPassid(String pass_id) { passid=pass_id; }
	public String getPassID() { return passid; }
	public void setAddress(String add){address=add; }
	public String getAddress() { return address; }
	public void setID(int id){ID=id; }
	public int getID() { return ID; }
	public void setAwoke(int id){awoke=id; }
	public int getAwoke() { return awoke; }
	
	public boolean checkUsername(String name)
	{
		
		String queryString;
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("person");
		try 
		{
			
			queryString = "select username from person where username='" +
				      username + "'";						
			rs = DB.executeQuery(queryString);
			if(rs!=null){
	   	    	
			if(rs.next())
	   	    { // 用户存在返回false
	   	    	DB.close();
	   	    	return false;
	   	    }
	   	    
			DB.close();
			}
			else
			{
				DB.close();
			return false;
			}
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
							 
							  
		}
		return true;
		
	}
	public boolean GetUserID(String name){
		
		String queryString;
		
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("person");
		try 
		{
			
			
	   	    rs=DB.executeQuery("Select Id From person Where UserName='"+name+"'");
			if(rs!=null){
			if (rs.next()){
	    	ID=rs.getInt("ID");
			}
			setID(ID);
	   	   DB.close();
			}else{
				DB.close();
				return false;}
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}//用户不存在返回true
		return true;
	}
	public boolean SelectMaxID(){
		
		String queryString;
		
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("person");
		try 
		{
			
			//降序选择ID
	   	    rs=DB.executeQuery("Select ID From person  order by Id Desc ");
			if(rs!=null){
			if (rs.next()){
	    	ID=rs.getInt(1);
			}
			ID++;
			setID(ID);
			DB.close();
			}else {
				DB.close(); 
				return false;
			}
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}//用户不存在返回true
		return true;
		
	}
	
	public boolean insertUserdata(String Query)
	{
		    DBOperater DB = new DBOperater ("person");
			try{
				if( DB.executeUpdate (Query)==0){
					DB.close();
				 return false;
				}
				DB.close();
				return true;
			}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
	}
	
	public boolean Delete(int Id){
		
		String queryString;
		int ID=Id;
		DBOperater DB = new DBOperater ("person");		
		queryString="Delete From person Where  id='" + Id+"'";
		
		ResultSet  rs;
		//删除用户定制信息在userchannel,userstock中
		try{
			rs=DB.executeQuery("select username from  person where ID='"+ID+"'");
			if(rs!=null){
			if(rs.next())
			{
				String username=rs.getString(1);
			
				if(username!=null)
					username=username.trim();
				DB.executeUpdate("delete from  userchannel where username='"+username+"'");
				DB.executeUpdate("delete from userstock where username='"+username+"'");
				DB.executeUpdate("delete from ps_weather where username='"+username+"'");
				DB.executeUpdate("delete from card where username='"+username+"'");
				DB.executeUpdate("delete from bookmark where username='"+username+"'");
					
			}
			}
			else{
				DB.close();
				return false;
			}
		}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
		//删除用户在person中
		try{
	    DB.executeUpdate(queryString);
		}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
        DB.close();
		
		
		
	
		return true;
	}
	
	public boolean insertUserChannel(String name)
	{
		
	
		String queryString;
	
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("channel");
		/*String channelQuery="insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+channelid+"','"
							+type+"','"+orderid+"','"
							+pagenumber+"')";
		*/
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"weather"+"','"
							+1+"','"+1+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"date"+"','"
							+1+"','"+2+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"card"+"','"
							+1+"','"+3+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"bookmard"+"','"
							+1+"','"+4+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"folder"+"','"
							+1+"','"+5+"','"
							+0+"')" );

/*		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"Email"+"','"
							+2+"','"+1+"','"
							+0+"')" );
		*/
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"newsh"+"','"
							+2+"','"+2+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"newsd"+"','"
							+2+"','"+3+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"newsk"+"','"
							+2+"','"+4+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"stock"+"','"
							+2+"','"+5+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"wh"+"','"
							+2+"','"+6+"','"
							+0+"')" );
		DB.executeUpdate ( "insert into userchannel(username,channelid,type,orderid,pagenumber) values('"
							+name+"','"+"Hb"+"','"
							+2+"','"+7+"','"
							+0+"')" );
		DB.close ();		
		return true;
	}
	
	public boolean checkPassword(String pass)
	{
		if (pass==null )
			return false;
		
		String queryString;
		Statement stmt;
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("person");
		try 
		{
			
			queryString = "select password from person where username='" +
				      username + "'";
	   	    rs = DB.executeQuery(queryString);
			if(rs!=null){
			if(!rs.next())
	   	    { // 用户不存在
	   	    	DB.close();
	   	    	return false;
	   	    }
			String sPass = rs.getString (1);
			if(sPass!=null){
			sPass=sPass.trim();
			}
			if(pass!=null)
			pass = pass.trim();
	   	    if(pass.compareTo(sPass)!=0)
	   	    {
	   	    	DB.close();
	   	    	return false;
   		    }
			DB.close();
			}
			else{
				DB.close();
				return false;
			}
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			 DB.close();
			return false;
		}
		return true;
	}
	public boolean IsSuperMan()
	{
		String queryString;
		ResultSet rs;
		
		DBOperater DB = new DBOperater ("person");
		try 
		{
			queryString = "select mark from person where username='" +
				      username + "'";						
			System.out.println (queryString);
	   	    rs = DB.executeQuery(queryString);
			if(rs!=null)
			{
				if(rs.next())
	   			{
					int mark = rs.getInt (1);
					System.out.println ("mark:"+mark);
					if(mark==1){
						DB.close();
						return true;
					}
	   			}
			}
		}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
		DB.close();
		return false;
	}

	public boolean IsManager()
	{
		String queryString;
		ResultSet rs;

		DBOperater DB = new DBOperater ("person");
		try
		{
			queryString = "select mark from person where username='" +
				      username + "'";
 	    rs = DB.executeQuery(queryString);
			if(rs!=null)
			{
				if(rs.next())
	   			{
					int mark = rs.getInt (1);
						if((mark==2)||(mark==1)){
						DB.close();
						return true;
					}
	   			}
			}
		}catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
		DB.close();
		return false;
	}
 public int getSumUser(String sCondition)
 {
    String queryString;
		ResultSet rs;
    int sum=0;
		DBOperater DB = new DBOperater ("person");
		try
		{
			queryString = "select username from person ";
      queryString += sCondition;
 	    rs = DB.executeQuery(queryString);
			if(rs!=null)
			{
				while(rs.next())
	   			{
					  sum++;
					}
			}
		}catch(Exception ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
      	DB.close();
        return sum;
 }
 public String getUserPass(String sUsername)
 {
    String queryString="";
    String password="";
		ResultSet rs;
		DBOperater DB = new DBOperater ("person");
		try
		{
			queryString = 	queryString = "select password from person where username='" +
				      sUsername + "'";;
 	    rs = DB.executeQuery(queryString);
			if(rs!=null)
			{
				while(rs.next())
	   			{
					  password=rs.getString (1);
					}
			}
		}catch(Exception ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
      	DB.close();
    if ((password==null))
        return "";
    else
        return password;
 }
}