eBook图书网站，赛级高质量资源

package org.yidu.ebook.Dao; 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 org.yidu.ebook.entity.Product; import org.yidu.ebook.util.JdbcUtil; public class ProductDao { /** * @增加一件商品 * @author 贺显国 * @param product * @return */ public int addProduct(Product product){ PreparedStatement pst=null; Connection conn=null; try { //建立连接 conn=JdbcUtil.getConnection(); //获得SQL语句 String sql="insert into product" + "(name,author,publish," + "isbn,srcPrice,realPrice,quantity" + "picName,content,categoryId)" + "values(?,?,?,?,?,?,?,?,?,?)"; pst=conn.prepareStatement(sql); //替换参数 pst.setString(1, product.getName()); pst.setString(2, product.getAuthor()); pst.setString(3, product.getPublish()); pst.setString(4, product.getIsbn()); pst.setDouble(5, product.getSrcPrice()); pst.setDouble(6, product.getRealPrice()); pst.setInt(7, product.getQuantity()); pst.setString(8, product.getPicName()); pst.setString(9, product.getContent()); pst.setString(10, product.getCategoryID()); int n=pst.executeUpdate(); }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { // 释放资源 JdbcUtil.closeAll(null, pst, conn); } return 0; } /** * @author 贺显国 * @see 更改一件商品 * @param product * @return */ public int UpdateProduct(Product product){ PreparedStatement pst=null; Connection conn=null; try { //建立连接 conn=JdbcUtil.getConnection(); //获得SQL语句 String sql="update product " + "set name=?,author=?,publish=?" + "isbn=?,srcPrice=?,realPrice=?," + "quantity=?,picName=?,content=?,category=?" + "where id=?"; pst=conn.prepareStatement(sql); //替换参数 pst.setString(1, product.getName()); pst.setString(2, product.getAuthor()); pst.setString(3, product.getPublish()); pst.setString(4, product.getIsbn()); pst.setDouble(5, product.getSrcPrice()); pst.setDouble(6, product.getRealPrice()); pst.setInt(7, product.getQuantity()); pst.setString(8, product.getPicName()); pst.setString(9, product.getContent()); pst.setString(10, product.getCategoryID()); pst.setInt(11,product.getId()); int n=pst.executeUpdate(); }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { // 释放资源 JdbcUtil.closeAll(null, pst, conn); } return 0; } /** * @author 贺显国 * @see 查询全部商品 * @return */ public List<Product>queryProducts(){ List<Product> list = new ArrayList<Product>(); Connection conn = null; PreparedStatement pst = null; ResultSet rs = null; try{ // 获得连接 conn = JdbcUtil.getConnection(); // 获得语句对象 String sql = "select * from product"; pst = conn.prepareStatement(sql); // 执行SQL增删改的SQL rs = pst.executeQuery(); // 接续查询结果 while (rs.next()){ int id = rs.getInt("id"); String name = rs.getString("name"); String author = rs.getString("author"); String publish = rs.getString("publish"); String isbn = rs.getString("isbn"); Double srcPrice = rs.getDouble("srcPrice"); Double realPrice= rs.getDouble("realPrice"); int quantity = rs.getInt("quantity"); String picName = rs.getString("picName"); String content = rs.getString("content"); String categoryId=rs.getString("categoryId"); Product product = new Product(id,name,author, publish,isbn, srcPrice,realPrice,quantity, picName,content ,categoryId); list.add(product); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { // 释放资源 JdbcUtil.closeAll(null, pst, conn); } return list; } /** * @author 林天然 * @see 按id查询一件商品 * @param id * @return */ public Product getProduct(int id){ Connection conn = null; PreparedStatement pst = null; ResultSet rs = null; try{ // 获得连接 conn = JdbcUtil.getConnection(); // 获得语句对象 String sql = "select * from product where id=?"; // 替换参数 pst.setInt(1, id); pst = conn.prepareStatement(sql); // 执行SQL增删改的SQL rs = pst.executeQuery(); //接续查询结果 if(rs.next()){ String name = rs.getString("name"); String author = rs.getString("author"); String publish = rs.getString("publish"); String isbn = rs.getString("isbn"); Double srcPrice = rs.getDouble("srcPrice"); Double realPrice= rs.getDouble("realPrice"); int quantity = rs.getInt("quantity"); String picName = rs.getString("picName"); String content = rs.getString("content"); String categoryId=rs.getString("categoryId"); Product product = new Product(id,name,author,publish,isbn, srcPrice,realPrice,quantity,picName,content ,categoryId); return product; } }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { // 释放资源 JdbcUtil.closeAll(null, pst, conn); } return null; } /** * @author 林天然 * @see 删除一件商品 * @param product * @return */ public int deleteCustomer(Product product){ PreparedStatement pst = null; Connection conn = null; try{ // 获得连接 conn = JdbcUtil.getConnection(); // 获得语句对象 String sql = "delete from product where id=?"; pst = conn.prepareStatement(sql); // 替换参数 pst.setInt(1, product.getId()); // 执行SQL增删改的SQL int n = pst.executeUpdate(); // 返回结果 return n; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { // 释放资源 JdbcUtil.closeAll(null, pst, conn); } return 0; } }