adminbean.java

JSP+SQL 图书馆管理系统

package beans;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class AdminBean {
	private Connection con=null;
	public AdminBean() {
		con = DBConnection.getConnection();
	}
	
	public void addAdmin(Admin admin) throws Exception{
		PreparedStatement pst = con.prepareStatement("insert into Manager values(?,?,?,?,?)");
		
		pst.setString(1, admin.getRoomMID());
		pst.setString(2, admin.getMName());
		pst.setString(3, admin.getMTeleph());
		pst.setString(4, admin.getMCode());
		pst.setString(5, admin.getMAuth());
		pst.execute();
	}
	public void delAdmin(String adminID){
		try{
			Statement st = con.createStatement();
			st.execute("delete from Manager where MID='"+adminID+"'");
		}catch(Exception e){
			System.out.print("删除数据错误！");
			e.printStackTrace();
		}
	}
	public void modifyAdmin(Admin admin){
		try{
			PreparedStatement pst = con.prepareStatement("update Manager set MName=?,MSex=?,Mpwd=?,MAuth=? where MID=?");
			pst.setString(1, admin.getMName());
			pst.setString(2, admin.getMTeleph());
			pst.setString(3, admin.getMCode());
			pst.setString(4, admin.getMAuth());
			pst.setString(5, admin.getRoomMID());
			pst.execute();
		}catch(Exception e){
			System.out.print("修改数据错误！");
			e.printStackTrace();
		}
	}
}