mybatis一个业务多次提交事务commit造成主键不顺序递增问题
程序员文章站
2022-06-27 14:53:19
mybatis一个业务多次提交事务commit造成主键不顺序递增问题
package com.dangdang.service;
import java.text.da...
mybatis一个业务多次提交事务commit造成主键不顺序递增问题
package com.dangdang.service; import java.text.dateformat; import java.text.simpledateformat; import java.util.date; import java.util.set; import java.util.uuid; import org.apache.ibatis.session.sqlsession; import com.dangdang.dao.addressdao; import com.dangdang.dao.orderdao; import com.dangdang.dao.orderdetalldao; import com.dangdang.entity.buyaddress; import com.dangdang.entity.order; import com.dangdang.entity.orderdetall; import com.dangdang.entity.user; import com.dangdang.util.mybatisutil; import com.dangdang.vo.cart; import com.dangdang.vo.orderitem; public class orderserviceimpl implements orderservice{ //收货地址入库、订单入库、订单项表入库 @override public void orderorder(buyaddress address, user user, cart cart) { try { //收货地址入库 address.setuid(user.getid()); address.setaddrstatus(0); address.setisdefault(0); //把user对象存放在buyaddress address.setuser(user); addressdao ad = (addressdao) mybatisutil.getmapper(addressdao.class); ad.save(address); mybatisutil.commitforce(); mybatisutil.closesqlsession(); } catch (exception e) { mybatisutil.rollback(); e.printstacktrace(); } //订单入库 order order = null; try { //生成订单号onumber date date=new date(); string createtime=new simpledateformat("yyyymmddhh:mm:ss").format(date); string onumber = createtime + uuid.randomuuid().tostring(); //把user对象、buyaddress对象存放在order对象里 order = new order(null, cart.gettotalprice(), user.getid(), onumber, user, 1, address.getaddrid()+1, address); // new order(orderid, totalp00rice, uid, onumber, user, orderstatus, addrid, address) orderdao od = (orderdao) mybatisutil.getmapper(orderdao.class); od.save(order); mybatisutil.commitforce(); mybatisutil.closesqlsession(); } catch (exception e) { mybatisutil.rollback(); e.printstacktrace(); } //订单项表入库 orderdetalldao odd = (orderdetalldao) mybatisutil.getmapper(orderdetalldao.class); try { set keyset = cart.getcartmap().keyset(); //遍历cartmap for (integer key:keyset) { // system.out.println(key); orderitem orderitem = cart.getcartmap().get(key); orderdetall orderdetall = new orderdetall(); orderdetall.setnumber(orderitem.getamount()); orderdetall.settotal(orderitem.getsmallprice()); orderdetall.setorderid(order.getorderid()+1); orderdetall.setgid(orderitem.getgoods().getgid()); //调用dao层 odd.save(orderdetall); } mybatisutil.commit(); mybatisutil.closesqlsession(); } catch (exception e) { mybatisutil.rollback(); e.printstacktrace(); } } }
几点说明目的:希望先后地址入库、订单入库、订单项表入库,并且主键是连续的现状:可以入库,但主键不连续三张表
收货地址表d_buyaddress(主键d_addrid)、
订单表d_buyorder(主键d_orderid,外键d_addrid)、
订单项(详情条目)表d_buyorderdetall(外键d_orderid)
mybatisutil.commitforce();是sqlsession.commit(true);order.getorderid()+1是不得已 将错就错 之举:
debug时发现order.getorderid()的值 比 order表的orderid的值小1(数据库里的值比预料的自然递增数多1,如d_orderid本该到100,实际却是101);
如果不加1,会报错:违反完整约束条件,未找到父项关键字。