songdancer的博客

通过insert into ... select...插入数据并且返回自增主键 数据库：Oracle Mybatis注解方式通过@SelectKey注解查询主键自增后的序列，并将其返回，代码如下：@Insert("insert into sys_user (username, usercode) select username, usercode from sys_user where id = 2")@SelectKey(statement = "SELECT USER_ID_SEQ.CUR

1.新增多行数据@Insert({"<script>insert all " + "<foreach collection=\"list\" index=\"index\" item=\"item\" open=\"\" separator=\"\" close=\"\">" + " into s_user (user,username) values " + "(#{item.user},#{item.u