java 存取oracle資料庫日期資料

//存日期資料

SimpleDateFormat sdf = new SimpleDateFormate("yyyy-MM-dd"); //中間是大寫的MM

String date = sdf.format(new Date()); //Date 為util包的類型

String sql = "insert into scott.bankstatement (id,acction,txdate,amt,toaccno,fromaccno ) values (seqOnbank.nextval, " +\'storeM\',to_date(\'"+date+"\',\'yyyy-mm-dd\'),"+balance+","+accno+","+accno+")";

.....

 //如果用preparedStatement 類的setDate（）确定日期值得時候，講字元串轉為sql。Date日期類型

String dateStringToParse  = “2013-09-11”;

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd"); 

ry{

       java.util.Date date =df.parse(dateStringToParse);

       java.sql.Date sqlDate = new java.sql.Date(date.getTime());

       System.out.println(sqlDate.getTime());

}

catch (Exception ex) {

     System.out.println(ex.getMessage());

}

//取日期資料

String date = "\'1991-09-01\'"

String  sql = "select txdate from scott.bankstatement  where txdate = "  + date;