使用java类测试sqlite的方法

1 需要把jar包导入sqlitejdbc.jar 到lib包中【注意sqlite是不用设置帐号密码的】

2 把sqlitejdbc.dll放到system32下面，不知道为什么，估计是因为他是c写的，不然会报错误

java.lang.UnsatisfiedLinkError: no sqlitejdbc in java.library.path

3 写测试类

package com.nr.cache.sqlite;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class SQLiteTest {
	public static void main(String[] args) throws Exception {
		//System.oout.println( System.getProperty("java.library.path"));
		
	    Class.forName("org.sqlite.JDBC");
	    Connection conn = DriverManager.getConnection("jdbc:sqlite:portal2.db");
	    Statement stat = conn.createStatement();
//	    stat.executeUpdate("drop table if exists people;");
//	    stat.executeUpdate("create table people (name, occupation);");
	    PreparedStatement prep = conn.prepareStatement(
	      "insert into people values (?, ?);");

	    prep.setString(1, "Gandhi");
	    prep.setString(2, "politics");
	    prep.execute();
//	    prep.addBatch();
//	    prep.setString(1, "Turing");
//	    prep.setString(2, "computers");
//	    prep.addBatch();
//	    prep.setString(1, "Wittgenstein");
//	    prep.setString(2, "smartypants");
//	    prep.addBatch();
//
//	    conn.setAutoCommit(false);
//	    prep.executeBatch();
//	    conn.setAutoCommit(true);

	    ResultSet rs = stat.executeQuery("select * from people;");
	    while (rs.next()) {
	      System.out.println("name = " + rs.getString("name"));
	      System.out.println("job = " + rs.getString("occupation"));
	    }
	    rs.close();
	    conn.close();
	}
}

4 输出结果