JdbcTemplate "queryForObject" and "query" is deprecated in Spring. What should it be replaced by?

Question

Query for object,

Student student = return jdbcTemplate.queryForObject("select * from student_id = ?", new Object[] { studentId }, studentRowMapper);

For query,

List<Student> students = return jdbcTemplate.query("select * from class_room_id = ?", new Object[] { classRoomId }, studentRowMapper);

Both jdbcTemplate.queryForObject and jdbcTemplate.query are deprecated in spring boot 2.4.X above

Kenwrick

The one with a varargs argument instead of the Object[]. This is also explained in the @depracted documentation. See docs.spring.io/spring-framework/docs/current/javadoc-api/org/… as well as explained in the upgrade documentation github.com/spring-projects/spring-framework/wiki/… – Auriferous

Answer 1

As explained in the javadoc of the class as well as in the upgrade/migration guide it explains that you should use the varargs method.

jdbcTemplate.queryForObject("select * from student_id = ?", studentRowMapper, studentId);

and

List<Student> students = return jdbcTemplate.query("select * from class_room_id = ?", studentRowMapper, classRoomId);

Auriferous

Answer 2

You can just change the order of the array Object[ ] and the mapper. This syntax is supported in the current version. So your code would be:

Student student = return jdbcTemplate.queryForObject("select * from student_id = ?", 
studentRowMapper, new Object[] { studentId });

and

List<Student> students = return jdbcTemplate.query("select * from class_room_id = ?", 
studentRowMapper, new Object[] { classRoomId });

You can see the doc of this method here.

Ambi

You can simplify this further by removing the new Object[] { ... } around the parameter, as it is a varargs parameter. – Extracellular

The Object[] is deprecated now, developers should go ahead with the varargs approach, see docs.spring.io/spring-framework/docs/current/javadoc-api/org/… – Quack