public Visitor mapRow(ResultSet rs, int rowNum) throws SQLException { Visitor visitor = new Visitor(); visitor.setId(rs.getInt("id")); visitor.setIp(rs.getString("ip")); visitor.setCreate_time(rs.getTimestamp("create_time")); visitor.setUa(rs.getString("ua")); return visitor; }