@SelectKey(keyProperty = “orguuid”,resultType = String.class,before = true, statement = “select replace(uuid(), ‘-’, ‘’)”)
@Insert(“INSERT INTO org (orguuid, orgid, orgnum, orgname, orgenable,created, updated, deleted) VALUES (#{orguuid},null,#{orgnum},#{orgname},#{orgenable},now(),#{updated},‘2019-10-10’)”)
void save(Org org);
结合自己项目自己改下字段,上面selectkey是给uuid生成不带“-”的uuid,让后insert中传递上去。
网上好多答案没说到点上,此方法可行,后续逐步优化完善。
从service层优化uuid传入:
@Override
public void save(Emp emp) {
emp.setId(UUID.randomUUID().toString());
empDao.save(emp);
}