这里不过多介绍java和oracle里的各种日期的方法属性,只简要介绍两种可行的存取方案,本质上没什么区别
一:oracle中用date,java中用String
oracle表:
create table test(
t date
);
java存入:
String sql="insert into test values ( to_date( ? , 'yyyy-mm-dd hh24:mi:ss' ) )";
String time = " 2018-12-2 16:40:59 ";
ps = ct.prepareStatement(sql);
ps.serString( 1 , time);
ps.execute();
sql="commit";
ps = ct.prepareStatement(sql);
ps.execute();
java取出
String sql="select to_char(t , 'yyyy-mm-dd hh24:mi:ss' ) from test";
ps = ct.prepareStatement(sql);
ResultSet rs = ps.ps.executeQuery();
String the_time;
while(rs.next){
the_time = rs.getString(1);
}
二:oracle中用timestamp,java中用String
oracle表:
create table test(
t timestamp
);
java存入:
String sql="insert into test values ( to_timestamp( ? , 'yyyy-mm-dd hh24:mi:ss' ) )";
String time = " 2018-12-2 16:40:59 ";
ps = ct.prepareStatement(sql);
ps.serString( 1 , time);
ps.execute();
sql="commit";
ps = ct.prepareStatement(sql);
ps.execute();
java取出
String sql="select to_char(t , 'yyyy-mm-dd hh24:mi:ss' ) from test";
ps = ct.prepareStatement(sql);
ResultSet rs = ps.ps.executeQuery();
String the_time;
while(rs.next){
the_time = rs.getString(1);
}