javaweb为基础的网页购物界面的实现

package cn.edu.hzvtc.dao.impl; import cn.edu.hzvtc.dao.GoodsDao; import cn.edu.hzvtc.model.Goods; import cn.edu.hzvtc.util.DbUtil; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Timestamp; import java.util.ArrayList; import java.util.List; public class GoodsDaoImpl implements GoodsDao { @Override public Integer selectForRecordCount() { Integer result = 0; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "SELECT COUNT(*) FROM tbl_goods ORDER BY id DESC"; PreparedStatement psmt = conn.prepareStatement(sql); //执行操作，返回查询结果集 ResultSet rs = psmt.executeQuery(); if (rs.next()) { result = rs.getInt(1); } //释放资源 DbUtil.close(rs, psmt, conn); } catch (Exception e) { System.out.println(e.getMessage()); } return result; } @Override public List<Goods> selectForPageItems(Integer offset, Integer rows) { List<Goods> result = null; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "SELECT g.id,g.name,g.price,g.description,g.stock,g.image1,g.image2,g.image3," + "g.image4,g.image5,g.createtime,t.id typeId,t.name typeName " + "FROM tbl_goods g LEFT JOIN tbl_type t ON g.type_id=t.id ORDER BY g.id DESC LIMIT ?,?"; PreparedStatement psmt = conn.prepareStatement(sql); //设置传入参数 psmt.setInt(1, offset); psmt.setInt(2, rows); //执行操作，返回查询结果集 ResultSet rs = psmt.executeQuery(); result = new ArrayList<>(); while (rs.next()) { Goods goods = new Goods(); goods.setId(rs.getInt("id")); goods.setName(rs.getString("name")); goods.setPrice(rs.getFloat("price")); goods.setDescription(rs.getString("description")); goods.setStock(rs.getInt("stock")); goods.setImage1(rs.getString("image1")); goods.setImage2(rs.getString("image2")); goods.setImage3(rs.getString("image3")); goods.setImage4(rs.getString("image4")); goods.setImage5(rs.getString("image5")); goods.setCreateTime(rs.getTimestamp("createtime")); goods.getType().setId(rs.getInt("typeId")); goods.getType().setName(rs.getString("typeName")); result.add(goods); } //释放资源 DbUtil.close(rs, psmt, conn); } catch (Exception e) { System.out.println(e.getMessage()); } return result; } @Override public List<Goods> selectGoodsByIds(String ids) { List<Goods> result = null; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "SELECT g.id,g.name,g.price,g.description,g.stock,g.image1,g.image2,g.image3,g.image4,g.image5,g.createtime,t.id typeId,t.name typeName FROM tbl_goods g LEFT JOIN tbl_type t ON g.type_id=t.id WHERE g.id IN (" + ids + ") ORDER BY g.id DESC"; PreparedStatement psmt = conn.prepareStatement(sql); //执行操作，返回查询结果集 ResultSet rs = psmt.executeQuery(); result = new ArrayList<>(); while (rs.next()) { Goods goods = new Goods(); goods.setId(rs.getInt("id")); goods.setName(rs.getString("name")); goods.setPrice(rs.getFloat("price")); goods.setDescription(rs.getString("description")); goods.setStock(rs.getInt("stock")); goods.setImage1(rs.getString("image1")); goods.setImage2(rs.getString("image2")); goods.setImage3(rs.getString("image3")); goods.setImage4(rs.getString("image4")); goods.setImage5(rs.getString("image5")); goods.setCreateTime(rs.getTimestamp("createtime")); goods.getType().setId(rs.getInt("typeId")); goods.getType().setName(rs.getString("typeName")); result.add(goods); } //释放资源 DbUtil.close(rs, psmt, conn); } catch (Exception e) { System.out.println(e.getMessage()); } return result; } @Override public Integer deleteGoodsByIds(String ids) { Integer result = -999; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "DELETE FROM tbl_goods WHERE id IN (" + ids + ")"; PreparedStatement psmt = conn.prepareStatement(sql); //执行操作，返回影响行数 result = psmt.executeUpdate(); //释放资源 DbUtil.close(null, psmt, conn); } catch (Exception e) { System.out.println(e.getMessage()); } return result; } @Override public Integer selectForRecordCount(Integer searchId, String keyword) { Integer result = 0; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "SELECT COUNT(*) FROM tbl_goods "; if (searchId > 0) { sql = sql + "WHERE type_id = ? AND name LIKE ? "; } else { sql = sql + "WHERE name LIKE ? "; } sql = sql + "ORDER BY id DESC"; PreparedStatement psmt = conn.prepareStatement(sql); if (searchId > 0) { psmt.setInt(1, searchId); psmt.setString(2, "%" + keyword + "%"); } else { psmt.setString(1, "%" + keyword + "%"); } //执行操作，返回查询结果集 ResultSet rs = psmt.executeQuery(); if (rs.next()) { result = rs.getInt(1); } //释放资源 DbUtil.close(rs, psmt, conn); } catch (Exception e) { System.out.println(e.getMessage()); } return result; } @Override public List<Goods> selectForPageItems(Integer offset, Integer rows, Integer searchId, String keyword) { List<Goods> result = null; try { //获取数据库连接对象 Connection conn = DbUtil.getConnection(); //创建预处理命令对象 String sql = "SELECT g.id,g.name,g.price,g.description,g.stock,g.image1,g.image2,g.image3," + "g.image4,g.image5,g.createtime,t.id typeId,t.name typeName " + "FROM tbl_goods g LEFT JOIN tbl_type t ON g.type_id=t.id "; if (searchId > 0) { sql = sql + "WHERE t.id = ? AND g.name LIKE ? "; } else { sql = sql + "WHERE g.name LIKE ? "; } sql = sql + "ORDER BY g.id DESC LIMIT ?,?"; PreparedStatement psmt = conn.prepareStatement(sql); //设置传入参数 if (searchId > 0) { psmt.setInt(1, searchId); psmt.setString(2, "%" + keyword + "%"); psmt.set