数据库id自增

MySQL数据库

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/orcl
jdbc.username=root
jdbc.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_info
minvalue  1
maxvalue  999999
start  with  1
increment  by  1
cache  20;

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.username=scott
jdbc.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>