数据库id自增

来源：互联网发布：斗牛牌型算法编辑：程序博客网时间：2024/05/16 15:53

MySQL数据库

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc\:mysql\://localhost\:3306/orcljdbc.username=rootjdbc.password=root

<insert id="insert" useGeneratedKeys="true" keyProperty="id">    insert into users(user_name,password) values(#{userName},#{password})</insert>

在插入数据时不用传入id，在MySQL数据库中创建该表时，设置该表id自增

Oracle

需要先在数据库中创建一个自增的序列

create sequence seq_user_infominvalue  1maxvalue  999999start  with  1increment  by  1cache  20;

jdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcljdbc.username=scottjdbc.password=root

<insert id="insert">    <selectKey keyProperty="id" order="BEFORE" resultType="_int">        select seq_user_info.nextval id from dual    </selectKey>    insert into users(id,user_name,password) values(#{id},#{userName},#{password})</insert>

阅读全文

0 0