---订单---service---
package com.Service;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import com.DAO.CartDAO;
import com.DAO.OrderesDAO;
import com.DAOImple.CartDAOImple;
import com.DAOImple.OrderesDAOImple;
import com.DB.DB;
import com.Entity.Use;
import com.Entity.orderes;
public class OrderService {
//对dao进行操作
OrderesDAO oim=new OrderesDAOImple();
CartDAO cim=new CartDAOImple();
//对订单,进行增删该查---strid, useid, oen
public void deleteCartandSaveOrder(String gid,Use uen,int usID,orderes oen)
{//使用事务操作,业务层可以这样操作,对不同的dao操作;
Connection con=null;
PreparedStatement psta=null;
Statement sta=null;
try{
//添加到订单表中同时删除原来的购物车数据方法
oim.addOrder(oen);
StringBuilder strSql=new StringBuilder();
strSql.append("delete from CartItem where useid="+usID+" and goodsid in (");
strSql.append(gid);
strSql.append(")");
String sql=strSql.toString();
System.out.println("购物车将删除:"+sql);
con=DB.getcon();//连接数据库
sta=con.createStatement();
sta.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
DB.closeAll(null, psta, con);
}
}
public int insertOrderes(String address,String tel,String way,String useName,int useID) {
return oim.insertOrderes(address, tel, way, useName, useID);
}//添加到订单表中
public int addOrder(orderes en) {
return oim.addOrder(en);
}
public List<orderes> findOrderById(int id){
return oim.findOrderById(id);}
}
-------------------------------servlet-------------------------
package com.web;
import java.io.IOException;
import java.util.Date;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.Entity.CartItem;
import com.Entity.Use;
import com.Entity.goods;
import com.Entity.orderes;
import com.Service.Order;
import com.Service.OrderService;
public class OrderServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
@SuppressWarnings("unchecked")
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
//将购物车中的数据删除,同时增加数据进订单表和订单详情表;
//用getParameterValues的方法,将取到的值放到[]数组中
String [] gids=req.getParameterValues("gcid");
//用于字符串操作
StringBuilder sbgid=new StringBuilder();//创建一个stringbuilder对象
for(String gid:gids)
{
sbgid.append(gid+",");
}
//截取字符串
String strid=sbgid.substring(0,sbgid.length()-1);
System.out.println("选择物品:"+strid);
//获取选择的商品
OrderService oim=new OrderService();
orderes oen=new orderes();
Use useid=(Use)req.getSession().getAttribute("Useen");
Map<Integer,CartItem> cart=(Map<Integer,CartItem>)req.getSession().getAttribute("cart");
CartItem goodsID=cart.get(gids);
System.out.println("goodsIDgoodsIDgoodsID"+goodsID);
int usID=useid.getId();
System.out.println("获取用户的useID顾客的ID-----"+usID+"---------");
oen.setUseid(usID);
String goodsname=req.getParameter("goodsname");
System.out.println("物品的名称:"+goodsname);
oen.setName(goodsname);
String moneys=req.getParameter("total");
//double mid=Double.parseDouble(moneys);
System.out.println("金额:"+moneys);
oen.setTotal(moneys);
oim.deleteCartandSaveOrder(strid, useid,usID, oen);
resp.sendRedirect("CartAdderss.jsp");
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
this.doGet(req, resp);
}
}