Select with named parameter query which has between where qualifier

Question

In case of select with named parameter query with like where qualifier ,we are using like below.

final String sqlQuery = "select  e.COMM,  e.DEPTNO,  e.EMPNO,  e.ENAME from EMP e where
 JOB like :JOB"
 Map namedParameters = new HashMap();
 namedParameters.put("JOB", "");
 List result = namedParameterJdbcTemplate.queryForList(sqlQuery, namedParameters);

How will be select with named parameter query with between where qualifier?

Your SQL syntax is incorrect, the BETWEEN values should not be within brackets. — Perception
– Perception, Commented Feb 27, 2013 at 11:43

Joop Eggen · Accepted Answer · 2013-02-27 12:14:17Z

1

final String sqlQuery =
    "SELECT e.id, e.name, e.salary, e.dept FROM emp e "
    + "WHERE e.salary BETWEEN ? AND ?";

If you are using PreparedStatement then example:

pst.setLong(1,Long.parseLong(searchCriteria.getTransactionNo()));
pst.setLong(2,Long.parseLong(searchCriteria.getTransactionNo()));

edited Feb 27, 2013 at 12:14

Joop Eggen

110k8 gold badges89 silver badges142 bronze badges

answered Feb 27, 2013 at 11:46

Biswajit

2,5162 gold badges32 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anu Over a year ago

This is for select simple query.I want the query for select with named parameter.

Collectives™ on Stack Overflow

Select with named parameter query which has between where qualifier

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related