{"id":687,"date":"2015-12-22T20:08:52","date_gmt":"2015-12-22T13:08:52","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=687"},"modified":"2024-05-11T07:06:51","modified_gmt":"2024-05-11T00:06:51","slug":"sqlite-java-create-a-new-table","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/create-table\/","title":{"rendered":"SQLite Java: Create a New Table"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to create a new table in an SQLite database from a Java program using SQLite JDBC Driver.<\/p>\n\n\n\n

To create a new table in a specific database, you use the following steps:<\/p>\n\n\n\n

    \n
  1. First, prepare a CREATE TABLE<\/a><\/code>\u00a0statement to create the table you want.<\/li>\n\n\n\n
  2. Second, connect to the database<\/a>.<\/li>\n\n\n\n
  3. Third, create a new instance of the Statement<\/code> class from a Connection<\/code> object.<\/li>\n\n\n\n
  4. Fourth, execute the CREATE TABLE<\/code>\u00a0statement by calling the executeUpdate()<\/code> method of the Statement<\/code> object.<\/li>\n<\/ol>\n\n\n\n

    The following program illustrates the steps of creating a table:<\/p>\n\n\n

    import<\/span> java.sql.DriverManager;\nimport<\/span> java.sql.SQLException;\n\npublic<\/span> class<\/span> Main<\/span> <\/span>{\n\n    public<\/span> static<\/span> void<\/span> main<\/span>(String[] args)<\/span> <\/span>{\n        \/\/ SQLite connection string<\/span>\n        var<\/span> url = \"jdbc:sqlite:my.db\"<\/span>;\n\n        \/\/ SQL statement for creating a new table<\/span>\n        var<\/span> sql = \"CREATE TABLE IF NOT EXISTS warehouses (\"<\/span>\n                + \"\tid INTEGER PRIMARY KEY,\"<\/span>\n                + \"\tname text NOT NULL,\"<\/span>\n                + \"\tcapacity REAL\"<\/span>\n                + \");\"<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url);\n             var<\/span> stmt = conn.createStatement()) {\n            \/\/ create a new table<\/span>\n            stmt.execute(sql);\n        } catch<\/span> (SQLException e) {\n            System.out.println(e.getMessage());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    How it works.<\/p>\n\n\n\n
    First, import the classes from java.sql<\/code> package:<\/p>\n\n\n
    import<\/span> java<\/span>.sql<\/span>.DriverManager<\/span>;\nimport<\/span> java<\/span>.sql<\/span>.SQLException<\/span>;<\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    Second, declare and initialize a variable that holds a connection string to the my.db<\/code> database:<\/p>\n\n\n
    var<\/span> url = \"jdbc:sqlite:my.db\"<\/span>;<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Third, construct a CREATE TABLE<\/code> statement that creates the warehouses<\/code> table in the sqlite database file:<\/p>\n\n\n
    var<\/span> sql = \"CREATE TABLE IF NOT EXISTS warehouses (\"<\/span> +\n  \"\tid INTEGER PRIMARY KEY,\"<\/span> +\n  \"\tname text NOT NULL,\"<\/span> +\n  \"\tcapacity REAL\"<\/span> +\n  \");\"<\/span>;<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Fourth, open a new database connection to the sqlite database using the getConnection() method of the DriverManager class:<\/p>\n\n\n
    var<\/span> conn = DriverManager.getConnection(url);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Fifth, create a Statement class from the Connection object for executing SQL statements:<\/p>\n\n\n
    var<\/span> stmt = conn.createStatement()<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    We use the try-with-resources to properly close the statement and connection objects.<\/p>\n\n\n\n
    Sixth, call the execute() statement to execute the CREATE TABLE<\/code> statement:<\/p>\n\n\n
    stmt<\/span>.execute<\/span>(sql<\/span>);<\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    Seventh, display the error message if any SQL exception occurs in the catch block:<\/p>\n\n\n
    System<\/span>.out<\/span>.println<\/span>(e<\/span>.getMessage<\/span>());<\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    Finally, run the program to create the warehouses<\/code> table.<\/p>\n\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Call the execute()<\/code> method of the Statement<\/code> object to run the CREATE TABLE<\/code> statement to create a new table in the SQLite database.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful ?<\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t