Java实现的购物商城，可用作毕业设计，课程设计

package com.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import com.entity.CommentInfo; import com.entity.GoodsInfo; /** * 商品操作类 * @author Administrator * */ public class GoodsCtrl { /** * 添加商品方法 * @param goods * @return */ public int addGoods(GoodsInfo goods){ int res =0; Connection conn =ConnDB.getConn(); PreparedStatement stmt =null; String sql ="insert into GoodsInfo values(?,?,?,?,?,?,?,?,?,?,?,?)"; try { stmt =conn.prepareStatement(sql); stmt.setString(1, goods.getGoodsname()); stmt.setString(2, goods.getGoodssort()); stmt.setDouble(3, goods.getGoodsprice()); stmt.setDouble(4, goods.getGoodscarr()); stmt.setString(5, goods.getGoodsaddr()); stmt.setString(6, goods.getGoodsimg()); stmt.setString(7, goods.getGoodstuijian()); stmt.setString(8, goods.getGoodsxianliang()); stmt.setString(9, goods.getGoodstejia()); stmt.setString(10, goods.getGoodscuxiao()); stmt.setString(11, goods.getGoodszt()); stmt.setString(12, goods.getGoodsintro()); res =stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(null, stmt, conn); } return res; } /*==商品列表数据分页==*/ /** * 根据当前页数和每页显示的行数来查询相应的结果 * * @param pageSize * 每页显示的行数 * @param pageNow * 当前的页数 * @return */ public ArrayList<GoodsInfo> getGoodsForPage(int pageSize, int pageNow) { ArrayList<GoodsInfo> agoods = null; Connection conn = ConnDB.getConn(); Statement stmt = null; ResultSet rs = null; String sql = "select Top " + pageSize + " * from GoodsInfo where goodsId not in(select Top (" + pageSize + " * (" + pageNow + "- 1)) goodsId from GoodsInfo)"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ if(agoods==null){ agoods=new ArrayList<GoodsInfo>(); } GoodsInfo goods = new GoodsInfo(); goods.setGoodsId(rs.getInt("goodsId")); goods.setGoodsname(rs.getString("goodsName")); goods.setGoodssort(rs.getString("goodsSort")); goods.setGoodsprice(rs.getDouble("goodsPrice")); goods.setGoodscarr(rs.getDouble("goodsCarr")); goods.setGoodsaddr(rs.getString("goodsAddr")); goods.setGoodsimg(rs.getString("goodsImg")); goods.setGoodszt(rs.getString("goodsZt")); agoods.add(goods); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(rs, stmt, conn); } return agoods; } /** * 获取总页数 * @param pageSize * @return */ public int getGoodsCount(int pageSize){ int pageCount = 0; int goodsCount = 0;//获取到商品的总数 Connection conn = ConnDB.getConn(); Statement stmt = null; ResultSet rs = null; String sql = "select count(*) as goodsCount from GoodsInfo"; try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql); if(rs.next()){ goodsCount = rs.getInt("goodsCount"); } //页数计算 if(goodsCount % pageSize == 0){ pageCount = goodsCount / pageSize; }else{ pageCount = goodsCount / pageSize + 1; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(rs, stmt, conn); } return pageCount; } /** * 根据ID查询商品方法 * @param goodsId * @return */ public GoodsInfo selgoods(int goodsId){ GoodsInfo goods = null; Connection conn = ConnDB.getConn(); Statement stmt = null; ResultSet rs = null; String sql = "select * from GoodsInfo where goodsId=" + goodsId; try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql); if(rs.next()){ goods = new GoodsInfo(); goods.setGoodsId(rs.getInt("goodsId")); goods.setGoodsname(rs.getString("goodsName")); goods.setGoodssort(rs.getString("goodsSort")); goods.setGoodsprice(rs.getDouble("goodsPrice")); goods.setGoodscarr(rs.getDouble("goodsCarr")); goods.setGoodsaddr(rs.getString("goodsAddr")); goods.setGoodsimg(rs.getString("goodsImg")); goods.setGoodstuijian(rs.getString("goodsTuijian")); goods.setGoodsxianliang(rs.getString("goodsXianliang")); goods.setGoodstejia(rs.getString("goodsTejia")); goods.setGoodscuxiao(rs.getString("goodsCuxiao")); goods.setGoodszt(rs.getString("goodsZt")); goods.setGoodsintro(rs.getString("goodsIntro")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(rs, stmt, conn); } return goods; } /** * 修改商品方法 */ public int updateGoods(GoodsInfo goods){ int res = 0; Connection conn =ConnDB.getConn(); PreparedStatement stmt = null; String sql = "update GoodsInfo set goodsName=?,goodsSort=?,goodsPrice=?,goodsCarr=?,goodsAddr=?,goodsImg=?,goodsTuijian=?,goodsXianliang=?,goodsTejia=?,goodsCuxiao=?,goodsZt=?,goodsIntro=?" +" where goodsId=?"; try { stmt =conn.prepareStatement(sql); stmt.setString(1, goods.getGoodsname()); stmt.setString(2, goods.getGoodssort()); stmt.setDouble(3, goods.getGoodsprice()); stmt.setDouble(4, goods.getGoodscarr()); stmt.setString(5, goods.getGoodsaddr()); stmt.setString(6, goods.getGoodsimg()); stmt.setString(7, goods.getGoodstuijian()); stmt.setString(8, goods.getGoodsxianliang()); stmt.setString(9, goods.getGoodstejia()); stmt.setString(10, goods.getGoodscuxiao()); stmt.setString(11, goods.getGoodszt()); stmt.setString(12, goods.getGoodsintro()); stmt.setInt(13, goods.getGoodsId()); res = stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(null, stmt, conn); } return res; } /** * 根据ID删除商品 * @param userId * @return */ public int deleteGoods(int goodsId){ int res = 0; String sql = "delete GoodsInfo where goodsId=?"; Connection conn = ConnDB.getConn(); PreparedStatement stmt = null; try { stmt = conn.prepareStatement(sql); stmt.setInt(1, goodsId); res = stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(null, stmt, conn); } return res; } /*==推荐、限量、特价、促销商品搜索数据分页==*/ /** * 根据导航栏连接搜索商品 * * 根据当前页数和每页显示的行数来查询相应的结果 * * @param pageSize * 每页显示的行数 * @param pageNow * 当前的页数 * @param tj * 查询条件：（推荐、特价等） * @return */ public ArrayList<GoodsInfo> getDaohlGoods(int pageSize, int pageNow,String tj) { ArrayList<GoodsInfo> agoods = null; Connection conn = ConnDB.getConn(); Statement stmt = null; ResultSet rs = null; String sql = "select Top " + pageSize + " * from GoodsInfo where goodsId not in(select Top (" + pageSize + " * (" + pageNow + "- 1)) goodsId from GoodsInfo) and "+tj+"='true' and goodsZt='true' order by goodsId desc"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ if(agoods==null){ agoods=new ArrayList<GoodsInfo>(); } GoodsInfo goods = new GoodsInfo(); goods.setGoodsId(rs.getInt("goodsId")); goods.setGoodsname(rs.getString("goodsName")); goods.setGoodsprice(rs.getDouble("goodsPrice")); goods.setGoodsimg(rs.getString("goodsImg")); agoods.add(goods); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ ConnDB.close(rs, stmt