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