Java/Spring/SingleConnectionDataSource
Create and use SingleConnectionDataSource
<source lang="java">
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(); }
}
</source>