package dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.StringTokenizer;
import po.Flower;
import tool.Tool;
public class FlowerDAO {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public List showFlower(){
List list = new ArrayList();
try {
con=Tool.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from flower ");
while(rs.next()){
Flower f = new Flower();
f.setId(rs.getInt(1));
f.setName(rs.getString(2));
f.setPrice(rs.getDouble(3));
list.add(f);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close(); rs=null;
}
if(stmt!=null){
stmt.close(); stmt=null;
}
if(con!=null){
con.close(); con=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
public Flower getFlower(int id){
Flower f = new Flower();
try {
con=Tool.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from flower where id = "+id);
if(rs.next()){
f.setId(rs.getInt(1));
f.setName(rs.getString(2));
f.setPrice(rs.getDouble(3));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close(); rs=null;
}
if(stmt!=null){
stmt.close(); stmt=null;
}
if(con!=null){
con.close(); con=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return f;
}
public String updateCart(String values,int fid,int fcount){
String string="";
boolean b = false;
StringTokenizer st1 = new StringTokenizer(values,"|");
while(st1.hasMoreTokens()){
String str=st1.nextToken();
StringTokenizer st2 = new StringTokenizer(str,"&");
int id = Integer.parseInt(st2.nextToken());
int count = Integer.parseInt(st2.nextToken());
if(id==fid){
count=count+fcount;
b=true;
}
string+=id+"&"+count+"|";
}
if(!b){
string=values+fid+"&"+fcount+"|";
}
return string;
}
public List showCart(String values){
List list = new ArrayList();
StringTokenizer st1 = new StringTokenizer(values,"|");
while(st1.hasMoreTokens()){
String str=st1.nextToken();
StringTokenizer st2 = new StringTokenizer(str,"&");
int id = Integer.parseInt(st2.nextToken());
int count = Integer.parseInt(st2.nextToken());
Flower f = getFlower(id);
f.setCount(count);
list.add(f);
}
return list;
}
public double showAllPrice(List list){
double b = 0;
for(Iterator i = list.iterator();i.hasNext();){
Flower f =(Flower)i.next();
b+=f.getPrice()*f.getCount();
}
return b;
}
public String deleteCart(String values,int fid){
String string="";
StringTokenizer st1 = new StringTokenizer(values,"|");
while(st1.hasMoreTokens()){
String str=st1.nextToken();
StringTokenizer st2 = new StringTokenizer(str,"&");
int id = Integer.parseInt(st2.nextToken());
int count = Integer.parseInt(st2.nextToken());
if(id==fid){
continue;
}
string+=id+"&"+count+"|";
}
return string;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
Cart.rar (30个子文件)
Cart
.project 1KB
.mymetadata 285B
WebRoot
WEB-INF
.struts-config.mex 2KB
web.xml 1KB
struts-config.xml 1023B
lib
commons-logging.jar 33KB
commons-digester.jar 147KB
commons-fileupload.jar 19KB
commons-beanutils.jar 160KB
antlr.jar 344KB
struts.jar 474KB
commons-validator.jar 74KB
mysql-connector-java-5.0.3-bin.jar 482KB
jakarta-oro.jar 62KB
classes
dao
FlowerDAO.class 5KB
com
yinhe
struts
action
ControlCartAction.class 4KB
form
ControlCartForm.class 1KB
ApplicationResources.properties 81B
tool
Tool.class 925B
po
Flower.class 1KB
index.jsp 2KB
META-INF
MANIFEST.MF 39B
.myeclipse
src
dao
FlowerDAO.java 4KB
com
yinhe
struts
action
ControlCartAction.java 4KB
form
ControlCartForm.java 1KB
ApplicationResources.properties 81B
tool
Tool.java 511B
po
Flower.java 790B
.mystrutsdata 256B
.classpath 1KB
共 30 条
- 1
资源评论
- zxb135499312712012-06-28菜鸟表示很高级,要研究很久
- 盖世飞翔2014-01-24还行吧!不错!
yujixun
- 粉丝: 1
- 资源: 15
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功