jdbc连接SQLite操作

项目导入sqlite-jdbc-3.7.2.jar

地址：http://pan.baidu.com/s/1kVHAGdD

 

示例：

package test;

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

public class OpSqliteDBTest {
    
    private static final String Class_Name = "org.sqlite.JDBC";
    private static final String DB_URL = "jdbc:sqlite:E:\\workspace\\eclipse\\hello\\SQLiteTest\\src\\lib\\testdatabase.db";

    public static void main(String args[]) {
        Connection connection = null;
        try {
            connection = createConnection();
            func1(connection);
            System.out.println("Success!");
        }  catch (SQLException e) {
            System.err.println(e.getMessage());
        } catch(Exception e) {
            e.printStackTrace