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

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -