(二)CRUD
1、namespace
namespace中的包名要和Dao/mapper接口的包名一致!
2、select
选择,查询语句;
- id:对应的namesapce中的方法名;
- resultType:Sql语句执行的返回值!
- parameterType:参数类型!
-
编写接口
//根据id查询用户 User getUserById(int id);
-
在xml文件中编写对应的标签
<select id="getUserById" parameterType="int" resultType="com.ysl.pojo.User"> select * from mybatis.user where id = #{id} </select>
-
测试
@Test public void getUserById(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); User user = mapper.getUserById(3); System.out.println(user); sqlSession.close(); }
增删改需要提交事务
3、insert
<insert id="addUser" parameterType="com.ysl.pojo.User" >
insert into mybatis.user (id, name, pwd) values (#{id},#{name},#{pwd})
</insert>
4、update
<update id="updateUser" parameterType="com.ysl.pojo.User">
update mybatis.user
set name =#{name},pwd=#{pwd}
where id = #{id};
</update>
5、delete
<delete id="delUser" parameterType="int">
delete
from mybatis.user
where id = #{id};
</delete>
6、万能Map
假设,我们的实体类,或者数据库中的表,字段或者参数过多,我们应当考虑使用Map!
//万能Map
int addUser2(Map<String, Object> map);
<insert id="addUser2" parameterType="map">
insert into mybatis.user(id, name, pwd) values (#{userid},#{username},#{userpawd})
</insert>
@Test
public void addUser2(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Map<String, Object> map = new HashMap<>();
map.put("userid",12);
map.put("username","wangwu");
map.put("userpawd",123123);
mapper.addUser2(map);
sqlSession.commit();
sqlSession.close();
}
Map传递参数,直接在sql中取出key’即可!【parameterType=“map”】
对象传递参数,直接在sql中取出对象的属性即可!【parameterType=“Object”】
只有一个基本类型参数的情况下,可以直接在sql中取到!
多个参数用Map,或者注解!