Pages Navigation Menu

Coding is much easier than you think

JDBC Statement example to Insert a record

SONY DSC
 
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;
}
}

 
download

About Mohaideen Jamil