java打开db文件_Java – JDBC驱动程序SQLite 3.7.2 – 无法打开数据库test.db：文件已加密或不是数据库...

我正在使用

java中的SQLite JDBC驱动程序3.7.2将一些数据写入数据库文件.当我尝试在命令行上打开数据库文件时,收到一条错误消息：

“无法打开数据库test.db：文件已加密或不是数据库”

我做了一个最小的例子导致了这种行为：

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

public class PlaygroundSQLite {

public static void insertIntoDB(String dbFilename, String tablename){

try {

Class.forName("org.sqlite.JDBC");

Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbFilename);

PreparedStatement prep = conn.prepareStatement("insert into " + tablename + "( id, text) values (?, ?);");

prep.setString(1, "1FD22A38");

prep.setString(2, "This is a simple test");

prep.addBatch();

conn.setAutoCommit(false);

prep.executeBatch();

conn.setAutoCommit(true);

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

public static void createDB(String dbFilename, String tablename){

try {

Class.forName("org.sqlite.JDBC");

Connection conn = DriverManager.getConnection("jdbc:sqlite:" + dbFilename);

Statement stat = conn.createStatement();

stat.executeUpdate("drop table if exists test;");

stat.executeUpdate("create table " + tablename + " (key INTEGER PRIMARY KEY, id TEXT , text TEXT);");

conn.close();

stat.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

String dbFilename = "test.db";

String tablename = "test";

PlaygroundSQLite.createDB(dbFilename, tablename);

PlaygroundSQLite.insertIntoDB(dbFilename, tablename);

}

}