练习mybits时，添加用户出现的空值问题



    insert into smbms.smbms_user(id, userCode, userName, userPassword, gender, birthday, phone, address, userRole, createdBy, creationDate, modifyBy, modifyDate, idPicPath, workPicPath)
    VALUES (id=#{id},userCode=#{userCode},userName=#{userName},userPassword=#{userPassword},gender=#{gender},birthday=#{birthday},phone=#{phone},address=#{address},userRole=#{userRole},createdBy=#{createdBy},creationDate=#{creationDate},modifyBy=#{modifyBy},modifyDate=#{modifyDate},idPicPath=#{idPicPath},workPicPath=#{workPicPath})

这时感觉写的没问题啊，但是经过测试发现传入数据库的值全为null。

测试代码：

@Test
public void addUser() {
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    User user = new User();
    user.setUserCode("zhangsan");
    user.setUserName("张三");
    user.setUserPassword("123456");
    user.setGender(1);
    user.setPhone("132112121121");
    user.setAddress("陕西西安");
    user.setBirthday(new Date());

    user.setUserRole(2);
    user.setCreationDate(new Date());

    System.out.println(user.getUserName());
    System.out.println(user.getUserCode());
    System.out.println(user.getBirthday());

    mapper.add(user);
    sqlSession.commit();
    sqlSession.close();
}

数据库结果：

然后对代码进行修改


        insert into smbms.smbms_user(id, userCode, userName, userPassword, gender, birthday, phone, address, userRole, createdBy, creationDate, modifyBy, modifyDate, idPicPath, workPicPath)
        VALUES (#{id},#{userCode},#{userName},#{userPassword},#{gender},#{birthday},#{phone},#{address},#{userRole},#{createdBy},#{creationDate},#{modifyBy},#{modifyDate},#{idPicPath},#{workPicPath})

结果：

练习mybits时，添加用户出现的空值问题

相关

标签