[TOC] 在pojo包下創建QueryVo類 ~~~ package pojo; import java.io.Serializable; public class QueryVo implements Serializable { private static final long serialVersionUID = 1L; private User user; public User getUser() { return user; } public void setUser(User user) { this.user = user; } } ~~~ UserMapper類的接口 ~~~ public List<User> findUserByQueryVo(QueryVo vo); ~~~ 然后我們寫sql ~~~ <!-- 根據用戶名,模糊查詢 --> <select id="findUserByQueryVo" parameterType="QueryVo" resultType="pojo.User"> select * from user where username like "%"#{user.username}"%" </select> ~~~ 測試 ~~~ @Test public void testQueryVo() throws Exception { // 加載核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); // 創建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); // 創建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); // SqlSEssion幫我生成一個實現類 （給接口） UserMapper userMapper = sqlSession.getMapper(UserMapper.class); QueryVo vo = new QueryVo(); User user = new User(); user.setUsername("五"); vo.setUser(user); List<User> us = userMapper.findUserByQueryVo(vo); for (User u : us) { System.out.println(u); } } ~~~