查询表里的创建时间 @Select("SELECT\n" + "\tcount(id)\n" + "FROM\n" + "\test \n" + "WHERE\n" + "\tDATE_FORMAT( createtime, '%Y-%m-%d' ) = #{today}") Integer getNowXjNum(@Param("today")String today);
实现类:
int count = 0;
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
String today = format.format(new Date());
Integer xdCount = this.baseMapper.getNowXjNum(today);
count = xdCount + 1;
//取编号 如 1 变为 001
String orderNumEnding = "000" + count;
orderNumEnding = orderNumEnding.substring(orderNumEnding.length() - 3);
//拼接编号
String xjNo = "XD" + today.replace("-", "") + orderNumEnding;
Test test = new Test();
test.setNum(ORDER);
this.save(test);
效果图: