René's URL Explorer Experiment

{"@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/"}]}

{"@context":"http:\/\/schema.org","@type":"BreadcrumbList","@id":"#Breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"item":{"name":"Home","@id":"https:\/\/examples.javacodegeeks.com\/"}},{"@type":"ListItem","position":2,"item":{"name":"Java Development","@id":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"}},{"@type":"ListItem","position":3,"item":{"name":"Core Java","@id":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"}},{"@type":"ListItem","position":4,"item":{"name":"sql","@id":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"}},{"@type":"ListItem","position":5,"item":{"name":"PreparedStatement","@id":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/preparedstatement\/"}}]}

{"@context":"http:\/\/schema.org","@type":"Article","dateCreated":"2014-10-08T15:00:03+03:00","datePublished":"2014-10-08T15:00:03+03:00","dateModified":"2021-01-04T10:35:08+02:00","headline":"java.sql.PreparedStatement – Prepared Statement Java Example","name":"java.sql.PreparedStatement – Prepared Statement Java Example","keywords":"interface,prepared,query,sql,statement","url":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","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 precompiled SQL statement. This object can th","copyrightYear":"2014","articleSection":"PreparedStatement","articleBody":"\nIn 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.\n\n\n\nThe PreparedStatement interface extends the Statement interface, which is used for executing a static SQL statement and returning the results it produces.\n\n\n\nThe PreparedStatement interface exists since JDK1.2, with methods added in both JDK1.4 and JDK1.6.\n\n\n\n1. Why using prepared statements?\n\n\n\nPrepared 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.\n\n\n\nSecondly, 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.\n\n\n\n2. Selecting with Prepared Statement in Java\n\n\n\nTo see how PreparedStatement is used, firstly create a database, a table and put some data in it by executing this SQL:\n\n\n\n\n\n\n\n\n\n01\n02\n03\n04\n05\n06\n07\n08\n09\n10\n11\n\n\n\nCREATE DATABASE db_test;\nCREATE TABLE IF NOT EXISTS db_test.tbl (\n    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(20) NOT NULL,\n    surname VARCHAR(20) NOT NULL,\n    age INT NOT NULL\n);\n \nINSERT INTO db_test.tbl VALUES (1, 'Bruce', 'Scott', 65);\nINSERT INTO db_test.tbl VALUES (2, 'John', 'Doe', 40);\nINSERT INTO db_test.tbl VALUES (3, 'Jane', 'Doe', 35);\n\n\n\n\n\n\n\n\n\n\nNow that the database is ready and has some data, we can continue with some Java code. Create a class called PreparedSelectExample with the following source code:\n\n\n\nPreparedSelectExample.java\n\n\n\n\n\n\n\n\n\n01\n02\n03\n04\n05\n06\n07\n08\n09\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n\n\n\npackage com.javacodegeeks.examples;\n \nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\n \npublic class PreparedSelectExample {\n    private static final String HOST = \"jdbc:mysql:\/\/localhost\/\";\n    private static final String DB = \"db_test\";\n    private static final String USER = \"root\";\n    private static final String PASSWORD = \"bitnami\";\n     \n    public static void main(String[] args) {\n        String sqlQuery = \"SELECT * FROM tbl WHERE surname = ?\";\n         \n        try {\n            Class.forName(\"com.mysql.jdbc.Driver\");\n            Connection conn = DriverManager.getConnection(HOST+DB,USER,PASSWORD);\n             \n            PreparedStatement preparedSelect = conn.prepareStatement(sqlQuery);\n            preparedSelect.setString(1, \"Doe\");\n            ResultSet rs = preparedSelect.executeQuery();\n             \n            while (rs.next()) {\n                int id = rs.getInt(1);\n                String name = rs.getString(2);\n                String surname = rs.getString(3);\n                int age = rs.getInt(4);\n                System.out.printf(\"%d\\t%s\\t%s\\t%d\\n\",id,name,surname,age);\n            }\n             \n        } catch (ClassNotFoundException e) {\n            e.printStackTrace();\n        } catch (SQLException e) {\n            e.printStackTrace();\n        }\n \n    }\n \n}\n\n\n\n\n\n\n\n\n\n\nIn 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 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.\n\n\n\nAfter the connection with the database is done successfully (don't forget to add the drivers), 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.\n\n\n\nTake a look at line 23, where the question mark of the prepared statement is replaced by \"Doe\". PreparedStatement has plenty of these setter methods for different kind of data types, like setArray(), setBigDecimal(), setInt(), setDouble() 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.\n\n\n\nAfter executing the above code, the output will be this:\n\n\n\n\n\n\n\n\n\n1\n2\n\n\n\n2   John    Doe 40\n3   Jane    Doe 35\n\n\n\n\n\n\n\n\n\n\n3. Changing data with PreparedStatement\n\n\n\nIn 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() method to select the data.\n\n\n\nWhen the data is changed, by an insert, update or delete query, the method that should be used is executeUpdate(). The following example will show how to use the method when inserting data, but the case is the same even when deleting or updating.\n\n\n\nCreate a class called PreparedInsertExample and put the following source code in it:\n\n\n\nPreparedInsertExample.java\n\n\n\n\n\n\n\n\n\n01\n02\n03\n04\n05\n06\n07\n08\n09\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n\n\n\npackage com.javacodegeeks.examples;\n \nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.SQLException;\n \npublic class PreparedInsertExample {\n    private static final String HOST = \"jdbc:mysql:\/\/localhost\/\";\n    private static final String DB = \"db_test\";\n    private static final String USER = \"root\";\n    private static final String PASSWORD = \"bitnami\";\n     \n    public static void main(String[] args) {\n        String sqlQuery = \"INSERT INTO `tbl` (`name`, `surname`, `age`) VALUES (?,?,?)\";\n         \n        try {\n            Class.forName(\"com.mysql.jdbc.Driver\");\n            Connection conn = DriverManager.getConnection(HOST+DB,USER,PASSWORD);\n             \n            PreparedStatement preparedInsert = conn.prepareStatement(sqlQuery);\n             \n            String myName = \"Aldo\";\n            String mySurname = \"Ziflaj\";\n            int myAge = 19;\n             \n            preparedInsert.setInt(3, myAge);\n            preparedInsert.setString(1, myName);\n            preparedInsert.setString(2, mySurname);\n             \n            int status = preparedInsert.executeUpdate();\n            System.out.println(status);\n        } catch (ClassNotFoundException e) {\n            e.printStackTrace();\n        } catch (SQLException e) {\n            e.printStackTrace();\n        }\n         \n    }\n \n}\n\n\n\n\n\n\n\n\n\n\nJust 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() method, which returns either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing.\n\n\n\n4. Inserting multiple records with one PreparedStatement\n\n\n\nIf you were going to insert more than one record on the database, you don't have to create another prepared statement; the same PreparedStatement instance can be used multiple times.\n\n\n\n\n\n\n\nThe following code shows just this, adding a list of people. Firstly, create a Person class:\n\n\n\nPerson.java\n\n\n\n\n\n\n\n\n\n01\n02\n03\n04\n05\n06\n07\n08\n09\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n\n\n\npackage com.javacodegeeks.examples.multiple_insert;\n \npublic class Person {\n    private String name;\n    private String surname;\n    private int age;\n     \n    protected Person() {}\n     \n    public Person(String name, String surname, int age) {\n        this.name = name;\n        this.surname = surname;\n        this.age = age;\n    }\n     \n    public String getName() {\n        return this.name;\n    }\n     \n    public String getSurname() {\n        return this.surname;\n    }\n     \n    public int getAge() {\n        return this.age;\n    }\n \n}\n\n\n\n\n\n\n\n\n\n\nThis is a very simple class that will hold the information for a single person that would be inserted in the database.\n\n\n\nNow create an interface called DbContract and put this code in it:\n\n\n\nDbContract.java\n\n\n\n\n\n\n\n\n\n1\n2\n3\n4\n5\n6\n7\n8\n\n\n\npackage com.javacodegeeks.examples.multiple_insert;\n \npublic interface DbContract {\n    public static final String HOST = \"jdbc:mysql:\/\/localhost\/\";\n    public static final String DB = \"db_test\";\n    public static final String USER = \"root\";\n    public static final String PASSWORD = \"bitnami\";\n}\n\n\n\n\n\n\n\n\n\n\nYou may want to put your data instead of keeping my data here.\n\n\n\nIn 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).\n\n\n\nNow create another class called MultipleInsertExample:\n\n\n\nMultipleInsertExample.java\n\n\n\n\n\n\n\n\n\n01\n02\n03\n04\n05\n06\n07\n08\n09\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n44\n45\n46\n47\n48\n\n\n\npackage com.javacodegeeks.examples.multiple_insert;\n \nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.SQLException;\nimport java.util.ArrayList;\nimport java.util.List;\n \npublic class MultipleInsertExample {\n     \n    public static void main(String[] args) {\n        String sqlQuery = \"INSERT INTO `tbl` (`name`, `surname`, `age`) VALUES (?,?,?)\";\n         \n        List<Person> coolGuys = new ArrayList<>();\n         \n        coolGuys.add(new Person(\"Larry\", \"Ellison\", 70));\n        coolGuys.add(new Person(\"Sergey\", \"Brin\", 41));\n        coolGuys.add(new Person(\"Stephan\", \"Wozniak\", 64));\n         \n        try {\n            Class.forName(\"com.mysql.jdbc.Driver\");\n             \n            Connection conn = DriverManager.getConnection(\n                                        DbContract.HOST+DbContract.DB,\n                                        DbContract.USER,\n                                        DbContract.PASSWORD);\n             \n            PreparedStatement preparedInsert = conn.prepareStatement(sqlQuery);\n             \n            int insertions = 0;\n            for (Person guy : coolGuys) {\n                preparedInsert.setString(1,guy.getName());\n                preparedInsert.setString(2, guy.getSurname());\n                preparedInsert.setInt(3, guy.getAge());\n                 \n                insertions += preparedInsert.executeUpdate();\n            }\n             \n            System.out.println(insertions+\" records added\");\n        } catch (ClassNotFoundException | SQLException e) {\n            e.printStackTrace();\n        }\n         \n \n    }\n \n}\n\n\n\n\n\n\n\n\n\n\nAfter 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 is used more than once.\n\n\n\nAfter executing this you should see this output:\n\n\n\n\n\n\n\n\n\n1\n\n\n\n3 records added\n\n\n\n\n\n\n\n\n\n\n5. Download the source code\n\n\n\nDownload\nYou can download the full source code of this example here: java.sql.PreparedStatement - Prepared Statement Java Example\n\n\n\nLast updated on May 20th, 2020\n","publisher":{"@id":"#Publisher","@type":"Organization","name":"Examples Java Code Geeks","logo":{"@type":"ImageObject","url":"\/wp-content\/uploads\/2013\/05\/JavaCodeGeeks-logo.png"},"sameAs":["https:\/\/feeds.feedburner.com\/examplesjavacodegeeks","https:\/\/www.facebook.com\/javacodegeeks","https:\/\/twitter.com\/javacodegeeks","https:\/\/www.linkedin.com\/groups\/3810709\/","https:\/\/www.youtube.com\/channel\/UCxoUc7Rar2q90Gu0nT2ffuQ","https:\/\/github.com\/javacodegeeks\/"]},"sourceOrganization":{"@id":"#Publisher"},"copyrightHolder":{"@id":"#Publisher"},"mainEntityOfPage":{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/java-sql-preparedstatement-prepared-statement-java-example\/","breadcrumb":{"@id":"#Breadcrumb"}},"author":{"@type":"Person","name":"Aldo Ziflaj","url":"https:\/\/examples.javacodegeeks.com\/author\/aldo-ziflaj\/"},"image":{"@type":"ImageObject","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":1200,"height":150}}