{"id":15019,"date":"2014-10-08T15:00:03","date_gmt":"2014-10-08T12:00:03","guid":{"rendered":"http:\/\/examples.javacodegeeks.com\/?p=15019"},"modified":"2021-01-04T10:35:08","modified_gmt":"2021-01-04T08:35:08","slug":"java-sql-preparedstatement-example","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","title":{"rendered":"java.sql.PreparedStatement – Prepared Statement Java Example"},"content":{"rendered":"

In this example, we will discuss the Prepared Statement interface<\/a> and its usage in Java using examples. This interface creates an object that represents a precompiled SQL statement. This object can then be used to efficiently execute this statement multiple times.<\/p>\n

The PreparedStatement<\/code> interface extends the Statement<\/code><\/a> interface, which is used for executing a static SQL statement and returning the results it produces.<\/p>\n

The PreparedStatement<\/code> interface exists since JDK1.2, with methods added in both JDK1.4 and JDK1.6.<\/p>\n

1. Why using prepared statements?<\/h2>\n

Prepared statements examples have two main advantages above static statements. Firstly, they have a better performance than static statements. This because they are compiled only once from the database engine, and not everytime they get executed.<\/p>\n

Secondly, prepared statements are the best protection against SQL injections. This because of the fact that the values that will be inserted into a SQL query are sent to the SQL server after the actual query is sent to the server. In other words, the data input by a potential hacker is sent separately from the prepared query statement. This means that there is absolutely no way that the data input by a hacker can be interpreted as SQL, and there\u2019s no way that the hacker could run his own SQL on your application.<\/p>\n

2. Selecting with Prepared Statement in Java<\/h2>\n

To see how PreparedStatement<\/code> is used, firstly create a database, a table and put some data in it by executing this SQL:<\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
CREATE<\/code> DATABASE<\/code> db_test;<\/code><\/div>\n
CREATE<\/code> TABLE<\/code> IF <\/code>NOT<\/code> EXISTS db_test.tbl (<\/code><\/div>\n
    <\/code>id <\/code>INT<\/code> NOT<\/code> NULL<\/code> PRIMARY<\/code> KEY<\/code> AUTO_INCREMENT,<\/code><\/div>\n
    <\/code>name<\/code> VARCHAR<\/code>(20) <\/code>NOT<\/code> NULL<\/code>,<\/code><\/div>\n
    <\/code>surname <\/code>VARCHAR<\/code>(20) <\/code>NOT<\/code> NULL<\/code>,<\/code><\/div>\n
    <\/code>age <\/code>INT<\/code> NOT<\/code> NULL<\/code><\/div>\n
);<\/code><\/div>\n
 <\/div>\n
INSERT<\/code> INTO<\/code> db_test.tbl <\/code>VALUES<\/code> (1, <\/code>'Bruce'<\/code>, <\/code>'Scott'<\/code>, 65);<\/code><\/div>\n
INSERT<\/code> INTO<\/code> db_test.tbl <\/code>VALUES<\/code> (2, <\/code>'John'<\/code>, <\/code>'Doe'<\/code>, 40);<\/code><\/div>\n
INSERT<\/code> INTO<\/code> db_test.tbl <\/code>VALUES<\/code> (3, <\/code>'Jane'<\/code>, <\/code>'Doe'<\/code>, 35);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now that the database is ready and has some data, we can continue with some Java code. Create a class called PreparedSelectExample<\/code> with the following source code:<\/p>\n

PreparedSelectExample.java<\/em><\/u><\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n<\/td>\n
\n
\n
package<\/code> com.javacodegeeks.examples;<\/code><\/div>\n
 <\/div>\n
import<\/code> java.sql.Connection;<\/code><\/div>\n
import<\/code> java.sql.DriverManager;<\/code><\/div>\n
import<\/code> java.sql.PreparedStatement;<\/code><\/div>\n
import<\/code> java.sql.ResultSet;<\/code><\/div>\n
import<\/code> java.sql.SQLException;<\/code><\/div>\n
 <\/div>\n
public<\/code> class<\/code> PreparedSelectExample {<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String HOST = <\/code>\"jdbc:mysql:\/\/localhost\/\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String DB = <\/code>\"db_test\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String USER = <\/code>\"root\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String PASSWORD = <\/code>\"bitnami\"<\/code>;<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> static<\/code> void<\/code> main(String[] args) {<\/code><\/div>\n
        <\/code>String sqlQuery = <\/code>\"SELECT * FROM tbl WHERE surname = ?\"<\/code>;<\/code><\/div>\n
        <\/code> <\/div>\n
        <\/code>try<\/code> {<\/code><\/div>\n
            <\/code>Class.forName(<\/code>\"com.mysql.jdbc.Driver\"<\/code>);<\/code><\/div>\n
            <\/code>Connection conn = DriverManager.getConnection(HOST+DB,USER,PASSWORD);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>PreparedStatement preparedSelect = conn.prepareStatement(sqlQuery);<\/code><\/div>\n
            <\/code>preparedSelect.setString(<\/code>1<\/code>, <\/code>\"Doe\"<\/code>);<\/code><\/div>\n
            <\/code>ResultSet rs = preparedSelect.executeQuery();<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>while<\/code> (rs.next()) {<\/code><\/div>\n
                <\/code>int<\/code> id = rs.getInt(<\/code>1<\/code>);<\/code><\/div>\n
                <\/code>String name = rs.getString(<\/code>2<\/code>);<\/code><\/div>\n
                <\/code>String surname = rs.getString(<\/code>3<\/code>);<\/code><\/div>\n
                <\/code>int<\/code> age = rs.getInt(<\/code>4<\/code>);<\/code><\/div>\n
                <\/code>System.out.printf(<\/code>\"%d\\t%s\\t%s\\t%d\\n\"<\/code>,id,name,surname,age);<\/code><\/div>\n
            <\/code>}<\/code><\/div>\n
            <\/code> <\/div>\n
        <\/code>} <\/code>catch<\/code> (ClassNotFoundException e) {<\/code><\/div>\n
            <\/code>e.printStackTrace();<\/code><\/div>\n
        <\/code>} <\/code>catch<\/code> (SQLException e) {<\/code><\/div>\n
            <\/code>e.printStackTrace();<\/code><\/div>\n
        <\/code>}<\/code><\/div>\n
 <\/div>\n
    <\/code>}<\/code><\/div>\n
 <\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In this example, I firstly set some global constants that hold information about the database name, username and password (you would want to change the username\/password). Then, I create a prepared SQL statement that would select every person from the table tbl<\/code> that have the same surname. This surname is unknown initially; it can be set later in the program (as I do), it can be entered by the user as an input, etc.

<\/div> <\/div><\/p>\n

After the connection with the database is done successfully (don’t forget to add the drivers<\/strong>), the prepared SQL statement gets compiled (line 22), and the first question mark on the prepared statement is replaced by “Doe” (line 23). Then, the statement gets executed and the result is printed.<\/p>\n

Take a look at line 23, where the question mark of the prepared statement is replaced by “Doe”. PreparedStatement<\/code> has plenty of these setter methods for different kind of data types, like setArray()<\/code><\/a>, setBigDecimal()<\/code><\/a>, setInt()<\/code><\/a>, setDouble()<\/code><\/a> and many more. The first argument of the setter methods is the index of the question mark that will be replaced by the object, starting by 1.<\/p>\n

After executing the above code, the output will be this:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
2   John    Doe 40<\/code><\/div>\n
3   Jane    Doe 35<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3. Changing data with PreparedStatement<\/h2>\n

In the above example the data stored in the database didn’t change, it was just printed in the screen. In that example, we used executeQuery()<\/code><\/a> method to select the data.<\/p>\n

When the data is changed, by an insert, update or delete query, the method that should be used is executeUpdate()<\/code><\/a>. The following example will show how to use the method when inserting data, but the case is the same even when deleting or updating.<\/p>\n

Create a class called PreparedInsertExample<\/code> and put the following source code in it:<\/p>\n

PreparedInsertExample.java<\/em><\/u><\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n<\/td>\n
\n
\n
package<\/code> com.javacodegeeks.examples;<\/code><\/div>\n
 <\/div>\n
import<\/code> java.sql.Connection;<\/code><\/div>\n
import<\/code> java.sql.DriverManager;<\/code><\/div>\n
import<\/code> java.sql.PreparedStatement;<\/code><\/div>\n
import<\/code> java.sql.SQLException;<\/code><\/div>\n
 <\/div>\n
public<\/code> class<\/code> PreparedInsertExample {<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String HOST = <\/code>\"jdbc:mysql:\/\/localhost\/\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String DB = <\/code>\"db_test\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String USER = <\/code>\"root\"<\/code>;<\/code><\/div>\n
    <\/code>private<\/code> static<\/code> final<\/code> String PASSWORD = <\/code>\"bitnami\"<\/code>;<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> static<\/code> void<\/code> main(String[] args) {<\/code><\/div>\n
        <\/code>String sqlQuery = <\/code>\"INSERT INTO `tbl` (`name`, `surname`, `age`) VALUES (?,?,?)\"<\/code>;<\/code><\/div>\n
        <\/code> <\/div>\n
        <\/code>try<\/code> {<\/code><\/div>\n
            <\/code>Class.forName(<\/code>\"com.mysql.jdbc.Driver\"<\/code>);<\/code><\/div>\n
            <\/code>Connection conn = DriverManager.getConnection(HOST+DB,USER,PASSWORD);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>PreparedStatement preparedInsert = conn.prepareStatement(sqlQuery);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>String myName = <\/code>\"Aldo\"<\/code>;<\/code><\/div>\n
            <\/code>String mySurname = <\/code>\"Ziflaj\"<\/code>;<\/code><\/div>\n
            <\/code>int<\/code> myAge = <\/code>19<\/code>;<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>preparedInsert.setInt(<\/code>3<\/code>, myAge);<\/code><\/div>\n
            <\/code>preparedInsert.setString(<\/code>1<\/code>, myName);<\/code><\/div>\n
            <\/code>preparedInsert.setString(<\/code>2<\/code>, mySurname);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>int<\/code> status = preparedInsert.executeUpdate();<\/code><\/div>\n
            <\/code>System.out.println(status);<\/code><\/div>\n
        <\/code>} <\/code>catch<\/code> (ClassNotFoundException e) {<\/code><\/div>\n
            <\/code>e.printStackTrace();<\/code><\/div>\n
        <\/code>} <\/code>catch<\/code> (SQLException e) {<\/code><\/div>\n
            <\/code>e.printStackTrace();<\/code><\/div>\n
        <\/code>}<\/code><\/div>\n
        <\/code> <\/div>\n
    <\/code>}<\/code><\/div>\n
 <\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Just as in the first example, I created the main structure of the SQL query and then went on adding my data (name, surname and age) at the query. Then, on line 31, the query is executed by calling the executeUpdate()<\/code> method, which returns either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing.<\/p>\n

4. Inserting multiple records with one PreparedStatement<\/h2>\n

If you were going to insert more than one record on the database, you don’t have to create another prepared statement; the same PreparedStatement<\/code> instance can be used multiple times.<\/p>\n

\n
\"prepared<\/a><\/figure>\n<\/div>\n

The following code shows just this, adding a list of people. Firstly, create a Person<\/code> class:<\/p>\n

Person.java<\/em><\/u><\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n<\/td>\n
\n
\n
package<\/code> com.javacodegeeks.examples.multiple_insert;<\/code><\/div>\n
 <\/div>\n
public<\/code> class<\/code> Person {<\/code><\/div>\n
    <\/code>private<\/code> String name;<\/code><\/div>\n
    <\/code>private<\/code> String surname;<\/code><\/div>\n
    <\/code>private<\/code> int<\/code> age;<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>protected<\/code> Person() {}<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> Person(String name, String surname, <\/code>int<\/code> age) {<\/code><\/div>\n
        <\/code>this<\/code>.name = name;<\/code><\/div>\n
        <\/code>this<\/code>.surname = surname;<\/code><\/div>\n
        <\/code>this<\/code>.age = age;<\/code><\/div>\n
    <\/code>}<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> String getName() {<\/code><\/div>\n
        <\/code>return<\/code> this<\/code>.name;<\/code><\/div>\n
    <\/code>}<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> String getSurname() {<\/code><\/div>\n
        <\/code>return<\/code> this<\/code>.surname;<\/code><\/div>\n
    <\/code>}<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> int<\/code> getAge() {<\/code><\/div>\n
        <\/code>return<\/code> this<\/code>.age;<\/code><\/div>\n
    <\/code>}<\/code><\/div>\n
 <\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

This is a very simple class that will hold the information for a single person that would be inserted in the database.<\/p>\n

Now create an interface called DbContract<\/code> and put this code in it:<\/p>\n

DbContract.java<\/em><\/u><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
package<\/code> com.javacodegeeks.examples.multiple_insert;<\/code><\/div>\n
 <\/div>\n
public<\/code> interface<\/code> DbContract {<\/code><\/div>\n
    <\/code>public<\/code> static<\/code> final<\/code> String HOST = <\/code>\"jdbc:mysql:\/\/localhost\/\"<\/code>;<\/code><\/div>\n
    <\/code>public<\/code> static<\/code> final<\/code> String DB = <\/code>\"db_test\"<\/code>;<\/code><\/div>\n
    <\/code>public<\/code> static<\/code> final<\/code> String USER = <\/code>\"root\"<\/code>;<\/code><\/div>\n
    <\/code>public<\/code> static<\/code> final<\/code> String PASSWORD = <\/code>\"bitnami\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

You may want to put your data instead of keeping my data here.<\/p>\n

In a normal application or software, this interface would store more data, about the tables name, their columns, and so on. This is done to keep the code DRY (Don’t Repeat Yourself).<\/p>\n

Now create another class called MultipleInsertExample<\/code>:<\/p>\n

MultipleInsertExample.java<\/em><\/u><\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n<\/td>\n
\n
\n
package<\/code> com.javacodegeeks.examples.multiple_insert;<\/code><\/div>\n
 <\/div>\n
import<\/code> java.sql.Connection;<\/code><\/div>\n
import<\/code> java.sql.DriverManager;<\/code><\/div>\n
import<\/code> java.sql.PreparedStatement;<\/code><\/div>\n
import<\/code> java.sql.SQLException;<\/code><\/div>\n
import<\/code> java.util.ArrayList;<\/code><\/div>\n
import<\/code> java.util.List;<\/code><\/div>\n
 <\/div>\n
public<\/code> class<\/code> MultipleInsertExample {<\/code><\/div>\n
    <\/code> <\/div>\n
    <\/code>public<\/code> static<\/code> void<\/code> main(String[] args) {<\/code><\/div>\n
        <\/code>String sqlQuery = <\/code>\"INSERT INTO `tbl` (`name`, `surname`, `age`) VALUES (?,?,?)\"<\/code>;<\/code><\/div>\n
        <\/code> <\/div>\n
        <\/code>List<Person> coolGuys = <\/code>new<\/code> ArrayList<>();<\/code><\/div>\n
        <\/code> <\/div>\n
        <\/code>coolGuys.add(<\/code>new<\/code> Person(<\/code>\"Larry\"<\/code>, <\/code>\"Ellison\"<\/code>, <\/code>70<\/code>));<\/code><\/div>\n
        <\/code>coolGuys.add(<\/code>new<\/code> Person(<\/code>\"Sergey\"<\/code>, <\/code>\"Brin\"<\/code>, <\/code>41<\/code>));<\/code><\/div>\n
        <\/code>coolGuys.add(<\/code>new<\/code> Person(<\/code>\"Stephan\"<\/code>, <\/code>\"Wozniak\"<\/code>, <\/code>64<\/code>));<\/code><\/div>\n
        <\/code> <\/div>\n
        <\/code>try<\/code> {<\/code><\/div>\n
            <\/code>Class.forName(<\/code>\"com.mysql.jdbc.Driver\"<\/code>);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>Connection conn = DriverManager.getConnection(<\/code><\/div>\n
                                        <\/code>DbContract.HOST+DbContract.DB,<\/code><\/div>\n
                                        <\/code>DbContract.USER,<\/code><\/div>\n
                                        <\/code>DbContract.PASSWORD);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>PreparedStatement preparedInsert = conn.prepareStatement(sqlQuery);<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>int<\/code> insertions = <\/code>0<\/code>;<\/code><\/div>\n
            <\/code>for<\/code> (Person guy : coolGuys) {<\/code><\/div>\n
                <\/code>preparedInsert.setString(<\/code>1<\/code>,guy.getName());<\/code><\/div>\n
                <\/code>preparedInsert.setString(<\/code>2<\/code>, guy.getSurname());<\/code><\/div>\n
                <\/code>preparedInsert.setInt(<\/code>3<\/code>, guy.getAge());<\/code><\/div>\n
                <\/code> <\/div>\n
                <\/code>insertions += preparedInsert.executeUpdate();<\/code><\/div>\n
            <\/code>}<\/code><\/div>\n
            <\/code> <\/div>\n
            <\/code>System.out.println(insertions+<\/code>\" records added\"<\/code>);<\/code><\/div>\n
        <\/code>} <\/code>catch<\/code> (ClassNotFoundException | SQLException e) {<\/code><\/div>\n
            <\/code>e.printStackTrace();<\/code><\/div>\n
        <\/code>}<\/code><\/div>\n
        <\/code> <\/div>\n
 <\/div>\n
    <\/code>}<\/code><\/div>\n
 <\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After going through the two first examples, the code for this is supposed to be kinda obvious. The only difference here is that the same PreparedStatement<\/code> is used more than once.<\/p>\n

After executing this you should see this output:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
3 records added<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

5. Download the source code<\/h2>\n
Download<\/strong>
\nYou can download the full source code of this example here: java.sql.PreparedStatement – Prepared Statement Java Example<\/a><\/strong><\/div>\n

Last updated on May 20th, 2020<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a precompiled SQL statement. This object can then be used to efficiently execute this statement multiple times. The PreparedStatement interface extends the Statement interface, which is used for executing a static …<\/p>\n","protected":false},"author":25,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[703],"tags":[702,699,701,1055,700],"class_list":["post-15019","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-preparedstatement","tag-interface","tag-prepared","tag-query","tag-sql","tag-statement"],"yoast_head":"\nPrepared Statement Java Example - Examples Java Code Geeks - 2026<\/title>\n<meta name=\"description\" content=\"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Prepared Statement Java Example - Examples Java Code Geeks - 2026\" \/>\n<meta property=\"og:description\" content=\"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-08T12:00:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-04T08:35:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Aldo Ziflaj\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aldo Ziflaj\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\"},\"author\":{\"name\":\"Aldo Ziflaj\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/6beef552aebee0085de08795a1dfbd73\"},\"headline\":\"java.sql.PreparedStatement – Prepared Statement Java Example\",\"datePublished\":\"2014-10-08T12:00:03+00:00\",\"dateModified\":\"2021-01-04T08:35:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\"},\"wordCount\":860,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"interface\",\"prepared\",\"query\",\"sql\",\"statement\"],\"articleSection\":[\"PreparedStatement\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\",\"name\":\"Prepared Statement Java Example - Examples Java Code Geeks - 2026\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2014-10-08T12:00:03+00:00\",\"dateModified\":\"2021-01-04T08:35:08+00:00\",\"description\":\"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"PreparedStatement\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/preparedstatement\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"java.sql.PreparedStatement – Prepared Statement Java Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/6beef552aebee0085de08795a1dfbd73\",\"name\":\"Aldo Ziflaj\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3046bd4c20f494a738f2c0f6c2b0010b6184df4510e6d0701e4ffcc1f05da0de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3046bd4c20f494a738f2c0f6c2b0010b6184df4510e6d0701e4ffcc1f05da0de?s=96&d=mm&r=g\",\"caption\":\"Aldo Ziflaj\"},\"description\":\"Aldo is a student of Computer Engineering and a programming addict. He spares his free time coding, whether mobile, web, or desktop programming. He is also one of the co-founders of Things Lab.\",\"sameAs\":[\"http:\/\/aziflaj.github.io\/\"],\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/aldo-ziflaj\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Prepared Statement Java Example - Examples Java Code Geeks - 2026","description":"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","og_locale":"en_US","og_type":"article","og_title":"Prepared Statement Java Example - Examples Java Code Geeks - 2026","og_description":"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a","og_url":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2014-10-08T12:00:03+00:00","article_modified_time":"2021-01-04T08:35:08+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Aldo Ziflaj","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Aldo Ziflaj","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/"},"author":{"name":"Aldo Ziflaj","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/6beef552aebee0085de08795a1dfbd73"},"headline":"java.sql.PreparedStatement – Prepared Statement Java Example","datePublished":"2014-10-08T12:00:03+00:00","dateModified":"2021-01-04T08:35:08+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/"},"wordCount":860,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["interface","prepared","query","sql","statement"],"articleSection":["PreparedStatement"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","url":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","name":"Prepared Statement Java Example - Examples Java Code Geeks - 2026","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2014-10-08T12:00:03+00:00","dateModified":"2021-01-04T08:35:08+00:00","description":"In this example, we will discuss the Prepared Statement interface and its usage in Java using examples. This interface creates an object that represents a","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"PreparedStatement","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/preparedstatement\/"},{"@type":"ListItem","position":6,"name":"java.sql.PreparedStatement – Prepared Statement Java Example"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/6beef552aebee0085de08795a1dfbd73","name":"Aldo Ziflaj","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3046bd4c20f494a738f2c0f6c2b0010b6184df4510e6d0701e4ffcc1f05da0de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3046bd4c20f494a738f2c0f6c2b0010b6184df4510e6d0701e4ffcc1f05da0de?s=96&d=mm&r=g","caption":"Aldo Ziflaj"},"description":"Aldo is a student of Computer Engineering and a programming addict. He spares his free time coding, whether mobile, web, or desktop programming. He is also one of the co-founders of Things Lab.","sameAs":["http:\/\/aziflaj.github.io\/"],"url":"https:\/\/examples.javacodegeeks.com\/author\/aldo-ziflaj\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/15019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=15019"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/15019\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=15019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=15019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=15019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}