Skip to content

Instantly share code, notes, and snippets.

@Haoxiqiang

Haoxiqiang/App.kt

Created January 12, 2022 13:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Haoxiqiang/76baa3ba065e8b0204019872f1b8906c to your computer and use it in GitHub Desktop.
Save Haoxiqiang/76baa3ba065e8b0204019872f1b8906c to your computer and use it in GitHub Desktop.
Download ZIP
load sqlite db from jar
Raw
App.kt
/**
* from my repo:https://github.com/Haoxiqiang/android-quick-reference
* In Idea's plugin, org.sqlite.JDBC won't auto registe.
* you should call any mehtod which make classloader load org.sqlite.JDBC
*/
val classLoader = App.javaClass.classLoader
val resource: URL = classLoader.getResource("db/QuickRefDB.db")!!
val jdbcURL = "jdbc:sqlite::resource:${resource.toURI()}"
// try call org.sqlite.JDBC.<cinit>
JDBC.isValidURL(jdbcURL)
val driver = JdbcSqliteDriver(jdbcURL)
val database = QuickRefDB.invoke(driver)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment