如何在java链接数据库时插入时间？

Question

建表数据：
CREATE TABLE REGISTER (
ID NUMBER PRIMARY KEY,
NAME VARCHAR2 (20) CONSTRAINT register_name_nn NOT NULL,
room NUMBER CONSTRAINT register_room_nn NOT NULL,
bed NUMBER CONSTRAINT register_bed_nn NOT NULL,
depart VARCHAR2 (50) CONSTRAINT register_depart_nn NOT NULL,
aclass VARCHAR2 (20) CONSTRAINT register_aclass_nn NOT NULL,
tel NUMBER CONSTRAINT register_tel_un UNIQUE,
leave_time TIMESTAMP,
back_time TIMESTAMP
);
表：
java插入数据代码：
ps=connection.prepareStatement("insert into register(id,name,room,bed,depart,aclass,tel,leave_time,back_time) values(3,'lily',817,1,'数学与计算机','17计算机',12345678907,timestamp('2020-01-24','yyyy-mm-dd'),timestamp('2020-4-30','yyyy-mm-dd'))");
日期那怎么插入麻烦指点一下，谢谢

Answer 1

在程序连接时插入一条使用记录数据，一层层拨开init时插入就可以了