• +91 9723535972
  • info@interviewmaterial.com

JDBC Interview Questions and Answers

Question - How Can I Convert A Java Array To A Java.sql.array?

Answer -

A Java array is a first class object and all of the references basically use PreparedStatement.setObject() or ResultSet.updateObject() methods for putting the array to an ARRAY in the database. Here's a basic example:

String[] as = { "One", "Two", "Three" };
...
PreparedStatement ps = con.prepareStatement( 
"UPDATE MYTABLE SET ArrayNums = ? WHERE MyKey = ?" );
...
ps.setObject( 1, as );

Comment(S)

Show all Coment

Leave a Comment




NCERT Solutions

 

Share your email for latest updates

Name:
Email:

Our partners