首先下载Sqlite JDBC驱动程序
网站
https://bitbucket.org/xerial/sqlite-jdbc/downloads/
添加到java 工程lib 库里
package SqliteJDBC;
import java.sql.*;
public class SqliteJDBC {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection c = null;
try {
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:test.db");
Statement stmt = null;
c.setAutoCommit(false);
stmt = c.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM mytable;" );
while ( rs.next() ) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println( "ID = " + id );
System.out.println( "NAME