JDBC Statement example to Insert a record
Here’s an example to show you how to insert a record into table via JDBC statement.
To issue a insert statement, calls the Statement.executeUpdate() method like this :
Statement statement = connection.createStatement(); // execute the insert SQL stetement statement.executeUpdate(insertTableQuery);
Full example…
File: JDBCStatementInsertExample.java
package com.simplecode.jdbc; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.SQLException; public class JDBCStatementInsertExample { private static final String dbDriver = "oracle.jdbc.driver.OracleDriver"; private static String serverName = "127.0.0.1"; private static String portNumber = "1521"; private static String sid = "XE"; private static final String dbUrl="jdbc:oracle:thin:@"+serverName+":"+portNumber+":"+sid; private static final String dbUser = "system"; private static final String dbPassword = "admin"; public static void main(String[] argv) { try { insertRecordIntoTable(); } catch (SQLException e) { System.out.println(e.getMessage()); } } private static void insertRecordIntoTable() throws SQLException { Connection connection = null; Statement statement = null; String insertTableQuery = "INSERT INTO EMPLOYEE" + "(USER_ID, USERNAME, CREATED_BY) VALUES" + "(1000,'nilafar','jamil')"; try { connection = getDBConnection(); statement = connection.createStatement(); // execute insert SQL statement statement.executeUpdate(insertTableQuery); System.out.println("Record is inserted into EMPLOYEE table!"); } catch (SQLException e) { System.out.println(e.getMessage()); } finally { if (statement != null) { statement.close(); } if (connection != null) { connection.close(); } } } private static Connection getDBConnection() { Connection dbConnection = null; try { Class.forName(dbDriver); } catch (ClassNotFoundException e) { System.out.println(e.getMessage()); } try { dbConnection = DriverManager.getConnection(dbUrl, dbUser, dbPassword); return dbConnection; } catch (SQLException e) { System.out.println("Db "+e.getMessage()); } return dbConnection; } }