| 1 | package br.org.agilcoop.cursos.testes.bancoDeDados; |
| 2 | |
| 3 | import org.springframework.jdbc.core.JdbcTemplate; |
| 4 | import org.springframework.jdbc.datasource.DriverManagerDataSource; |
| 5 | |
| 6 | |
| 7 | public class Config { |
| 8 | public static JdbcTemplate jdbc; |
| 9 | |
| 10 | static { |
| 11 | bootstrap(); |
| 12 | } |
| 13 | |
| 14 | public static void bootstrap() { |
| 15 | DriverManagerDataSource ds = new DriverManagerDataSource(); |
| 16 | ds.setDriverClassName("org.hsqldb.jdbcDriver"); |
| 17 | ds.setUrl("jdbc:hsqldb:mem:teste;shutdown=true"); |
| 18 | ds.setUsername("sa"); |
| 19 | ds.setPassword(""); |
| 20 | |
| 21 | try { |
| 22 | ds.getConnection(); |
| 23 | } catch (Exception e) { |
| 24 | e.printStackTrace(); |
| 25 | } |
| 26 | jdbc = new JdbcTemplate(ds); |
| 27 | System.out.println("Configuração OK."); |
| 28 | jdbc.execute("SET WRITE_DELAY 0 MILLIS"); |
| 29 | jdbc.execute("SET SCHEMA PUBLIC"); |
| 30 | jdbc.execute("CREATE MEMORY TABLE usuario (id integer, nome varchar(100), senha varchar(100))"); |
| 31 | System.out.println(jdbc.queryForInt("select count(0) from usuario")); |
| 32 | System.out.println("Tabelas criadas."); |
| 33 | } |
| 34 | |
| 35 | } |