Java JDBC HSQL Connection createTweetTable()

Description

create Tweet Table

License

Open Source License

Declaration

public static void createTweetTable() throws Exception 

Method Source Code

//package com.java2s;
/*//  www . j  a v  a2s .c o m
 *  The MIT License
 *
 *   Copyright (c) 2015, Mahmoud Ben Hassine (mahmoud@benhassine.fr)
 *
 *   Permission is hereby granted, free of charge, to any person obtaining a copy
 *   of this software and associated documentation files (the "Software"), to deal
 *   in the Software without restriction, including without limitation the rights
 *   to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 *   copies of the Software, and to permit persons to whom the Software is
 *   furnished to do so, subject to the following conditions:
 *
 *   The above copyright notice and this permission notice shall be included in
 *   all copies or substantial portions of the Software.
 *
 *   THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 *   IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 *   FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 *   AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 *   LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *   OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 *   THE SOFTWARE.
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
    public static final String USER = "sa";
    public static final String PASSWORD = "pwd";
    private static final String DATABASE_URL = "jdbc:hsqldb:mem";

    public static void createTweetTable() throws Exception {
        Connection connection = getConnection();
        Statement statement = connection.createStatement();

        String query = "DROP TABLE IF EXISTS tweet";
        statement.executeUpdate(query);
        query = "CREATE TABLE tweet (\n" + "  id integer NOT NULL PRIMARY KEY,\n" + "  user varchar(32) NOT NULL,\n"
                + "  message varchar(140) NOT NULL,\n" + ");";

        statement.executeUpdate(query);
        statement.close();
        connection.close();
    }

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(DATABASE_URL, USER, PASSWORD);
    }
}

Related

1. createConnection()
2. createHSQLDBConnection(String hsqldbName)
3. createSchemasForHSQLDB(String dbName, String[] schemaNames)
4. getConnection()
5. getDbConnection()
6. getHSQLConnection()
7. printSchema()