MyBatis属性回填

MyBatis属性回填

一、数据自增长，增长后获取最后插入的id值，回填到User的id属性中。

方法1.

<insert id="adduser" parameterType="org.rong.bean.User">   <selectKey resultType="Long" keyProperty="id" order="AFTER">       SELECT LAST_INSERT_ID()   </selectKey>   INSERT INTO user set username=#{username},password=#{password},nickname=#{nickname}</insert>

方法2.

    <insert id="adduser2" parameterType="org.rong.bean.User" useGeneratedKeys="true" keyProperty="id">         INSERT INTO user set username=#{username},password=#{password},nickname=#{nickname}    </insert>

二，数据非自增长，先查询数据库uuid()，生成一段唯一的字符串，将字符串当成User的id属性值插入到数据库中

    <insert id="adduser3" parameterType="org.rong.bean.User2">        <selectKey resultType="String" keyProperty="id" order="BEFORE">            SELECT uuid()        </selectKey>        INSERT INTO user2 set username=#{username},id=#{id}    </insert>

三、测试

public class Main {    public static void main(String[] args) throws IOException {       SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getInstance();        SqlSession sqlSession = sqlSessionFactory.openSession();        User2 user2 = new User2(null, "qweqwewq");        sqlSession.insert("namespace.User.adduser3", user2);        sqlSession.commit();        System.out.println(user2.toString());    }}