package br.org.agilcoop.cursos.testes.bancoDeDados;

 import org.springframework.jdbc.core.JdbcTemplate;

 import org.springframework.jdbc.datasource.DriverManagerDataSource;

 public class Config {

         public static JdbcTemplate jdbc;

         static {

                 bootstrap();

         }

         public static void bootstrap() {

                 DriverManagerDataSource ds = new DriverManagerDataSource();

                 ds.setDriverClassName("org.hsqldb.jdbcDriver");

                 ds.setUrl("jdbc:hsqldb:mem:teste;shutdown=true");

                 ds.setUsername("sa");

                 ds.setPassword("");

                 try {

                         ds.getConnection();

                 } catch (Exception e) {

                         e.printStackTrace();

                 }

                 jdbc = new JdbcTemplate(ds);

                 System.out.println("Configuração OK.");

                 jdbc.execute("SET WRITE_DELAY 0 MILLIS");

                 jdbc.execute("SET SCHEMA PUBLIC");

                 jdbc.execute("CREATE MEMORY TABLE usuario (id integer, nome varchar(100), senha varchar(100))");

                 System.out.println(jdbc.queryForInt("select count(0) from usuario"));

                 System.out.println("Tabelas criadas.");

         }

 }