String uuid = UUID.randomUUID().toString().toUpperCase();
java.util.Date d = new java.util.Date();
java.sql.Timestamp now = new java.sql.Timestamp(d.getTime());
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss");
java.util.Date recTime = formatter.parse(time);
java.sql.Timestamp sqlRecTime = new java.sql.Timestamp(recTime.getTime());