readerbean.java

JSP+SQL 图书馆管理系统

package beans;

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

public class ReaderBean {
	private Connection con=null;
	public ReaderBean() {
		con = DBConnection.getConnection();
	}
	
	public void addReader(Reader reader) throws Exception{
		PreparedStatement pst = con.prepareStatement("insert into Reader(ReaNo,ReaName,Reapwd,ReaType,ReaDep,ReaGrade) values(?,?,?,?,?,?)");
		
		pst.setString(1, reader.getReaID());
		pst.setString(2, reader.getReaName());
		pst.setString(3, reader.getReaCode());
		pst.setString(4, reader.getTypeID());
		pst.setString(5, reader.getReaDep());
		pst.setString(6, reader.getReaPre());
		pst.execute();
	}
	public void delReader(String readerID){
		try{
			Statement st = con.createStatement();
			st.execute("delete from Reader where ReaNo='"+readerID+"'");
		}catch(Exception e){
			System.out.print("删除数据错误！");
			e.printStackTrace();
		}
	}
	public void modifyReader(Reader reader){
		try{
			PreparedStatement pst = con.prepareStatement("update Reader set ReaName=?,ReaType=?,Reapwd=?,ReaDep=?,ReaGrade=? where ReaNo=?");
			pst.setString(6, reader.getReaID());
			pst.setString(1, reader.getReaName());
			pst.setString(2, reader.getTypeID());
			pst.setString(3, reader.getReaCode());
			pst.setString(4, reader.getReaDep());
			pst.setString(5, reader.getReaPre());
			pst.execute();
		}catch(Exception e){
			System.out.print("修改数据错误！");
			e.printStackTrace();
		}
	}
}