建表数据:
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'))");
日期那怎么插入麻烦指点一下,谢谢
在程序连接时插入一条使用记录数据,一层层拨开init时插入就可以了