图书管理系统针对管理员和用户有着不同的功能，共同的功能有登陆注册.zip

/** * 学校：长江师范学院 * 学院：计算机工程学院 * 专业：计算机科学与技术（软件服务外包） * 年级：2012级 * 日期：2014年12月30日 * 时间：下午10:00:36 * 文件名：QueryDao.java * 所属包名：yznu.holiday.dao * 所属项目名：HolidayReading */ package yznu.holiday.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import yznu.holiday.bean.BookInfoBean; import yznu.holiday.bean.BookTypeBean; import yznu.holiday.bean.BorrowRecordBean; import yznu.holiday.impl.QueryInterface; /** * 关于查询的数据库操作 */ public class QueryDao extends BaseDao implements QueryInterface { /* * （非 Javadoc） 查询某一用户的借书记录 * * @see * yznu.holiday.impl.QueryInterface#QueryBorrowRecord(java.lang.String[]) */ @Override public List<BorrowRecordBean> QueryBorrowRecord(String[] args) { // TODO 自动生成的方法存根 String sql = "select * from tb_borrowrecord where userISBN=? and isback=0"; ResultSet re = super.select(sql, args); List<BorrowRecordBean> list = new ArrayList<BorrowRecordBean>(); try { while (re.next()) { String recordid = re.getString("recordid"); String bookISBN = re.getString("bookISBN"); String userISBN = re.getString("userISBN"); String borrowDate = re.getString("borrowDate"); String isback = re.getString("isback"); String backDate = re.getString("backDate"); String arg[] = { bookISBN }; String bookname = this.QueryBook(arg).getBookname(); // System.out.println(bookname+"**"+recordid); list.add(new BorrowRecordBean(recordid, bookISBN, bookname, userISBN, isback, borrowDate, backDate)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } /* * （非 Javadoc） * * @see yznu.holiday.impl.QueryInterface#QueryKindsBooks(java.lang.String[]) */ /** * 查询某一种类的图书 */ @Override public List<BookInfoBean> QueryKindsBooks(String[] args) { // TODO 自动生成的方法存根 String sql = "select ISBN,bookname,writer,translator,publisher,date,price from tb_bookinfo where typeId=?"; ResultSet re = super.select(sql, args); List<BookInfoBean> list = new ArrayList<BookInfoBean>(); try { while (re.next()) { String ISBN = re.getString("ISBN"); String bookname = re.getString("bookname"); String writer = re.getString("writer"); String translator = re.getString("translator"); String publisher = re.getString("publisher"); String date = re.getDate("date").toString(); String price = String.valueOf(re.getDouble("price")); list.add(new BookInfoBean(ISBN, args[0], bookname, writer, translator, publisher, date, price)); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); return null; } return list; } /** * 模糊查询图书 */ @Override public List<BookInfoBean> QuerySearchBooks(String[] args, String a[]) { // TODO 自动生成的方法存根 String sql = "SELECT * from tb_bookinfo where ISBN like '%" + a[0] + "%' OR typeId like '%" + a[0] + "%' OR bookname like '%" + a[0] + "%'" + "or writer like '%" + a[0] + "%' or publisher like '%" + a[0] + "%' or price like '%" + a[0] + "%'"; ResultSet re = super.select(sql, args); List<BookInfoBean> list = new ArrayList<BookInfoBean>(); try { while (re.next()) { String ISBN = re.getString("ISBN"); String typeId = re.getString("typeId"); String bookname = re.getString("bookname"); String writer = re.getString("writer"); String translator = re.getString("translator"); String publisher = re.getString("publisher"); String date = re.getDate("date").toString(); String price = String.valueOf(re.getDouble("price")); list.add(new BookInfoBean(ISBN, typeId, bookname, writer, translator, publisher, date, price)); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); return null; } return list; } /* * （非 Javadoc） 查询一本书的详细信息 * * @see yznu.holiday.impl.QueryInterface#QueryBook(java.lang.String[]) */ @Override public BookInfoBean QueryBook(String[] args) { // TODO 自动生成的方法存根 String sql = "select * from tb_bookinfo where ISBN=?"; ResultSet re = super.select(sql, args); BookInfoBean book = new BookInfoBean(); try { while (re.next()) { String ISBN = re.getString("ISBN"); String bookname = re.getString("bookname"); String writer = re.getString("writer"); String translator = re.getString("translator"); String publisher = re.getString("publisher"); String date = re.getDate("date").toString(); String price = String.valueOf(re.getDouble("price")); String typeId = re.getString("typeId"); book.setBookname(bookname); book.setDate(date); book.setPrice(price); book.setPublisher(publisher); book.setWriter(writer); book.setTypeId(typeId); book.setTranslator(translator); book.setISBN(ISBN); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); return null; } return book; } /* * （非 Javadoc） * * @see yznu.holiday.impl.QueryInterface#QueryBookStock(java.lang.String[]) */ /** * 查询库存量（参数个数：1【ISBN】） */ @Override public int QueryBookStock(String[] args) { // TODO 自动生成的方法存根 String sql = "select amount from tb_stockpile where ISBN=?"; ResultSet re = super.select(sql, args); int n = 0; try { if (re.next()) { n = re.getInt("amount"); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } return n; } /* * （非 Javadoc） * * @see yznu.holiday.impl.QueryInterface#pageList(java.lang.String[]) */ /** * 分页查询书籍（int page, int pageContent） * * @param page * 显示的页码 * @param pageContent * 每页的容量 */ @Override public List<BookInfoBean> pageList(int page, int pageContent, String type) { // TODO 自动生成的方法存根 int startNum = (page - 1) * pageContent; // 计算起始记录点 // int endNum = page * pageContent; // 计算终止记录点 String sql = "select ISBN,typeId,bookname,writer,translator,publisher,date,price from tb_bookinfo where typeId=? limit ?, ?"; Connection con = super.getConnection(); List<BookInfoBean> bookList = null; try { PreparedStatement pst = con.prepareStatement(sql); pst.setString(1, type); pst.setInt(2, startNum); pst.setInt(3, pageContent); bookList = new ArrayList<BookInfoBean>(); ResultSet rs = pst.executeQuery(); while (rs.next()) { String ISBN = rs.getString("ISBN"); String typeId = String.valueOf(rs.getInt("typeId")); String bookname = rs.getString("bookname"); String writer = rs.getString("writer"); String translator = rs.getString("translator"); String publisher = rs.getString("publisher"); String date = rs.getDate("date").toString(); String price = String.valueOf(rs.getDouble("price")); bookList.add(new BookInfoBean(ISBN, typeId, bookname, writer, translator, publisher, date, price)); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } return bookList; } /** * 查询某一种类书籍名 */ @Override public String queryTypeName(String[] args) { String sql = "select type from tb_booktype where btid=?"; ResultSet re = super.select(sql, args); String n = null; try { if (re.next()) { n = re.getString("type"); } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } return n; } /** * 查询所有种类书籍名 */ @Override public List<BookTypeBean> queryAllTypeName(String[] args) { String sql = "select * from tb_booktype"; ResultSet re = super.select(sql, args); List<BookTypeBean> list = new ArrayList<BookTypeBean>(); try { while (re.next()) { String typename = re.getString(2); String btid = re.g