package com.mall.daoimpl;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.mall.common.DbUtil;
import com.mall.dao.GoodsDao;
import com.mall.po.BuyRecord;
import com.mall.po.Goods;
import com.mall.po.Page;
public class GoodsDaoImpl implements GoodsDao {
/**
* 显示商品
* @param type 显示类别（热卖，新商品，降价,特别推荐）
* @param flag 表示是否是（热卖，新商品，降价）
*/
public List showGoods(int type,int flag){
List all = new ArrayList();
PreparedStatement pstmt = null;
DbUtil dbUtil = null;
ResultSet rs = null;
String sql = null;
if(type==0){
//显示所有商品
sql = "select * from tb_goods";
try {
dbUtil = new DbUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()) {
Goods Goods = new Goods();
Goods.setGoodsId(rs.getInt("bookId"));
Goods.setGoodsName(rs.getString("GoodsName"));
Goods.setISBN(rs.getString("ISBN"));
Goods.setProduceDate(rs.getString("produceDate"));
Goods.setAuthor(rs.getString("author"));
Goods.setPublisher(rs.getString("publisher"));
Goods.setIntroduce(rs.getString("introduce"));
Goods.setPrice(rs.getFloat("price"));
Goods.setNowPrice(rs.getFloat("nowPrice"));
Goods.setPicture(rs.getString("picture"));
all.add(Goods);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
rs.close();
pstmt.close();
dbUtil.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}else {
if(type==1) {
//热卖商品
sql = "select * from tb_goods where hostGoods=?";
}
if(type==2){
//新到商品
sql = "select * from tb_goods where newGoods=?";
}
if(type==3){
//打折商品
sql = "select * from tb_goods where saleGoods=?";
}
if(type==4){
// 特别推荐
sql = "select * from tb_goods where specialGoods=?";
}
if(type==9){
// 分类查看
sql = "select * from tb_goods where superTypeId=?";
}
try {
dbUtil = new DbUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
pstmt.setInt(1, flag);
rs = pstmt.executeQuery();
while(rs.next()) {
Goods Goods = new Goods();
Goods.setGoodsId(rs.getInt("bookId"));
Goods.setGoodsName(rs.getString("goodsName"));
Goods.setISBN(rs.getString("ISBN"));
Goods.setProduceDate(rs.getString("produceDate"));
Goods.setAuthor(rs.getString("author"));
Goods.setPublisher(rs.getString("publisher"));
Goods.setIntroduce(rs.getString("introduce"));
Goods.setPrice(rs.getFloat("price"));
Goods.setNowPrice(rs.getFloat("nowPrice"));
Goods.setPicture(rs.getString("picture"));
all.add(Goods);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
rs.close();
pstmt.close();
dbUtil.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return all;
}
public boolean updateGoodsNum(int num,int GoodsId) {
DbUtil daoUtil = null;
PreparedStatement ps = null;
String sql = "update tb_goods set GoodsNum=? where bookId=?";
try {
daoUtil = new DbUtil();
ps = daoUtil.getCon().prepareStatement(sql);
ps.setInt(1, num);
ps.setInt(2, GoodsId);
int i = ps.executeUpdate();
if(i != 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
ps.close();
daoUtil.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return false;
}
public boolean updateGoods(Goods Goods){
DbUtil daoUtil = null;
PreparedStatement ps = null;
String sql = "update tb_goods set goodsName=?,goodsNum=?,introduce=?,ISBN=?,author=?,superTypeId=?,subTypeId=?,publisher=?,price=?,nowPrice=?," +
"pages=?,hostGoods=?,newGoods=?,saleGoods=?,specialGoods=? where bookId=?";
try {
daoUtil = new DbUtil();
ps = daoUtil.getCon().prepareStatement(sql);
ps.setString(1, Goods.getGoodsName());
ps.setInt(2, Goods.getGoodsNum());
ps.setString(3, Goods.getIntroduce());
ps.setString(4, Goods.getISBN());
ps.setString(5, Goods.getAuthor());
ps.setInt(6, Goods.getSuperTypeId());
ps.setInt(7, Goods.getSubTypeId());
ps.setString(8, Goods.getPublisher());
ps.setFloat(9, Goods.getPrice());
ps.setFloat(10, Goods.getNowPrice());
ps.setString(11, Goods.getProduceDate());
ps.setInt(12, Goods.getHostGoods());
ps.setInt(13, Goods.getNewGoods());
ps.setInt(14, Goods.getSaleGoods());
ps.setInt(15, Goods.getSpecialGoods());
ps.setInt(16, Goods.getGoodsId());
int i = ps.executeUpdate();
if(i != 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
ps.close();
daoUtil.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return false;
}
/**
* 根据商品的GoodsId号来展示该商品的详细信息
* @param GoodsId 商品号
* @return Goods
*/
public Goods showGoodsById(int GoodsId){
Goods Goods = new Goods();
PreparedStatement pstmt = null;
ResultSet rs = null;
DbUtil dbUtil = null;
String sql = "select * from tb_goods where bookId=?";
try {
dbUtil = new DbUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
pstmt.setInt(1, GoodsId);
rs = pstmt.executeQuery();
if(rs.next()){
Goods.setGoodsId(rs.getInt("bookId"));
Goods.setGoodsName(rs.getString("goodsName"));
Goods.setIntroduce(rs.getString("introduce"));
Goods.setISBN(rs.getString("ISBN"));
Goods.setAuthor(rs.getString("author"));
Goods.setProduceDate(rs.getString("produceDate"));
Goods.setSuperTypeId(rs.getInt("superTypeId"));
Goods.setSubTypeId(rs.getInt("subTypeId"));
Goods.setPublisher(rs.getString("publisher"));
Goods.setPrice(rs.getFloat("price"));
Goods.setNowPrice(rs.getFloat("nowPrice"));
Goods.setPicture(rs.getString("picture"));
Goods.setGoodsNum(rs.getInt("goodsNum"));
Goods.setHostGoods(rs.getInt("hostGoods"));
Goods.setNewGoods(rs.getInt("newGoods"));
Goods.setSaleGoods(rs.getInt("saleGoods"));
Goods.setSpecialGoods(rs.getInt("specialGoods"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
rs.close();
pstmt.close();
dbUtil.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return Goods;
}
public List showBuyRecordsById(int GoodsId){
List searchList = new ArrayList();
PreparedStatement pstmt = null;
ResultSet rs = null;
DbUtil dbUtil = null;
String sql = "select B.name,A.goodsNum,B.orderDate from tb_orderitem A, tb_order B where A.orderId=B.orderId and A.bookId="+GoodsId+"";
try
{
dbUtil = new DbUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
BuyRecord brc = new BuyRecord();
brc.setName(rs.getString("name"));
brc.setGoodsNum(rs.getInt("goodsNum"));
brc.setOrderDate(rs.getString("orderDate"));
searchList.add(brc);
}
} catch (SQLException e) {
e.printStackTrace();
}
return searchList;
}
/**
* 将商品本信息录入数据库
*/
public boolean addGoods(Goods Goods){
boolean flag = false;
PreparedStatement pstmt = null;
DbUtil dbUtil = null;
String sql = "insert into tb_goods values(null,?,?,?,?,?,?,?,?,?,?,?,null,?,?,?,?)";
try {
dbUtil = new DbUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
pstmt.setInt(1, Goods.getSuperTypeId());
pstmt.setInt(
毕业设计小型网上零食销售系统的设计与实现
5星 · 超过95%的资源 需积分: 49 84 浏览量
2017-10-12
10:17:43
上传
评论 18
收藏 4.16MB ZIP 举报 
毕业设计小型网上零食销售系统的设计与实现 （673个子文件） 
GoodsDaoImpl.class 14KB AdminOrderDaoImpl.class 14KB UserDaoImpl.class 13KB Model.class 12KB AdminGoodsDaoImpl.class 10KB AdminDaoImpl.class 9KB AdminInformDaoImpl.class 6KB AdminUserDaoImpl.class 6KB AdminAdminDaoImpl.class 5KB OrderDaoImpl.class 5KB AdminNoteDaoImpl.class 5KB UpdateGoodsServlet.class 4KB AddGoodsServlet.class 4KB AdminSubTypeDaoImpl.class 4KB Goods.class 4KB AdminSuperTypeDaoImpl.class 4KB AdminTypeDaoImpl.class 4KB AddOrderServlet.class 3KB RandomCodeServlet.class 3KB AdminLoginDaoImpl.class 3KB User.class 3KB AdminLoginServlet.class 3KB UpdatePassword.class 3KB DetailSearch.class 3KB WordsFilter.class 3KB AdminSendOrderServlet.class 3KB UpdateAdminServlet.class 3KB LoginServlet.class 3KB UpdateUserTrue.class 3KB ShowSubTypeServlet.class 3KB GetOrderNotSendPagerServlet.class 3KB GetOrderFreezePagerServlet.class 3KB GetOrderSendPagerServlet.class 3KB GetGoodsPagerServlet.class 3KB GetAdminPagerServlet.class 3KB GetUserPagerServlet.class 3KB GetSubTypeBySuperTypeId.class 2KB FindUser.class 2KB BuyGoodsServlet.class 2KB AdminLoginListener.class 2KB IndexServlet.class 2KB RegisterServlet.class 2KB GetOrderPagerServlet.class 2KB Cart.class 2KB GetGoodsByGoodsNameServlet.class 2KB DeleteOrderServlet.class 2KB UserLoginListener.class 2KB HttpReqWrapper.class 2KB Order.class 2KB PageServlet.class 2KB GetInformPagerServlet.class 2KB DeleteFreezeOrderServlet.class 2KB GetAdminType.class 2KB PageSearchServlet.class 2KB GetNotePagerServlet.class 2KB FreezeOrderServlet.class 2KB DeleteInformServlet.class 2KB DeleteAdminsServlet.class 2KB DeleteGoodsServlet.class 2KB DeleteUserServlet.class 2KB DeleteNoteServlet.class 2KB AddAdminServlet.class 2KB GetSuperType.class 2KB AddSubTypeServlet.class 2KB GetGoodsByTypeServlet.class 2KB GetAllGoodsNameServlet.class 2KB SubTypeDaoImpl.class 2KB AddInformServlet.class 2KB UpdataPwd.class 2KB CheckLogin_Note.class 2KB AddSuperTypeServlet.class 2KB GetOneAdminServlet.class 2KB GetOneUserServlet.class 2KB CheckSuperTypeIsExist.class 2KB CheckLoginNameIsExist.class 2KB CheckGoodsNameIsExist.class 2KB CheckSubTypeIsExist.class 2KB SuperTypeDaoImpl.class 2KB PageNoteServlet.class 2KB SonOrder.class 2KB CheckISBNIsExist.class 2KB AdminUpdatePassword.class 2KB AdminLoginFilter.class 2KB AddNoteServlet.class 2KB CheckNameExist.class 2KB InformDaoImpl.class 2KB CheckRandomCode.class 2KB ShowAllGoodsByType.class 2KB SearchServlet.class 2KB OneUserManameServlet.class 2KB GetNotSendOrderServlet.class 2KB CheckCode.class 2KB UpdateGoodServlet.class 2KB GetSendOrderServlet.class 2KB ShowGoodsByIdServlet.class 2KB GetOneOrderServlet.class 2KB UpdateGoodsCount.class 2KB GetOneInformServlet.class 2KB ShowNoteServlet.class 2KB CheckLogin.class 2KB共 673 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
weixin_428155592020-04-17这个URL访问路径是什么
weixin_421238032018-09-06作者在上传一个软件文档就好了
