我们经常需要在oracle中用到date类型的字段,怎样获取当前时间并将其插入到数据库中呢,
java.util.Date a = new java.util.Date();
java.sql.Timestamp d = new java.sql.Timestamp(a.getTime());
String sql = "insert into ORDE(OID,BID,UIDD,ONUMBER,ODATE,OTYPE) values(?,?,?,?,?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, order.getOId());
pstmt.setInt(2, order.getBId());
pstmt.setInt(3, order.getUIdd());
pstmt.setInt(4, order.getONumber());
pstmt.setTimestamp(5, d);
pstmt.setInt(6, order.getOType());
return pstmt.executeUpdate();