订单号生成
package com.sims.service.goods.impl;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
@Service
public class OrderServiceBean extends DaoSupport<Order> implements OrderService{
* 生成订单号,订单号的组成 两位年+两位月+两位日+两位小时+当天的订单总数 如:11071012100
* @param createDate
* @return
*/
private String buildOrderid(Date createDate) {
SimpleDateFormat dateFormat = new SimpleDateFormat("yyMMddHH");
StringBuilder out = new StringBuilder(dateFormat.format(createDate));
dateFormat = new SimpleDateFormat("yyyy-MM-dd");
String strdate = dateFormat.format(createDate);// 2011-07-10
Date date = createDate;
try {
date = dateFormat.parse(strdate);
} catch (ParseException e) {e.printStackTrace();}
long count = (Long)em.createQuery("select count(o) from Order o where o.createDate>=?1")
.setParameter(1, date, TemporalType.TIMESTAMP).getSingleResult();
out.append(count+1);
return out.toString();
}
}
声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
- 上一篇:没有了
- 下一篇: mysql创建自定义函数和存储过程
