08ESx6HU

1public void createTablesIfNotExists() throws ClassNotFoundException, SQLException {
2        String sqlClientes = "CREATE TABLE IF NOT EXISTS clientes (n"
3                    + "cliente_id         INTEGER PRIMARY KEY,n"
4                    + "nombre_empresa     TEXT    NOT NULL    UNIQUE,n"
5                    + "nombre_persona     TEXT,n"
6                    + "numero_movil       TEXT,n"
7                    + "numero_oficina     TEXT,n"
8                    + "numero_oficina_ext TEXT,n"
9                    + "fax                TEXT,n"
10                    + "email              TEXT    UNIQUE,n"
11                    + "direccion1         TEXT,n"
12                    + "direccion2         TEXT,n"
13                    + "ciudad             TEXT,n"
14                    + "provincia          TEXT,n"
15                    + "codigo_postal      INTEGER,n"
16                    + "rnc                TEXT    UNIQUE,n"
17                    + "ncf                TEXT    UNIQUEn"
18                    + ");";
19
20        String sqlNotas = "CREATE TABLE IF NOT EXISTS notas (n"
21                    + "nota_id    INTEGER PRIMARY KEY,n"
22                    + "nota       TEXT    NOT NULL,n"
23                    + "prioridad  INTEGER NOT NULL,n"
24                    + "cliente_id INTEGER REFERENCES clientes (cliente_id) ON DELETE CASCADEn"
25                    + ");";
26
27        try (Connection conn = this.getConnection();
28                 Statement stmt = conn.createStatement()) {
29            // Set auto-commit to false
30            conn.setAutoCommit(false);
31            // Add SQL statement in the batch
32            stmt.addBatch(sqlClientes);
33            stmt.addBatch(sqlNotas);
34            //Explicitly commit statements to apply changes
35            conn.commit();
36        }
37    }