How to delete the record from the database using JdbcTemplate with Spring Boot? | Spring Boot

🚀 Level Up Your Coding Skills!

Subscribe to Ram N Java for more easy-to-follow Spring Boot and Java tutorials!

Click Here to SUBSCRIBE!

Effortlessly Delete Data in Spring Boot with JdbcTemplate

Deleting data is a fundamental part of any application's CRUD (Create, Read, Update, Delete) operations. In this guide, we dive deep into how you can use Spring Boot's JdbcTemplate to remove records from your database safely and efficiently.

Why Use JdbcTemplate for Deletion?

While JPA is popular, JdbcTemplate offers more control and better performance for simple SQL operations. It handles the connection management and cleanup for you, allowing you to focus on the logic.

The Core Method: update()

To delete a record, we use the update method. Despite its name, it is the standard way to execute DELETE and UPDATE queries in Spring JDBC. It returns the number of rows affected, which is great for verifying if the deletion actually happened.

Step-by-Step Implementation

• Write the SQL: Create a query like "DELETE FROM users WHERE id = ?".
• Pass Parameters: Use the ID or any unique field to target the specific row.
• Execute: Use jdbcTemplate.update(sql, id) to run the command.

Real-World Example

Imagine an e-commerce app where a user wants to remove an item from their cart. You would use JdbcTemplate to find that item by its Product ID and delete it from the database in real-time!

Check Out More From My Channel

If you found this useful, here are three other videos you might enjoy:

• 🔗 Spring Boot: Mastering Multiple Database Configurations
• 🔗 MCP Server Setup Using Java | Build Your First MCP Server from Scratch
• 🔗 Why AI Needs RAG | Retrieval-Augmented Generation Explained

Spring + JdbcTemplate + Execute delete statement with multiple parameters with object array example

🚀 Master Java & Spring!

Get the best coding tutorials simplified for you. Join the Ram N Java community today!

SUBSCRIBE NOW

Deleting Rows with Multiple Parameters in Spring JDBC

Deleting specific records from a database is a core operation in any application. While deleting by a single ID is common, sometimes you need to delete based on multiple conditions (e.g., delete an employee with a specific name AND age). In this guide, we'll see how Spring JdbcTemplate makes this easy using Object Arrays.

The SQL Delete Logic

To delete with multiple conditions, we use ? placeholders in our SQL string. This keeps the code clean and protects against SQL injection:

DELETE FROM employee WHERE name = ? AND age = ?

Using the Object Array Approach

Spring's update() method (used for INSERT, UPDATE, and DELETE) can take an array of objects as an argument. This is perfect for beginners because:

• Easy Mapping: The first object in the array replaces the first ?, the second replaces the second ?, and so on.
• Type Safety: You can mix different types (Strings, Integers, etc.) in the same array.
• Readable Code: It separates your SQL query from your actual data values.

How to Implement It

1. SQL String: Define your query with DELETE FROM ... WHERE ... ? AND ... ?.

2. Object Array: Create your data array: new Object[] { "John Doe", 30 }.

3. Execution: Call jdbcTemplate.update(sql, objectArray).

⚡ Quick Tip:

Always check the return value of the update() method. It returns an int representing the number of rows actually deleted!

Check Out More Tutorials

Explore these related videos from Ram N Java to build your Spring JDBC expertise:

• 👉 What is Spring JdbcTemplate? | Overview for Beginners
• 👉 Update Rows with Multiple Parameters (Object Array)
• 👉 Executing Delete Statements with One Parameter

---

Click here to watch on Youtube: 
https://www.youtube.com/watch?v=J4uwf_2l2PQ&list=UUhwKlOVR041tngjerWxVccw

Click the below Image to Enlarge:

Spring + JdbcTemplate + Execute delete statement with multiple parameters with object array example

Employee.sql

CREATE DATABASE org_db;


CREATE TABLE `employee` (
  `EMPLOYEE_ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(100) NOT NULL,
  `AGE` INT(10) NOT NULL,
  `SALARY` INT(10) DEFAULT NULL,
  PRIMARY KEY (`EMPLOYEE_ID`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('1','Peter','28','80000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('2','John','50','40000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('3','David','45','20000');

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.ram.core</groupId>
    <artifactId>SpringDemo</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>SpringDemo</name>
    <url>http://maven.apache.org</url>

    <properties>
        <spring.version>5.0.5.RELEASE</spring.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>

        <!-- Spring 5 dependencies -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <!-- MySQL database driver -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

    </dependencies>

</project>

EmployeeDAO.java

package com.ram.employee.dao;

public interface EmployeeDAO
{
    public int deleteByEmployeeNameAndAge(String name,int age);
}

EmployeeDAOImpl.java

package com.ram.employee.dao.impl;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.ram.employee.dao.EmployeeDAO;

public class EmployeeDAOImpl extends JdbcDaoSupport implements EmployeeDAO
{

    public int deleteByEmployeeNameAndAge(String name, int age)
    {
        String sql = "DELETE FROM EMPLOYEE WHERE Name=? and AGE=?";
        int numberOfRowsAffected = getJdbcTemplate().update(sql,
                new Object[] { name, age });
        return numberOfRowsAffected;
    }

}

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">

    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/org_db" />
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>

    <bean id="employeeDAO" class="com.ram.employee.dao.impl.EmployeeDAOImpl">
        <property name="dataSource" ref="dataSource" />
    </bean>

</beans>

App.java

package com.ram.core;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ram.employee.dao.EmployeeDAO;

public class App
{
    public static void main(String[] args)
    {
        ApplicationContext context = new ClassPathXmlApplicationContext(
                "applicationContext.xml");

        EmployeeDAO employeeDAO = (EmployeeDAO) context
                .getBean("employeeDAO");
        int numberOfRowsAffected = employeeDAO.deleteByEmployeeNameAndAge("John",50);
        System.out.println(numberOfRowsAffected + " employee row deleted successfully.");
    }
}

Output:

Feb 11, 2019 10:51:56 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@35d176f7: startup date [Mon Feb 11 10:51:56 IST 2019]; root of context hierarchy
Feb 11, 2019 10:51:56 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Feb 11, 2019 10:51:57 AM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
Mon Feb 11 10:52:06 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1 employee row deleted successfully.

Click the below link to download the code:
https://sites.google.com/site/javaspringram2019/java_spring_2019/SpringDemo_delete_multi_param_object_array.zip?attredirects=0&d=1

Github Link:
https://github.com/ramram43210/Java_Spring_2019/tree/master/Spring_2019/SpringDemo_delete_multi_param_object_array

Bitbucket Link:
https://bitbucket.org/ramram43210/java_spring_2019/src/8f8b5563b7f2921ed260908e4906103995d9c6cc/Spring_2019/SpringDemo_delete_multi_param_object_array/?at=master

See also:

All JavaEE Videos Playlist

All JavaEE Videos

All JAVA EE Links

Spring Tutorial

Servlets Tutorial

All Design Patterns Links

JDBC Tutorial

Java Collection Framework Tutorial

JAVA Tutorial

Kids Tutorial

Cooking Tutorial

Spring + JdbcTemplate + Execute delete statement with multiple parameters with object args example

🚀 Master Spring & Java with Us!

Want to simplify complex coding concepts? Join the Ram N Java family today!

SUBSCRIBE NOW

Deleting Data with Multiple Arguments in Spring JDBC

In this tutorial, we will explore how to perform a DELETE operation in a database using Spring JdbcTemplate when you have multiple filtering criteria. Using Object arguments is one of the most efficient and cleanest ways to pass multiple values into your SQL queries.

The SQL Query Pattern

When you need to delete a record based on more than one condition (for example, deleting an employee by both their Name and Age), you use ? placeholders for each dynamic value:

DELETE FROM employee WHERE name = ? AND age = ?

Why Use Object Arguments?

Using an Object[] or varargs (variable arguments) in the update() method is perfect for beginners because:

• Prevents SQL Injection: Spring handles the parameter binding safely.
• Cleaner Code: You don't have to manually build long strings with + signs.
• Automatic Typing: Spring automatically identifies if your parameter is a String, Integer, or Date.

Practical Implementation

1. SQL Statement: Write your DELETE query with ? for values.
2. Arguments: Prepare your values. If using an Object array, the order must match the ? order in the SQL.
3. Execute: Call jdbcTemplate.update(sql, "EmployeeName", 30).

⭐ Pro Tip:

The update() method returns an integer. This number tells you exactly how many rows were deleted. If it returns 0, no matching records were found!

Expand Your Knowledge

Check out these other Spring JDBC tutorials from Ram N Java to sharpen your skills:

• 📌 MCP Server Setup Using Java | Step-by-Step Guide
• 📌 Delete Statement with Multiple Parameters (Object Array)
• 📌 Update Rows with Multiple Parameters (Object Array) Example

---

Click here to watch on Youtube:
https://www.youtube.com/watch?v=ZF-Wfgn2by0&list=UUhwKlOVR041tngjerWxVccw

Click the below Image to Enlarge:

Spring + JdbcTemplate + Execute delete statement with multiple parameters with object args example

Employee.sql

CREATE DATABASE org_db;


CREATE TABLE `employee` (
  `EMPLOYEE_ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(100) NOT NULL,
  `AGE` INT(10) NOT NULL,
  `SALARY` INT(10) DEFAULT NULL,
  PRIMARY KEY (`EMPLOYEE_ID`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('1','Peter','28','80000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('2','John','50','40000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('3','David','45','20000');

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.ram.core</groupId>
    <artifactId>SpringDemo</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>SpringDemo</name>
    <url>http://maven.apache.org</url>

    <properties>
        <spring.version>5.0.5.RELEASE</spring.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>

        <!-- Spring 5 dependencies -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <!-- MySQL database driver -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

    </dependencies>

</project>

EmployeeDAO.java

package com.ram.employee.dao;

public interface EmployeeDAO
{
    public int deleteByEmployeeNameAndAge(String name,int age);
}

EmployeeDAOImpl.java

package com.ram.employee.dao.impl;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.ram.employee.dao.EmployeeDAO;

public class EmployeeDAOImpl
        extends JdbcDaoSupport implements EmployeeDAO
{

    public int deleteByEmployeeNameAndAge(String name,int age)
    {
        String sql = "DELETE FROM EMPLOYEE WHERE Name=? and AGE=?";
        int numberOfRowsAffected = getJdbcTemplate().update(sql, name,age);
        return numberOfRowsAffected;
    }

}

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">

    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/org_db" />
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>

    <bean id="employeeDAO" class="com.ram.employee.dao.impl.EmployeeDAOImpl">
        <property name="dataSource" ref="dataSource" />
    </bean>
 
</beans>

App.java

package com.ram.core;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ram.employee.dao.EmployeeDAO;

public class App
{
    public static void main(String[] args)
    {
        ApplicationContext context = new ClassPathXmlApplicationContext(
                "applicationContext.xml");

        EmployeeDAO employeeDAO = (EmployeeDAO) context
                .getBean("employeeDAO");
        int numberOfRowsAffected = employeeDAO.deleteByEmployeeNameAndAge("Peter",28);
        System.out.println(numberOfRowsAffected + " employee row deleted successfully.");
    }
}

Output:

Feb 09, 2019 11:04:51 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@35d176f7: startup date [Sat Feb 09 11:04:50 IST 2019]; root of context hierarchy
Feb 09, 2019 11:04:51 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Feb 09, 2019 11:04:52 AM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
Sat Feb 09 11:04:58 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1 employee row deleted successfully.

Click the below link to download the code:
https://sites.google.com/site/javaspringram2019/java_spring_2019/SpringDemo_delete_multi_param_args.zip?attredirects=0&d=1

Github Link:
https://github.com/ramram43210/Java_Spring_2019/tree/master/Spring_2019/SpringDemo_delete_multi_param_args

Bitbucket Link:
https://bitbucket.org/ramram43210/java_spring_2019/src/a3741618d82a4fb8b8d7a6751e0e628f0b8999ea/Spring_2019/SpringDemo_delete_multi_param_args/?at=master

See also:

All JavaEE Videos Playlist

All JavaEE Videos

All JAVA EE Links

Spring Tutorial

Servlets Tutorial

All Design Patterns Links

JDBC Tutorial

Java Collection Framework Tutorial

JAVA Tutorial

Kids Tutorial

Cooking Tutorial

Spring + JdbcTemplate + Execute delete statement with one parameter example | Spring JDBC tutorial

🚀 Ready to Master Spring JDBC?

Don't miss out on more easy-to-follow Java tutorials. Join Ram N Java today!

SUBSCRIBE TO CHANNEL

Deleting Records Using a Single Parameter

Deleting data safely and efficiently is a critical part of any database application. In this guide, we'll learn how to use Spring JdbcTemplate to execute a DELETE statement using a single dynamic parameter, such as an employee ID.

The SQL Delete Statement

When we want to delete a specific row, we use the WHERE clause with a placeholder (?). This is much safer than concatenating strings directly, as it protects against SQL injection.

DELETE FROM employee WHERE id = ?

Using JdbcTemplate's Update Method

In Spring JDBC, the update() method is versatile. It is used not only for updates and inserts but also for deletions. When dealing with a single parameter, the method signature is straightforward.

How it works:

• Query: Pass your SQL string with the ? placeholder.
• Value: Pass the actual value (like the ID) that should replace the ?.

Beginner-Friendly Logic

1. Identify the Target: Determine which column (e.g., ID or Name) you'll use to filter the deletion.
2. Inject JdbcTemplate: Ensure your DAO or Service has access to the JdbcTemplate object.
3. Execute: Call jdbcTemplate.update(sql, parameterValue). Spring handles the database connection and statement cleanup for you!

⭐ Important Note:

The update() method returns an int. This value represents the total number of rows deleted. If it returns 1, one record was successfully removed. If 0, no matching record was found.

Keep Learning with Ram N Java

Check out these related tutorials from our channel to expand your Spring JDBC skills:

• 📌 What is Spring JdbcTemplate? | Overview & Benefits
• 📌 Spring JdbcTemplate and JdbcDaoSupport Tutorial
• 📌 Spring JdbcTemplate: BeanPropertyRowMapper Example

---

Click here to watch on Youtube:
https://www.youtube.com/watch?v=OgR-AcRtN0Y&list=UUhwKlOVR041tngjerWxVccw

Click the below Image to Enlarge:

Spring + JdbcTemplate + Execute delete statement with one parameter example | Spring JDBC tutorial

Employee.sql

CREATE DATABASE org_db;


CREATE TABLE `employee` (
  `EMPLOYEE_ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(100) NOT NULL,
  `AGE` INT(10) NOT NULL,
  `SALARY` INT(10) DEFAULT NULL,
  PRIMARY KEY (`EMPLOYEE_ID`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('1','Peter','28','80000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('2','John','50','40000');
INSERT INTO `employee` (`EMPLOYEE_ID`, `NAME`, `AGE`, `SALARY`) VALUES('3','David','45','20000');

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.ram.core</groupId>
    <artifactId>SpringDemo</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>SpringDemo</name>
    <url>http://maven.apache.org</url>

    <properties>
        <spring.version>5.0.5.RELEASE</spring.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>

        <!-- Spring 5 dependencies -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <!-- MySQL database driver -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

    </dependencies>

</project>

EmployeeDAO.java

package com.ram.employee.dao;

public interface EmployeeDAO
{
    public void deleteByEmployeeId(int employeeId);
}

EmployeeDAOImpl.java

package com.ram.employee.dao.impl;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.ram.employee.dao.EmployeeDAO;

public class EmployeeDAOImpl
        extends JdbcDaoSupport implements EmployeeDAO
{

    public void deleteByEmployeeId(int employeeId)
    {
        String sql = "DELETE FROM EMPLOYEE WHERE EMPLOYEE_ID=?";
        getJdbcTemplate().update(sql, employeeId);
    }

}

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">

    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/org_db" />
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>

    <bean id="employeeDAO" class="com.ram.employee.dao.impl.EmployeeDAOImpl">
        <property name="dataSource" ref="dataSource" />
    </bean>
   
</beans>

App.java

package com.ram.core;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ram.employee.dao.EmployeeDAO;

public class App
{
    public static void main(String[] args)
    {
        ApplicationContext context = new ClassPathXmlApplicationContext(
                "applicationContext.xml");

        EmployeeDAO employeeDAO = (EmployeeDAO) context
                .getBean("employeeDAO");
        employeeDAO.deleteByEmployeeId(1);
        System.out.println("employee row deleted successfully.");
    }
}

Output:

Feb 08, 2019 10:17:37 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@35d176f7: startup date [Fri Feb 08 10:17:37 IST 2019]; root of context hierarchy
Feb 08, 2019 10:17:37 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Feb 08, 2019 10:17:38 AM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
Fri Feb 08 10:17:51 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
ERROR: JDWP Unable to get JNI 1.2 environment, jvm->GetEnv() return code = -2
JDWP exit error AGENT_ERROR_NO_JNI_ENV(183):  [util.c:840]
employee row deleted successfully.

Click the below link to download the code:
https://sites.google.com/site/javaspringram2019/java_spring_2019/SpringDemo_delete_one_param.zip?attredirects=0&d=1

Github Link:
https://github.com/ramram43210/Java_Spring_2019/tree/master/Spring_2019/SpringDemo_delete_one_param

Bitbucket Link:
https://bitbucket.org/ramram43210/java_spring_2019/src/a3741618d82a4fb8b8d7a6751e0e628f0b8999ea/Spring_2019/SpringDemo_delete_one_param/?at=master

See also:

All JavaEE Videos Playlist

All JavaEE Videos

All JAVA EE Links

Spring Tutorial

Servlets Tutorial

All Design Patterns Links

JDBC Tutorial

Java Collection Framework Tutorial

JAVA Tutorial

Kids Tutorial

Cooking Tutorial