bookmodel.java

来自「图书馆管理的源代码文件」· Java 代码 · 共 107 行

package com.nitpro.webmvc.model;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.nitpro.jdbc.ConnnectManager;
import com.nitpro.webmvc.bean.Book;
import com.nitpro.webmvc.dao.BookDao;

public class BookModel {
    public void addNewBook(Book b){
    	Connection conn = null;
    	try {
			conn = ConnnectManager.getConn();
			conn.setAutoCommit(false);
			BookDao bookDao = new BookDao();
			bookDao.setConn(conn);
			bookDao.insert(b);
			conn.commit();
			conn.close();
		} catch (Exception e) {
			try {
				if(conn != null){
					conn.rollback();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
    }

    public List<Book> getAllBook(){
    	Connection conn = null;
    	List<Book> list = new ArrayList();
    	try {
			conn = ConnnectManager.getConn();
			BookDao bookDao = new BookDao();
			list = bookDao.selectAll(); 
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
    }
    
    public void deleteBook(int bookId){
    	Connection conn = null;
    	try {
			conn = ConnnectManager.getConn();
			conn.setAutoCommit(false);
			BookDao bookDao = new BookDao();
			bookDao.setConn(conn);
			bookDao.deleteById(bookId);
			conn.commit();
			conn.close();
		} catch (Exception e) {
			try {
				if(conn != null){
					conn.rollback();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
    }

    public Book getBookById(int bookId){
    	Connection conn = null;
    	Book book = null;
    	try {
			conn = ConnnectManager.getConn();
			BookDao bookDao = new BookDao();
			book = bookDao.selectById(bookId); 
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return book;
    }

    public void updateBook(Book b){
    	Connection conn = null;
    	try {
			conn = ConnnectManager.getConn();
			conn.setAutoCommit(false);
			BookDao bookDao = new BookDao();
			bookDao.setConn(conn);
			bookDao.update(b);
			conn.commit();
			conn.close();
		} catch (Exception e) {
			try {
				if(conn != null){
					conn.rollback();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
    }
}