SQLLite資料庫簡單案例源碼

package com.macower.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; public class SQLLiteTest { public static void main(String[] args) throws Exception {       Class.forName("org.sqlite.JDBC");       Connection conn = DriverManager.getConnection("jdbc:sqlite:test.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.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;");           int i  = 0;       while (rs.next()) {           System.out.print("name = " + rs.getString("name"));           System.out.println(",job = " + rs.getString("occupation"));                  i++;       }       System.out.println("count="+i);       rs.close();       conn.close();   }

}