bookbean.java

JSP+SQL 图书馆管理系统

package beans;

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

public class BookBean {
	private Connection con=null;
	public BookBean() {
		con = DBConnection.getConnection();
	}
	
	public void addBook(Book book) throws Exception{
		PreparedStatement pst = con.prepareStatement("insert into Book values(?,?,?,?,?,?,?,?,?,?,?,?)");
		
		pst.setString(1, book.getBookID());
		pst.setString(2, book.getBookName());
		pst.setString(3, book.getBookWriter());
		pst.setString(4, book.getBookPublish());
		pst.setString(5, book.getBookPrice());
		pst.setDate(6, book.getBookDate());
		pst.setString(7, book.getBookClass());
		pst.setString(8, book.getBookMain());
		pst.setString(9, book.getBookPrim());
		pst.setString(10, book.getBookNum());
		pst.setString(11, book.getBookState());
		pst.setString(12, book.getRoomNo());
		pst.execute();
	}
	public void delBook(String bookID){
		try{
			Statement st = con.createStatement();
			st.execute("delete from Book where BookNo='"+bookID+"'");
		}catch(Exception e){
			System.out.print("删除数据错误！");
			e.printStackTrace();
		}
	}
	public void modifyBook(Book book){
		try{
			PreparedStatement pst = con.prepareStatement("update Book set BookName=?,BookWriter=?,BookPublish=?,BookPrice=?," +
					"BookDate=?,BookClass=?,BookMain=?,BookPrim=?,BookCopy=?,BookState=?,BookRNo=? where BookNo=?");
			pst.setString(12, book.getBookID());
			pst.setString(1, book.getBookName());
			pst.setString(2, book.getBookWriter());
			pst.setString(3, book.getBookPublish());
			pst.setString(4, book.getBookPrice());
			pst.setDate(5, book.getBookDate());
			pst.setString(6, book.getBookClass());
			pst.setString(7, book.getBookMain());
			pst.setString(8, book.getBookPrim());
			pst.setString(9, book.getBookNum());
			pst.setString(10, book.getBookState());
			pst.setString(11, book.getRoomNo());
			pst.execute();
		}catch(Exception e){
			System.out.print("修改数据错误！");
			e.printStackTrace();
		}
	}
}