private static SignUpSubscriber getSignUpSubscriber(ResultSet resultSet) {
SignUpSubscriber signUpSubscriber = new SignUpSubscriber();
try {
signUpSubscriber.setiSubscriberID(resultSet.getInt("iSubscriberID"));
signUpSubscriber.setsName(resultSet.getString("sName"));
signUpSubscriber.setsEmail(resultSet.getString("sEmail"));
signUpSubscriber.setsPassword(resultSet.getString("sPassword"));
signUpSubscriber.setsAddress(resultSet.getString("sPhoneNumber"));
signUpSubscriber.setsPhoneNumber(resultSet.getString("sAddress"));
signUpSubscriber.setiDOB(resultSet.getDate("iDOB"));
signUpSubscriber.setiBalance(resultSet.getInt("iBalance"));
signUpSubscriber.setiRegistrationStatus(resultSet.getInt("iRegistrationStatus"));
return signUpSubscriber;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return signUpSubscriber;
}
