jar：sqlite-jdbc-3.7.2.jar
字典：汉字解释
package com.lago;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SqliteDB {
private static final String Class_Name = “org.sqlite.JDBC”;
private static final String DB_URL = “jdbc:sqlite:D:\py2\WhatIsYourName-main\data\zidian.db3”;
public static void main(String args[]) {
// load the sqlite-JDBC driver using the current class loader
Connection connection = null;
try {
connection = createConnection();
func1(connection);
System.out.println(“Success!”);
} catch (SQLException e) {
System.err.println(e.getMessage());
} catch(Exception e) {
e.printStackTrace();
} finally{
try {
if (connection != null)
connection.close();
} catch (SQLException e) {
// connection close failed.
System.err.println(e);
}
}
}
// 创建Sqlite数据库连接
public static Connection createConnection() throws SQLException, ClassNotFoundException {
Class.forName(Class_Name);
System.out.println(Class_Name);
return DriverManager.getConnection(DB_URL);
}
public static void func1(Connection connection) throws SQLException {
Statement statement = connection.createStatement();
statement.setQueryTimeout(30); // set timeout to 30 sec.
// 执行查询语句
ResultSet rs = statement.executeQuery(“select * from WordDictionary”);
int num =0;
while (rs.next()) {
String col1 = rs.getString(“Word”);
String col2 = rs.getString(“PinYin_1”);
String col3 = rs.getString(“Bushou”);
String col4 = rs.getString(“Wubi”);
String col5 = rs.getString(“bihua”);
String col6 = rs.getString(“Remark”);
String col7 = rs.getString(“content”);
System.out.println(“col1 = ” + col1 + ” col2 = ” + col2 +”====”+col3+”====”+col4+”====”+col5+”====”+col6+”====”+col7);
num++;
}
System.out.println(num);
}
}
Original: https://blog.csdn.net/lb521200200/article/details/123711673
Author: 梦无痕123
Title: java 读取sqlite3
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/815486/
转载文章受原作者版权保护。转载请注明原作者出处！