Oracle插入timestamp类型数据

create table TEST(
? ID? ? ? INTEGER,
? BIRTHDAY TIMESTAMP
);

使用JDBC将日期插入到TIMESTAMP类型字段

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class Test {
?
?static {
? try {
? ?Class.forName("oracle.jdbc.driver.OracleDriver");
? } catch (ClassNotFoundException e) {
? ?e.printStackTrace();
? }
?}

?/**
? * 获得Connection
? *
? * @return
? */
?public static Connection getConnection() {
? Connection conn = null;
? try {
? ?conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/orcl", "root", "root");
? } catch (SQLException e) {
? ?e.printStackTrace();
? }
? return conn;
?}

?public static void main(String[] args) throws SQLException {
? // TODO Auto-generated method stub
? PreparedStatement pst = null;
? Connection conn = getConnection();
? SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
? String myDate = df.format(new Date()); //当前时间
? String sql = "insert into test(id,birthday) values('1',to_timestamp('" + myDate + "','yyyy-mm-dd hh24:mi:ss'))";
? pst = conn.prepareStatement(sql);
?
? pst.executeUpdate();
? // 省略IO流close
?}

}

使用to_timestamp将字符型转成timestamp