Java/Spring/SingleConnectionDataSource

Create and use 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("t1cket");
    //
    // ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    // ds.setUrl("jdbc:oracle:thin:@fiji:1521:my10g");
    // ds.setUsername("spring");
    // ds.setPassword("t1cket");
    
    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();
  }
}