mybatis增删改查

Mybatis增删改查操作流程：

1. 接口中添加方法；
2. mapper.xml實作接口
3. Junit測試運作.

一、 查詢資料

user getUserById(int id);
           

<select id="getUserById" parameterType="int" resultType="com.wang.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(1);
    System.out.println(user);
}
           

二、删除，插入、修改操作

UserMapper.java

void addUser(user user);
void updateUser(user user);
void deleteUser(int id);
           

UserMapper.xml

<insert id="addUser" parameterType="com.wang.pojo.user" >
   insert into mybatis.user(id,name,pwd) values(#{id},#{name},#{pwd})
</insert>

 <update id="updateUser" parameterType="com.wang.pojo.user" >
   update mybatis.user set name=#{name} ,pwd=#{pwd} where id=#{id}
 </update>

 <delete id="deleteUser" parameterType="int" >
   delete from mybatis.user where id=#{id}
 </delete>
           

UserMapperTest.java

@Test
public void addUser(){
    SqlSession sqlSession=MybatisUtils.getSqlSession();
    UserMapper mapper=sqlSession.getMapper(UserMapper.class);
    mapper.addUser(new user(6,"張中","66666"));
    sqlSession.commit();
    sqlSession.close();
}
@Test
public void updateUser(){
    SqlSession sqlSession=MybatisUtils.getSqlSession();
    UserMapper mapper=sqlSession.getMapper(UserMapper.class);
    mapper.updateUser(new user(2,"zzz","0011123"));
    sqlSession.commit();
    sqlSession.close();
}
@Test
public void deleteUser(){
    SqlSession sqlSession=MybatisUtils.getSqlSession();
    UserMapper mapper= sqlSession.getMapper(UserMapper.class);
    mapper.deleteUser(1);
    sqlSession.commit();
    sqlSession.close();
}
           

三、Map操作、模糊查詢

UserMapper.java

//萬能的map
void addUser2(Map<String,Object> map);
List<user> getUserByLike(String value);
           

UserMapper.xml

<insert id="addUser2" parameterType="com.wang.pojo.user" >
   insert into mybatis.user(id,pwd) values(#{id},#{pwd})
</insert>

 <select id="getUserByLike" parameterType="String" resultType="com.wang.pojo.user">
   select * from mybatis.user where name like#{value}
</select>
           

UserMapperTest.java

@Test
public void addUser2(){
    SqlSession sqlSession=MybatisUtils.getSqlSession();
    UserMapper mapper=sqlSession.getMapper(UserMapper.class);
    Map<String,Object> map =new HashMap<String,Object>();
    map.put("id",1);
    map.put("name","xhhs");
    map.put("pwd","11111111111");
    mapper.addUser2(map);
    sqlSession.commit();
    sqlSession.close();
}

@Test
public void getUserByLike(){
    SqlSession sqlSession=MybatisUtils.getSqlSession();
    UserMapper mapper=sqlSession.getMapper(UserMapper.class);
    List<user> userList =mapper.getUserByLike("%小%");
    for(user user:userList){
        System.out.println(user);
    }
}
ass);
    List<user> userList =mapper.getUserByLike("%小%");
    for(user user:userList){
        System.out.println(user);
    }
}