Mybatis 返回主键

最新推荐文章于 2024-07-04 16:46:39 发布

wanhf11

最新推荐文章于 2024-07-04 16:46:39 发布

阅读量292

点赞数

分类专栏： Mybatis

本文链接：https://blog.csdn.net/qq_17612199/article/details/50985940

版权

Mybatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<insert id="insert" parameterType="com.patest.entiy.UserInfo"
        useGeneratedKeys="true" keyProperty="userId">
        insert into user_info (user_id,
        usrpf_id, username,
        password, classroom, is_teacher,
        is_admin,
        is_active, last_login,
        add_time)
        values (#{userId,jdbcType=INTEGER},
        #{usrpfId,jdbcType=INTEGER},
        #{username,jdbcType=VARCHAR},
        #{password,jdbcType=VARCHAR}, #{classroom,jdbcType=VARCHAR},
        #{isTeacher,jdbcType=INTEGER},
        #{isAdmin,jdbcType=INTEGER},
        #{isActive,jdbcType=INTEGER},
        #{lastLogin,jdbcType=TIMESTAMP},
        #{addTime,jdbcType=TIMESTAMP})
</insert>

@Test
    public void test_insertUserInfo() throws Exception {
//      List<UserInfo> data=new ArrayList<UserInfo>();
//      data.add(new UserInfo(1, "hsah", "sajdhk", "das", 1, 1, 1,
//              Calendar.getInstance().getTime(), Calendar.getInstance().getTime()));
        System.out.println(testObj.insert(new UserInfo(1, "hds1231assah", "sajdhk", "das", 1, 1, 1,
                Calendar.getInstance().getTime(), Calendar.getInstance().getTime())));
    }