user.java

mysql+stuts jdbc连接数据库 BBS论坛

package j2eebbs;

import java.sql.ResultSet;
import java.util.Vector;

public class User {
	private String username = null;

	private String password = null;

	private String sex = null;

	private String email = null;

	private String icq = null;

	private String signature = null;

	private String grade = null;

	public User() {
	}

	public String getEmail() {
		return email;
	}

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

	public String getGrade() {
		return grade;
	}

	public void setGrade(String grade) {
		this.grade = grade;
	}

	public String getIcq() {
		return icq;
	}

	public void setIcq(String icq) {
		this.icq = icq;
	}

	public String getPassword() {
		return password;
	}

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

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public String getSignature() {
		return signature;
	}

	public void setSignature(String signature) {
		this.signature = signature;
	}

	public String getUsername() {
		return username;
	}

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

	public static boolean 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()) {
			return true;
		} else {
			return false;
		}

	}

	public boolean insert(DB db) throws Exception {
		String strSql;
		strSql = "insert into user values('" + username + "','" + password
				+ "','" + sex + "','" + email + "','" + icq + "','" + signature
				+ "','user')";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}

	public static String getUserGrade(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("grade");
		} else {
			return null;
		}

	}

	public static Vector search(DB db, String username) throws Exception {
		Vector Users = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from user where username like '%" + username + "%'";
		rs = db.OpenSql(strSql);

		while (rs.next()) {
			User user = new User();

			user.setUsername(rs.getString("username"));
			user.setGrade(rs.getString("grade"));

			Users.add(user);
		}
		return Users;
	}

	public static Vector searchUsers(DB db) throws Exception {
		Vector userVector = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from user";
		rs = db.OpenSql(strSql);

		while (rs.next()) {
			User user = new User();

			user.setUsername(rs.getString("username"));
			user.setGrade(rs.getString("grade"));

			userVector.add(user);
		}

		return userVector;
	}

	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 static boolean edit(DB db, String username, String grade, String forumid)
			throws Exception {
		String strSql;
		strSql = "update user set grade='" + grade + "' where username='"
				+ username + "'";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			if (!grade.equals("????")) {
				strSql = "update forum set manager='" + username + "' where id=" + forumid;
				db.ExecSql(strSql);
			}
			return true;
		}
	}
}