user.java

文件管理系统

package fm;

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

public class User implements java.io.Serializable{
	private int id;

	private String username = null;

	private String password = null;

	private float diskquota;

	private int ifpublic = 0;

	private int canupload = 0;

	private int candownload = 0;

	private int candelete = 0;

	private String grade = null;

	public User() {
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public int getCandelete() {
		return candelete;
	}

	public void setCandelete(int candelete) {
		this.candelete = candelete;
	}

	public int getCandownload() {
		return candownload;
	}

	public void setCandownload(int candownload) {
		this.candownload = candownload;
	}

	public int getCanupload() {
		return canupload;
	}

	public void setCanupload(int canupload) {
		this.canupload = canupload;
	}

	public float getDiskquota() {
		return diskquota;
	}

	public void setDiskquota(float diskquota) {
		this.diskquota = diskquota;
	}

	public String getGrade() {
		return grade;
	}

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

	public int getIfpublic() {
		return ifpublic;
	}

	public void setIfpublic(int ifpublic) {
		this.ifpublic = ifpublic;
	}

	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 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 static User search(DB db, String username, String password)
			throws Exception {
		User user = new User();
		ResultSet rs;
		String strSql = null;

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

		if (rs.next()) {
			user.setId(Integer.parseInt(rs.getString("id")));
			user.setUsername(rs.getString("username"));
			user.setPassword(rs.getString("password"));
			user.setDiskquota(Float.parseFloat(rs.getString("diskquota")));
			user.setIfpublic(Integer.parseInt(rs.getString("ifpublic")));
			user.setCanupload(Integer.parseInt(rs.getString("canupload")));
			user.setCandownload(Integer.parseInt(rs.getString("candownload")));
			user.setCandelete(Integer.parseInt(rs.getString("candelete")));
			user.setGrade(rs.getString("grade"));
		}
		return user;
	}

	public static User search(DB db, String id) throws Exception {
		User user = new User();
		ResultSet rs;
		String strSql = null;

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

		if (rs.next()) {
			user.setId(Integer.parseInt(id));
			user.setUsername(rs.getString("username"));
			user.setPassword(rs.getString("password"));
			user.setDiskquota(Float.parseFloat(rs.getString("diskquota")));
			user.setIfpublic(Integer.parseInt(rs.getString("ifpublic")));
			user.setCanupload(Integer.parseInt(rs.getString("canupload")));
			user.setCandownload(Integer.parseInt(rs.getString("candownload")));
			user.setCandelete(Integer.parseInt(rs.getString("candelete")));
			user.setGrade(rs.getString("grade"));
		}
		return user;
	}

	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.setId(Integer.parseInt(rs.getString("id")));
			user.setUsername(rs.getString("username"));
			user.setPassword(rs.getString("password"));
			user.setDiskquota(Float.parseFloat(rs.getString("diskquota")));
			user.setIfpublic(Integer.parseInt(rs.getString("ifpublic")));
			user.setCanupload(Integer.parseInt(rs.getString("canupload")));
			user.setCandownload(Integer.parseInt(rs.getString("candownload")));
			user.setCandelete(Integer.parseInt(rs.getString("candelete")));
			user.setGrade(rs.getString("grade"));

			userVector.add(user);
		}

		return userVector;
	}

	public boolean insert(DB db) throws Exception {
		String strSql = null;

		strSql = "insert into user(username, password, diskquota, ifpublic, canupload, candownload, candelete, grade)values ('"
				+ username
				+ "','"
				+ password
				+ "',"
				+ diskquota
				+ ","
				+ ifpublic
				+ ","
				+ canupload
				+ ","
				+ candownload
				+ ","
				+ candelete + ",'" + grade + "')";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}

	public boolean delete(DB db, String id) throws Exception {
		String strSql;
		strSql = "delete from user where id=" + id;
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}

	public boolean modify(DB db) throws Exception {
		String strSql;
		strSql = "update user set username='" + username + "', password='"
				+ password + "', diskquota=" + diskquota + ", ifpublic="
				+ ifpublic + ", canupload=" + canupload + ", candownload="
				+ candownload + ", candelete=" + candelete + ", grade='"
				+ grade + "' where id=" + id;
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}
}