查詢常用方法如下： <br/> **1. `Map<String, Object> queryForMap(String sql, @Nullable Object... args)`** ```java String sql = "select id, name, age, gender from student where id=?"; Map<String, Object> dataMap = jdbcTemplate.queryForMap(sql, new Object[]{51}); ``` **2. `<T> List<T> query(String sql, RowMapper<T> rowMapper)`** ```java String sql = "select id, name, age, gender from student"; List<Student> dataList = jdbcTemplate.query(sql, new RowMapper<Student>() { @Override public Student mapRow(ResultSet rs, int i) throws SQLException { Student student = new Student(); student.setId(rs.getInt("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setGender(rs.getString("gender")); return student; } }); ``` **3. `<T> List<T> query(String sql, @Nullable Object[] args, RowMapper<T> rowMapper)`** ```java String sql = "select id, name, age, gender from student where id = ?"; List<Student> dataList = jdbcTemplate.query(sql, new Object[]{51}, new RowMapper<Student>() { @Override public Student mapRow(ResultSet rs, int i) throws SQLException { Student student = new Student(); student.setId(rs.getInt("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setGender(rs.getString("gender")); return student; } }); ``` **4. `<T> List<T> query(String sql, @Nullable PreparedStatementSetter pss, RowMapper<T> rowMapper)`** ```java String sql = "select id, name, age, gender from student where id = ?"; List<Student> dataList = jdbcTemplate.query(sql, new PreparedStatementSetter() { @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setInt(1, 51); } }, new RowMapper<Student>() { @Override public Student mapRow(ResultSet rs, int i) throws SQLException { Student student = new Student(); student.setId(rs.getInt("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setGender(rs.getString("gender")); return student; } }); ``` **5. `List<Map<String, Object>> queryForList(String sql)`** ```java String sql = "select id, name, age, gender from student"; List<Map<String, Object>> dataList = jdbcTemplate.queryForList(sql); ``` **6. `<T> List<T> queryForList(String sql, Class<T> elementType)`** ```java String sql = "select id, name, age, gender from student"; List<Student> dataList = jdbcTemplate.queryForList(sql, Student.class); ``` **7. `List<Map<String, Object>> queryForList(String sql, @Nullable Object... args)`** ```java String sql = "select id, name, age, gender from student where id=?"; List<Map<String, Object>> dataList = jdbcTemplate.queryForList(sql, new Object[]{51}); ``` **8. ` <T> List<T> queryForList(String sql, Class<T> elementType, @Nullable Object... args)`** ```java String sql = "select id, name, age, gender from student where id=?"; List<Student> dataList = jdbcTemplate.queryForList(sql, Student.class, new Object[]{51}); ``` **9. 分頁查詢** `<T> List<T> queryForList(String sql, Class<T> elementType, @Nullable Object... args)` ```java //當前頁 int page = 1; //頁面大小 int size = 10; String sql = "select id, name, age, gender from student where gender=? limit ?,?"; List<Student> dataList = jdbcTemplate.queryForList(sql, Student.class, new Object[]{"男", (page - 1) * size, size}); ``` **10. Oracle的分頁查詢語句** ```sql SELECT * FROM (SELECT A.*,ROWNUM AS RN FROM (SELECT * FROM ${tableName} WHERE 1=1 -- 條件 ORDER BY CREATETIME DESC,ID -- 排序 ) A WHERE A.ROWNUM <= #{pageNum}*#{pageSize} ) B WHERE B.RN > #{pageNum-1}*#{pageSize} /* 由于oracle排序算法問題，如果排序遇到相同的條件，比如時間， 會使分頁后一頁包含前一頁的內容，所以這個時候添加一個唯一的字段，比如ID。 */ ```