一:商品订单
购物车用Map是因为要对购物车操作,比如删除 修改,但是订单不需要操作删除,只需要存数据 (订单提交后,就不能修改了)
public class OrderItem {
private String itemid;//订单项的id
private int count;//订单项内商品的购买数量
private double subtotal;//订单项小计
private Product product;//订单项内部的商品
private Order order;//该订单项属于哪个订单
}
public class Order {
private String oid;//该订单的订单号
private Date ordertime;//下单时间
private double total;//该订单的总金额
private int state;//订单支付状态 1代表已付款 0代表未付款
private String address;//收货地址
private String name;//收货人
private String telephone;//收货人电话
private User user;//该订单属于哪个用户
//该订单中有多少订单项
List<OrderItem> orderItems = new ArrayList<OrderItem>();
}
//提交订单
public class SubmitOrderServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
//判断用户是否已经登录
User user=(User) session.getAttribute("user");
if(user ==null){
//没有登录
response.sendRedirect(request.getContextPath()+"/login.jsp");
return;
}
//目的:封装好一个Order对象 传递给service层
Order order=new Order();
order.setOid(CommUtils.getUUID()); //该订单的订单号
order.setOrdertime(new Date()); //下单时间
//获得session中的购物车
Cart cart = (Cart) session.getAttribute("cart");
order.setTotal(cart.getTotal()); //该订单的总金额
order.setState(0); //订单支付状态 1代表已付款 0代表未付款
order.setAddress(null); //收货地址
order.setName(null); //收货人
order.setTelephone(null); //收货人电话
order.setUser(user); //该订单属于哪个用户
//获得购物车中的购物项的集合map
Map<String, CartItem> cartItems = cart.getCartItems();
for (Map.Entry<String, CartItem> entry :cartItems.entrySet()) {
//取出每一个购物项
CartItem cartItem = entry.getValue();
//创建新的订单项
OrderItem orderItem = new OrderItem();
orderItem.setItemid(CommUtils.getUUID()); //订单项的id
orderItem.setCount(cartItem.getBuyNum()); //订单项内商品的购买数量
orderItem.setSubtotal(cartItem.getSubtotal()); //订单项小计
orderItem.setProduct(cartItem.getProduct()); //订单项内部的商品
orderItem.setOrder(order); //该订单项属于哪个订单
//将该订单项添加到订单的订单项集合中
order.getOrderItems().add(orderItem);
}
ProductService service=new ProductService();
service.submitOrder(order);
//页面跳转
session.setAttribute("order", order);
response.sendRedirect(request.getContextPath()+"/order_info.jsp");
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
public class ProductService {
//提交订单 将订单的数据和订单项的数据存储到数据库中
public void submitOrder(Order order) {
ProductDao dao=new ProductDao();
try {
//1、开启事务
DataSourceUtils.startTransaction();
//2、调用dao存储order表数据的方法
dao.addOrder(order);
//3、调用dao存储orderitem表数据的方法
dao.addOrdetItems(order);
} catch (SQLException e) {
try {
DataSourceUtils.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
DataSourceUtils.commitAndRelease();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public class ProductDao {
//向orders表插入数据
public void addOrder(Order order) throws SQLException {
QueryRunner runner=new QueryRunner();
String sql="insert into orders values(?,?,?,?,?,?,?,?)";
Connection conn = DataSourceUtils.getConnection();
runner.update(conn,sql, order.getOid(),order.getOrdertime(),order.getTotal(),order.getState(),
order.getAddress(),order.getName(),order.getTelephone(),order.getUser().getUid());
}
//向orderitem表插入数据
public void addOrdetItems(Order order) throws SQLException {
QueryRunner runner=new QueryRunner();
String sql="insert into orderItem values(?,?,?,?,?)";
Connection conn = DataSourceUtils.getConnection();
List<OrderItem> orderItems = order.getOrderItems();
//订单项有多个
for (OrderItem item : orderItems) {
runner.update(conn,sql,item.getItemid(),item.getCount(),
item.getSubtotal(),item.getProduct().getPid(),item.getOrder().getOid());
}
}
}
二:更新收货人信息
//确认订单---更新收获人信息+在线支付
public class ConfirmOrderServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1、更新收货人信息
request.setCharacterEncoding("utf-8");
Order order=new Order();
Map<String, String[]> properties = request.getParameterMap();
try {
BeanUtils.populate(order, properties);
} catch (Exception e) {
e.printStackTrace();
}
ProductService service=new ProductService();
service.updateOrder(order);
//2、在线支付
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
public class ProductService {
public void updateOrder(Order order) {
ProductDao dao=new ProductDao();
try {
dao.updateOrder(order);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class ProductDao {
public void updateOrder(Order order) throws SQLException {
QueryRunner runner=new QueryRunner(DataSourceUtils.getDataSource());
String sql="update orders set address=?,name=?,telephone=? where oid=?";
runner.update(sql, order.getAddress(),order.getName(),order.getTelephone(),order.getOid());
}
}
三:在线支付
这个支付代码不需要自己写,会复制粘贴就可以了.
//第一步 主要修改 支付必须基本数据的信息 订单编号和支付金额
package cn.itcast.servlet;
import java.io.IOException;
import java.util.ResourceBundle;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.itcast.utils.PaymentUtil;
public class PayServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 获得 支付必须基本数据
String orderid = request.getParameter("orderid");
String money = request.getParameter("money"); //支付金额
// 银行
String pd_FrpId = request.getParameter("pd_FrpId");
// 发给支付公司需要哪些数据
String p0_Cmd = "Buy";
String p1_MerId = ResourceBundle.getBundle("merchantInfo").getString("p1_MerId");
String p2_Order = orderid;
String p3_Amt = money;
String p4_Cur = "CNY";
String p5_Pid = "";
String p6_Pcat = "";
String p7_Pdesc = "";
// 支付成功回调地址 ---- 第三方支付公司会访问、用户访问
// 第三方支付可以访问网址
String p8_Url = ResourceBundle.getBundle("merchantInfo").getString("callback");
String p9_SAF = "";
String pa_MP = "";
String pr_NeedResponse = "1";
// 加密hmac 需要密钥
String keyValue = ResourceBundle.getBundle("merchantInfo").getString(
"keyValue");
String hmac = PaymentUtil.buildHmac(p0_Cmd, p1_MerId, p2_Order, p3_Amt,
p4_Cur, p5_Pid, p6_Pcat, p7_Pdesc, p8_Url, p9_SAF, pa_MP,
pd_FrpId, pr_NeedResponse, keyValue);
String url = "https://www.yeepay.com/app-merchant-proxy/node?pd_FrpId="+pd_FrpId+
"&p0_Cmd="+p0_Cmd+
"&p1_MerId="+p1_MerId+
"&p2_Order="+p2_Order+
"&p3_Amt="+p3_Amt+
"&p4_Cur="+p4_Cur+
"&p5_Pid="+p5_Pid+
"&p6_Pcat="+p6_Pcat+
"&p7_Pdesc="+p7_Pdesc+
"&p8_Url="+p8_Url+
"&p9_SAF="+p9_SAF+
"&pa_MP="+pa_MP+
"&pr_NeedResponse="+pr_NeedResponse+
"&hmac="+hmac;
//重定向到第三方支付平台
response.sendRedirect(url);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
//第二步 merchantInfo.properties
p1_MerId=****
keyValue=****
callback=http://localhost:8082/Store/callbackServlet
//第三步
package cn.itcast.utils;
import java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.util.Arrays;
public class PaymentUtil {
private static String encodingCharset = "UTF-8";
/**
* 生成hmac方法
*
* @param p0_Cmd 业务类型
* @param p1_MerId 商户编号
* @param p2_Order 商户订单号
* @param p3_Amt 支付金额
* @param p4_Cur 交易币种
* @param p5_Pid 商品名称
* @param p6_Pcat 商品种类
* @param p7_Pdesc 商品描述
* @param p8_Url 商户接收支付成功数据的地址
* @param p9_SAF 送货地址
* @param pa_MP 商户扩展信息
* @param pd_FrpId 银行编码
* @param pr_NeedResponse 应答机制
* @param keyValue 商户密钥
* @return
*/
public static String buildHmac(String p0_Cmd,String p1_MerId,
String p2_Order, String p3_Amt, String p4_Cur,String p5_Pid, String p6_Pcat,
String p7_Pdesc,String p8_Url, String p9_SAF,String pa_MP,String pd_FrpId,
String pr_NeedResponse,String keyValue) {
StringBuilder sValue = new StringBuilder();
// 业务类型
sValue.append(p0_Cmd);
// 商户编号
sValue.append(p1_MerId);
// 商户订单号
sValue.append(p2_Order);
// 支付金额
sValue.append(p3_Amt);
// 交易币种
sValue.append(p4_Cur);
// 商品名称
sValue.append(p5_Pid);
// 商品种类
sValue.append(p6_Pcat);
// 商品描述
sValue.append(p7_Pdesc);
// 商户接收支付成功数据的地址
sValue.append(p8_Url);
// 送货地址
sValue.append(p9_SAF);
// 商户扩展信息
sValue.append(pa_MP);
// 银行编码
sValue.append(pd_FrpId);
// 应答机制
sValue.append(pr_NeedResponse);
return PaymentUtil.hmacSign(sValue.toString(), keyValue);
}
/**
* 返回校验hmac方法
*
* @param hmac 支付网关发来的加密验证码
* @param p1_MerId 商户编号
* @param r0_Cmd 业务类型
* @param r1_Code 支付结果
* @param r2_TrxId 易宝支付交易流水号
* @param r3_Amt 支付金额
* @param r4_Cur 交易币种
* @param r5_Pid 商品名称
* @param r6_Order 商户订单号
* @param r7_Uid 易宝支付会员ID
* @param r8_MP 商户扩展信息
* @param r9_BType 交易结果返回类型
* @param keyValue 密钥
* @return
*/
public static boolean verifyCallback(String hmac, String p1_MerId,
String r0_Cmd, String r1_Code, String r2_TrxId, String r3_Amt,
String r4_Cur, String r5_Pid, String r6_Order, String r7_Uid,
String r8_MP, String r9_BType, String keyValue) {
StringBuilder sValue = new StringBuilder();
// 商户编号
sValue.append(p1_MerId);
// 业务类型
sValue.append(r0_Cmd);
// 支付结果
sValue.append(r1_Code);
// 易宝支付交易流水号
sValue.append(r2_TrxId);
// 支付金额
sValue.append(r3_Amt);
// 交易币种
sValue.append(r4_Cur);
// 商品名称
sValue.append(r5_Pid);
// 商户订单号
sValue.append(r6_Order);
// 易宝支付会员ID
sValue.append(r7_Uid);
// 商户扩展信息
sValue.append(r8_MP);
// 交易结果返回类型
sValue.append(r9_BType);
String sNewString = PaymentUtil.hmacSign(sValue.toString(), keyValue);
return sNewString.equals(hmac);
}
/**
* @param aValue
* @param aKey
* @return
*/
public static String hmacSign(String aValue, String aKey) {
byte k_ipad[] = new byte[64];
byte k_opad[] = new byte[64];
byte keyb[];
byte value[];
try {
keyb = aKey.getBytes(encodingCharset);
value = aValue.getBytes(encodingCharset);
} catch (UnsupportedEncodingException e) {
keyb = aKey.getBytes();
value = aValue.getBytes();
}
Arrays.fill(k_ipad, keyb.length, 64, (byte) 54);
Arrays.fill(k_opad, keyb.length, 64, (byte) 92);
for (int i = 0; i < keyb.length; i++) {
k_ipad[i] = (byte) (keyb[i] ^ 0x36);
k_opad[i] = (byte) (keyb[i] ^ 0x5c);
}
MessageDigest md = null;
try {
md = MessageDigest.getInstance("MD5");
} catch (NoSuchAlgorithmException e) {
return null;
}
md.update(k_ipad);
md.update(value);
byte dg[] = md.digest();
md.reset();
md.update(k_opad);
md.update(dg, 0, 16);
dg = md.digest();
return toHex(dg);
}
public static String toHex(byte input[]) {
if (input == null)
return null;
StringBuffer output = new StringBuffer(input.length * 2);
for (int i = 0; i < input.length; i++) {
int current = input[i] & 0xff;
if (current < 16)
output.append("0");
output.append(Integer.toString(current, 16));
}
return output.toString();
}
/**
*
* @param args
* @param key
* @return
*/
public static String getHmac(String[] args, String key) {
if (args == null || args.length == 0) {
return (null);
}
StringBuffer str = new StringBuffer();
for (int i = 0; i < args.length; i++) {
str.append(args[i]);
}
return (hmacSign(str.toString(), key));
}
/**
* @param aValue
* @return
*/
public static String digest(String aValue) {
aValue = aValue.trim();
byte value[];
try {
value = aValue.getBytes(encodingCharset);
} catch (UnsupportedEncodingException e) {
value = aValue.getBytes();
}
MessageDigest md = null;
try {
md = MessageDigest.getInstance("SHA");
} catch (NoSuchAlgorithmException e) {
e.printStackTrace();
return null;
}
return toHex(md.digest(value));
}
}
public class ProductService {
//修改订单状态
public void updateState(String r6_Order) {
ProductDao dao=new ProductDao();
try {
dao.updateState(r6_Order);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class ProductDao {
public void updateState(String r6_Order) throws SQLException {
QueryRunner runner=new QueryRunner(DataSourceUtils.getDataSource());
String sql="update orders set state=? where oid=?";
runner.update(sql, 1,r6_Order);
}
}
四:用户登录(补用户登录的功能) 明天整理后写上去
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
UserService service=new UserService();
request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
User user=service.login(username,password);
if(user !=null){
session.setAttribute("user", user);
request.getRequestDispatcher("/default.jsp").forward(request, response);
}else{
response.sendRedirect(request.getContextPath()+"/login.jsp");
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
public class UserService {
public User login(String username, String password) {
UserDao dao=new UserDao();
User user=null;
try {
user=dao.login(username,password);
} catch (SQLException e) {
e.printStackTrace();
}
return user;
}
}
public class UserDao {
public User login(String username, String password) throws SQLException {
QueryRunner runner=new QueryRunner(DataSourceUtils.getDataSource());
String sql="select * from user where username=? and password=?";
return runner.query(sql, new BeanHandler<User>(User.class),username,password);
}
}