@Test public void testGetTopicRowSet() { SqlRowSet srs = topicDao.getTopicRowSet(1); while (srs.next()) { System.out.println(srs.getString("topic_id")); } }
public SqlRowSet getTopicRowSet(int userId) { String sql = "SELECT topic_id,topic_title FROM t_topic WHERE user_id=?"; return jdbcTemplate.queryForRowSet(sql,userId); }
TopicDao { public SqlRowSet getTopicRowSet(int userId) { String sql = "SELECT topic_id,topic_title FROM t_topic WHERE user_id=?"; return jdbcTemplate.queryForRowSet(sql,userId); } }
TopicDao { public SqlRowSet getTopicRowSet(int userId) { String sql = "SELECT topic_id,topic_title FROM t_topic WHERE user_id=?"; return jdbcTemplate.queryForRowSet(sql,userId); }  }
TopicDao { public SqlRowSet getTopicRowSet(int userId) { String sql = "SELECT topic_id,topic_title FROM t_topic WHERE user_id=?"; return jdbcTemplate.queryForRowSet(sql,userId); }  @Autowired void setJdbcTemplate(JdbcTemplate jdbcTemplate); double getReplyRate(int userId); int getUserTopicNum(final int userId); int getUserTopicNum2(int userId); SqlRowSet getTopicRowSet(int userId); }
TopicDao { public SqlRowSet getTopicRowSet(int userId) { String sql = "SELECT topic_id,topic_title FROM t_topic WHERE user_id=?"; return jdbcTemplate.queryForRowSet(sql,userId); }  @Autowired void setJdbcTemplate(JdbcTemplate jdbcTemplate); double getReplyRate(int userId); int getUserTopicNum(final int userId); int getUserTopicNum2(int userId); SqlRowSet getTopicRowSet(int userId);  }