private Account createAccount(ResultSet rs) throws Exception { Account a = new Account(); a.setId(rs.getInt("id")); a.setRecommenderId(rs.getInt("recommender_id")); a.setLoginName(rs.getString("login_name")); a.setLoginPassword(rs.getString("login_passwd")); a.setStatus(rs.getString("status")); a.setCreateDate(rs.getDate("create_date")); a.setPauseDate(rs.getDate("pause_date")); a.setCloseDate(rs.getDate("close_date")); a.setRealName(rs.getString("real_name")); a.setIdcardNo(rs.getString("idcard_no")); a.setBirthdate(rs.getDate("birthdate")); a.setGender(rs.getString("gender")); a.setOccupation(rs.getString("occupation")); a.setTelephone(rs.getString("telephone")); a.setEmail(rs.getString("email")); a.setMailaddress(rs.getString("mailaddress")); a.setZipcode(rs.getString("zipcode")); a.setQq(rs.getString("qq")); a.setLastLoginTime(rs.getDate("last_login_time")); a.setLastLoginIp(rs.getString("last_login_ip")); return a; }