www.pudn.com > BuyFlowers.rar > AdminBean.java

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; 
	} 
}