adminbean.java

j2ee框架下的mvc模式的一个网上销售系统

package com.qrsx.buyflowers.beans;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;

public class AdminBean extends DBConnection {

	private AdminClass adminClass;// 本类的实体对象

	private Collection collection = null;

	private PreparedStatement ptst = null;

	private ResultSet rs = null;

	public AdminBean() throws ClassNotFoundException, SQLException {
		super();
		// TODO Auto-generated constructor stub
	}

	/*
	 * public AdminClass getAdminClass() { return adminClass; } public void
	 * setAdminClass(AdminClass adminClass) { this.adminClass = adminClass; }
	 */

	// 设置管理员的信息
	public void setAdminInfo(AdminClass adminClass) {
		this.adminClass = adminClass;
	}

	// 添加管理员
	public void addAdminInfo() {
		String sql = "insert into admin(adminName,adminPass) values(?,?);";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, this.adminClass.getAdminName());
			ptst.setString(2, this.adminClass.getAdminPass());
			ptst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 按管理员ID删除管理员
	public void deleteAdmin(String adminId) {
		String sql = "delete from admin where adminId=?";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, adminId);
			ptst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 获取所有的管理员信息
	public Collection getAllUserInfo() {
		String sql = "select * from admin;";
		try {
			ptst = con.prepareStatement(sql);
			rs = ptst.executeQuery();
			collection = new ArrayList();
			while (rs.next()) {
				adminClass = new AdminClass();
				adminClass.setAdminName(rs.getString("adminName"));
				adminClass.setAdminId(rs.getString("adminId"));
				adminClass.setAdminPass(rs.getString("adminPass"));
				collection.add(adminClass);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	// 修改管理员密码
	public void modifyAdminPass(String adminPass) {
		String sql = "update admin set adminPass=?";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, adminPass);
			ptst.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	// 检测帐号是否正确
	public boolean checkAdminInfo() {
		boolean check = false;
		String sql = "select * from admin where adminName=? and adminPass=?";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, this.adminClass.getAdminName());
			ptst.setString(2, this.adminClass.getAdminPass());
			rs = ptst.executeQuery();
			if (rs.next()) {
				check = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return check;
	}
}