Create SingleConnectionDataSource : SingleConnectionDataSource « Spring « Java Tutorial

1. Java Tutorial
2. Spring
3. SingleConnectionDataSource

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')");    
    
    
    Object[] parameters = new Object[] {"M"};
    int count = jt.queryForInt("select count(*) from employee where name > ?",
        parameters);
    
    System.out.println(count);
    ds.destroy();
  }
}

28.20.SingleConnectionDataSource
	28.20.1.	Create SingleConnectionDataSource