{"id":4235,"date":"2024-07-25T15:54:53","date_gmt":"2024-07-25T08:54:53","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/?page_id=4235"},"modified":"2024-07-29T07:47:41","modified_gmt":"2024-07-29T00:47:41","slug":"java-sql-server-insert","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/","title":{"rendered":"Java SQL Server: Inserting Data"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to insert data into an SQL Server table using a Java program.<\/p>\n\n\n\n<p class=\"note\">This tutorial begins where&nbsp;the&nbsp;<a href=\"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-connect-to-sql-server\/\">connecting to the SQL Server from the Java program tutorial<\/a>&nbsp;left off.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='inserting-data-into-a-table-from-java'>Inserting data into a table from Java <a href=\"#inserting-data-into-a-table-from-java\" class=\"anchor\" id=\"inserting-data-into-a-table-from-java\" title=\"Anchor for Inserting data into a table from Java\">#<\/a><\/h2>\n\n\n\n<p>Here are the steps for inserting data into a table in SQL Server from a Java program using JDBC:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, open a new database connection to the SQL Server.<\/li>\n\n\n\n<li>Next, create a new <code>PreparedStatement<\/code> object that accepts an <code><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-insert\/\">INSERT<\/a><\/code> statement.<\/li>\n\n\n\n<li>Then, set the parameters for the statement by calling the <code>set*<\/code> methods of the <code>PreparedStatement<\/code> object.<\/li>\n\n\n\n<li>After that, call the <code>executeUpdate()<\/code> method of the <code>PreparedStatement<\/code> to run the <code>INSERT<\/code> statement to insert a new row into a table.<\/li>\n\n\n\n<li>Finally, close the prepared statement and database connection.<\/li>\n<\/ul>\n\n\n\n<p>If you use the try-with-resources statement, you don&#8217;t need to close the prepared statement and database connection manually.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='inserting-author'>Inserting author <a href=\"#inserting-author\" class=\"anchor\" id=\"inserting-author\" title=\"Anchor for Inserting author\">#<\/a><\/h2>\n\n\n\n<p>Step 1. Create a new file <code>Author.java<\/code> that stores the <code>Author <\/code>class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">import<\/span> java.time.LocalDate;\n\npublic <span class=\"hljs-class\"><span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">Author<\/span> <\/span>{\n    private <span class=\"hljs-built_in\">String<\/span> firstName;\n    private <span class=\"hljs-built_in\">String<\/span> lastName;\n    private LocalDate birthDate;\n\n    public Author(<span class=\"hljs-built_in\">String<\/span> firstName, <span class=\"hljs-built_in\">String<\/span> lastName, LocalDate birthDate) {\n        <span class=\"hljs-keyword\">this<\/span>.firstName = firstName;\n        <span class=\"hljs-keyword\">this<\/span>.lastName = lastName;\n        <span class=\"hljs-keyword\">this<\/span>.birthDate = birthDate;\n    }\n\n    public <span class=\"hljs-built_in\">String<\/span> getFirstName() {\n        <span class=\"hljs-keyword\">return<\/span> firstName;\n    }\n\n    public <span class=\"hljs-keyword\">void<\/span> setFirstName(<span class=\"hljs-built_in\">String<\/span> firstName) {\n        <span class=\"hljs-keyword\">this<\/span>.firstName = firstName;\n    }\n\n    public <span class=\"hljs-built_in\">String<\/span> getLastName() {\n        <span class=\"hljs-keyword\">return<\/span> lastName;\n    }\n\n    public <span class=\"hljs-keyword\">void<\/span> setLastName(<span class=\"hljs-built_in\">String<\/span> lastName) {\n        <span class=\"hljs-keyword\">this<\/span>.lastName = lastName;\n    }\n\n    public LocalDate getBirthDate() {\n        <span class=\"hljs-keyword\">return<\/span> birthDate;\n    }\n\n    public <span class=\"hljs-keyword\">void<\/span> setBirthDate(LocalDate birthDate) {\n        <span class=\"hljs-keyword\">this<\/span>.birthDate = birthDate;\n    }\n\n    @Override\n    public <span class=\"hljs-built_in\">String<\/span> toString() {\n        <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-string\">\"Author{\"<\/span> +\n                <span class=\"hljs-string\">\"firstName='\"<\/span> + firstName + <span class=\"hljs-string\">'\\''<\/span> +\n                <span class=\"hljs-string\">\", lastName='\"<\/span> + lastName + <span class=\"hljs-string\">'\\''<\/span> +\n                <span class=\"hljs-string\">\", birthDate=\"<\/span> + birthDate +\n                <span class=\"hljs-string\">'}'<\/span>;\n    }\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Step 1. Create a new Java file <code>AuthorDB.java<\/code> and define the <code>AuthorDB<\/code> class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-class\"><span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">AuthorDB<\/span> <\/span>{\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Step 2. Add the <code>insert()<\/code> method to the <code>AuthorDB<\/code> class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">import<\/span> java.sql.Connection;\n<span class=\"hljs-keyword\">import<\/span> java.sql.Date;\n<span class=\"hljs-keyword\">import<\/span> java.sql.SQLException;\n\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-class\"><span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">AuthorDB<\/span> <\/span>{\n    <span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">final<\/span> Connection connection;\n\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-title\">AuthorDB<\/span><span class=\"hljs-params\">(Connection connection)<\/span> <\/span>{\n        <span class=\"hljs-keyword\">this<\/span>.connection = connection;\n    }\n\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">insert<\/span><span class=\"hljs-params\">(Author author)<\/span> <\/span>{\n        <span class=\"hljs-keyword\">if<\/span> (author == <span class=\"hljs-keyword\">null<\/span>) {\n            <span class=\"hljs-keyword\">return<\/span>;\n        }\n\n        <span class=\"hljs-keyword\">var<\/span> sql = <span class=\"hljs-string\">\"INSERT INTO Authors (FirstName, LastName, BirthDate) VALUES (?,?,?)\"<\/span>;\n        <span class=\"hljs-keyword\">try<\/span> (<span class=\"hljs-keyword\">var<\/span> statement = connection.prepareStatement(sql)) {\n            <span class=\"hljs-comment\">\/\/ Bind values to parameters<\/span>\n            statement.setString(<span class=\"hljs-number\">1<\/span>, author.getFirstName());\n            statement.setString(<span class=\"hljs-number\">2<\/span>, author.getLastName());\n            statement.setDate(<span class=\"hljs-number\">3<\/span>, Date.valueOf(author.getBirthDate()));\n\n            <span class=\"hljs-comment\">\/\/ Execute the query<\/span>\n            statement.executeUpdate();\n\n        } <span class=\"hljs-keyword\">catch<\/span> (SQLException e) {\n            e.printStackTrace();\n        }\n    }\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>How it works.<\/p>\n\n\n\n<p>First, import the <code>Date<\/code>, <code>SQLException<\/code>, and <code>Connection<\/code> classes from the <code>java.sql<\/code> package:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">import<\/span> java.sql.Date;\n<span class=\"hljs-keyword\">import<\/span> java.sql.SQLException;\n<span class=\"hljs-keyword\">import<\/span> java.sql.Connection;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Second, add a connection property to the <code>AuthorDB<\/code> class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">private<\/span> <span class=\"hljs-keyword\">final<\/span> Connection connection;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Third, define a constructor that accepts a Connection object:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-function\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-title\">AuthorDB<\/span><span class=\"hljs-params\">(Connection connection)<\/span> <\/span>{\n   <span class=\"hljs-keyword\">this<\/span>.connection = connection;\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Fourth, define the method <code>insert()<\/code> that accepts an <code>Author<\/code> object and inserts a new row with the data from the author object into the <code>Authors<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"> <span class=\"hljs-function\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">insert<\/span><span class=\"hljs-params\">(Author author)<\/span> <span class=\"hljs-keyword\">throws<\/span> DBException<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Fifth, return immediately if the author object is null:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">if<\/span> (author == <span class=\"hljs-keyword\">null<\/span>) {\n   <span class=\"hljs-keyword\">return<\/span>;\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Sixth, construct an <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-insert\/\">INSERT<\/a> statement that inserts a new row into the Authors table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">var<\/span> sql = <span class=\"hljs-string\">\"INSERT INTO Authors (FirstName, LastName, BirthDate) VALUES (?,?,?)\"<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In the query, the question marks (?) are placeholders for parameters. They will be substituted with actual value at runtime. This approach ensures the user input is safely passed to the SQL query, which helps prevent SQL injection attacks.<\/p>\n\n\n\n<p>Seventh, create a <code>PreparedStatement<\/code> object with the <code>INSERT<\/code> statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">try<\/span> (<span class=\"hljs-keyword\">var<\/span> pstmt = connection.prepareStatement(sql)) {<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Eighth, bind actual values to the placeholders in the <code>INSERT<\/code> statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\">statement.setString(<span class=\"hljs-number\">1<\/span>, author.getFirstName());\nstatement.setString(<span class=\"hljs-number\">2<\/span>, author.getLastName());\nstatement.setDate(<span class=\"hljs-number\">3<\/span>, Date.valueOf(author.getBirthDate()));<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Ninth, call the <code>executeUpdate()<\/code> method of the <code>PreparedStatement<\/code> object to execute the <code>INSERT<\/code> statement and return number of rows inserted:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\">statement.executeUpdate();<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Finally, throw a new <code>DBException<\/code> if an error occurred during the insertion:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">throw<\/span> <span class=\"hljs-keyword\">new<\/span> DBException(e.getMessage());<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Step 3. Modify the <code>main()<\/code> method of the <code>Main<\/code> class to use the <code>insert()<\/code> method of the <code>AuthorDB<\/code> class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">import<\/span> java.sql.SQLException;\n<span class=\"hljs-keyword\">import<\/span> java.time.LocalDate;\n\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-class\"><span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">Main<\/span> <\/span>{\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">main<\/span><span class=\"hljs-params\">(String&#91;] args)<\/span> <\/span>{\n\n        <span class=\"hljs-comment\">\/\/ Create a new Author object<\/span>\n        <span class=\"hljs-keyword\">var<\/span> author = <span class=\"hljs-keyword\">new<\/span> Author(<span class=\"hljs-string\">\"John\"<\/span>,<span class=\"hljs-string\">\"Doe\"<\/span>,LocalDate.of(<span class=\"hljs-number\">1990<\/span>, <span class=\"hljs-number\">12<\/span>, <span class=\"hljs-number\">31<\/span>));\n\n        <span class=\"hljs-comment\">\/\/ Connect to the SQL Server<\/span>\n        <span class=\"hljs-keyword\">try<\/span> (<span class=\"hljs-keyword\">var<\/span> connection = SQLServerConnection.connect()) {\n            <span class=\"hljs-comment\">\/\/ Create a new AuthorDB object<\/span>\n            <span class=\"hljs-keyword\">var<\/span> authorDB = <span class=\"hljs-keyword\">new<\/span> AuthorDB(connection);\n\n            <span class=\"hljs-comment\">\/\/ Insert the author into the database<\/span>\n            authorDB.insert(author);\n        } <span class=\"hljs-keyword\">catch<\/span> (SQLException | DBException e) {\n            System.err.println(e.getMessage());\n        }\n    }\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>How it works.<\/p>\n\n\n\n<p>First, create a new <code>Author<\/code> object for insertion:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">var<\/span> author = <span class=\"hljs-keyword\">new<\/span> Author(<span class=\"hljs-string\">\"John\"<\/span>,<span class=\"hljs-string\">\"Doe\"<\/span>,LocalDate.of(<span class=\"hljs-number\">1990<\/span>, <span class=\"hljs-number\">12<\/span>, <span class=\"hljs-number\">31<\/span>));<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Second, call the <code>connect()<\/code> method of the <code>SQLServerConnection<\/code> class to connect to the SQL Server:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"><span class=\"hljs-keyword\">try<\/span> (<span class=\"hljs-keyword\">var<\/span> connection = SQLServerConnection.connect())<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Third, create a new <code>AuthorDB<\/code> object:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"Java\" data-shcb-language-slug=\"java\"><span><code class=\"hljs language-java\"> <span class=\"hljs-keyword\">var<\/span> authorDB = <span class=\"hljs-keyword\">new<\/span> AuthorDB(connection);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Java<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">java<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Fourth, insert a new <code>Author<\/code> into the database by calling the <code>insert()<\/code> method of the <code>AuthorDB<\/code> object:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">authorDB<\/span><span class=\"hljs-selector-class\">.insert<\/span>(<span class=\"hljs-selector-tag\">author<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Finally, catch the <code>SQLException<\/code> and <code>DBException<\/code> and display the error:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-19\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">} <span class=\"hljs-keyword\">catch<\/span> (SQLException | DBException e) {\n     System.err.println(e.getMessage());\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Step 4. Run the Java program.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='verify-the-insert'>Verify the insert <a href=\"#verify-the-insert\" class=\"anchor\" id=\"verify-the-insert\" title=\"Anchor for Verify the insert\">#<\/a><\/h2>\n\n\n\n<p>Step 1. Open SQL Server Management Studio (SSMS) and connect to the SQL Server.<\/p>\n\n\n\n<p>Step 2. Execute the following query to retrieve data from the <code>Authors<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-20\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> <span class=\"hljs-keyword\">Authors<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-21\" data-shcb-language-name=\"plaintext\" data-shcb-language-slug=\"plaintext\"><span><code class=\"hljs language-plaintext\">AuthorID | FirstName | LastName | BirthDate\n---------+-----------+----------+------------\n1        | John      | Doe      | 1990-12-31\n(1 row)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">plaintext<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">plaintext<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\" id='download-the-project-source-code'>Download the project source code <a href=\"#download-the-project-source-code\" class=\"anchor\" id=\"download-the-project-source-code\" title=\"Anchor for Download the project source code\">#<\/a><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/java-insert.zip\">Download the project source code<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='summary'>Summary <a href=\"#summary\" class=\"anchor\" id=\"summary\" title=\"Anchor for Summary\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Call the <code>executeUpdate()<\/code> method of the <code>PreparedStatement<\/code> object to execute an <code>INSERT<\/code> statement to insert a row into a table.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"4235\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/\"\n\t\t\t\tdata-post-title=\"Java SQL Server: Inserting Data\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"4235\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/\"\n\t\t\t\tdata-post-title=\"Java SQL Server: Inserting Data\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you will learn how to insert data into an SQL Server table using a Java program. This tutorial begins where&nbsp;the&nbsp;connecting to the SQL Server from the Java program tutorial&nbsp;left off. Inserting data into a table from Java # Here are the steps for inserting data into a table in SQL Server [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4217,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-4235","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Java SQL Server: Inserting Data<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Java SQL Server: Inserting Data\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-29T00:47:41+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/java-sql-server-insert\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/java-sql-server-insert\\\/\",\"name\":\"Java SQL Server: Inserting Data\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"datePublished\":\"2024-07-25T08:54:53+00:00\",\"dateModified\":\"2024-07-29T00:47:41+00:00\",\"description\":\"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/java-sql-server-insert\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/java-sql-server-insert\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/java-sql-server-insert\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java SQL Server\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/java-sql-server\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Java SQL Server: Inserting Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Java SQL Server: Inserting Data","description":"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.","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:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/","og_locale":"en_US","og_type":"article","og_title":"Java SQL Server: Inserting Data","og_description":"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.","og_url":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2024-07-29T00:47:41+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/","url":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/","name":"Java SQL Server: Inserting Data","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"datePublished":"2024-07-25T08:54:53+00:00","dateModified":"2024-07-29T00:47:41+00:00","description":"In this tutorial, you will learn how to insert data into a SQL Server table from a Java program.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/java-sql-server-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"Java SQL Server","item":"https:\/\/www.sqlservertutorial.net\/java-sql-server\/"},{"@type":"ListItem","position":3,"name":"Java SQL Server: Inserting Data"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/4235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=4235"}],"version-history":[{"count":5,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/4235\/revisions"}],"predecessor-version":[{"id":4356,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/4235\/revisions\/4356"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/4217"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=4235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}