Java JDBC Sqlite Connection createTable(final String databaseName, final String statement)

Description

create Table

License

Apache License

Declaration

public static void createTable(final String databaseName, final String statement) 

Method Source Code

//package com.java2s;
//License from project: Apache License 

import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.SQLException;
import java.sql.Statement;

public class Main {
    private final static StringBuilder sb = new StringBuilder();
    private static final String JDBC_PREFIX = "jdbc:sqlite:";
    private static final String DB_SUFFIX = ".db";

    public static void createTable(final String databaseName, final String statement) {
        Connection c = null;//  w  ww.jav  a2 s  .c  om
        Statement stmt = null;
        try {
            c = DriverManager.getConnection("jdbc:sqlite:" + databaseName + ".db");
            System.out.println("Opened database successfully");
            stmt = c.createStatement();
            stmt.executeUpdate(statement);
            stmt.close();
            c.close();
        } catch (Exception e) {
            System.err.println(e.getClass().getName() + ": " + e.getMessage());
        }
        System.out.println("Table created successfully");
    }

    public static Connection getConnection(final String databaseName) throws SQLException {
        sb.setLength(0);
        sb.append(JDBC_PREFIX).append(databaseName).append(DB_SUFFIX);
        Connection conn = null;
        conn = DriverManager.getConnection(sb.toString());
        sb.setLength(0);
        return conn;
    }
}

Related

1. checkConnection()
2. createTable(String database, String sqlScript)
3. getConnection()
4. getConnection(final String databaseName)
5. getConnection(String dbFile)