sql - how to bind a list of tuples using Spring JDBCTemplate? -
I have some questions like this:
list listoffers = array.asList ( New integer [] {1, 2, 3}); List objects = nominated ParameterJdbcTemplate.query ("Select from bla, id in id: (id)", archive.Singlitamap ("id", listoff integers), myRowMapper); This will send the database to this SQL query:
select * bla where id (1, 2, 3) Now I want to send this type of query to the database:
from select * bla (id, name) in ((1, 'foo'), (2, Bar '), (3,' phobar ')) Do I have a list & lt; List & lt; Object & gt; & Gt; to accomplish this? Will this spring work with JDBC template?
I have debug the spring code and have found that it is expected to provide the toplex as an object [], So to work with this list, this list and the Lieutenant Object []>. should be there.
Comments
Post a Comment