JAVA向表里添加一条数据并返回ID

最新推荐文章于 2024-04-17 14:17:33 发布

pojo0121

最新推荐文章于 2024-04-17 14:17:33 发布

阅读量925

点赞数

分类专栏： MySql Road Java Road 文章标签： java object insert sql integer string

本文链接：https://blog.youkuaiyun.com/pojo0121/article/details/3593729

版权

Java Road 同时被 2 个专栏收录

7 篇文章

订阅专栏

MySql Road

6 篇文章

订阅专栏

本文介绍了一个用于电子商务系统中订单信息插入的Java工具类OrderPreparedStatementCreator。该类使用Spring JDBC模块的PreparedStatementCreator接口实现，负责将订单信息及订单项详细数据批量插入到数据库中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

OrderPreparedStatementCreator：

package com.mmera.store.dao.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Map;

import org.springframework.jdbc.core.PreparedStatementCreator;

public class OrderPreparedStatementCreator implements PreparedStatementCreator {
private static final String sql = "insert into store_order(orderSerial,orderZipCode,orderAddress,userId,orderReceiver,orderMessage,orderPhone,orderMobile,orderPayType,orderLogisticFee,orderTime) values(?,?,?,?,?,?,?,?,?,now())";
private Map<Object, Object> order;
public OrderPreparedStatementCreator(Map<Object,Object> order){
  this.order = order;
}

public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
  PreparedStatement ps = connection.prepareStatement(sql);
  ps.setString(1, order.get("orderSerial").toString());
  ps.setString(2, order.get("orderZipCode").toString());
  ps.setString(3, order.get("orderAddress").toString());
  ps.setInt(4, (Integer)order.get("userId"));
  ps.setString(5, order.get("orderReceiver").toString());
  ps.setString(6, order.get("orderMessage").toString());
  ps.setString(7, order.get("orderPhone").toString());
  ps.setString(8, order.get("orderMobile").toString());
  ps.setString(9, order.get("orderPayType").toString());
  ps.setDouble(10, (Double)order.get("orderLogisticFee"));
  return ps;
}

}

public void insertOrder(Map<Object,Object> order,List<Map<?,?>> orderItems){
  KeyHolder kh = new GeneratedKeyHolder();
  PreparedStatementCreator psc = new OrderPreparedStatementCreator(order);
  getJdbcTemplate().update(psc, kh);
  Long orderId = kh.getKey().longValue();
  String sql = "insert into store_orderitem(orderId,orderItemSerial,orderItemBrand,orderItemCatena,orderItemName,orderItemPrice,orderItemSpec,orderItemStyle,productSerial) values(?,?,?,?,?,?,?,?,?)";
  for(int i=0;i<orderItems.size();i++){
   Map<?, ?> orderItem = orderItems.get(i);
   Object[] args = {
     orderId,
     orderItem.get("orderItemSerial"),
     orderItem.get("orderItemBrand"),
     orderItem.get("orderItemCatena"),
     orderItem.get("orderItemName"),
     (Double)orderItem.get("orderItemPrice"),
     orderItem.get("orderItemSpec"),
     orderItem.get("orderItemStyle"),
     orderItem.get("productSerial")
   };
   getJdbcTemplate().update(sql, args);
  }
}