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资源评论
zxb135499312712012-06-28菜鸟表示很高级，要研究很久- 盖世飞翔2014-01-24还行吧！不错！
