public void saveVisitByYear() { SqlRowSet s = this.queryForRowSet( "SELECT year,COUNT(*) AS visit " + " FROM log_visit " + " GROUP BY year ;"); while (s.next()) { VisitInfo visitInfo = new VisitInfo(); visitInfo.setName(s.getString("year")); visitInfo.setVisitQuantity(s.getInt("visit")); visitInfo.setType("year"); handleSaveVisitInfo(visitInfo); } }