<!-- public int insertUser(User user); -->
<insert id="insertUser" parameterType="com.offcn.pojo.User" >
insert into user values(uid=#{uid},uname=#{userName},address=#{address},weixin=#{weixin},qq=#{qq})
</insert>
// 添加user对象》》10条
@Test
public void show1(){
SqlSession session = Utils.getSeesion();
UserMapper mapper = session.getMapper(UserMapper.class);
User user = new User();
user.setUid(1000);
user.setAddress("address");
user.setWeixin("55500");
user.setQq("99900");
user.setUserName("name");
mapper.insertUser(user );
session.commit();
session.close();
}
在向user表中插入数据时,各项数据全部为0。
检查后发现sql插入语句书写错误。
insert into user values(uid=#{uid},uname=#{userName},address=#{address},weixin=#{weixin},qq=#{qq})
//修改为下方代码即可
insert into user values(#{uid},#{userName},#{address},#{weixin},#{qq})
修改后结果: