Android上的SQLite JDBC驱动程序 [英] SQLite JDBC driver on Android
本文介绍了Android上的SQLite JDBC驱动程序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正尝试使用 xerial sqlite-jdbc 在Android中管理我的数据库,但没有成功.我遇到了java.lang.NoClassDefFoundError: org.sqlite.SQLiteConnection
异常.我已将此依赖项'org.xerial:sqlite-jdbc:3.18.0'
导入了我的摇篮.
我的代码如下,
I'm trying to use xerial sqlite-jdbc to manage my database in Android with no success.I'm getting an java.lang.NoClassDefFoundError: org.sqlite.SQLiteConnection
exception.I've imported this dependency 'org.xerial:sqlite-jdbc:3.18.0'
in my gradle.
My code is as follows,
try {
Class.forName("org.sqlite.JDBC");
Connection connection = DriverManager.getConnection("jdbc:sqlite:hs.db");
} catch (ClassNotFoundException eString) {System.err.println("Could not init JDBC driver - driver not found");
} catch (java.sql.SQLException e) {e.printStackTrace();}
在我的项目中不能使用android.database.sqlite
,因此请不要提出答案.
Using android.database.sqlite
in my project is not option so please don't suggest that as an answer.
推荐答案
Gradle
compile 'org.sqldroid:sqldroid:1.0.3'
JAVA
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
public class MainActivity extends AppCompatActivity {
private Connection connection;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
try {
DriverManager.registerDriver((Driver) Class.forName("org.sqldroid.SQLDroidDriver").newInstance());
} catch (Exception e) {
throw new RuntimeException("Failed to register SQLDroidDriver");
}
String jdbcUrl = "jdbc:sqldroid:" + "/data/data/" + getPackageName() + "/my-database.db";
try {
this.connection = DriverManager.getConnection(jdbcUrl);
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
@Override
public void onDestroy() {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
super.onDestroy();
}
}
https://github.com/SQLDroid/SQLDroid
这篇关于Android上的SQLite JDBC驱动程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文