网上图书销售系统（java jsp）

package dao; import java.sql.Connection; import java.util.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import entity.BookEntity; public class BookDao extends BaseDao { public List<BookEntity> bookQuery(String name, String type, String publish) { List<BookEntity> list = new ArrayList<BookEntity>(); Connection conn = super.getconn(); PreparedStatement ps = null; ResultSet rs = null; String sql = "select * from book where 1=1"; if (name != "") { sql += " and book_name like '%" + name + "%'"; } if (type != "") { sql += " and book_type like '%" + type + "%'"; } if (publish != "") { sql += " and book_publish like '%" + publish + "%'"; } try { ps = conn.prepareStatement(sql); // ps.setString(1, name); // ps.setString(2, type); // ps.setString(3, publish); rs = ps.executeQuery(); //if (!rs.next()) { // return null; //} while (rs.next()) { BookEntity booke = new BookEntity(); booke.setBook_id(rs.getInt("book_id")); booke.setBook_name(rs.getString("book_name")); booke.setBook_type(rs.getString("book_type")); booke.setBook_publish(rs.getString("book_publish")); booke.setBook_date(rs.getDate("book_date")); list.add(booke); } } catch (SQLException e) { e.printStackTrace(); } finally { super.closeAll(conn, ps, rs); } return list; } public List<BookEntity> bookQueryAll() { List<BookEntity> list = new ArrayList<BookEntity>(); Connection conn = super.getconn(); PreparedStatement ps = null; ResultSet rs = null; String sql = "select * from book"; try { ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { BookEntity booke = new BookEntity(); booke.setBook_id(rs.getInt("book_id")); booke.setBook_name(rs.getString("book_name")); booke.setBook_type(rs.getString("book_type")); booke.setBook_publish(rs.getString("book_publish")); booke.setBook_date(rs.getDate("book_date")); list.add(booke); } } catch (SQLException e) { e.printStackTrace(); } finally { super.closeAll(conn, ps, rs); } return list; } public int addBook(BookEntity book) { Connection conn = super.getconn(); PreparedStatement ps = null; ResultSet rs = null; int rows = 0; String sql = "insert into book values(?,?,?,?)"; try { ps = conn.prepareStatement(sql); ps.setString(1, book.getBook_name()); ps.setString(2, book.getBook_type()); ps.setString(3, book.getBook_publish()); java.sql.Date date = new java.sql.Date(book.getBook_date().getTime()); ps.setDate(4, date); rows = ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { super.closeAll(conn, ps, rs); } return rows; } private Date dateToString(String date) { SimpleDateFormat formatDate = new SimpleDateFormat("yyyy-MM-dd"); String str = formatDate.format(date); Date time = null; try { time = (Date) formatDate.parse(str); } catch (ParseException e) { e.printStackTrace(); } return time; } }