基于Java web的图书管理系统设计（源码+数据库）.zip

package com.gx.dao.impl; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.gx.dao.BookDao; import com.gx.po.BookClass; import com.gx.po.BookClass2; import com.gx.po.BookName; import com.gx.po.LibraryCard; import com.gx.po.LibraryCard2; import com.gx.po.NewBook; import com.gx.servlet.BorrowBooks.PageByBorrow; import com.gx.servlet.dimSelect.DimPaging; import com.gx.servlet.myRecord.Page; import com.gx.servlet.returnBook.Paging; import com.gx.util.DButil; public class ImplBookDao implements BookDao { public static String otxt=""; public static String otxt2=""; public static String otxt3=""; public static String otxt4=""; public static String select=""; public Connection conn=null; public PreparedStatement ps=null; public Statement st=null; public ResultSet rs=null; String SelectAllBook="SELECT BookIinventory.*,BookClass.* FROM BookIinventory JOIN BookClass ON BookIinventory.ClassID =BookClass.BookClassID "; String SelectBookByID="SELECT BookIinventory.*,BookClass.* FROM BookIinventory JOIN BookClass ON BookIinventory.ClassID =BookClass.BookClassID where BookID=?"; String BorrowBook="INSERT INTO borrowbooks(userID,BookCardID,date,returnDete,cost,FreeDate,evaluate) VALUES(?,?,?,?,?,?,?)"; String updatesql="UPDATE bookiinventory SET state=1,Brcount=Brcount+1 WHERE BookID=?"; String SelectBookByName="SELECT BookIinventory.*,BookClass.* FROM BookIinventory JOIN BookClass ON BookIinventory.ClassID =BookClass.BookClassID where bookiinventory.BookMC=?"; String SelectBookByBookCard="SELECT bookiinventory.*,borrowbooks.* FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID WHERE librarycard.libraryCard=? and state=1 group by bookiinventory.BookMC"; String selectCountsql="SELECT COUNT(DISTINCT bookiinventory.BookMC) COUNT FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID WHERE users.usersID=? AND bookiinventory.state=1 "; String updateBooksql="UPDATE borrowbooks SET date=?,cost=?,FreeDate=? WHERE BorrowBooksID=?"; String updateBooksql2="UPDATE borrowbooks SET returnDete=? WHERE BorrowBooksID=?"; String updatesql2="UPDATE bookiinventory SET state=0 WHERE BookID=?"; String SelectBookByDim="SELECT bookiinventory.*,bookclass.* FROM bookiinventory JOIN bookclass ON bookiinventory.ClassID =bookclass.BookClassID WHERE 1=1 "; String selectBookCount2="SELECT COUNT(*) COUNT FROM bookiinventory"; String t="SELECT bookiinventory.*,bookclass.* FROM bookiinventory JOIN bookclass ON bookiinventory.ClassID =bookclass.BookClassID"; String updateNewBooksql="UPDATE bookiinventory SET BookMC=?,authorName=?,PressName=?,publicationDate=?,recordDate=?,ClassID=?,location=?,price=? WHERE BookID=?"; String updateStateLosesql="UPDATE bookiinventory SET state=2 WHERE BookID=?"; String updateCost="UPDATE borrowbooks SET cost=? WHERE BorrowBooksID=?"; String SelectRecord="SELECT borrowbooks.*,bookiinventory.* FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID where users.usersID=?"; String SelectCountByAll="SELECT count(*) count FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID where users.usersID=?"; String updateEvaluate="UPDATE borrowbooks SET evaluate=? WHERE BorrowBooksID=?"; String SelectMonth="SELECT bookiinventory.BookMC,bookiinventory.BookID, COUNT(borrowbooks.BookCardID) COUNT FROM borrowbooks,bookiinventory WHERE bookiinventory.BookID= borrowbooks.BookCardID AND borrowbooks.date>=? AND borrowbooks.date<=? GROUP BY borrowbooks.BookCardID ORDER BY COUNT DESC LIMIT 0,8"; String SelectAllCount="SELECT bookiinventory.*,borrowbooks.* FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID GROUP BY bookiinventory.BookMC ORDER BY BookIinventory.Brcount DESC LIMIT 0,8"; String SelectAllBookByBorrow="SELECT BookIinventory.*,BookClass.* FROM BookIinventory JOIN BookClass ON BookIinventory.ClassID =BookClass.BookClassID WHERE BookIinventory.state=0"; String SelectAllBookByUserID="SELECT bookiinventory.*,borrowbooks.* FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID WHERE users.usersID=? group by bookiinventory.BookMC"; String SelectBroowbookcount="SELECT COUNT(*) countbookiinventory FROM BookIinventory JOIN BookClass ON BookIinventory.ClassID =BookClass.BookClassID WHERE BookIinventory.state=0"; String SelectEvaluate="SELECT bookiinventory.BookMC,borrowbooks.evaluate FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID WHERE users.usersID=? GROUP BY bookiinventory.BookMC ORDER BY borrowbooks.evaluate DESC"; String SelectEvaluateByBookname="SELECT bookiinventory.BookID,bookiinventory.BookMC,borrowbooks.evaluate,users.usersID FROM (users LEFT JOIN librarycard ON users.usersID=librarycard.usersID) LEFT JOIN borrowbooks ON users.usersID=borrowbooks.userID LEFT JOIN bookiinventory ON borrowbooks.BookCardID=bookiinventory.BookID WHERE bookiinventory.BookMC=? GROUP BY users.usersID"; String selectBookClass="SELECT bookclass.BookClassMC, COUNT(*)COUNT FROM bookiinventory JOIN bookclass ON bookiinventory.ClassID =bookclass.BookClassID GROUP BY bookiinventory.ClassID ORDER BY COUNT DESC"; String Selectbook="SELECT * FROM bookiinventory JOIN bookclass ON bookiinventory.ClassID =bookclass.BookClassID WHERE bookclass.BookClassMC=? ORDER BY bookiinventory.Brcount DESC"; String Selectbookcard="SELECT * FROM librarycard"; @Override public List<NewBook> findAllBook() { List<NewBook> list=new ArrayList<NewBook>(); try { conn=DButil.getConnection(); ps=conn.prepareStatement(SelectAllBook); rs=ps.executeQuery(); while(rs.next()) { NewBook book=new NewBook(); book.setBookID(rs.getInt("BookID")); book.setPublicationDate(rs.getDate("publicationDate")); book.setRecordDate(rs.getDate("recordDate")); book.setAuthorName(rs.getString("authorName")); book.setBookMC(rs.getString("bookMC")); book.setBrcount(rs.getInt("brcount")); book.setBookClass(rs.getString("BookClassMC")); book.setEvaluate(rs.getInt("evaluate")); book.setLocation(rs.getString("location")); book.setPressName(rs.getString("pressName")); book.setPrice(rs.getString("price")); book.setState(rs.getInt("state")); list.add(book); } } catch (SQLException e) { e.printStackTrace(); } finally { DButil.colseAll2(conn, ps, rs); } return list; } @Override public int insetRowBook(NewBook t) { return 0; } @Override public int updateRowBook(NewBook t) { //BookMC=?,authorName=?,PressName=?,publicationDate=?,recordDate=?, //ClassID=?,location=?,price=? WHERE BookID=? int updatefinall=0; tr