Spring Tutorials

Executing an SQL statement requires very little code. You need a DataSource and a JdbcTemplate, including the convenience methods that are provided with the JdbcTemplate. We can use the execute(..) method from jdbcTemplate to execute any SQL statements or DDL statements. Following is an example to use CREATE statement to create a table.

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class ExecuteStatement {
private JdbcTemplate jt;
public void setDataSource(DataSource ds) {
this.jt = new JdbcTemplate(ds);}
public void Execute() {
this.jt.execute
("create table employee (id integer, name varchar(20),salary integer)");
}}

The following example shows a column updated for a primary key. In this example, an SQL statement has placeholders for row parameters. The parameter values can be passed in as varargs or alternatively as an array of objects. Thus primitives should be wrapped in the primitive wrapper classes explicitly or using auto-boxing.

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class ExecuteUpdate {
private JdbcTemplate jt;
public void setDataSource(DataSource ds) {
this.jt = new JdbcTemplate(ds); }
public void setName(int id, String name) {
this.jt.update
("update employee set name = ? where id = ?", name, id);
}}