In [ ]:

    

%classpath add mvn org.xerial sqlite-jdbc 3.27.2.1


    

In [ ]:

    

conn = BxDriverManager.getConnection("jdbc:sqlite:sample.db");


    

In [ ]:

    

try{  
    sql = "CREATE TABLE IF NOT EXISTS Person ( id integer PRIMARY KEY,  name text NOT NULL);";  
    stmt = conn.createStatement();  
    result  = stmt.execute(sql);  
    dbm = conn.getMetaData();
    tables = dbm.getTables(null, null, "Person", null);
     while (tables.next()) { 
            tName = tables.getString("TABLE_NAME");
            if (tName != null && tName.equals("Person")) {
                println("table '"+tName+"' exists ");  
                tExists = true;
                break;
            }
        }
} catch (Exception e) {  
   println(e.getMessage());  
 } finally{
     conn.close()
 }


    

In [ ]:

    

import java.sql.DriverManager
java.sql.DriverManager.getConnection("jdbc:sqlite:sample.db")