适合初学者学习课程课题设计javaweb超级简单图书管理系统基于servlet基础开发

package com.rain.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Calendar; import com.rain.bean.AdminBean; import com.rain.bean.BookBean; import com.rain.bean.HistoryBean; import com.rain.bean.TypeBean; import com.rain.util.DBUtil; /** * 关于图书连接数据库的所有操作的类 */ public class BookDao { /** * 添加图书信息，传入所有的信息 * @param card * @param name * @param type * @param autho * @param press * @param num */ public void addBook(String card, String name, String type, String autho, String press, int num) { // TODO Auto-generated method stub Connection conn = DBUtil.getConnectDb(); String sql = "insert into book(card,name,type,autho,press,num) values(?,?,?,?,?,?)"; int rs = 0; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1, card); stm.setString(2, name); stm.setString(3, type); stm.setString(4, autho); stm.setString(5, press); stm.setInt(6, num); rs = stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 获取所有的图书信息，返回的是ArrayList数组形式 * @return */ public ArrayList<BookBean> get_ListInfo(){ ArrayList<BookBean> tag_Array = new ArrayList<BookBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from book"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ BookBean tag = new BookBean(); tag.setBid(rs.getInt("bid")); tag.setName(rs.getString("name")); tag.setCard(rs.getString("card")); tag.setType(rs.getString("type")); tag.setAutho(rs.getString("autho")); tag.setPress(rs.getString("press")); tag.setNum(rs.getInt("num")); tag_Array.add(tag); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 获取借阅记录的全部信息，传入的条件有status，aid，表示搜索正在借阅的，或者已经还书的信息，aid代表当前登录用户 * @param status * @return */ public ArrayList<HistoryBean> get_HistoryListInfo(int status,String aid){ ArrayList<HistoryBean> tag_Array = new ArrayList<HistoryBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from history where aid='"+aid+"' and status='"+status+"'"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ HistoryBean tag = new HistoryBean(); tag.setHid(rs.getInt("hid")); tag.setAid(rs.getInt("aid")); tag.setBid(rs.getInt("bid")); tag.setBookname(rs.getString("bookname")); tag.setCard(rs.getString("card")); tag.setAdminname(rs.getString("adminname")); tag.setUsername(rs.getString("username")); tag.setBegintime(rs.getString("begintime")); tag.setEndtime(rs.getString("endtime")); tag.setStatus(rs.getInt("status")); tag_Array.add(tag); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 获取借阅记录的全部信息，传入的条件有status，表示搜索正在借阅的，或者已经还书的信息 * @param status * @return */ public ArrayList<HistoryBean> get_HistoryListInfo2(int status){ ArrayList<HistoryBean> tag_Array = new ArrayList<HistoryBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from history where status='"+status+"'"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ HistoryBean tag = new HistoryBean(); tag.setHid(rs.getInt("hid")); tag.setAid(rs.getInt("aid")); tag.setBid(rs.getInt("bid")); tag.setBookname(rs.getString("bookname")); tag.setCard(rs.getString("card")); tag.setAdminname(rs.getString("adminname")); tag.setUsername(rs.getString("username")); tag.setBegintime(rs.getString("begintime")); tag.setEndtime(rs.getString("endtime")); tag.setStatus(rs.getInt("status")); tag_Array.add(tag); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 获取单个图书的信息，根据传入的bid来查找，返回一个BookBean数据类型 * @param bid * @return */ public BookBean get_BookInfo(int bid){ BookBean tag = new BookBean(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from book where bid='"+bid+"'"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ tag.setBid(rs.getInt("bid")); tag.setName(rs.getString("name")); tag.setCard(rs.getString("card")); tag.setType(rs.getString("type")); tag.setAutho(rs.getString("autho")); tag.setPress(rs.getString("press")); tag.setNum(rs.getInt("num")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil.CloseDB(rs, stm, conn); } return tag; } /** * 修改图书的信息，bid作为条件， */ public void updateBook(int bid, String card, String name, String type, String autho, String press, int num) { // TODO Auto-generated method stub Connection conn = DBUtil.getConnectDb(); String sql = "update book set name=?,card=?,type=?,autho=?,press=?,num=? where bid=?"; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1, name); stm.setString(2, card); stm.setString(3, type); stm.setString(4, autho); stm.setString(5, press); stm.setInt(6, num); stm.setInt(7, bid); stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 删除图书信息，根据传入的bid作为条件 * @param bid */ public void deleteBook(int bid) { // TODO Auto-generated method stub Connection conn = DBUtil.getConnectDb(); String sql = "delete from book where bid=?"; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setInt(1, bid); stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println(uid); } /** * 用户查找图书，根据输入的名称，使用like进行模糊查询，然后返回一个ArrayList数组类型 * @param name * @return */ public ArrayList<BookBean> getLikeList(String name) { // TODO Auto-generated method stub ArrayList<BookBean> tag_Array = new ArrayList<BookBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from book where name like '%"+name+"%'"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while(rs.next()){ BookBean tag = new BookBean(); tag.setBid(rs.getInt("bid")); tag.setName(rs.getString("name")); tag.setCard(rs.getString("card")); tag.setType(rs.getString("type")); tag.setAutho(rs.getString("autho")); tag.setPress(rs.getString("press")); tag.setNum(rs.getInt("num")); tag_Array.add(tag); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 图书借阅函数，根据传入bid图书id，adminbean当前登录用户的信息，在借阅记录数据表中新插入一条记录 * @param bid * @param adminbean */ public void b