java操作Oracle日期类型

方法一
SimpleDateFormat formatter = new SimpleDateFormat (“yyyy-MM-dd HH:mm:ss”);
String datetime = formatter.format(new Date());
String sql = “UPDATE HZSW_TZGL SET PUB_RSS_TIME = to_date(’” + datetime + “’,’[b]YYYY-MM-DD hh24:mi:ss[/b]’)” ;
方法二
PreparedStatement pstmt = conn.prepareStatement(“insert into book (name,buydate) values (?,?)”);
　　java.sql.Date buydate=java.sql.Date.valueOf(“2005-06-08”);
　　pstmt.setString(1, “Java编程思想”);
　　pstmt.setDate(2,buydate );
　　pstmt.execute();
方法三
PreparedStatement pstmt = conn.prepareStatement(“insert into book (name,buydate) values (?,?)”);

java.sql.Timestamp buydate=java.sql.Timestamp.valueOf(“2004-06-08 05:33:99”);
　　pstmt.setString(1, “Java编程思想”);
　　pstmt.setTimestamp(2,buydate );
　　pstmt.execute();
方法四
PreparedStatement pstmt = conn.prepareStatement(“insert into book (name,buydate) values (?,to_date(?, ‘yyyy-mm-dd hh24:mi:ss’)”);

String buydate=“2004-06-08 05:33:99”;
　　pstmt.setString(1, “Java编程思想”);
　　pstmt.setString(2,buydate );
　　pstmt.execute();