mybatis之使用Map和模糊查询

使用Map

接口类

package com.yeyue.dao;

import com.yeyue.pojo.User;

import java.util.List;
import java.util.Map;

public interface UserDao {
    //新增用户
    int addUser2(Map<String,Object> map);
}

mapper.xml

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace:绑定一个对应的Dao/Mapper接口-->
<mapper namespace="com.yeyue.dao.UserDao">
    <!--新增用户-->
    <insert id="addUser2" parameterType="map" >
        insert into mybatis.user (id,name,pwd) values (#{id2},#{name2},#{pwd2});
    </insert>
</mapper>

测试类

package com.yeyue.dao;

import com.yeyue.pojo.User;
import com.yeyue.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class UserDaoTest {
    @Test
    public void test6() {
        //获得session对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        try {
            UserDao mapper = sqlSession.getMapper(UserDao.class);

            Map<String,Object> map = new HashMap<String,Object>();

            map.put("id2",9);
            map.put("name2","不好啦");
            map.put("pwd2","6688668");

            mapper.addUser2(map);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //提交事务
            sqlSession.commit();
            //关闭session
            sqlSession.close();
        }
    }
}

模糊查询

• //传递参数时拼接
  mapper.getUserList("%李%");
  

• <!--在sql中拼接-->
  <select id="getUserList" resultType="com.yeyue.pojo.User">
      select * from mybatis.user where name like "%"#{name}"%";
  </select>