Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. select * from EmployeeDetails where empNo like '%"+searchWord+"%' or Name like '%"+searchWord+"%'"
  2.  
  3. private SimpleJdbcTemplate simpleJdbcTemplate = null;
  4.  
  5. @Autowired
  6. public void setDataSource(final DataSource dataSource) {
  7. this.simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
  8. }
  9.  
  10.  
  11. List<Employee> employeeList = simpleJdbcTemplate.queryForList("SELECT * FROM Employee");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement