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 map);
}

mapper.xml

<?xml version="1.0" encoding="UTF8" ?>



    
    
        insert into mybatis.user (id,name,pwd) values (#{id2},#{name2},#{pwd2});
    

测试类

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 map = new HashMap();

            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("%李%");
  

• 
  
      select * from mybatis.user where name like "%"#{name}"%";