Mybatis框架-10：mapper开发，参数传递之传递map类型和pojo类型

刺骨的言语ヽ痛彻心扉 2022-01-31 02:09 282阅读 0赞

# map传参 #

**1.先定义一个接口，接口书写遵循前面说的规范哦，我们这里需要传递一个map集合作为查询的参数**

public Customer queryCustomerByLike(Map hasmap);

**2.测试类中操作，我们这里自己new一个map，然后进行赋值，最后将这map传进去**

@Test
        public void test03(){
            SqlSession session = MyUtils.openSession();
            CustomerDao mapper = session.getMapper(CustomerDao.class);
            HashMap<String, Object> hashMap = new HashMap<>();
            hashMap.put("cust_id",2);
            hashMap.put("cust_name","李白");
            mapper.queryCustomerByLike(hashMap);
        }

**3.映射配置文件中，看，这里映射配置文件中的属性值（就是\#\{\}里的东西）必须是和你map里设置的key是一样的**

<select id="queryCustomerByLike" resultType="com.ctbu.domain.Customer">
    		select * from `customer` where cust_name like #{cust_name} and cust_id = #{cust_id}
    	</select>

# POJO传参 #

**1.定义一个使用pojo类型查询的接口（其他数据库操作类似）**

public Customer queryCustomerByPojo(Customer customer);

**2.映射配置文件中定义传入的参数类型**

<select id="queryCustomerByPojo" parameterType="com.ctbu.domain.Customer" resultType="com.ctbu.domain.Customer">
    		select * from `customer` where cust_name like #{cust_name} and cust_id = #{cust_id}
    	</select>

**3.测试类中进行测试（这里我们定义一个对象类型，设置好相关参数后，将怎个对象作为参数传递进去）**

@Test
        public void test04(){
            SqlSession session = MyUtils.openSession();
            CustomerDao mapper = session.getMapper(CustomerDao.class);
            Customer customer = new Customer();
            customer.setCust_name("李白");
            customer.setCust_id(2);
            mapper.queryCustomerByPojo(customer);
            session.close();
        }