Create table via sqlite JDBC connection - Java JDBC

Java examples for JDBC:Sqlite

  1. HOME
  2. Java
  3. JDBC
  4. Sqlite

Description

Create table via sqlite JDBC connection

Demo Code

import java.sql.*;

public class SQLiteJDBCcreateTable{

    public static void main( String args[] )
      {/*from ww  w  . j a va 2  s  . c  o  m*/
        Connection c = null;
        Statement stmt = null;
        try {
          Class.forName("org.sqlite.JDBC");
          c = DriverManager.getConnection("jdbc:sqlite:test.db");
          System.out.println("Opened database successfully");
    
          stmt = c.createStatement();
          String sql = "CREATE TABLE COMPANY " +
                       "(ID INT PRIMARY KEY     NOT NULL," +
                       " NAME           TEXT    NOT NULL, " + 
                       " AGE            INT     NOT NULL, " + 
                       " ADDRESS        CHAR(50), " + 
                       " SALARY         REAL)"; 
          stmt.executeUpdate(sql);    
          stmt.close();    
          c.close();
        } catch ( Exception e ) {
          System.err.println( e.getClass().getName() + ": " + e.getMessage() );
          System.exit(0);
        }
        System.out.println("Table created successfully");
      }
}

Related Tutorials