动态代理操作数据库 只需要:1个接口 1个mapper.xml即可 避免自己手写实现类 简化了操作
创建测试程序1: 根据学号查找学生
测试代码:
public class MapperTest {
@Test
public void Test3() throws IOException {
String resource = "sqlMapConfig.xml"; //路径
//读取配置文件(用输入流来读取)
InputStream in = Resources.getResourceAsStream(resource );
//创建sqlSessionFactory
SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(in);
//生产一个sqlSession
SqlSession ss = ssf.openSession();
//操作数据库
StudentMapper mapper = ss.getMapper(StudentMapper.class);
//通过mapper能直接获取接口对象
Student student = mapper.selectStuByNum("2016001");
System.out.println(student);
}
}
接口:
public interface StudentMapper {
//通过学号查询学生
public Student selectStuByNum(String num);
}
StudentMapper.xml:
运行结果: