MyBatis02：CRUD操作和配置解析

MyBatis02：CRUD操作和配置解析

CRUD

select

根据id查询用户

1. 接口方法

public interface UserMapper {
   

    //查询所有用户
    List<User> selectUser();

}

2. sql映射文件

<select id="selectUserById" parameterType="integer" resultType="com.wgg.pojo.User">
    select * from user where id=#{id}
</select>

3. 测试

@Test
public void testSelectUserById() {
   
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);
    
    User user = mapper.selectUserById(2);
    System.out.println(user);
    session.close();
}

根据密码和名字查询用户

1. 接口方法

//通过密码和名字查询用户
User selectUserByNP(@Param("username") String username, @Param("pwd") String pwd);

2. sql映射文件

<select id="selectUserByNP" resultType="com.wgg.pojo.User">
    select * from user where name=#{username} and pwd=#{pwd}
</select>

3. 测试

@Test
public void testSelectUserByNP() {
   
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);
    User user = mapper.selectUserByNP("张三", "abcdef");
    System.out.println(user);
    session.close();
}

使用万能Map

1. 接口方法

 //通过密码和名字查询用户,通过Map传递参数
User selectUserByNP2(Map<String,Object> map);

2. sql映射文件

<select id="selectUserByNP2" parameterType="map" resultType="com.wgg.pojo.User">
    select * from user where name=#{username} and pwd=#{pwd}
</select>

3. 测试

@Test
public void testSelectUserByNP2() {
   
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);

    Map<String, Object> map = new HashMap<String, Object>();
    map.put("username","小明");
    map.put("pwd","123456");

    User user = mapper.selectUserByNP2(map);
    System.out.