Retrieving multiple records using spring jdbc+mysql

(type1 without passing any parameters to query and getting all rows)

String SELECT_NAME_CARDID_EXPIRY=""select *from user_enrollment_data";

DAO
public List<FailedRecords> getAllRecords();

DaoImpl

public List<FailedRecords> getAllRecords() {

return mysqlJdbcTemplate.query

(SELECT_NAME_CARDID_EXPIRY, 

new NullRecordRowMapper());  

}

NullRecordRowMapper

public class NullRecordRowMapper implements RowMapper<FailedRecords> {

@Override

public FailedRecords mapRow(ResultSet resultSet, int line)

throws SQLException {

NullRecordsExtractor userExtractor = new NullRecordsExtractor();

return userExtractor.extractData(resultSet);

}

}

NullRecordsExtractor 

Here  FailedRecords  pojo it contains database fileds

public class NullRecordsExtractor  implements ResultSetExtractor<FailedRecords>{

public FailedRecords extractData(ResultSet resultSet) throws SQLException,  

DataAccessException {  

FailedRecords failedRecords = new FailedRecords();  

failedRecords.setId(resultSet.getString(1));

failedRecords.setBusinessCode(resultSet.getString(2));

failedRecords.setCsvData(resultSet.getString(3));

failedRecords.setCardId(resultSet.getString(4));

failedRecords.setCardExpiry(resultSet.getString(5));

failedRecords.setMailStatus(resultSet.getString(6));

failedRecords.setSmsStatus(resultSet.getString(7));

failedRecords.setMobileNo(resultSet.getString(8));

failedRecords.setCreatedDate(resultSet.getDate(9));

/*String firstName=csvData.split(",")[1];

String lastName=csvData.split(",")[2];

System.out.println(firstName+" "+lastName);*/

return failedRecords;  

}  

}  

type2(passing single paramter and getting single row)

String  SELECT_TOTAL_FAMILY=" public final String SELECT_TOTAL_FAMILY="select *from user_enrollment_data where mail_status is null and mobile_no=?";

DAO

public List<FailedRecords> getFamilyMembers(String mobileNo);

DaoImpl

public List<FailedRecords> getFamilyMembers(String mobileNo) {  

return mysqlJdbcTemplate.query

(SELECT_TOTAL_FAMILY,

new Object[] { mobileNo }, 

new NullRecordRowMapper());  

}

same  NullRecordRowMapper and NullRecordsExtractor