练习mybits时,添加用户出现的空值问题
练习mybits时,添加用户出现的空值问题
<!-- //有问题,加进去的都是null-->
<insert id="add" parameterType="cn.laoyao.pojo.User">
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})
</insert>
这时感觉写的没问题啊,但是经过测试发现传入数据库的值全为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 id="add" parameterType="cn.laoyao.pojo.User">
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})
</insert>
结果: