图书管理系统借书还书等操作

package com.nhu.library.DAO; import com.nhu.library.DBUtils.*; import java.io.PrintStream; import java.sql.Connection; import java.sql.SQLException; import java.util.List; import java.util.Map; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.MapListHandler; // Referenced classes of package com.nhu.library.DAO: // BookDetailsDAO public class BookDetailsDAOImpl implements BookDetailsDAO { public BookDetailsDAOImpl() { } public List getAllBooks() throws Exception { return DBUtils.DBOperationQurey("select * from tb_bookdetailsinfo"); } public boolean updateBookStatus(String param[]) throws Exception { int result = -1; result = DBUtils.DBOperationUpdate("update tb_bookdetailsinfo set bookstatus=? where bookID=?", param); return result > 0; } public long getBookCanBorowDays(Object params[]) throws Exception { MysqlDbUtils mysqlDbUtils = new MysqlDbUtilsImpl(); Connection conn = null; mysqlDbUtils.init(); conn = mysqlDbUtils.getConnection(); QueryRunner queryRunner = new QueryRunner(); List bookList = (List)queryRunner.query(conn, "select * from tb_booktype where bookTypeID=?", params, new MapListHandler()); int result = -1; System.out.println(bookList.size()); result = Integer.parseInt(((Map)bookList.get(0)).get("canBrowDays").toString()); mysqlDbUtils.closeConnection(conn); return (long)result; } public List getBook(String params[]) throws Exception { return DBUtils.DBOperationQurey("select * from tb_bookdetailsinfo,tb_booktype where isbn=? and tb_bookdetailsinfo" + ".bookTypeID=tb_booktype.bookTypeID" , params); } public List getHostBooks() throws ClassNotFoundException, SQLException { return DBUtils.DBOperationQurey("select * from tb_bookdetailsinfo,tb_booktype,tb_bookshelfinfo ,tb_bookborowedcou" + "nt where tb_bookshelfinfo.bookShelfID=tb_bookType.bookShelfID and tb_bookType.bo" + "okTypeID=tb_bookdetailsinfo.bookTypeID and tb_bookdetailsinfo.bookID=tb_bookbor" + "owedcount.bookID order by borowedCount desc limit 0,10" ); } private void init() { } public List getAllBooksBaicInfo() throws ClassNotFoundException, SQLException { return DBUtils.DBOperationQurey("select * from tb_bookdetailsinfo"); } public boolean deleteBookFromLibrary(String param) { MysqlDbUtils mysqlDbUtils; Connection conn; int result; int result2; mysqlDbUtils = new MysqlDbUtilsImpl(); conn = null; result = -1; result2 = -1; mysqlDbUtils.init(); try { conn = mysqlDbUtils.getConnection(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } try{ conn.setAutoCommit(false); QueryRunner queryRunner = new QueryRunner(); result2 = queryRunner.update(conn, "delete from tb_bookborowedcount where bookID=?", param); result = queryRunner.update(conn, "delete from tb_bookdetailsinfo where bookID=?", param); conn.commit(); conn.setAutoCommit(true); //break MISSING_BLOCK_LABEL_178; //SQLException e; //e; conn.rollback(); conn.setAutoCommit(true); mysqlDbUtils.closeConnection(conn); } catch(SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } //return false; //SQLException e1; //e1; //e1.printStackTrace(); // e.printStackTrace(); try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } //break MISSING_BLOCK_LABEL_195; //Exception exception; //exception; try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } //throw exception; try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } return (result > 0) & (result2 > 0); } public boolean getbookstatus(String param) throws Exception { List list = DBUtils.DBOperationQurey("select bookstatus from tb_bookdetailsinfo where bookID=?", param); return (new Boolean(((Map)list.get(0)).get("bookstatus").toString())).booleanValue(); } public List getAllBooksType() throws Exception { return DBUtils.DBOperationQurey("select * from tb_booktype"); } public boolean addbook(String param[]) { MysqlDbUtils mysqlDbUtils; Connection conn; int result1; int result2; mysqlDbUtils = new MysqlDbUtilsImpl(); conn = null; mysqlDbUtils.init(); result1 = -1; result2 = -1; try { conn = mysqlDbUtils.getConnection(); QueryRunner queryRunner = new QueryRunner(); long maxid = getMaxBookID(); System.out.println(maxid); result1 = queryRunner.update(conn, "insert into tb_bookdetailsinfo (bookTypeID,isbn,bookName,authorName,publisherNam" + "e,publisherTime,bookPrice,remark)values(?,?,?,?,?,?,?,?)" , param); maxid = getMaxBookID(); System.out.println("dd"); String bookID = (new Long(maxid)).toString(); System.out.println(bookID); result2 = queryRunner.update(conn, "insert into tb_bookborowedcount (bookID,borowedCount)values(?,0)", bookID); System.out.println("s"); //break MISSING_BLOCK_LABEL_171; return false; } catch(SQLException e) { e.printStackTrace(); } try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } //break MISSING_BLOCK_LABEL_188; //Exception exception; //exception; try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } //throw exception; try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackTrace(); } return result1 > 0 && result2 > 0; } public long getMaxBookID() { MysqlDbUtils mysqlDbUtils; Connection conn; long maxid; mysqlDbUtils = new MysqlDbUtilsImpl(); conn = null; mysqlDbUtils.init(); maxid = -1L; try { conn = mysqlDbUtils.getConnection(); QueryRunner queryRunner = new QueryRunner(); List typeList = (List)queryRunner.query(conn, "select max(bookID)as bookID from tb_bookdetailsinfo", new MapListHandler()); maxid = (new Long(((Map)typeList.get(0)).get("bookID").toString())).longValue(); //break MISSING_BLOCK_LABEL_140; return -1l; } catch(SQLException e) { e.printStackTrace(); } try { mysqlDbUtils.closeConnection(conn); } catch(SQLException e) { e.printStackT