Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes insertRow or SQl query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "insertRow or SQl query" Watch "insertRow or SQl query" New topic

insertRow or SQl query

aakash bhatt
Ranch Hand

Joined: Jan 09, 2003
Posts: 182
is it better to use rs.insertRow through a resultset or by an statement of SQl query through a connection object.
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Its better to use prepared statement to insert the record in database. Its more efficient. I think most of the drivers not support insertRow.
I agree. Here's the link:
subject: insertRow or SQl query
It's not a secret anymore!