In [ ]:

    

%classpath add mvn org.xerial sqlite-jdbc 3.27.2.1


    

In [ ]:

    

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


    

In [ ]:

    

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


    

In [ ]:

    

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


    

In [ ]: