How to connect SQLite with Java?

Question

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.

Answer 1

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.