CODEWITHSUNDEEP
javamysqldatabaseeclipse
Anu
Anu

Reputation: 405

Select with named parameter query which has between where qualifier

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?

Upvotes: 1

Views: 512

Answers (1)

Biswajit
Biswajit

Reputation: 2516

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()));

Upvotes: 1

Related Questions