首先根据数据表定义实体类
实体类,添加无参构造,有参构造,getter setter, toString, equals hashCode 方法。
public class User implements Serializable {
private Integer empno;
private String ename;
private String job;
private Integer mgr;
private String hiredate;
private Double sal;
private int comm;
private int deptno;
}
public interface UserMapper {
@Select("select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp where empno=#{empno}")
User findUserById(Integer empno);
}
@Test
public void testFindUserById(){
UserMapper mapper = ctx.getBean("userMapper",UserMapper.class);
User user = mapper.findUserById(1);
System.out.println(user);
}