在Java下连接SQLite数据库
一、下载SQLite数据库的JDBC：http://www.99jianzhu.com/sqlitejdbc/
二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下，并且将其添加到ClassPath系统环境变量中。一定要保证在类路径ClassPath中有该jar包，并且保证在JAVA库路径JAVA Library Path中有本地库Native Library（\workspace\"Web应用"\WebRoot\WEB-INF\lib\下最好也要加入该jar包）。"SQLite.JDBCDriver"作为JDBC的驱动程序类名。连接JDBC的URL格式为jdbc:sqlite:/path。这里的path为指定到SQLite数据库文件的路径，例如：
jdbc:sqlite://dirA/dirB/dbfile
jdbc:sqlite://DRIVE:/dirA/dirB/dbfile
jdbc:sqlite://COMPUTERNAME/shareA/dirB/dbfile
三、下面是使用SQLite的两段代码以供参考：
代码段1：
1 import java.sql.*;
2 import org.sqlite.JDBC;
3
4 public class SQLiteTest {
5 public static void main(String[] args) {
6try {
7// The SQLite (3.3.8) Database File
8// This database has one table (pmp_countries) with 3 columns (country_id, country_code, country_name)
9// It has like 237 records of all the countries I could think of.
10String fileName = "c:/pmp.db";
11// Driver to Use
12// http://www.99jianzhu.com/sqlitejdbc/index.html
13Class.forName("org.sqlite.JDBC");
14// Create Connection Object to SQLite Database
15// If you want to only create a database in memory, exclude the +fileName
16Connection conn = DriverManager.getConnection("jdbc:sqlite:"+fileName);
17// Create a Statement object for the database connection, dunno what this stuff does though.
18Statement stmt = conn.createStatement();
19// Create a result set object for the statement
20ResultSet rs = stmt.executeQuery("SELECT * FROM pmp_countries ORDER BY country_name ASC");
21// Iterate the result set, printing each column
22// if the column was an int, we could do rs.getInt(column name here) as well, etc. 23while (rs.next()) {
24 String id = rs.getString("country_id"); // Column 1
25 String code = rs.getString("country_code"); // Column 2
26 String name = rs.getString("country_name"); // Column 3
27 System.out.println("ID: "+id+" Code: "+code+" Name: "+name); 28
29 }
30 // Close the connection
31 conn.close();
32 }
33 catch (Exception e) {
34 // Print some generic debug info
35 System.out.println(e.getMessage());
36 System.out.println(e.toString());
37 }
38 }
39 }
www.99jianzhu.com/包含内容：建筑图纸、PDF/word/ppt 流程，表格，案例，最新,免费下载,施工方案、工程书籍、建筑论文、合同表格、标准规范、CAD图纸等内容。