package com.mpshop.dao.goods;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import com.csuinfo.until.DBUtil;
import com.mpshop.util.DBManager;
import com.mpshop.util.PageInfo;
import com.mpshop.vo.GoodsVo;
import com.mpshop.vo.ProCondition;
public class GoodsDao {
public List<GoodsVo> getMainPageGoods() {
Connection conn = DBManager.getConnection();
String sql = "select goods_id,img_uri,this_price,goods_name,descript,show_title from (select rownum r,goods.* from goods) t where r<19";
String[] fields = new String[] { "goodsId", "imgUri", "realPrice",
"goodsName", "descript", "showTitle" };
List<GoodsVo> l = DBUtil.getVoList(GoodsVo.class, conn, sql, null,
fields);
DBManager.close(conn);
return l;
}
public GoodsVo getById(int id) {
Connection conn = DBManager.getConnection();
String sql = "select g.goods_id,g.class_id,g.brand_id,g.market_price,g.this_price,"
+ "g.look_times,g.sold_num,g.ori_makeup,g.sele_makeup,g.capability,"
+ "g.img_uri,g.goods_state,g.goods_num,g.descript,g.show_title,"
+ "g.goods_size,c.class_name,b.brand_name,"
+ "b.img_url from goods g,goods_class c,goods_brand b "
+ "where g.goods_id="
+ id
+ " and g.class_id=c.class_id "
+ " and g.brand_id=b.brand_id";
String[] fields = new String[] { "goodsId", "classId", "brandId",
"marketPrice", "realPrice", "lookTimes", "soldNumber",
"oriMakeup", "seleMakeup", "capability", "imgUri",
"goodsState", "goodsNumber", "descript", "showTitle",
"goodsSize", "className", "brandName", "brandImgUri" };
GoodsVo goods = DBUtil
.getVoList(GoodsVo.class, conn, sql, null, fields).get(0);
DBManager.close(conn);
return goods;
}
public boolean updateLookTimes(int id) {
Connection conn = DBManager.getConnection();
String sql = "update goods set look_times=look_times+1 where goods_id="
+ id;
PreparedStatement ps = null;
int count = 0;
try {
ps = conn.prepareStatement(sql);
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
DBManager.close(conn);
return count > 0;
}
public PageInfo<GoodsVo> splitQuery(ProCondition cd) {
PageInfo<GoodsVo> page = new PageInfo<GoodsVo>();
String bb="select a.*,gc.class_name,gbr.brand_name from Goods a,goods_class gc,goods_brand gbr where a.class_id=gc.class_id and a.brand_id=gbr.brand_id ";
int currentPage=cd.getCurrentPage();
StringBuilder builder=new StringBuilder();
builder.append(bb);
if(cd.getBrandId()!=0){
builder.append(" and gbr.brand_Id="+cd.getBrandId());
}
if(cd.getClassId()!=0){
builder.append(" and gc.class_Id="+cd.getClassId());
}
if(cd.getCapability()!=0){
builder.append(" and a.capability="+cd.getCapability());
}
if(cd.getGoodSize()!=0){
builder.append(" and a.goods_size="+cd.getGoodSize());
}
if(cd.getMinPrice()!=0){
builder.append(" and a.this_price>="+cd.getMinPrice());
}
if(cd.getMaxPrice()!=0){
builder.append(" and a.this_price<="+cd.getMaxPrice());
}
String base=builder.toString();
if(cd.getParamId()!=0){
base="select base.*,gp.param_id,gp.param_value,p.param_name,p.param_type from ("+base+") base,goods_params gp,params p where base.goods_id=gp.goods_id and gp.param_id=p.param_id and p.param_id="+cd.getParamId();
}
String sql1="select count(*) from ("+base+")";
Connection conn = DBManager.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
int totalSize=0;
try {
ps=conn.prepareStatement(sql1);
rs=ps.executeQuery();
rs.next();
totalSize=rs.getInt(1);
int pageSize=16;
page.setPageSize(pageSize);
int temp=totalSize/page.getPageSize();
int totalPage=(totalSize%page.getPageSize()>0?temp+1:temp);
page.setCurrentPage(currentPage);
page.setTotalCount(totalSize);
page.setTotalPage(totalPage);
String sql ="select rownum r,d.* from ("+base+") d";
String sql3="select t.goods_num,t.sold_num, t.goods_id,t.img_uri,t.this_price,t.goods_name,t.descript,t.show_title,t.class_name,t.brand_name from ("+sql+") t where t.r>"+(currentPage-1)*16+" and t.r<="+currentPage*16;
String[] fields = new String[] {"goodsNumber","soldNumber", "goodsId", "imgUri", "realPrice",
"goodsName", "descript", "showTitle","className","brandName" };
List<GoodsVo> l=DBUtil.getVoList(GoodsVo.class,conn,sql3,null,fields);
page.setLstPage(l);
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBManager.close(conn, ps, rs);
}
return page;
}
public PageInfo<GoodsVo> getMpGoods(int classId1,int classId2){
PageInfo<GoodsVo> page = new PageInfo<GoodsVo>();
Connection conn=DBManager.getConnection();
String sql1="select count(*) from goods";
PreparedStatement ps=null;
ResultSet rs=null;
int totalCount=0;
try {
ps=conn.prepareStatement(sql1);
rs=ps.executeQuery();
rs.next();
totalCount=rs.getInt(1);
int pageSize=16;
int temp=totalCount/page.getPageSize();
int totalPage=(totalCount%page.getPageSize()>0?temp+1:temp);
page.setCurrentPage(1);
page.setPageSize(pageSize);
page.setTotalCount(totalCount);
page.setTotalPage(totalPage);
String sql2="select goods_id,img_uri,this_price,goods_name,descript,show_title from (select rownum r,goods.* from goods where class_id="+classId1+" or class_id="+classId2+") t where r<="+16;
String[] fields = new String[] { "goodsId", "imgUri", "realPrice",
"goodsName", "descript", "showTitle" };
List<GoodsVo> l=DBUtil.getVoList(GoodsVo.class,conn,sql2,null,fields);
page.setLstPage(l);
} catch (SQLException e) {
e.printStackTrace();
}
return page;
}
public PageInfo<GoodsVo> getMpGoods(int classId1){
PageInfo<GoodsVo> page = new PageInfo<GoodsVo>();
Connection conn=DBManager.getConnection();
String sql1="select count(*) from goods";
PreparedStatement ps=null;
ResultSet rs=null;
int totalCount=0;
try {
ps=conn.prepareStatement(sql1);
rs=ps.executeQuery();
rs.next();
totalCount=rs.getInt(1);
int pageSize=16;
int temp=totalCount/page.getPageSize();
int totalPage=(totalCount%page.getPageSize()>0?temp+1:temp);
page.setCurrentPage(1);
page.setPageSize(pageSize);
page.setTotalCount(totalCount);
page.setTotalPage(totalPage);
String sql2="select goods_id,img_uri,this_price,goods_name,descript,show_title from (select rownum r,goods.* from goods where class_id="+classId1+") t where r<="+16;
String[] fields = new String[] { "goodsId", "imgUri", "realPrice",
"goodsName", "descript", "showTitle" };
List<GoodsVo> l=DBUtil.getVoList(GoodsVo.class,conn,sql2,null,fields);
page.setLstPage(l);
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBManager.close(conn, ps);
DBManager.close(rs);
}
return page;
}
public boolean insert(GoodsVo goods){
boolean flag=false;
Connection conn=DBManager.getConnection();
String sql="insert into goods values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
String sql2="insert into goods_params values(?,?,?)";
// String[] fields1 = new String[] { "goodsId", "goodsName","classId","brandId",
// "marketPrice", "realPrice", "lookTimes", "soldNumber",
// "oriMakeup", "seleMakeup", "capability","goodsSize", "imgUri",
// "goodsState", "goodsNumber", "showTitle","descript"
// };
String[] fields1 = new String[] { "goodsId","classId","brandId",
"marketPrice", "realPrice", "lookTimes", "soldNumber",
"oriMakeup", "seleMakeup", "capability", "imgUri",
"goodsState", "goodsNumber","descript","goodsName", "showTitle","goodsSize"
};
String[] fields2=new String[]{"goodsId","paramId","paramValue"};
try {
conn.setAutoCommit(false);
DBUtil.insert
数码产品网上销售管理系统设计和开发 （899个子文件） 
nav.js.bak 2KB GoodsDao.class 10KB AdminDao.class 9KB OrderDao.class 8KB GoodsVo.class 6KB GoodsBrandDao.class 6KB OrderForm.class 5KB NewsDao.class 5KB UsersVo.class 5KB VipDao.class 5KB UploadUtil.class 5KB OrdersDao.class 5KB Query_newsdao.class 5KB Back_commentDao.class 4KB GoodsClassDao.class 4KB ParamDao.class 4KB Back_consultationDao.class 4KB DBManager.class 4KB AddGoodsAction.class 4KB ProvinceDao.class 4KB SplitTag.class 4KB StatDao.class 4KB MakeOrderAction.class 4KB CollectionDao.class 4KB ConsultationDao.class 4KB ProCondition.class 4KB UpdateCartAction.class 4KB DateConvertor.class 3KB UpdateGoodsAction.class 3KB DeleteCartProAction.class 3KB GoodsParamDao.class 3KB OrderLoginAction.class 3KB PayForAction.class 3KB UsersDao.class 3KB CheckLogin.class 3KB ModifyGoodsAction.class 3KB SearchOrderAction.class 3KB ModifyEmp.class 3KB GetPasswordDao.class 3KB AddEmpAction.class 3KB CommentDao.class 3KB LoginAction.class 3KB ContextListener.class 3KB AdminVo.class 3KB LoginDao.class 2KB AddToCartAction.class 2KB QueryCityByProvinceNameAction.class 2KB ProReadAction.class 2KB QueryCityAction.class 2KB ModifyParamAction.class 2KB ModifyClassAction.class 2KB ModifyBrandAction.class 2KB Goods_comment_insertAction.class 2KB AddNewsAction.class 2KB CommentVo.class 2KB UseMbAction.class 2KB LoginAction.class 2KB BackCommentVo.class 2KB NewsVo.class 2KB OrderCondition.class 2KB StatAllAction.class 2KB ModifyNewsAction.class 2KB SearchUserAction.class 2KB AddBrandAction.class 2KB QueryFleightAction.class 2KB SearchBrandAction.class 2KB DeleteParamAction.class 2KB AdminLoginFilter.class 2KB VipRegisterAction.class 2KB VerifyOrderAction.class 2KB IntoGetPasswordAction.class 2KB Back_modifyConsultationAction.class 2KB QueryVipInfoAction.class 2KB SearchNewsAction.class 2KB CollectGoods.class 2KB QueryOrderListByIdAction.class 2KB Back_consultation_viewAction.class 2KB Back_goodsComment_viewAction.class 2KB Back_modifyCommentAction.class 2KB CommentVo.class 2KB Consultation_viewAction.class 2KB DeleteBrandAction.class 2KB QueryOrderDetailByIdAction.class 2KB QueryCollectionAction.class 2KB ProListActiona.class 2KB UserDao.class 2KB ConsultationVo.class 2KB Back_modifyConsultation_DBAction.class 2KB ProListAction.class 2KB PageInfo.class 2KB Consultation_insertAction.class 2KB Back_updateCommentAction.class 2KB AnswerProblemAction.class 2KB GoodsComment_view.class 2KB StatVo.class 2KB UserCondition.class 2KB News_action.class 2KB OrderDetailVo.class 2KB NewsConditon.class 2KB CommentDao.class 2KB共 899 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
资源评论
0诛天02018-07-18很有帮助谢谢了
lp188423513632014-06-05java做的，蛮不错。不过本人需要的是基于.net,不过看了下确实很好.- caohaiqi2013-07-05界面做的很炫，数据用的oracle
w5z2l0
- 粉丝: 7
- 资源: 1
最新资源
- 安卓PictureThis花花草草植物识别器v5.0.14.mp4
- 安卓谷歌相机v8.4pixel系列手机内置相机版.mp4
- 安卓纯粹免费直播v1.8.0聚合六大平台直播.mp4
- 安卓佳肴菜谱v1.0.0免费菜谱软件纯净版.mp4
- 安卓谜底黑胶v2.4.40高级版 – 音乐播放器.mp4
- 安卓模拟来电v1.0.0可自定义逃离场合必备.mp4
- 安卓魔力自动点击器v1.4.24 自动点击器.mp4
- webrtc+qt demo
- 安卓特狗影视v3.2.0丰富影视资源纯净版.mp4
- 安卓一木记账v5.8.90解锁VIP绿化高级版.mp4
- 安卓芝樱动漫V2.0 给你极致的观影体验.mp4
- 霸王茶姬抽3千份中杯免单券.mp4
- 白云视频app 高清追剧软件.mp4
- 百度打车国潮季领最高30亓券.mp4
- 基于Android Studio开发的安卓的记事本app项目源码（高分期末大作业）
- JAVA资料8-10学习
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
