namespace中的包名要和Dao/Mapper接口名一致
id:对应的为namespace中的方法名
resultType:sql语句执行的返回值
parameterType:参数的类型
步骤：
1.编写接口
1 Integer addUser();
2. 编写对应mapper中的sql语句
1 <insert id="addUser" parameterType="com.dz.pojo.User"> 2 insert into mybatis.user id,name,pwd values (#{id},#{name},#{pwd}); 3 </insert>
3. 测试
1 @Test 2 public void addUser(){ 3 SqlSession sqlSession =MybatisUtils.getSqlSession(); 4 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); 5 int res = userMapper.addUser(new User(4,"dz","1213")); 6 if(res>0){ 7 System.out.println("添加成功"); 8 } 9 //提交事务 10 sqlSession.commit(); 11 sqlSession.close(); 12 }
注：增删改需要提交事务
1.编写接口
1 Integer deleteUser(Integer id);
2.编写对应mapper中的sql语句
1 <delete id="deleteUser" parameterType="int"> 2 delete from mybatis.user where id=#{id} 3 </delete>
3. 测试
1 public void deleteUser(){ 2 SqlSession sqlSession =MybatisUtils.getSqlSession(); 3 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); 4 userMapper.deleteUser(4); 5 sqlSession.commit(); 6 sqlSession.close(); 7 }
。。。
原文：https://www.cnblogs.com/lxzlovewyq/p/13435532.html