B4J Question How do you use SQLite in B4J pages?

Erel said:

same code will work with B4J

Click to expand...

Erel said:

The same code will work with B4J. You just need to call SQL.InitializeSQLite and add this line to main module:

B4X:

#AdditionalJar: sqlite-jdbc-3.7.2

Click to expand...

Credo said:

Hi Erel,

One more thing;
I already made a db file with db browser. How do I add it to code?

sql.InitializeSQLite(File.DirData("sql"),"patient.db",True)
WebView1.LoadHtml(DBUtils.ExecuteHtml(sql,"SELECT * FROM login",Null, -1, False))


This is the code I written based on the video you made. Am I able to use a pre-existing DB file in the application folder?

"...\B4J\Files\patient.db"

Thank you again!

Click to expand...

    If File.Exists(File.DirData("sql"), "patient.db") = False Then
        'copy the default DB
        File.Copy(File.DirAssets, "patient.db", File.DirData("sql"), "patient.db")
    End If


    sql.InitializeSQLite(File.DirData("sql"), "patient.db", True)
    WebView1.LoadHtml(DBUtils.ExecuteHtml(sql,"SELECT * FROM login",Null, -1, False))