package com.SchoolyardShop.daoImp;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.SchoolyardShop.dao.IGoodsDao;
import com.SchoolyardShop.model.Goods;
public class GoodsDaoImp implements IGoodsDao {
public int deleteOneGoods(String GoodsId) {
String sql = "delete from Goods where GoodsId='"+GoodsId+"'";
return dbhandle.executeupdate(sql);
}
public int deleteTypeGoods(String TypeId) {
String sql = "delete from Goods where TypeId='"+TypeId+"'";
return dbhandle.executeupdate(sql);
}
public List fuzzy_query(String TypeId, String key) {
String sql = "select * from Goods where TypeId='"+TypeId+"' and GoodsName like '%"+key+"%'";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
list.add(goods);
}
return list;
} catch (SQLException e) {
System.out.println("模糊查询Goods表失败");
return null;
}
}
public int insertTypeGoods(Goods goods) {
String sql = "insert into Goods values('"+goods.getTypeId()
+"','"+goods.getPordId()+"','"+goods.getGoodsName()
+"','"+goods.getNowPrice()+"','"+goods.getGoodsDiscount()
+"','"+goods.getPordName()+"','"+goods.getBewrite()
+"','"+goods.getIsPreferred()+"','"+goods.getPicturePath()+"')";
return dbhandle.executeupdate(sql);
}
public Goods selectOneGoods(String GoodsId) {
String sql = "select * from Goods where GoodsId='"+GoodsId+"'";
ResultSet rs = dbhandle.executeQuery(sql);
try {
if(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
return goods;
}else{
return null;
}
} catch (SQLException e) {
System.out.println("查询一个商品失败");
return null;
}
}
public List selectTypeGoods(String TypeId) {
String sql = "select * from Goods where TypeId='"+TypeId+"'";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
list.add(goods);
}
return list;
} catch (SQLException e) {
System.out.println("查询某个类的所有商品失败");
return null;
}
}
public int updateGoods(Goods goods) {
String sql = "update Goods set TypeId='"+goods.getTypeId()+"',PordId='"+goods.getPordId()
+"',GoodsName='"+goods.getGoodsName()+"',NowPrice='"+goods.getNowPrice()
+"',GoodsDiscount='"+goods.getGoodsDiscount()+"',PordName='"+goods.getPordName()
+"',Bewrite='"+goods.getBewrite()+"',IsPreferred='"+goods.getIsPreferred()
+"',PicturePath='"+goods.getPicturePath()+"' where GoodsId='"+goods.getGoodsId()+"'";
return dbhandle.executeupdate(sql);
}
public List selectAllGoods() {
String sql = "select * from Goods";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
list.add(goods);
}
return list;
} catch (SQLException e) {
System.out.println("查询所有商品失败");
return null;
}
}
public int selectGoodsId() {
int i;
String sql = "select max(GoodsId) from Goods";
ResultSet rs = dbhandle.executeQuery(sql);
try {
if(rs.next()){
return i = rs.getInt(1);
}else{
return -1;
}
} catch (SQLException e) {
System.out.println("查询商品ID失败");
return -1;
}
}
public List selectRecommendGoods() {
String sql = "select * from Goods where IsPreferred='1'";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
list.add(goods);
}
return list;
} catch (SQLException e) {
System.out.println("查询推荐商品失败");
return null;
}
}
public List selectNewGoods() {
String sql = "select top 10 * from Goods,Storage where Goods.GoodsId=Storage.GoodsId order by ImpAndExpDate desc";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPreferred"));
goods.setPicturePath(rs.getString("picturePath"));
list.add(goods);
System.out.print("00000");
}
return list;
} catch (SQLException e) {
System.out.println("查询最新商品失败");
return null;
}
}
public List selectTJGoods() {
String sql = "select * from Goods";
ResultSet rs = dbhandle.executeQuery(sql);
List list = new ArrayList();
try {
while(rs.next()){
Goods goods = new Goods();
goods.setGoodsId(rs.getString("goodsId"));
goods.setTypeId(rs.getString("typeId"));
goods.setPordId(rs.getString("pordId"));
goods.setGoodsName(rs.getString("goodsName"));
goods.setNowPrice(rs.getString("nowPrice"));
goods.setGoodsDiscount(rs.getString("goodsDiscount"));
goods.setPordName(rs.getString("pordName"));
goods.setBewrite(rs.getString("bewrite"));
goods.setIsPreferred(rs.getString("isPr
校园购物网(J2EE)
需积分: 9 85 浏览量
2010-01-01
21:24:31
上传
评论
收藏 4.27MB RAR 举报
校园购物网(J2EE) （553个子文件） 
javascript10.chm 258KB GoodsAction.class 7KB GoodsDaoImp.class 7KB OrderDaoImp.class 5KB OOdAction.class 5KB StorageDaoImp.class 4KB Goods_catAction.class 4KB UserAction.class 4KB OrderAction.class 4KB GoodsStorageForm.class 4KB UserDaoImp.class 3KB ProviderAction.class 3KB GoodsStorageAction.class 3KB ProviderDaoImp.class 3KB OOdForm.class 3KB GoodsForm.class 3KB StorageForm.class 3KB Goods_catForm.class 3KB OrderForm.class 3KB LWAction.class 3KB TypeDaoImp.class 3KB Order_detailDaoImp.class 3KB LeaveWordDaoImp.class 3KB StorageAction.class 2KB AdminAction.class 2KB Goods.class 2KB SetOrderId.class 2KB Order.class 2KB Test.class 2KB Storage.class 2KB LWForm.class 2KB GoodsServiceImp.class 2KB UserForm.class 2KB AdminDaoImp.class 2KB ServiceFactory.class 2KB Order_detailForm.class 2KB ProviderForm.class 2KB Order_detailAction.class 2KB LeaveWord.class 2KB DaoFactory.class 2KB TypeServiceImp.class 2KB OrderServiceImp.class 2KB User.class 1KB AdminForm.class 1KB T.class 1KB DbHandle.class 1KB Order_detail.class 1KB Provider.class 1KB StorageServiceImp.class 1KB UserServiceImp.class 1KB DbConnSql.class 1KB ProviderServiceImp.class 1KB Test3.class 1KB TestTJGoods.class 1KB Torder.class 1KB DbConn_J_O.class 1KB LeaveWordServiceImp.class 992B DbFactory.class 992B TestSetOrderId.class 958B IGoodsDao.class 947B IGoodsService.class 924B IOrderService.class 913B Order_detailServiceImp.class 912B ActionServlet.class 902B AdminServiceImp.class 899B ITypeService.class 790B Type.class 757B IOrderDao.class 756B Admin.class 752B TTT.class 714B IUserService.class 714B IUserDao.class 708B IStorageService.class 708B IStorageDao.class 693B IProviderService.class 676B IDbHandle.class 672B SetQty.class 662B IProviderDao.class 659B ITypeDao.class 651B IOrder_detailDao.class 608B ILeaveWordService.class 601B IOrder_detailService.class 587B ILeaveWordDao.class 579B IAdminService.class 573B IAdminDao.class 561B ReadInoFile.class 408B IDbConn.class 167B .classpath 949B normal.css 6KB index.css 4KB index.css 4KB style.css 4KB style.css 4KB Thumbs.db 364KB Thumbs.db 322KB Thumbs.db 25KB Thumbs.db 11KB Thumbs.db 10KB
loginbg2.gif 36KB main_logo.gif 7KB共 553 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
DLoveJForever
- 粉丝: 2
- 资源: 4
最新资源
- 基于Pytorch复现Point-Transformer，用于ShapeNet数据集点云分割
- 【医学影像分析】2D超声图像的分割检测（Ultrasound Nerve Segmentation - Kaggle数据集）
- 嘎嘎香的五款神仙谷歌插件
- .arch书源导入教程.mp4
- 贪心算法介绍及代码示例讲解
- CR13SP35MSI64 Crystal 水晶报表运行组件最后版本64位
- 图像分类数据集：玉米叶是否感染分类数据集（2分类，包含训练集、验证集）
- 小U商城.zip
- 高光谱图像计算机视觉分类图像预处理工具集，包含去除图片无关背景，数据增强，生成标签文件等功能
- (顶刊复现)基于配电网韧性提升的应急移动电源预配置和动态调度(下)-MPS动态调度
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
