user.java

在线拍卖系统

package j2eebbs;

import java.sql.ResultSet;

public class User {
	private int userid;
	
	private String username = null;

	private String password = null;

	private String email = null;

	private String address = null;//地址

	private String type ;//用户类型；"putong" 为普通用户 "admin"系统管理员

	private String mobile = null;//手机

	public User() {
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}


	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}
	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public String getMobile() {
		return mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}
	//登陆
	public  User checkUser(DB db, String username, String password)
			throws Exception {
		String strSql;
		ResultSet rs;
		strSql = "select * from user where username='" + username
				+ "' and password='" + password + "'";
		rs = db.OpenSql(strSql);
		if (rs.next()) {
			username = rs.getString("username");
			userid = rs.getInt("id");
			type = rs.getString("type");
			return this;
		} else {
			return null;
		}
	}
	//注册时候检查用户名字
	public static boolean checkUserName(DB db, String username)
			throws Exception {
		String strSql;
		ResultSet rs;
		strSql = "select * from user where username='" + username
				+ "'";
		rs = db.OpenSql(strSql);
		if (rs.next()) {
			return true;
		} else {
			return false;
		}
	}
	//新建用户
	public boolean insert(DB db) throws Exception {
		String strSql;
		strSql = "insert into user (username,password,email,address,mobile,type) values('" + username + "','" + password
				+ "','" + email + "','" + address + "','" + mobile
				+ "','"+type+"')";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}
	//取得用户类型
	public static String getUserType(DB db, String username) throws Exception {
		String strSql;
		ResultSet rs;
		strSql = "select * from user where username='" + username + "'";
		rs = db.OpenSql(strSql);
		if (rs.next()) {
			return rs.getString("type");
		} else {
			return null;
		}

	}
	//删除用户
	public static boolean delete(DB db, String username) throws Exception {
		String strSql;
		strSql = "delete from user where username='" + username + "'";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}

	public int getUserid() {
		return userid;
	}

	public void setUserid(int userid) {
		this.userid = userid;
	}


	
}