在Java下连接SQLite数据库

一、下载SQLite数据库的JDBC：http://www.zentus.com/sqlitejdbc/ 二、将下载到的包解压后得到jar包放到%JAVA_HOME%\\lib下，并且将其添加到ClassPath系统环境变量中。一定要保证在类路径ClassPath中有该jar包，并且保证在JAVA库路径JAVA Library Path中有本地库Native Library（\\workspace\\\应用\下最好也要加入该jar包）。\作为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) { 6 try {

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. 10 String fileName = \11 // Driver to Use

12 // http://www.zentus.com/sqlitejdbc/index.html 13 Class.forName(\

14 // Create Connection Object to SQLite Database

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

16 Connection conn = DriverManager.getConnection(\eName);

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

18 Statement stmt = conn.createStatement(); 19 // Create a result set object for the statement

20 ResultSet rs = stmt.executeQuery(\

s 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.

23 while (rs.next()) {

24 String id = rs.getString(\// Column 1 25 String code = rs.getString(\// Column 2 26 String name = rs.getString(\// Column 3 27 System.out.println(\e); 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 }

本文来源：https://www.bwwdw.com/article/5gio.html