数据库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>