Thursday 21 February 2019

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


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
  • 57 comments:

    1. There is large and wide scope for this technologies.Today majority of the frameworks, software are running on java and java is running rapidly .
      Regards

      ReplyDelete
    2. it is the easy way to understand the code thanking you it is help full
      Azure Data Factory course in Ameerpet
      Azure Data Engineer Training Online Hyderabad
      azure training in hyderabad ameerpet
      Azure Data Factory online Training in Hyderabad
      Microsoft Azure Data Factory in hyderabad

      ReplyDelete
    3. Microsoft Azure is an operating system that allows you to create web applications and store data in the cloud.Azure admin training in hyderabad visit our link to get more information:-https://azuretrainings.in/

      ReplyDelete
    4. This post is so interactive and informative.keep update more information...
      Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us By eMexo Technologies

      Java Training in Electronic City Bangalore
      Java Course in Electronic City Bangalore
      Best Java Training Institute in Electronic City Bangalore
      Java Certification Training in Electronic City Bangalore
      Java Training in Electronic City

      ReplyDelete
    5. Hello Sir I saw your blog, It was very nice blog, and your blog content is awesome. Digital Marketing

      ReplyDelete
    6. Thank you for the Valuable information

      Check our online certification courses and get certified

      Project Management Techniques

      ReplyDelete
    7. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    8. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    9. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    10. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    11. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    12. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    13. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    14. Good information

      Check our online certification courses and get certified

      PMP certification from our expert training

      ReplyDelete
    15. Good information

      Check our online certification courses and get certified

      PMP certification from our expert training

      ReplyDelete
    16. Thank you for the Valuable information

      Check our online certification courses and get certified

      Project Management Techniques

      ReplyDelete
    17. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    18. Thank you for the Valuable information

      Check our online certification courses and get certified

      Project Management Techniques

      ReplyDelete
    19. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    20. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    21. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    22. Good information

      Check our online certification courses and get certified

      PMP Certification training online

      ReplyDelete
    23. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    24. Thank you for the Valuable information

      Check our online certification courses and get certified

      Project Management Techniques

      ReplyDelete
    25. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    26. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    27. Thanks for sharing amazing information. Are you looking for reliable search engine marketing services India? There is no need to look any further! Our professionals can assist you in increasing your internet exposure and driving more visitors to your website. To learn more, please contact us immediately.

      ReplyDelete
    28. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    29. Your blog post is insightful and well-researched. It provides valuable information and practical tips that are highly relevant. The clear writing style makes complex concepts easy to understand. I look forward to reading more from your blog in the future. Keep up the great work. If you are looking for professional Job oriented course like
      Python Training in noida
      Data Science Training in noida
      full stack development training in noida
      Software Testing Training in Noida
      Digital Marketing Training in Noida

      ReplyDelete
    30. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    31. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    32. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    33. Thank you for the Valuable information

      Check out our Certification Programs :

      Events in scrum

      ReplyDelete
    34. Thank you for sharing! I always appreciate engaging content with valuable insights. The presented ideas are not only excellent but also captivating, making the post thoroughly enjoyable. Your continued efforts are commendable. Keep up the fantastic work.
      visit: Python in the Cloud: Deploying Apps with AWS and Azure

      ReplyDelete
    35. Nice Article!

      Thanks for sharing with us 🙂

      Full Stack Course in Hyderabad

      ReplyDelete