package?bookstore.bean;

import?java.util.*;
import?java.sql.*;
import?bookstore.common.*;

public?class?UserBean?{
????private?String?userid;
????private?String?username;
????private?String?userpass;
????private?String?type;
????private?java.util.Date?birthday;
????private?String?sex;
????private?String?qq;
????private?String?phone;
????private?String?comment;
????private?String?email;
????private?String?local;
????private?String?address;
????private?String?managerid;
????private?String?managerpass;
????private?String?managertype;
????
???public?String?getUserid（）?{
		return?userid;
	}
???
	public?void?setUserid（String?userid）?{
		this.userid?=?userid;
	}

	public?String?getUsername（）?{
		return?username;
	}

	public?void?setUsername（String?username）?{
		this.username?=?username;
	}

	public?String?getUserpass（）?{
		return?userpass;
	}

	public?void?setUserpass（String?userpass）?{
		this.userpass?=?userpass;
	}
	
	public?String?getType（）?{
		return?type;
	}

	public?void?setType（String?type）?{
		this.type?=?type;
	}

	public?java.util.Date?getBirthday（）?{
		return?birthday;
	}

	public?void?setBirthday（java.util.Date?birthday）?{
		this.birthday?=?birthday;
	}

	public?String?getSex（）?{
		return?sex;
	}

	public?void?setSex（String?sex）?{
		this.sex?=?sex;
	}

	public?String?getQq（）?{
		return?qq;
	}

	public?void?setQq（String?qq）?{
		this.qq?=?qq;
	}

	public?String?getPhone（）?{
		return?phone;
	}

	public?void?setPhone（String?phone）?{
		this.phone?=?phone;
	}

	public?String?getComment（）?{
		return?comment;
	}

	public?void?setComment（String?comment）?{
		this.comment?=?comment;
	}

	public?String?getEmail（）?{
		return?email;
	}

	public?void?setEmail（String?email）?{
		this.email?=?email;
	}

	public?String?getLocal（）?{
		return?local;
	}

	public?void?setLocal（String?local）?{
		this.local?=?local;
	}

	public?String?getAddress（）?{
		return?address;
	}

	public?void?setAddress（String?address）?{
		this.address?=?address;
	}
	public?String?getmanagerid（）?{
		return?managerid;
	}

	public?void?setmanagerid（String?managerid）?{
		this.managerid?=?managerid;
	}

	public?String?getmanagerpass（）?{
		return?managerpass;
	}

	public?void?setmanagerpass（String?managerpass）?{
		this.managerpass?=?managerpass;
	}
	
	public?String?getmanagertype（）?{
		return?managertype;
	}

	public?void?setmanagertype（String?managertype）?{
		this.managertype?=?managertype;
	}

//?添加用戶
???public?void?add（）?throws?Exception
???{
??????//?連接對象
??????Connection?con=null;
??????//?創建DBBean對象
??????DBBean?db?=?new?DBBean（）;
??????//?添加語句，根據參數編寫動態的添加語句?
??????StringBuffer?sql?=?new?StringBuffer（）;
??????sql.append（“insert?into?usertable?values（‘“）;
??????sql.append（userid）;??//?用戶ID
??????sql.append（“‘‘“）;
??????sql.append（username）;??//?用戶名
??????sql.append（“‘‘“）;
??????sql.append（userpass）;???//?口令
??????sql.append（“‘‘“）;
?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????362??2010-06-10?12:29??tongxun\.classpath

?????文件????????294??2010-06-11?11:01??tongxun\.mymetadata

?????文件???????1413??2010-06-10?09:54??tongxun\.project

?????文件???????8370??2010-06-11?13:24??tongxun\WebRoot\add.jsp

?????文件???????8365??2010-06-11?13:24??tongxun\WebRoot\addUser.jsp

?????文件????????834??2010-06-10?09:31??tongxun\WebRoot\index.jsp

?????文件???????1345??2010-06-11?13:25??tongxun\WebRoot\login.jsp

?????文件???????2040??2010-06-11?13:23??tongxun\WebRoot\wenjian\sl.jsp

?????文件???????1056??2010-06-11?13:23??tongxun\WebRoot\wenjian\sr.jsp

?????文件????????499??2010-06-11?11:42??tongxun\WebRoot\wenjian\stu.jsp

?????文件???????7549??2010-06-11?09:28??tongxun\WebRoot\WEB-INF\web.xml

?????文件?????153253??2007-01-28?22:01??tongxun\WebRoot\WEB-INF\lib\jdom.jar

?????文件??????14976??2007-01-28?22:01??tongxun\WebRoot\WEB-INF\lib\jspSmartUpload.jar

?????文件??????20682??2004-10-25?13:33??tongxun\WebRoot\WEB-INF\lib\jstl.jar

?????文件?????347137??2007-01-28?22:01??tongxun\WebRoot\WEB-INF\lib\mail.jar

?????文件?????178220??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\mailapi.jar

?????文件?????440483??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\mysql-connector-java-3.1.11-bin.jar

?????文件?????446464??2010-04-15?10:50??tongxun\WebRoot\WEB-INF\lib\mysql-connector-java-3.1.12-bin.jar

?????文件??????20080??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\pop3.jar

?????文件??????84091??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\resolver.jar

?????文件?????278286??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\serializer.jar

?????文件??????23252??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\smtp.jar

?????文件?????393259??2004-10-25?13:33??tongxun\WebRoot\WEB-INF\lib\standard.jar

?????文件????1223877??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\xercesImpl.jar

?????文件?????165864??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\xercesSamples.jar

?????文件?????194354??2007-01-28?22:02??tongxun\WebRoot\WEB-INF\lib\xml-apis.jar

?????文件???????3124??2010-06-11?11:01??tongxun\WebRoot\WEB-INF\classes\bookstore\servlet\AddServlet.class

?????文件???????2996??2010-06-11?11:01??tongxun\WebRoot\WEB-INF\classes\bookstore\servlet\AddUserServlet.class

?????文件???????1800??2010-06-11?11:01??tongxun\WebRoot\WEB-INF\classes\bookstore\servlet\DeleteUserServlet.class

?????文件???????2379??2010-06-11?11:01??tongxun\WebRoot\WEB-INF\classes\bookstore\servlet\FindAllUserServlet.class

............此處省略72個文件信息