1.去网站http://files.zentus.com/sqlitejdbc/下载sqlitejdbc.根据自已需要,下载linux或Win或Mac版的JDBC
2.
下载后将解压的sqlitejdbc.jar放到/home/jdk/jre/lib/ext(这是我的安装jdk目录,根据自已jdk安装目录修改地
址)下。若是Window下的,除了放sqlitejdbc.jar外还要将解压的sqlite.dll放到X:/jdk/bin下。若是Mac的要将
libsqlitejdbc.jnilib 放到哪呢?应该也是jdk/bin下吧。Mac没用过。
3.如果你只是随便的将sqlitejdbc.jar放在任一目录,并且你又是run in pure-java mode(纯java模式下运行?是这么译吗)请参考http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
4.如果你已看了第三步的网站,以下可以不用看了,下面的介绍只是复述3里面的而已。
5.转自http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC 的实例经验证可以运行。 import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; publicclass Sample
{ publicstaticvoid main(String[] args) throws ClassNotFoundException
{ // load the sqlite-JDBC driver using the current class loader Class.forName("org.sqlite.JDBC");
Connection connection = null; try
{ // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:sample.db");
Statement statement = connection.createStatement();
statement.setQueryTimeout(30); // set timeout to 30 sec.
statement.executeUpdate("drop table if exists person");
statement.executeUpdate("create table person (id integer, name string)");
statement.executeUpdate("insert into person values(1, 'leo')");
statement.executeUpdate("insert into person values(2, 'yui')");
ResultSet rs = statement.executeQuery("select * from person"); while(rs.next())
{ // read the result set System.out.println("name = " + rs.getString("name"));
System.out.println("id = " + rs.getInt("id"));
}
} catch(SQLException e)
{ // if the error message is "out of memory", // it probably means no database file is found System.err.println(e.getMessage());
} finally
{ try
{ if(connection != null)
connection.close();
} catch(SQLException e)
{ // connection close failed. System.err.println(e);
}
}
}
}6.sqlite中国网站http://www.sqlite.com.cn/,不过这网站不爽,动不动就要求你登陆(如果你没登陆的话)。