String number = "";
String _str_date = MiscUtils.timestampToString(new Date(), "yyMMdd");
···
sql = "select * from inv_lot_trans v where v.issue_number like '%_str_date%'"
···
if (resultSet.next()) {
int temp = resultSet.getInt(1);
number = (temp + "").substring(1);
} else {
number = "001";
}