1、查询用户
1.1查询所有用户
UserMapper:
//查询所有用户
List<User> getUserList();
UserMapper.xml:
<!--查询所有用户-->
<select id="getUserList" resultType="com.tang.pojo.User">
select * from maybatis.user
</select>
Test:
@Test
public void test(){
//第一步:获取SqlSession对象
SqlSession sqlSession= MybatisUtils.getSqlSession();
//方式1
UserMapper userMapper =sqlSession.getMapper(UserMapper.class);
List<User> userList= userMapper.getUserList();
for(User user:userList){
System.out.println(user);
}
sqlSession.close();
}
1.2 模糊查询
UserMapper:
//模糊查询
User getUserLike(String value);
User getUserLike(Map<String,Object>map);
UserMapper.xml:
<!-- 模糊查询-->
<select id="getUserLike" resultType="com.tang.pojo.User" parameterType="String">
select * from maybatis.user where name like "%"#{value}"%"
</select>
<select id="getUserLike2" resultType="com.tang.pojo.User" parameterType="map">
select * from maybatis.user where name like #{value}
</select>
这里值得注意的是:#{}格式是可以防止sql注入的
什么是sql注入呢?
select * from user where id=1;
1是用户自己可以输入的
select * from user where id=1 or 1=1
你会发现这是不是一个永真式,就会查询到所有的内容
Test:
@Test
public void getUserLike(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
// Map<String,Object> map=new HashMap<String,Object>();
User user = userMapper.getUserLike("小");
System.out.println(user);
}
@Test
public void getUserLike2(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
Map<String,Object> map=new HashMap<String,Object>();
map.put("value","%小%");
// User user = userMapper.getUserLike("小");
User userLike = userMapper.getUserLike(map);
System.out.println(userLike);
}
2、添加用户
2.1 通过实体类参数进行操作
UserMapper:
int addUser(User user);
UserMapper.xml:
<insert id="addUser" parameterType="com.tang.pojo.User">
insert into maybatis.user(name,sex) values (#{name},#{sex})
</insert>
Test:
@Test
public void addUser(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper =sqlSession.getMapper(UserMapper.class);
int i= userMapper.addUser(new User("哈哈哈","男"));
if(i>0){
System.out.println("插入成功!");
sqlSession.commit();
}
sqlSession.close();
}
2.2 通过Map进行传参操作:
UserMapper:
int addUser2(Map<String,Object> map);
UserMapper.xml:
<insert id="addUser2" parameterType="map">
insert into maybatis.user(name,sex) values(#{username},#{usersex})
</insert>
Test:
@Test
public void addUser2(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
Map<String,Object> map=new HashMap<String,Object>();
map.put("username","董权");
map.put("usersex","男");
userMapper.addUser2(map);
sqlSession.commit();
sqlSession.close();
}
这里仔细看看与实体类的区别,会发现在xml文件中,它的属性名是和实体类的属性名不一样的
个人体会:刚开始看map这个东西,我感觉好像很复杂,为什么还要用这个呢?
其实不然,这里是因为我们的参数过少的原因,在之前我用User实体类进行操作的时候就有体会,添加参数的时候,如果参数很多,而我只需要用一部分参数的时候,我还需要通过创建构造方法去实现,很麻烦。map也可以理解为一个容器,将东西存储进去后,也可以输出出来。
3、修改用户
UserMapper:
//修改用户信息
int updateUser(User user);
int updateUser2(Map<String,Object> map);
UserMapper.xml:
<update id="updateUser" parameterType="com.tang.pojo.User">
update maybatis.user set name=#{name},sex=#{sex} where id=#{id}
</update>
<update id="updateUser2" parameterType="map">
update maybatis.user set name=#{username},sex=#{usersex} where id=#{userid}
</update>
Test:
@Test
public void updateUser(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper =sqlSession.getMapper(UserMapper.class);
int i = userMapper.updateUser(new User(5,"唐三","男"));
if(i>0){
System.out.println("修改成功!");
sqlSession.commit();
}
sqlSession.close();
}
@Test
public void updateUser2(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
Map<String, Object> map = new HashMap<>();
map.put("username","小董");
map.put("usersex","女");
map.put("userid",8);
userMapper.updateUser2(map);
sqlSession.commit();
sqlSession.close();
}
4、删除用户
UserMapper:
//删除用户
int deleteUser(int id);
UserMapper.xml:
<!-- 删除用户-->
<delete id="deleteUser" parameterType="int">
delete from maybatis.user where id=#{id}
</delete>
Test:
@Test
public void deleteUser(){
SqlSession sqlSession=MybatisUtils.getSqlSession();
UserMapper userMapper =sqlSession.getMapper(UserMapper.class);
int i = userMapper.deleteUser(7);
if(i>0){
System.out.println("删除成功!");
sqlSession.commit();
}
sqlSession.close();
}