Number Of Row Affected : JdbcTemplate « Spring « Java Tutorial

1. Java Tutorial
2. Spring
3. JdbcTemplate

File: context.xml

File: Main.java

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.SingleConnectionDataSource;

public class Main {
  public static void main(String args[]) throws Exception {
    SingleConnectionDataSource ds = new SingleConnectionDataSource();
    ds.setDriverClassName("org.hsqldb.jdbcDriver");
    ds.setUrl("jdbc:hsqldb:data/tutorial");
    ds.setUsername("sa");
    ds.setPassword("");
    //
    // ds.setDriverClassName("com.mysql.jdbc.Driver");
    // ds.setUrl("jdbc:mysql://localhost:3306/spring");
    // ds.setUsername("spring");
    // ds.setPassword("password");
    //
    // ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    // ds.setUrl("jdbc:oracle:thin:@spring:1521:my10g");
    // ds.setUsername("spring");
    // ds.setPassword("password");
    
    JdbcTemplate jt = new JdbcTemplate(ds);
    jt.execute("create table employee (id int, name varchar)");
    int x = jt.update("insert into employee (id, name) values (1, 'A')");
    jt.execute("insert into employee (id, name) values (2, 'B')");
    jt.execute("insert into employee (id, name) values (3, 'C')");
    jt.execute("insert into employee (id, name) values (4, 'D')");
    jt.execute("insert into employee (id, name) values (5, 'E')");
    jt.execute("insert into employee (id, name) values (6, 'F')");    
    
   
    System.out.println(x);
    
    Object[] parameters = new Object[] {new Integer(1)};
    List l = jt.queryForList("select id, name from employee where id > ?",
        parameters);
    System.out.println(l.size());
    

    

    ds.destroy();
  }
}

28.21.JdbcTemplate
	28.21.1.	Use QueryForInt To Execute Aggregate Function
	28.21.2.	Use JdbcTemplate To Execute Aggregate Function
	28.21.3.	Use Jdbc Template To Create Table
	28.21.4.	Use batchUpdate To Execute Two Update Statements
	28.21.5.	Update, Delete Statements With Jdbc Template
	28.21.6.	Execute DeleteStatement
	28.21.7.	Query For Object, Return String
	28.21.8.	Query For Map
	28.21.9.	Query For List, Returns List Of LinkedHashMap
	28.21.10.	Query For List
	28.21.11.	Pass RowCallbackHandler Into Query Method In JdbcTemplate
	28.21.12.	Pass ResultSetExtractor To Query Method In JdbcTemplate
	28.21.13.	Pass Parameter As Object Array
	28.21.14.	Pass Object Array To Query Method In JdbcTemplate
	28.21.15.	Number Of Row Affected