CRUD
1.namespace
namespace中的包名要和Dao/Mapper接口包名一致
2.select
选择。查询语句;
- id就是对应Dao/Mapper接口下的方法名,实现接口的方法
- resultType 就是sql返回值类型 Class
- parameterType 参数类型
1.编写接口
User getUserByID(int id);
2.编写mapper中对应的方法SQL
<select id="getUserByID" resultType="com.kuang.pojo.User" parameterType="int">
select * from mybatis.user where id=#{id}
</select>
3.测试
@Test
public void getUserById(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper Mapper = sqlSession.getMapper(UserMapper.class);
User userByID = Mapper.getUserByID(1);
System.out.println(userByID);
sqlSession.close();
}
Insert
<insert id="addUser" parameterType="com.kuang.pojo.User" >
insert into mybatis.user (`id`,`name`,`pwd`) values (#{id},#{name},#{pwd})
</insert>
Delete
<!-- 为什么不需要返回值类型呢?-->
<delete id="deleteUser" parameterType="int" >
delete from mybatis.user where id =#{id}
</delete>
Update
<update id="updateUser" parameterType="com.kuang.pojo.User">
update mybatis.user set name=#{name} ,pwd=#{pwd} where id=#{id}
</update>
注意:
1.增删改需要提交事务