pregister.java

图书

package thizlinux.linuxhr;

import java.sql.*;
import java.text.*;

public class pregister {

	private String username="";
	private String passwd="";
	private String passwdoe="";
	private String mail="";
	private UserId uid;
	private userbean user;
	private String error="";
	private ResultSet rs=null;
	private boolean status=true;
	
	public void setError(String value){
		this.error=value;
	}
	public String getError(){
		return this.error;
	}

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

	public void setMail(String mail){
		if(mail!=null)
			this.mail=mail;
		else
			this.mail="";
	}
	public String getMail(){
		return this.mail;
	}
	public void setPasswd(String passwd){
		if(passwd!=null)
			this.passwd=passwd;
		else
			this.passwd="";
	}
	public String getPasswd(){
		return this.passwd;
	}

	public void setPasswdoe(String passwd){
		if(passwd!=null)
			this.passwdoe=passwd;
		else
			this.passwdoe="";
	}
	public String getPasswdoe(){
		return this.passwdoe;
	}

	public void setUid(UserId id){
		this.uid=id;
	}
	public UserId getUid(){
		return this.uid;
	}

	public void setUser(userbean user){
		this.user=user;
	}
	public userbean getUser(){
		return this.user;
	}

	public boolean register()
	{	
		status=true;
		DBconnect dbconn =new DBconnect();
		String sql="";
		try{
			 sql="select * from tbl_user where loginid='"+username+"' and usertype=0 ";                  
			rs=dbconn.executeQuery(sql);
			if(rs.next()){                    
				username="";
				status=false;
			}
			else{
				java.util.Date cur_time =new java.util.Date();
				SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd");
				String cdate =formatter.format(cur_time);
				String id=""+uid.getpid();
				sql ="insert into tbl_user ( uid, loginid, password, email, cdate, 							usertype, enabled) values (" + id + ",'" + username 							+ "','" + passwd + "','" + mail+ "','" + cdate + "',0,1)";

				dbconn.executeUpdate(sql);
				sql ="insert into tbl_puserinfo ( uid) values (" + id + ")";

				dbconn.executeUpdate(sql);
				user.setUsername(this.username);
				user.setPassword(this.passwd);
				user.setUsertype("0");
				user.loginstatus=true;
				user.setUserid(id);
				
				reset();
			}
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}finally{
			try{
				if(rs!=null)rs.close();
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}
		return  status;
	}
	public void reset(){
		username="";
		passwd="";
		passwdoe="";
		mail="";
		error="";
	}
}