Use Jdbc Template To Create Table : JdbcTemplate « Spring « Java Tutorial

1. Java Tutorial
2. Spring
3. JdbcTemplate

File: context.xml

File: Main.java

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)");
    jt.execute("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')");    
    
    
    int count = jt.queryForInt("select count(*) from employee");    
    
    System.out.println(count);
    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