Spring SimpleJdbcTemplate update


 

Spring SimpleJdbcTemplate update

This section is about update method using SimpleJdbcTemplate to update records .

This section is about update method using SimpleJdbcTemplate to update records .

Spring SimpleJdbcTemplate update

This section is about update method using SimpleJdbcTemplate  to update records . The update method is beneficial where you need to issue single update .It is easy and effective in this condition. This method throw DataAccessException .

EXAMPLE

In this example , we are going to update the database table row using update method . We are using "Emp" class for setting the value.

UpdateSJT.java

package net.roseindia;

import javax.sql.DataSource;

import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;

public class UpdateSJT {
	private SimpleJdbcTemplate simpleJdbcTemplate;
	private static final String update = 
	"update skills set first_name = ?, last_name = ? where id = ?";

	public void setDataSource(DataSource dataSource) {
		this.simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
	}

	public void insert(Emp emp) {
		simpleJdbcTemplate.update(update, emp.getFirstName(),
				emp.getLastName(), emp.getId());
	}

	public Emp newEmp() {
    Emp emp = new Emp();
	emp.setId(1101);
	emp.setFirstName("Rakesh");
	emp.setLastName("Chaudhary");
	return emp;
	}
}

UpdateSJTMain.html

package net.roseindia;

import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;

public class UpdateSJTMain {

	public static void main(String[] args) {

		XmlBeanFactory beanFactory = new XmlBeanFactory(new ClassPathResource(
				"UpdateSJT.xml"));

		UpdateSJT myBean = (UpdateSJT) beanFactory.getBean("BSJT");

		myBean.insert(myBean.newEmp());

	}
}

UpdateSJT.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<bean id="BSJT" class="net.roseindia.UpdateSJT">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="com.mysql.jdbc.Driver" />
<property name="jdbcUrl" value="jdbc:mysql://192.168.10.13:3306/ankdb" />
<property name="user" value="root" />
<property name="password" value="root" />
</bean>
</beans>

Emp.java

package net.roseindia;

public class Emp {
	private int id;
	private String firstName;
	private String lastName;

	public String getFirstName() {
		return this.firstName;
	}

	public String getLastName() {
		return this.lastName;
	}

	public int getId() {
		return this.id;
	}

	public void setId(int id) {
		this.id = id;
	}

	// setters methods

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String toString() {
		return id + " " + firstName + " " + lastName;
	}

}

OUTPUT

Before executing query database table :

After executing database table :

Download Source Code

Ads