mapper.xml文件
select * from tb_door
mapper的接口文件(接口由我们自己声明,由Spring-mybatis提供子类实现类)
package com.tedu.dao;
import java.util.List;
import com.tedu.pojo.Door;
public interface DoorMapper {
//方法名必须肯mapper文件中的id值一致
public List findAll();
}
测试类中调用findAll方法
package com.tedu;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.jasper.tagplugins.jstl.core.ForEach;
import org.junit.Test;
import com.tedu.dao.DoorMapper;
import com.tedu.pojo.Door;
public class TestMybatis01 {
@Test
public void testFindAll01() throws Exception {
//1.读取mybatis核心配置文件(mybatis-config.xml),Resources是mybatis提供的工具类
InputStream in = Resources.getResourceAsStream("mybatis/mybatis-config.xml");
//2.通过配置信息获取SqlSession工厂对象
SqlSessionFactory fac = new SqlSessionFactoryBuilder().build( in );
//3.获取SQLSession对象(打开与数据库的连接)
SqlSession session = fac.openSession();
//4.获取Doormapper子类实例
DoorMapper doormapper = session.getMapper(DoorMapper.class);
List lis = doormapper.findAll();
//5.输出结果
for (Door door : lis) {
System.out.println(door);
}
}
}
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持考高分网。



