Pages Navigation Menu

Coding is much easier than you think

JDBC Statement example to Delete a Record

drop table
 
Here is an example to show you how to delete a record from a table via JDBC statement.
 
To issue a delete statement, calls the Statement.executeUpdate() method as shown below :
 

Statement statement = connection.createStatement();
// execute delete  SQL stetement
statement.executeUpdate(deleteTableQuery);

 
Full example…
File: JDBCStatementDeleteExample.java
 

package com.simplecode.jdbc;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;

public class JDBCStatementDeleteExample  
{

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[] argc) 
	{
		try 
		{
			deleteRecordFromEmployeeTable();
		}
		catch (SQLException e) 
		{
			System.out.println(e.getMessage());
		}
	}

	private static void deleteRecordFromEmployeeTable() throws SQLException 
	{
	Connection connection = null;
	Statement statement = null;

	String deleteTableQuery = "DELETE EMPLOYEE WHERE USER_ID = 1000";

		try 
		{
			connection = getDBConnection();
			statement = connection.createStatement();

			// execute delete SQL statement
			statement.executeUpdate(deleteTableQuery);
			System.out.println("Record is deleted from EMPLOYEE table!");

		}
		catch (SQLException e) 
		{
			System.err.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.err.println(e.getMessage());
		}

		try 
		{
		dbConnection = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
		return dbConnection;
		}
		catch (SQLException e) 
		{
			System.err.println(e.getMessage());
		}

	return dbConnection;
	}
}

 
download

About Mohaideen Jamil


I'm a Full stack developer of IT exp in J2EE, AngularJs, MicroServices, Docker, Spring (Boot, MVC, Cloud), Bluemix, DevOps. Follow me on Facebook or Google Plus. If you like my tutorials, consider making a donation to this charity, thanks.

Advertisements
%d bloggers like this: