String maxDN = deliveryDAO.selectMaxDN(); // 从数据库查询出的最大编号
String dnNumber=DNUtils.generatorDnNumber(maxDN); //系统生成DN号
<select id="selectMaxDN" resultType="java.lang.String">
select max(DN_NUMBER) FROM DELIVERY_INFO
</select>
public class DNUtils {
public static String generatorDnNumber(String maxDN){
String dnNumber=null;
String df=DateUtil.getNowDate("YYYYMMdd");
String uid_pfix="DN"+df;
if (maxDN != null && maxDN.contains(uid_pfix)) {
String uid_end = maxDN.substring(10, 13); // 截取字符串最后三位,结果:001
int endNum = Integer.parseInt(uid_end); // 把String类型的001转化为int类型的1
int tmpNum = 1000 + endNum + 1; // 结果1002
dnNumber = uid_pfix + StringUtil.subStr("" + tmpNum, 1);// 把1002首位的1去掉,再拼成NO201601260002字符串
} else {
dnNumber = uid_pfix + "001";
}
return dnNumber;
}
}
public class DateUtil {
public static String getNowDate(String datePattern){
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat(datePattern);
return sdf.format(date);
}
}
参考地址:http://blog.csdn.net/jianyuerensheng/article/details/50592008