Retrieve IMPL

Please login or create account to add a snippet.

Follow @TagMyCode

Language: Text

Posted by: sumesh tg

Added: Sep 30, 2016 6:21 AM

Tags: jdbctemplate retireve spring

ObservableList<EmployerBranchBEAN> listContacts = FXCollections.observableArrayList();
jdbcTemplate = new JdbcTemplate(dataSource);
String query = "SELECT * FROM " + TableNames.TBL_SR_EMPLYR_HEAD_CONTACT + " WHERE employer_id = ?";
List<EmployerBranchBEAN> temp = jdbcTemplate.query(query, new Object[]{employerId}, new BranchMapper());
listContacts.addAll(temp);
return listContacts;