java sqlite封装类_使用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 输出结果