(1)根据id查询
//根据id查询 User findById(Integer userId);
(2)在IUserDao.xml中
<!--根据id查询--> <select id="findById" parameterType="int" resultType="cn.rzpt.domain.User"> select * from user where ud=#{id} </select>
(1)根据姓名查询
//根据姓名查询 List<User> findaByName(String username);
(2)在IUserDao.xml中
<!--根据姓名查询--> <select id="findaByName" parameterType="String" resultType="cn.rzpt.domain.User"> select * from user where username like #{name} </select>
(3)在测试类中:
List<User> userList = userDao.findaByName("%王%"); for (User user: userList) { System.out.println(user); }