Action
String s=getCommonQueryService().getDatabaseTime("yyyyMMddHH24miss");
int x=(int)(Math.random()*9000)+1000;
String serial = s + x;
model.setTtk_lsh(serial);
Impl
@Override
public String getDatabaseTime() {
return getQueryDao().getDatabaseTime("yyyy-MM-dd HH24:mi:ss");
}
Mapper
<select id="getDatabaseTime" resultType="string" parameterType="string">
select to_char(sysdate,#{dataFormat}) databaseTime from dual
</select>