{"id":662,"date":"2015-12-22T14:20:48","date_gmt":"2015-12-22T07:20:48","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=662"},"modified":"2024-05-11T08:15:49","modified_gmt":"2024-05-11T01:15:49","slug":"sqlite-java-create-database","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/create-database\/","title":{"rendered":"SQLite Java: Create a New SQLite Database"},"content":{"rendered":"\n

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

To create a new SQLite database from the Java application, you follow these steps:<\/p>\n\n\n\n

    \n
  1. First, specify the SQLite database file and its location.<\/li>\n\n\n\n
  2. Second, connect to the database via SQLite JDBC driver<\/a>.<\/li>\n<\/ol>\n\n\n\n

    When you connect to an SQLite database file that does not exist, it automatically creates a new database file. <\/p>\n\n\n\n

    The following program creates a new SQLite database file called my.db<\/code> within the same project directory:<\/p>\n\n\n

    import<\/span> java.sql.DriverManager;\nimport<\/span> java.sql.SQLException;\n\n\npublic<\/span> class<\/span> Main<\/span> <\/span>{\n\n    public<\/span> static<\/span> void<\/span> main<\/span>(String[] args)<\/span> <\/span>{\n        String url = \"jdbc:sqlite:my.db\"<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url)) {\n            if<\/span> (conn != null<\/span>) {\n                var<\/span> meta = conn.getMetaData();\n                System.out.println(\"The driver name is \"<\/span> + meta.getDriverName());\n                System.out.println(\"A new database has been created.\"<\/span>);\n            }\n        } catch<\/span> (SQLException e) {\n            System.err.println(e.getMessage());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    The driver name is SQLite JDBC\nA new database has been created.<\/code><\/span>Code language:<\/span> Shell Session<\/span> (<\/span>shell<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Connecting to an SQLite database file that does not exist will automatically create that database file.<\/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