1、java.util.Date和java.sql.Date之间的类型转换java.util.Date和java.sql.Date之间的类型转换
java.util.Date utilDate=new java.util.Date();
java.sql.Date sqlDate=new java.sql.Date(utilDate.getTime());
String trasaction_datetime = String.format("%tT", utilDate);
String storeTran = "insert into transaction values(" + (maxTranId+1) + ",'debit'," + balance + "," + accout_id + ",TO_DATE('"+sqlDate+" "+trasaction_datetime+"', 'YYYY-MM-DD HH24:MI:SS'))";
con.executeUpdate(storeTran);
2、String和Date的转换