package shop;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
public class shop {
/**
* 根据用户名得到会员对象
*/
public Member getMember(DB db,String username) throws Exception {
Member member = null;
ResultSet rs;
String strSql=null;
try {
strSql="select * from member where username="+username;
rs = db.executeQuery(strSql);
while (rs.next()){
member.setId(rs.getInt("id"));
member.setUsername(rs.getString("username"));
member.setPassword(rs.getString("password"));
member.setRealname(rs.getString("realname"));
member.setTel(rs.getString("tel"));
member.setAddress(rs.getString("address"));
member.setZip(rs.getString("zip"));
member.setEmail(rs.getString("email"));
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return member;
}
/**
* 根据商品ID得到商品对象
*/
public Product getProduct(DB db ,int Id) throws Exception {
Product product = null;
ResultSet rs;
String strSql=null;
try {
//connect = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "zgy01");
//Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
strSql="select * from product where id="+Id;
rs = db.executeQuery(strSql);
while(rs.next()){
product.setId(rs.getInt("id"));
product.setSortid(rs.getInt("sortid"));
product.setPrice(rs.getDouble("price"));
product.setName(rs.getString("name"));
product.setSaleprice(rs.getDouble("saleprice"));
product.setDescript(rs.getString("descript"));
product.setContents(rs.getString("contents"));
product.setSaledate(rs.getString("saledate"));
product.setSalecount(rs.getInt("salecount"));
product.setImage(rs.getString("image"));
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return product;
}
/**
* 得到指定数量的顶端商品对象����Ķ�����Ʒ����
*/
public Vector getTopProducts(DB db,int type) throws Exception {
Vector vector = new Vector();
ResultSet rs;
String strSql=null;
int dispNUm;
try {
if (type ==1) {
strSql="select * from product order by saledate desc";
dispNUm=4;
}
else{
strSql="select * from product order by salecount desc";
dispNUm=10;
}
//connect = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "zgy01");
//Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = db.executeQuery(strSql);
rs.setFetchSize(dispNUm);//有问题存在呀,不懂要问的。
while(rs.next()){
Product product = new Product();
product.setId(rs.getInt("id"));
product.setSortid(rs.getInt("sortid"));
product.setPrice(rs.getDouble("price"));
product.setName(rs.getString("name"));
product.setSaleprice(rs.getDouble("saleprice"));
product.setDescript(rs.getString("descript"));
product.setContents(rs.getString("contents"));
product.setSaledate(rs.getString("saledate"));
product.setSalecount(rs.getInt("salecount"));
product.setImage(rs.getString("image"));
vector.add(product);
}
} catch (SQLException e) {
e.printStackTrace();
}
return vector;
}
/**
* 得到所有符合条件商品对象
*/
public Vector getMatchProducts(DB db,int sortId,String keyword) throws Exception {
Vector vector=new Vector();
ResultSet rs;
String strSql=null;
try {
if (sortId ==-1)
strSql="select * from product where name like '%" + keyword + "%' ";
else
strSql="select * from product where sortid='" + sortId +"'";
rs = db.executeQuery(strSql);
while(rs.next()){
Product product = new Product();
product.setId(rs.getInt("id"));
product.setSortid(rs.getInt("sortid"));
product.setPrice(rs.getDouble("price"));
product.setName(rs.getString("name"));
product.setSaleprice(rs.getDouble("saleprice"));
product.setDescript(rs.getString("descript"));
product.setContents(rs.getString("contents"));
product.setSaledate(rs.getString("saledate"));
product.setSalecount(rs.getInt("salecount"));
product.setImage(rs.getString("image"));
vector.add(product);
}
} catch (SQLException e) {
e.printStackTrace();
}
return vector;
}
/**
* 得到所有商品类别对象
*/
public Vector getSorts(DB db) throws Exception {
Vector vector=new Vector();
ResultSet rs;
String strSql=null;
try {
strSql="select * from sort";
rs = db.executeQuery(strSql);
while(rs.next()){
Sort sort=new Sort();
sort.setId(rs.getInt("id"));
sort.setName(rs.getString("name"));
vector.add(sort);
}
} catch (SQLException e) {
e.printStackTrace();
}
return vector;
}
/**
*根据编号得到订单对象
*/
public Order getOrder(DB db,String orderno) throws Exception {
Order order = null;
ResultSet rs;
String strSql=null;
try {
strSql="select * from order where orderno="+orderno;
rs = db.executeQuery(strSql);
while(rs.next()){
order.setId(rs.getInt("id"));
order.setOrderno(rs.getString("orderno"));
order.setUserid(rs.getInt("userid"));
order.setRealname(rs.getString("realname"));
order.setAddress(rs.getString("address"));
order.setEmail(rs.getString("email"));
order.setMemo(rs.getString("memo"));
order.setPayment(rs.getString("payment"));
order.setPrice(rs.getDouble("price"));
order.setTag(rs.getInt("tag"));
order.setTel(rs.getString("tel"));
order.setTime(rs.getString("time"));
order.setZip(rs.getString("zip"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return order;
}
/**
* 得到指定用户所有订单对象
*/
public Vector getOrders(DB db,int userid) throws Exception {
Vector vector=new Vector();
ResultSet rs;
String strSql=null;
try {
strSql="select * from from order where userid=" + userid;
rs = db.executeQuery(strSql);
while(rs.next()){
Order order=new Order();
order.setId(rs.getInt("id"));
order.setOrderno(rs.getString("orderno"));
order.setUserid(rs.getInt("userid"));
order.setRealname(rs.getString("realname"));
order.setAddress(rs.getString("address"));
order.setEmail(rs.getString("email"));
order.setMemo(rs.getString("memo"));
order.setPayment(rs.getString("payment"));
order.setPrice(rs.getDouble("price"));
order.setTag(rs.getInt("tag"));
order.setTel(rs.getString("tel"));
order.setTime(rs.getString("time"));
order.setZip(rs.getString("zip"));
vector.add(vector);
}
} catch (SQLException e) {
e.printStackTrace();
}
return vector;
}
/**
* 修改实体对象所对应的记录
*/
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
网上书店 JSP源码 完整版(sqlserver数据库) (217个子文件)
SNAPSHOT.1 237B
LOGFILE.1 8B
BUYSERVLET.JAVA.BAK 2KB
UPDATESHOPCARTSERVLET.JAVA.BAK 2KB
DB.JAVA.BAK 2KB
DB.JAVA.BAK 2KB
DETAILSERVLET.JAVA.BAK 1KB
CLEARSHOPCARTSERVLET.JAVA.BAK 976B
SHOPADMIN.CLASS 6KB
SHOP.CLASS 6KB
ADDPRODUCTACTION.CLASS 4KB
CREATEORDERSERVLET.CLASS 4KB
ORDER.CLASS 3KB
ORDER.CLASS 3KB
DB.CLASS 3KB
BUYSERVLET.CLASS 3KB
LOGINACTION.CLASS 2KB
LOGINSERVLET.CLASS 2KB
SEARCHSERVLET.CLASS 2KB
DELORDERSERVLET.CLASS 2KB
VIEWPROCESSORDERACTION.CLASS 2KB
PRODUCT.CLASS 2KB
VIEWPRODUCTACTION.CLASS 2KB
VIEWMEMBERACTION.CLASS 2KB
VIEWORDERACTION.CLASS 2KB
UPDATESHOPCARTSERVLET.CLASS 2KB
VIEWSORTACTION.CLASS 2KB
MODIFYUSERINFOSERVLET.CLASS 2KB
PRODUCT.CLASS 2KB
INDEXSERVLET.CLASS 2KB
REGISTSERVLET.CLASS 2KB
ORDERLISTSERVLET.CLASS 2KB
DB.CLASS 2KB
DETAILSERVLET.CLASS 2KB
PROCESSORDERACTION.CLASS 2KB
DELPRODUCTACTION.CLASS 2KB
DELMEMBERACTION.CLASS 2KB
DELSORTACTION.CLASS 2KB
MEMBER.CLASS 2KB
ADDSORTACTION.CLASS 2KB
MEMBER.CLASS 2KB
MODIFYPRODUCTACTION.CLASS 2KB
CLEARSHOPCARTSERVLET.CLASS 1KB
EXITSERVLET.CLASS 1KB
ADDPRODUCTPREACTION.CLASS 1KB
VIEWLIST.CLASS 1KB
SHOPCART.CLASS 1KB
CONSTANTS.CLASS 1KB
ADMINUSER.CLASS 921B
CONSTANTS.CLASS 750B
SORT.CLASS 700B
SORT.CLASS 690B
ACTIONMESSAGES.CLASS 502B
.CLASSPATH 796B
.CVSIGNORE 7B
.CVSIGNORE 4B
THUMBS.DB 265KB
THUMBS.DB 25KB
LOGO_R.GIF 4KB
LOGO.GIF 4KB
LOGO_L.GIF 2KB
TUIJIAN.GIF 1KB
BG_OK.GIF 1KB
TEJIA.GIF 1KB
LOOK.GIF 1KB
TTT.GIF 1KB
NEWSHOP.GIF 1KB
LOOKBCAR.GIF 554B
USER_SUBMIT.GIF 492B
RELBCAR.GIF 489B
GOBUY.GIF 479B
BRIEF.GIF 447B
LOGIN.GIF 429B
LOGIN.GIF 429B
USER_LOGIN.GIF 384B
BG_BOOK.GIF 324B
OK.GIF 309B
DOWN.GIF 307B
UP.GIF 302B
CLOSEDB.GIF 298B
SERARCH.GIF 281B
SHOUCANG.GIF 262B
GOUWU.GIF 262B
TOP1.GIF 230B
BOTTOM1.GIF 227B
SEPERATOR.GIF 221B
7.GIF 207B
9.GIF 206B
FU.GIF 191B
X4.GIF 176B
X9.GIF 174B
X21.GIF 174B
3.GIF 165B
BBBB.GIF 150B
TOP_LINE_R.GIF 142B
ICON_NEW.GIF 136B
DC.GIF 132B
ORDER.GIF 129B
PROMO_LIST_TOP.GIF 124B
X3.GIF 121B
共 217 条
- 1
- 2
- 3
lsf304580500
- 粉丝: 12
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页