user.java

J2EE平台是一种比较 优秀的开发平台 此为其上一个比较大的案例开发

package UserAdmin;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;
/**
本类存储用户信息
2002年3月30日
*/
public class User implements java.io.Serializable {
	private String UserName; //用户名
	private String Password; //密码
	private String FromIP; //来自IP地址
	private String LoginDate; //登录日期
	private int LoginTimes;
	private String Name; //姓名
	private String Sex; //性别
	private String CompanyName;
	private String CompanyKind;
	private String CompanyAddr;
	private String ZipCode;
	private String Fax;
	private String Email;
	private String Question;
	private String Answer;
	private String Idnumber;
	private String Address;
	private String Telephone;
	public User() {
	};
	public User(
		String uname,
		String pwd,
		String name,
		String sex,
		String question,
		String answer,
		String idcard,
		String add,
		String zip,
		String tel,
		String email,
		String fax,
		String companyname,
		String companykind,
		String companyaddr) {
		this.UserName = uname;
		this.Password = pwd;
		this.Name = name;
		this.Sex = sex;
		this.Fax = fax;
		this.Address = add;
		this.CompanyName = companyname;
		this.CompanyAddr = companyaddr;
		this.CompanyKind = companykind;
		this.Question = question;
		this.ZipCode = zip;
		this.Answer = answer;
		this.Idnumber = idcard;
		this.Telephone = tel;
		this.Email = email;
	}
	public String getUserName() {
		return UserName;
	}
	public String getPassword() {
		return Password;
	}
	public String getFromIP() {
		return FromIP;
	}
	public String getName() {
		return Name;
	}
	public String getSex() {
		return Sex;
	}
	public String getCompanyName() {
		return CompanyName;
	}
	public String getCompanyKind() {
		return CompanyKind;
	}
	public String getCompanyAddr() {
		return CompanyAddr;
	}
	public String getEmail() {
		return Email;
	}
	public String getQuestion() {
		return Question;
	}
	public String getAnswer() {
		return Answer;
	}
	public String getIdnumber() {
		return Idnumber;
	}
	public String getAddress() {
		return Address;
	}
	public String getTelephone() {
		return Telephone;
	}
	//
	public void setUserName(String UserName) {
		this.UserName = UserName;
	}
	public void setPassword(String Password) {
		this.Password = Password;
	}
	public void setFromIP(String FromIP) {
		this.FromIP = FromIP;
	}
	public void setName(String Name) {
		this.Name = Name;
	}
	public void setSex(String Sex) {
		this.Sex = Sex;
	}
	public void setCompanyName(String CompanyName) {
		this.CompanyName = CompanyName;
	}
	public void setCompanyKind(String CompanyKind) {
		this.CompanyKind = CompanyKind;
	}
	public void setCompanyAddr(String CompanyAddr) {
		this.CompanyAddr = CompanyAddr;
	}
	public void setEmail(String Email) {
		this.Email = Email;
	}
	public void setQuestion(String Question) {
		this.Question = Question;
	}
	public void setAnswer(String Answer) {
		this.Answer = Answer;
	}
	public void setIdnumber(String Idnumber) {
		this.Idnumber = Idnumber;
	}
	public void setAddress(String Address) {
		this.Address = Address;
	}
	public void setTelephone(String Telephone) {
		this.Telephone = Telephone;
	}
	/**
	 * Returns the fax.
	 * @return String
	 */
	public String getFax() {
		return Fax;
	}
	/**
	 * Sets the fax.
	 * @param fax The fax to set
	 */
	public void setFax(String fax) {
		Fax = fax;
	}
	/**
	 * Returns the zipCode.
	 * @return String
	 */
	public String getZipCode() {
		return ZipCode;
	}
	/**
	 * Sets the zipCode.
	 * @param zipCode The zipCode to set
	 */
	public void setZipCode(String zipCode) {
		ZipCode = zipCode;
	}
	/**
	 * Returns the loginTimes.
	 * @return String
	 */
	public int getLoginTimes() {
		return LoginTimes;
	}
	/**
	 * Sets the loginTimes.
	 * @param loginTimes The loginTimes to set
	 */
	public void setLoginTimes(int loginTimes) {
		LoginTimes = loginTimes;
	}
	/**
	 * Returns the loginDate.
	 * @return String
	 */
	public String getLoginDate() {
		return LoginDate;
	}
	/**
	 * Sets the loginDate.
	 * @param loginDate The loginDate to set
	 */
	public void setLoginDate(String loginDate) {
		LoginDate = loginDate;
	}
	public static boolean isExsit(String user, String pass) {
		String DriverName = "oracle.jdbc.driver.OracleDriver";
		String ServerName = "146.200.51.54";
		String BaseName = "userinfo";
		String port = "1521";
		String uName = "sa";
		String psd = "sa";
		String url =
			"jdbc:oracle:thin:@" + ServerName + ":" + port + ":" + BaseName;
		boolean isEmpty = false;
		String search =
			"select * from USER_REG where USER_NAME=? and USER_PWD=?";
		try {
			Class.forName(DriverName);
			Connection jbc = DriverManager.getConnection(url, uName, psd);
			PreparedStatement ps;
			ps = jbc.prepareStatement(search);
			ps.setString(1, user);
			ps.setString(2, pass);
			String update = null;
			ResultSet rs = ps.executeQuery();
			isEmpty = !rs.next();
			ps.close();
			jbc.close();
		} catch (Exception e) {
		}
		return isEmpty;
	}
}