本期内容:
1、解决上期内容乱码
2、结算功能
一、乱码问题
分析乱码问题:
传递到后台的值,乱码的原因可能有两种
1、前台-->浏览器那一端就已经产生了乱码
2、后端-->在子控制器接受前端传递到后台的过程中出现乱码
上期乱码的根本原因:
就是前台正常的字符串传递到后台,出现了乱码
意味着中间做了编码的转换(编码解码)
因此猜想是过滤器(EncodingFiter)的问题:
package com.xhy.util;
import java.io.IOException;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;/**
* 中文乱码处理
*
*/
@WebFilter(filterName = "encodingFiter",urlPatterns = "/*")
public class EncodingFiter implements Filter {
private String encoding = "UTF-8";// 默认字符集public EncodingFiter() {
super();
}public void destroy() {
}public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) request;
HttpServletResponse res = (HttpServletResponse) response;// 中文处理必须放到 chain.doFilter(request, response)方法前面
res.setContentType("text/html;charset=" + this.encoding);
if (req.getMethod().equalsIgnoreCase("post")) {
req.setCharacterEncoding(this.encoding);
}// 这一串不需要
/*else {
Map map = req.getParameterMap();// 保存所有参数名=参数值(数组)的Map集合
Set set = map.keySet();// 取出所有参数名
Iterator it = set.iterator();
while (it.hasNext()) {
String name = (String) it.next();
String[] values = (String[]) map.get(name);// 取出参数值[注:参数值为一个数组]
for (int i = 0; i < values.length; i++) {
values[i] = new String(values[i].getBytes("ISO-8859-1"),
this.encoding);
}
}
}*/chain.doFilter(request, response);
}public void init(FilterConfig filterConfig) throws ServletException {
String s = filterConfig.getInitParameter("encoding");// 读取web.xml文件中配置的字符集
if (null != s && !s.trim().equals("")) {
this.encoding = s.trim();
}
}}
效果:
二、结算功能
1、购物车结算思路分析
操作两张表的数据:订单表、订单项表
功能:
①、点击去结算的按钮,对应弹出模态框
②、点击模态框确定的按钮,将购物车中的数据(订单表的数据以及订单项表的数据)一并提交到后台
子控制器ShoppingAction,createOrder方法中
①、将属于订单表的数据入库
②、将属于订单项表的数据也入库
注意:订单项表数据的外键要关联到订单表数据的主键
2、购物车结算编码
(1、
订单表的实体类Order
public class Order {
private long id;
private long uid;
private Date orderTime;
private String consignee;
private String phone;
private String postalcode;
private String address;
private int sendType;
private Date sendTime;
private float orderPrice;
private int orderState;}
订单项表的实体类OrderItem :
public class OrderItem {
private long id;
private long oid;
private String bid;
private int quantity;}
(2、
插入订单表OrderDao的方法
// 购物车结算,生成订单
public void add(Order t) throws Exception {
String sql="insert into t_easyui_order(uid,orderTime,consignee,phone,postalcode,address,sendType,sendTime,orderPrice,orderState) "
+ "values(?,now(),?,?,?,?,?,?,?,?)";
super.executeUpdate(sql, t, new String[] {"uid","consignee","phone","postalcode","address","sendType","sendTime","orderPrice","orderState"});
}// 按照订单时间倒序条件筛选查询
public List<Order> list(Order order, PageBean pageBean) throws Exception {
String sql="select * from t_easyui_order order by orderTime desc";
return super.executeQuery(sql, Order.class, pageBean);
}插入订单项表OrderItemDao的方法
// 购物车结算,订单项数据入库
public void add(OrderItem t) throws Exception {
String sql="insert into t_easyui_orderItem(oid,bid,quantity) values(?,?,?)";
super.executeUpdate(sql, t, new String[] {"oid","bid","quantity"});
}
(3、子控制器ShoppingAction
订单入库以及订单项入库
public class ShoppingAction extends ActionSupport implements ModelDriver<ShoppingVo>{
ShoppingVo sv=new ShoppingVo();
private OrderDao od=new OrderDao();
private OrderItemDao oid=new OrderItemDao();
@Override
public ShoppingVo getModel() {
// TODO Auto-generated method stub
return sv;
}
public void createOrder(HttpServletRequest req, HttpServletResponse resp) {
// 获取uid
User cuser=(User) req.getSession().getAttribute("cuser");
// 必须登录,不登录就结束
if(cuser==null) {
return;
}
// 组装数据
Order order=new Order();
order.setAddress(sv.getAddress());
order.setConsignee(sv.getConsignee());
// 订单价格总计
float orderPrice=0f;
String pageStr=sv.getPageStr();
if(StringUtils.isNotBlank(pageStr)&& pageStr.length()>1) {
for(String item:pageStr.substring(1).split(",")) {
String[] itemEle = item.split("-");
orderPrice+=Float.valueOf(itemEle[3]);
}
}
order.setOrderPrice(orderPrice);
order.setOrderState(1);
order.setPhone(sv.getPhone());
order.setPostalcode(sv.getPostalcode());
order.setSendType(sv.getSendType());
order.setUid(cuser.getId());
try {
// 订单数据入库
od.add(order);
// 订单项数据入库
Order newest = od.list(null, null).get(0);
if(StringUtils.isNotBlank(pageStr)&& pageStr.length()>1) {
for(String item:pageStr.substring(1).split(",")) {
OrderItem oi=new OrderItem();
String[] itemEle = item.split("-");
oi.setBid(itemEle[0]);
// 需要设置当前订单项是属于哪个订单的
// 思路:查询出最新订单的id,按照订单时间进行倒序查询,取第一条数据即可
oi.setOid(newest.getId());
oi.setQuantity(Integer.valueOf(itemEle[2]));
oid.add(oi);
}
}
} catch (Exception e) {
e.printStackTrace();
}
}}
2、销量的改变
BookDao方法:
// 根据书籍名称修改销量
public void editSales(Book book) throws Exception {
super.executeUpdate("update t_easyui_book set sales=sales+? where name=?",
book,new String[] {"sales","name"});
}子控制器ShoppingAction:
// 当前书籍被购买,那么这本书的销量就应该+被卖的书Quantity
Book b=new Book();
b.setName(itemEle[0]);
b.setSales(Integer.valueOf(itemEle[2]));
bd.editSales(b);
效果图