利用JavaWeb实现图书馆管理系统

package cn.book.dao; import cn.book.pojo.Book; import cn.book.pojo.BookLendType; import cn.book.pojo.Info; import cn.book.pojo.User; import cn.book.util.ConnectionFactory; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; public class FileDaoImpl implements FileDao{ @Override public List<User> getAllUser() { List<User> arr = new ArrayList<User>(); Connection connection = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet res = null; try { String sql = "select * from user where u_id!=0"; System.out.println(sql); try { pre = connection.prepareStatement(sql); res = pre.executeQuery(); while (res.next()){ User u = new User(); u.setUid(res.getString("u_id")); u.setName(res.getString("u_name")); u.setSex(res.getString("u_sex")); u.setIdcard(res.getString("u_idcard")); u.setU_times(res.getInt("u_times")); u.setPwd(res.getString("u_pwd")); u.setState(res.getInt("u_state")); u.setRole(res.getInt("u_role")); arr.add(u); } } catch (SQLException throwables) { throwables.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } return arr; } @Override public User getUserByidOrName(String admid) { Connection connection = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet res = null; User u = null; try { String sql = "select * from `user` where u_id='"+admid+"' or u_name like '%"+admid+"%'"; System.out.println(sql); try { pre = connection.prepareStatement(sql); res = pre.executeQuery(); while (res.next()){ u = new User(); u.setUid(res.getString("u_id")); u.setName(res.getString("u_name")); u.setSex(res.getString("u_sex")); u.setIdcard(res.getString("u_idcard")); u.setU_times(res.getInt("u_times")); u.setPwd(res.getString("u_pwd")); u.setState(res.getInt("u_state")); u.setRole(res.getInt("u_role")); } } catch (SQLException throwables) { throwables.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } return u; } @Override public List<Book> getAllBook() { List<Book> arr = new ArrayList<Book>(); Connection connection = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet res = null; try { String sql = "select * from books"; try { pre = connection.prepareStatement(sql); res = pre.executeQuery(); while (res.next()){ Book book = new Book(); book.setBook_id(res.getString("book_id")); book.setBook_name(res.getString("book_name")); book.setBook_type(res.getString("book_type")); book.setBook_num(res.getString("book_num")); book.setBook_price(res.getDouble("book_price")); book.setBook_lend(res.getInt("book_lend")); book.setBook_ISBN(res.getString("book_ISBN")); book.setBook_address(res.getString("book_address")); book.setBook_business(res.getString("book_business")); book.setBook_author(res.getString("book_author")); book.setBook_edition(res.getString("book_edition")); book.setBook_times(res.getInt("book_times")); arr.add(book); } } catch (SQLException throwables) { throwables.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } return arr; } @Override public List<Book> getBookByNameOrId(String goalFile) { System.out.println(goalFile); List<Book> arr = new ArrayList<Book>(); Connection connection = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet res = null; try { String sql = "select * from books where book_id='"+goalFile+"' or book_name like '%"+goalFile+"%' or book_type like '%"+goalFile+"%'"; System.out.println(sql); try { pre = connection.prepareStatement(sql); res = pre.executeQuery(); while (res.next()){ Book book = new Book(); book.setBook_id(res.getString("book_id")); book.setBook_name(res.getString("book_name")); book.setBook_type(res.getString("book_type")); book.setBook_num(res.getString("book_num")); book.setBook_price(res.getDouble("book_price")); book.setBook_lend(res.getInt("book_lend")); book.setBook_ISBN(res.getString("book_ISBN")); book.setBook_address(res.getString("book_address")); book.setBook_business(res.getString("book_business")); book.setBook_author(res.getString("book_author")); book.setBook_edition(res.getString("book_edition")); book.setBook_times(res.getInt("book_times")); arr.add(book); } } catch (SQLException throwables) { throwables.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } return arr; } @Override public void upBookNum(String bookId, String number, String price) { /* * 这个地方对数据库是不是就是 改变数据库 * 不是查询数据库 * 所以 我们在这个地方写相应的sql语句 * 然后设置以后函数专门处理sql语句 * * */ String sql = "UPDATE books SET book_num="+number+",book_price="+price+" WHERE book_id='"+bookId+"'"; deal(sql); } @Override public void addBook(String a, String b, String c, String d, String e, String f, String g, String h, String l) { Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddhhmmss"); String bid = "b"+sdf.format(date); String sql = "insert into books values('"+bid+"','"+a+"','"+b+"',"+c+","+d+",0,'"+e+"','"+f+"','"+g+"','"+h+"','"+l+"',0)"; deal(sql); } public List<BookLendType> getLendFiles(String sql){ Connection connection = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet res = null; List<BookLendType> list = null; try { try { list = new ArrayList<BookLendType>(); pre = connection.prepareStatement(sql); res = pre.executeQuery(); while (res.next()){ BookLendType blt = new BookLendType(); blt.setLend_id(res.getString("a")); blt