轻量级的文件式数据库SQLite的安装与使用

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

public class TestSQLiteJDBC {

    public static void main(String args[]) {
        Connection c = null;
        try {
            Class.forName("SQLite.JDBCDriver");
            c = DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/mydb.db", "", "");
            c.setAutoCommit(false);

            Statement st = c.createStatement();
            st.executeUpdate("INSERT INTO user(id,name) VALUES(1,'Hello SQLite')");
            
            ResultSet rs = st.executeQuery("SELECT * FROM user");
            while (rs.next()) {
                int id = rs.getInt(1);
                String name = rs.getString(2);
                System.out.println("id=" + id + ", name=" + name);
            }
            rs.close();
            st.close(); 

            c.commit();
            c.close();
        } catch (Exception e) {
            e.printStackTrace();
            System.exit(1);
            try {
                if (c != null && !c.isClosed()) {
                    c.rollback();
                    c.close();
                }
            } catch (SQLException sql) {
                // do nothing
            }
        }
    }

}