首先使用建表语句创建一个SOFTCLASS表:
CREATE TABLE "SCOTT"."SOFTCLASS" (
"ID" NUMBER NOT NULL ,
"NAME" VARCHAR2(255 BYTE) ,
"AGE" NUMBER ,
"SEX" VARCHAR2(255 BYTE) ,
"TEL" VARCHAR2(255 BYTE) ,
"MAIL_ACCOUNT" VARCHAR2(255 BYTE) ,
"ADDRESS" VARCHAR2(255 BYTE)
)
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('2', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('3', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('4', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('5', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('6', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('7', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('8', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
INSERT INTO "SCOTT"."SOFTCLASS"("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS") VALUES ('9', '测试', '18', '男', '15755332548', '110@163.com', '安徽阜阳');
其次为我们SOFTCLASS表的ID添加主键自增长策略:
CREATE SEQUENCE SOFTCLASS_sequence
INCREMENT BY 1
NOMAXVALUE
NOCYCLE
CACHE 10;
测试结果:
INSERT INTO SOFTCLASS
VALUES
( SOFTCLASS_sequence.nextval, '测试数据', '18', '男', '15755332548', '110@163.com', '安徽阜阳' );
到此则数据插入成功!
另外在Mybatis中插入数据时可以使用如下方式:
<insert id="addStudent" parameterType="com.ssm.pojo.SoftStudent">
<selectKey keyProperty="ID" resultType="int" order="BEFORE">
select SOFTCLASS_sequences.nextval from dual
</selectKey>
INSERT INTO SOFTCLASS("ID", "NAME", "AGE", "SEX", "TEL", "MAIL_ACCOUNT", "ADDRESS")
VALUES (#{ID} ,#{NAME}, #{AGE}, #{SEX}, #{TEL}, #{MAIL_ACCOUNT}, #{ADDRESS})
</insert>