Whats in this post?
- Background and Explanation of the code
Background and Explanation of the code
In this program we are using PreparedStatement to insert multiple records into database table. The main feature of a PreparedStatement object is that, unlike a Statement object, it is given a SQL statement when it is created. The advantage to this is that in most cases, this SQL statement is sent to the DBMS right away, where it is compiled. As a result, the PreparedStatement object contains not just a SQL statement, but a SQL statement that has been precompiled. This means that when the PreparedStatement is executed, the DBMS can just run the PrepareStatement SQL statement without having to compile it first. In case of multiple records this feature provides better performance.
To compile the program: javac InsertMultipleRecords.java
To run the program: java InsertMultipleRecords
After running the program, check the database table, it will have two newly inserted records.