guanli.zip_difficultmi1_java web开发_jsp_简单的图书管理_管理系统

package Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import entity.Book; import entity.SBook; import utils.DBHelper; public class BookDao { public static List<Book> showBook(){ // TODO Auto-generated method stub List<Book> books = new ArrayList<Book>(); String sql = "select * from book"; System.out.print(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { Book book=new Book(); book.setISBN(rs.getString("ISBN")); book.setTitle(rs.getString("title")); book.setAuthor(rs.getString("author")); book.setPress(rs.getString("press")); book.setIntroduce(rs.getString("introduce")); book.setLocation(rs.getString("location")); book.setCallnumber(rs.getString("callnumber")); books.add(book); } DBHelper.closeConnection(c, s, rs); } catch (Exception e) { System.out.println("getBook()��������"); e.printStackTrace(); } return books; } public static List<SBook> showSBook(){ // TODO Auto-generated method stub List<SBook> sbooks = new ArrayList<SBook>(); String sql = "select * from sbook"; System.out.print(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { SBook sbook=new SBook(); sbook.setISBN(rs.getString("ISBN")); sbook.setSbook_id("sbook_id"); sbooks.add(sbook); } DBHelper.closeConnection(c, s, rs); } catch (Exception e) { System.out.println("getBook()��������"); e.printStackTrace(); } return sbooks; } public static Book getBook(String ISBN) { // TODO Auto-generated method stub Book book = new Book(); String sql = "select * from book where ISBN='" + ISBN + "'"; System.out.print(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { book.setISBN(ISBN); book.setTitle(rs.getString("title")); book.setAuthor(rs.getString("author")); book.setPress(rs.getString("press")); book.setIntroduce(rs.getString("introduce")); book.setLocation(rs.getString("location")); book.setCallnumber(rs.getString("callnumber")); } DBHelper.closeConnection(c, s, rs); } catch (Exception e) { System.out.println("getBook()��������"); e.printStackTrace(); } return book; } public static List<SBook> getSbooks(String ISBN) { // TODO Auto-generated method stub List<SBook> sbooks = new ArrayList<SBook>(); String sql = "select sbook.sbook_id,ISBN from sbook " + "where ISBN='" + ISBN + "'"; System.out.print(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { SBook sbook = new SBook(); String sbook_id = rs.getString("sbook_id"); sbook.setISBN(ISBN); sbook.setSbook_id(sbook_id); sbooks.add(sbook); } DBHelper.closeConnection(c, s, rs); } catch (Exception e) { System.out.println("getSBooks()��������"); e.printStackTrace(); } return sbooks; } public static void addSbook(String ISBN,String sbook_id) { String sql = "INSERT INTO sbook SET ISBN = '" + ISBN + "', sbook_id = '" + sbook_id + "'"; System.out.println(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); s.executeUpdate(sql); DBHelper.closeConnection(c, s, null); } catch (Exception e) { System.out.println("add()方法出错！"); e.printStackTrace(); } } public void add(Book book) { try { Connection c = DBHelper.getInstance().getConnection(); String sql = "insert into book (ISBN,title,author,press,introduce,location,callnumber)values(?,?,?,?,?,?,?)"; PreparedStatement ps = c.prepareStatement(sql); ps.setString(1, book.getISBN()); ps.setString(2, book.getTitle()); ps.setString(3, book.getAuthor()); ps.setString(4,book.getPress()); ps.setString(5, book.getIntroduce()); ps.setString(6, book.getLocation()); ps.setString(7, book.getCallnumber()); ps.execute(); DBHelper.closeConnection(c, ps, null); } catch (Exception e) { e.printStackTrace(); } } public static void deleteBook(String ISBN){ String sql = "delete from book where ISBN= '" + ISBN + "' "; System.out.println(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); s.executeUpdate(sql); DBHelper.closeConnection(c, s, null); } catch (Exception e) { System.out.println("deleteBook()方法出错！"); e.printStackTrace(); } } public static void deleteSBook(String sbook_id){ String sql = "delete from sbook where sbook_id= '" + sbook_id + "' "; System.out.println(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); s.executeUpdate(sql); DBHelper.closeConnection(c, s, null); } catch (Exception e) { System.out.println("deleteSBook()方法出错！"); e.printStackTrace(); } } public static List<Book> getBooks(String ISBN){ List<Book> books = new ArrayList<Book>(); String sql="select * from book where ISBN='" + ISBN + "' "; System.out.print(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while(rs.next()){ Book book=new Book(); String title=rs.getString("title"); String author=rs.getString("author"); String press=rs.getString("press"); String introduce=rs.getString("introduce"); String location=rs.getString("location"); String callnumber=rs.getString("callnumber"); book.setISBN(ISBN); book.setTitle(title); book.setAuthor(author); book.setPress(press); book.setIntroduce(introduce); book.setLocation(location); book.setCallnumber(callnumber); books.add(book); } DBHelper.closeConnection(c, s, null); } catch (Exception e) { System.out.println("方法出错！"); e.printStackTrace(); } return books; } public static Book updateOne(String ISBN) { Book book=new Book(); String sql = "select * from book where ISBN='" +ISBN+"' "; System.out.println(sql); try { Connection c = DBHelper.getInstance().getConnection(); Statement s = c.createStatement(); ResultSet rs = s.executeQuery(sql); while(rs.next()){ String title=rs.getString("title"); String author=rs.getString("author"); String press=rs.getString("press"); String introduce=rs.getString("introduce"); String location=rs.getString("location"); String callnumber=rs.getString("callnumber"); book.setISBN(ISBN); book.setTitle(title); book.setAuthor(author); book.setPress(press); book.setIntroduce(introduce); book.setLocation(location); book.setCallnumber(callnumber); } DBHelper.closeConnection(c, s, null); } catch (Exception e) { e.printStackTrace(); } return book; } public static SBook supdateOne(String ISBN) { SBook sbook=new SBook(); String sql = "select * from sbook where ISBN='" +ISBN+"' "; System.out.println(sql); try { Connection c = DBHelper.getInstance().getConne