Mybatis--insert新增

Dao层接口SysUserMapper的方法：

int insert(SysUser user);

2、SysUserMapper.xml中对应的代码：

<insert id="insert" parameterType="com.gx.po.SysUser">

insert into sys_user (id, gmt_create, gmt_modified,

is_deleted, user_name, user_password,

salt, department_id, position_id,

role_id, real_name, gender,

birthday, portrait, email,

mobile, qq, wechat,

user_status, login_count, remark

)

values (#{id,jdbcType=INTEGER}, #{gmtCreate,jdbcType=TIMESTAMP}, #

{gmtModified,jdbcType=TIMESTAMP},

#{isDeleted,jdbcType=TINYINT}, #{userName,jdbcType=VARCHAR}, #

{userPassword,jdbcType=CHAR},

#{salt,jdbcType=CHAR}, #{departmentId,jdbcType=INTEGER}, #

{positionId,jdbcType=INTEGER},

#{roleId,jdbcType=INTEGER}, #{realName,jdbcType=VARCHAR}, #

{gender,jdbcType=TINYINT},

#{birthday,jdbcType=DATE}, #{portrait,jdbcType=VARCHAR}, #

{email,jdbcType=VARCHAR},#{mobile,jdbcType=VARCHAR}, #{qq,jdbcType=VARCHAR}, #

{wechat,jdbcType=VARCHAR},

#{userStatus,jdbcType=TINYINT}, #{loginCount,jdbcType=INTEGER}, #

{remark,jdbcType=VARCHAR}

)

</insert>

3、测试方法：

@Test

public void testInsert() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

try {

SysUserMapper sysUserMapper = sqlSession.getMapper(SysUserMapper.class);

SysUser user=new SysUser();

user.setUserName("user202108");

user.setUserPassword("jkdfkjvsjkjdjkfvnjdkvn");

user.setRealName("测试");

user.setGmtCreate(new Date());

int intR=sysUserMapper.insert(user);//返回的是受影响行数

System.out.println("新增结果:"+intR);

sqlSession.commit();//记得提交

} finally {

sqlSession.close();

}

}

新增结果：