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,会报错:违反完整约束条件,未找到父项关键字。
亖呉?盀