返回list
1、编写接口方法:
public List<Teacher> getTeachersByNameLike(String name); //根据名字模糊查询,返回一个list
2、编写mapper文件
这里的返回值类型是list中元素 的类型,不是List!!!!
<select id="getTeachersByNameLike" resultType="bean.Teacher">
select * from teacher where name like #{
name}
</select>
3、编码测试
@Test
public void testSearch4() throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
//创建sqlSessionFactory对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//生成session实例
try (SqlSession session = sqlSessionFactory.openSession()) {
//获取接口的实现
TeacherMapper teacherMapper = session.getMapper(TeacherMapper.class);
List