以下是一个简单的Java操作SQLite数据库的工具类示例。请确保你的项目中已经包含了SQLite JDBC驱动。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class SQLiteHelper {
private Connection connection;
public SQLiteHelper(String databaseFile) {
this.connect(databaseFile);
}
private void connect(String databaseFile) {
try {
// SQLite的JDBC URL
String url = "jdbc:sqlite:" + databaseFile;
connection = DriverManager.getConnection(url);
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
public void executeNonQuery(String sql, Object... params) {
try (PreparedStatement statement = connection.prepareStatement(sql)) {
for (int i = 0; i < params.length; i++) {
statement.setObject(i + 1, params[i]);
}
statement.executeUpdate();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql, Object... params) {
try (PreparedStatement statement = connection.prepareStatement(sql)) {
for (int i = 0; i < params.length; i++) {
statement.setObject(i + 1, params[i]);
}
return statement.executeQuery();
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
}
public void close() {
try {
if (connection != null && !connection.isClosed()) {
connection.close();
}
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
}使用方法：
SQLiteHelper dbHelper = new SQLiteHelper("path_to_your_database.db");
try {
// 创建一个表
String createTableSQL = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)";
dbHelper.executeNonQuery(createTableSQL);
// 插入数据
String insertSQL = "INSERT INTO users (name, email) VALUES (?, ?)";
dbHelper.executeNonQuery(insertSQL, "Alice", "alice@examp