sqlite java_在Windows环境，用Java读写SQLite数据库文件（.db文件）

import java.sql.*;

import org.sqlite.JDBC;

/**

* Very Basic SQLite Database Example

* @author Brandon Tanner

*/

public class dbReader {

public static void main(String[] args) {

try {

// The SQLite (3.3.8) Database File

// This database has one table (pmp_countries) with 3 columns (country_id, country_code, country_name)

// It has like 237 records of all the countries I could think of.

String fileName = "D:/projectDocument/knowledge/knowledge.db";

// Driver to Use

// http://www.zentus.com/sqlitejdbc/index.html

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

// Create Connection Object to SQLite Database

// If you want to only create a database in memory, exclude the +fileName

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

// Create a Statement object for the database connection, dunno what this stuff does though.

Statement stmt = conn.createStatement();

// Create a result set object for the statement

ResultSet rs = stmt.executeQuery("select  * from MY_17_75  WHERE language='CHI' and type='street_suffix_type'");

// Iterate the result set, printing each column

// if the column was an int, we could do rs.getInt(column name here) as well, etc.

while (rs.next()) {

String id   = rs.getString("country_id");   // Column 1

String code = rs.getString("country_code"); // Column 2

String name = rs.getString("country_name"); // Column 3

System.out.println("ID: "+id+" Code: "+code+" Name: "+name);

}

// Close the connection

conn.close();

}

catch (Exception e) {

// Print some generic debug info

System.out.println(e.getMessage());

System.out.println(e.toString());

}

}

}