java 连接 sqlite,如何将SQLite与Java连接？

I am using one simple code to access the SQLite database from Java application .

My code is

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class ConnectSQLite

{

public static void main(String[] args)

{

Connection connection = null;

ResultSet resultSet = null;

Statement statement = null;

try

{

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

connection = DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");

statement = connection.createStatement();

resultSet = statement

.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");

while (resultSet.next())

{

System.out.println("EMPLOYEE NAME:"

+ resultSet.getString("EMPNAME"));

}

}

catch (Exception e)

{

e.printStackTrace();

}

finally

{

try

{

resultSet.close();

statement.close();

connection.close();

}

catch (Exception e)

{

e.printStackTrace();

}

}

}

}

But this code gives one exception like

java.lang.ClassNotFoundException: org.sqlite.JDBC

How can I slove this,please help me.

解决方案

You need to have a SQLite JDBC driver in your classpath.

Taro L. Saito (xerial) forked the Zentus project and now maintains it under the name sqlite-jdbc. It bundles the native drivers for major platforms so you don't need to configure them separately.