package com.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import com.bean.Shop;
import com.comm.DBClass;
public class ShopDao {
/**
* 发布商品方法
*/
public boolean addShop(Shop sp){
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="insert into shop values('"+sp.getSname()+"',"+sp.getSprice()+","+sp.getSnum()+",'"+sp.getStype()+"','"+sp.getStore()+"','"+sp.getSay()+"','"+sp.getSimg()+"','"+sp.getUname()+"')";
sta.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
/**
* 修改商品数量方法
*/
public boolean updNum(int snum,String sname){
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="update shop set snum=snum-"+snum+" where sname='"+sname+"'";
sta.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
/**
* 下架商品方法
*/
public boolean delShop(int sid){
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="delete from shop where sid="+sid+"";
sta.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
/**
* 按类型查询商品方法
*/
public ArrayList<Shop> typeShopQuery(String stype){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop where stype='"+stype+"'";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 按店铺查询商品方法
*/
public ArrayList<Shop> storeShopQuery(String store){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop where store='"+store+"'";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 查询所有商品方法
*/
public ArrayList<Shop> ShopQuery(){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 商品ShopInfo
*/
public ArrayList<Shop> ShopInfo(Shop shop){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop where sid='"+shop.getSid()+"'";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 按掌柜查询商品方法
*/
public ArrayList<Shop> userShopQuery(String uname){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop where uname='"+uname+"'";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 按用户名查询商品方法
*/
public ArrayList<Shop> unameShopQuery(String uname){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
String sql="select * from shop where uname='"+uname+"'";
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
/**
* 模糊查询商品方法
*/
public ArrayList<Shop> searchShopQuery(String sql){
ArrayList<Shop> list=new ArrayList<Shop>();
Shop sp=null;
Connection conn=DBClass.getData();
try {
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
sp=new Shop();
sp.setSid(rs.getInt(1));
sp.setSname(rs.getString(2));
sp.setSprice(rs.getDouble(3));
sp.setSnum(rs.getInt(4));
sp.setStype(rs.getString(5));
sp.setStore(rs.getString(6));
sp.setSay(rs.getString(7));
sp.setSimg(rs.getString(8));
sp.setUname(rs.getString(9));
list.add(sp);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return list;
}
}
JSP，Servlet简易淘宝网JAVA （116个子文件） 
mytaobao.bmp 1.82MB
ShopDao.class 6KB BuySaleTaoBao.class 4KB AtBuy.class 4KB OrderDao.class 4KB Div.class 4KB Search.class 4KB AtOut.class 3KB OpenStore.class 3KB AddShop.class 3KB StoreDao.class 3KB StoreInfo.class 3KB UserDao.class 3KB UserRegister.class 3KB OnePrice.class 2KB UserLogin.class 2KB ShopInfo.class 2KB XiaJiaShop.class 2KB CheckServlet.class 2KB Shop.class 2KB SearchAll.class 2KB SelShop.class 2KB Order.class 2KB FenyeDao.class 2KB UserExit.class 1KB Store.class 1KB DBClass.class 1KB FilterONE.class 1KB User.class 878B .classpath 478B Thumbs.db 59KB
logo22.gif 4KB register_submit002.gif 2KB prepay_icon_00.gif 195B
standard.jar 343KB jstl.jar 17KB ShopDao.java 7KB Div.java 5KB BuySaleTaoBao.java 4KB Search.java 4KB AtOut.java 4KB AtBuy.java 4KB OpenStore.java 4KB AddShop.java 3KB OrderDao.java 3KB StoreDao.java 3KB UserRegister.java 3KB UserLogin.java 3KB StoreInfo.java 3KB XiaJiaShop.java 2KB OnePrice.java 2KB ShopInfo.java 2KB SelShop.java 2KB SearchAll.java 2KB UserDao.java 2KB UserExit.java 2KB CheckServlet.java 2KB Shop.java 1KB FenyeDao.java 1KB Order.java 1008B DBClass.java 772B Store.java 746B FilterONE.java 544B User.java 465B
mytaobao.jpg 168KB regibk.jpg 37KB jt2.jpg 23KB jt1.jpg 21KB jt3.jpg 20KB denglubeijing.jpg 11KB register.jpg 7KB zhifubao.jpg 6KB lijigoumai.jpg 3KB denglu1.jpg 3KB introStore.jpg 3KB MyOut.jpg 2KB MyBuy.jpg 2KB renzheng.jpg 1KB gwc1.jpg 1KB a1.jpg 1KB gwc.jpg 921B register.jsp 5KB ReadyOut.jsp 4KB AddShop.jsp 4KB Outing.jsp 4KB MyOrder.jsp 4KB index.jsp 4KB indexStore.jsp 3KB buyget.jsp 3KB MakeStore.jsp 3KB ShopInfo.jsp 3KB Store.jsp 2KB login.jsp 2KB MyTaoBao.jsp 2KB taobao.jsp 938B MANIFEST.MF 39B .mymetadata 282B
tsg_logo.png 2KB .project 1KB fmt.tld 19KB共 116 条
- 1
- 2
mxbld263
- 粉丝: 0
- 资源: 1
最新资源
- 基于lua-nginx-module，可以多维度检查和拦截恶意网络请求，具有简单易用、高性能、轻量级的特点
- 一个基于qt开发的包含各种基础图像处理技术的桌面应用，图像处理算法基于halcon，有直接调用halcon脚本和执行halcon
- 【带个人免签支付】宝宝取名源码 易经在线起名网 周易新生儿取名 生辰八字取名系统
- 微信公众号批量下载工具
- 创维8A06机芯 E750A系列 通用主程序 电视刷机 固件升级包 Ver01.01
- LxRunOffline-v3.5.0-11-gfdab71a-msvc.zip
- 惠普Laser Jet Professional P1100（系列）打印机驱动下载
- C#毕业设计基于leap motion和CNN的手语识别系统源代码+数据集+项目文档+演示视频
- 绑定halcon显示控件，可实现ROI交互，用于机器视觉领域.zip
- java连接数据库，jdbc连接数据库，并实现在控制台显示输入书名查询书本
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
评论1