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

package com.oracle.dao.impl; 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 com.oracle.dao.BookDao; import com.oracle.domain.Book; import com.oracle.domain.Fenlei; import com.oracle.domain.PageBean; import com.oracle.domain.User; import com.oracle.util.DBUtilsPlus; public class BookDaoImpl implements BookDao { @Override public List<Fenlei> findfl() { // TODO Auto-generated method stub Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Fenlei> list = new ArrayList<Fenlei>(); try { conn = DBUtilsPlus.getConnection(); String sql = "select * from fenlei order by id desc"; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { int id = rs.getInt(1); String name = rs.getString(2); Fenlei s = new Fenlei(id, name); list.add(s); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtilsPlus.close(conn, ps, rs); } return list; } @Override public int yanzheng(String name,String flname) { // TODO Auto-generated method stub int t = 0; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = DBUtilsPlus.getConnection(); ps = conn.prepareStatement("select * from book where name=? and flname=? "); ps.setString(1, name); ps.setString(2, flname); rs = ps.executeQuery(); if (rs.next()) { t = 1; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return t; } @Override public int addbook(Book book) { // TODO Auto-generated method stub // TODO Auto-generated method stub int s = 0; Connection conn = null; PreparedStatement ps = null; try { conn = DBUtilsPlus.getConnection(); ps = conn.prepareStatement( "insert into book (flname,name,money,press,state,reader) value(?,?,?,?,?,?)"); ps.setString(1, book.getFlname()); ps.setString(2, book.getName()); ps.setString(3, book.getMoney()); ps.setString(4, book.getPress()); ps.setString(5, book.getState()); ps.setString(6, book.getReader()); s = ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return s; } @Override public PageBean<Book> showPesgefl(int pageNew, int pageSize) { PageBean<Book> pb = new PageBean<Book>(); pb.setPageNew(pageNew); pb.setPageSize(pageSize); pb.setCounts(this.Count()); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Book> list = new ArrayList<Book>(); try { conn = DBUtilsPlus.getConnection(); String sql = "select * from book order by id desc limit ?,?"; ps = conn.prepareStatement(sql); ps.setInt(1, (pageNew - 1) * 5); ps.setInt(2, pageSize); rs = ps.executeQuery(); while (rs.next()) { int id = rs.getInt(1); String flname = rs.getString(2); String name = rs.getString(3); String money = rs.getString(4); String press = rs.getString(5); String state = rs.getString(6); String reader = rs.getString(7); // double money=Integer.parseInt(money1); Book b = new Book(id, flname, name, money, press, state, reader); list.add(b); } pb.setBeanList(list); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtilsPlus.close(conn, ps, rs); } return pb; } @Override public int Count() { // TODO Auto-generated method stub Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; int i = 0; try { conn = DBUtilsPlus.getConnection(); String sql = "select count(*) from book "; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); if (rs.next()) { i = rs.getInt(1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtilsPlus.close(conn, ps, rs); } return i; } @Override public int[] delete(String[] ids) { // TODO Auto-generated method stub int[] n = null; Connection conn = null; PreparedStatement ps = null; try { conn = DBUtilsPlus.getConnection(); conn.setAutoCommit(false); for (int i = 0; i < ids.length; i++) { // conn = DBUtilsPlus.getConnection(); ps = conn.prepareStatement("delete from book where id=?"); ps.setInt(1, Integer.parseInt(ids[i])); ps.addBatch(); n = ps.executeBatch(); } conn.commit(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); try { conn.rollback(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } finally { DBUtilsPlus.close(conn, ps); } return n; } @Override public Book dancha(int id1) { // TODO Auto-generated method stub Book b = null; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = DBUtilsPlus.getConnection(); ps = conn.prepareStatement("select * from book where id=? "); ps.setInt(1, id1); rs = ps.executeQuery(); if (rs.next()) { int id = rs.getInt(1); String flname = rs.getString(2); String name = rs.getString(3); String money = rs.getString(4); String press = rs.getString(5); String state = rs.getString(6); String reader = rs.getString(7); // double money=Integer.parseInt(money1); b = new Book(id, flname, name, money, press, state, reader); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return b; } @Override public int update2(Book book) { int s = 0; Connection conn = null; PreparedStatement ps = null; try { conn = DBUtilsPlus.getConnection(); ps = conn.prepareStatement( "update book set flname=?,name=?,money=?,press=?,state=?,reader=? where id=? "); ps.setString(1, book.getFlname()); ps.setString(2, book.getName()); ps.setString(3, book.getMoney()); ps.setString(4, book.getPress()); ps.setString(5, book.getState()); ps.setString(6, book.getReader()); ps.setInt(7, book.getId()); s = ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return s; } @Override public List<Book> showBook() { // TODO Auto-generated method stub Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Book> list=new ArrayList<Book>(); try { conn = DBUtilsPlus.getConnection(); String sql = "select * from book order by id desc"; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { int id = rs.getInt(1); String flname = rs.getString(2); String name = rs.getString(3); String money = rs.getString(4); String press = rs.getString(5); String state = rs.getString(6); String reader = rs.getString(7); // double money=Integer.parseInt(money1); Book b = new Book(id, flname, name, money, press, state, reader); list.add(b); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } @Override public List<Book> showIdsBook(String[] ids) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; List<Book> list = new ArrayList<Book>(); try { conn = DBUtilsPlus.getConnection(); String sql =ByIds(ids); ps = conn.prepareStatement(sql); for(int i=0;i<ids.length;i++){ ps.setInt(i+1, Integer.parseInt(ids[i])); } rs = ps.executeQuery(); while (rs