MyBatis案例二:根据主键查询
- 在DeptMapper接口中添加方法:
public Dept getById(int deptno);
- 在DeptMapper.xml文件中添加
<select id="getById" resultType="com.yy.domain.Dept">
select * from dept where deptno = #{id}
</select>
3.编写测试类方法:
@Test
public void testGetById() throws IOException{
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = factory.openSession();
DeptMapper deptMapper = session.getMapper(DeptMapper.class);
Dept dept = deptMapper.getById(10);
System.out.println(dept);
session.close();
}