Java基础 — JDBC

Java基础 — JDBC

首先得下载个驱动：
https://bitbucket.org/xerial/sqlite-jdbc/downloads/sqlite-jdbc-3.8.11.2.jar
保存到本地：比如/Users/robert/software/sqlite-jdbc-3.8.11.2.jar
具体API翻文档。直接上例子。

public class TestDb {
    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        try {
            Class.forName("org.sqlite.JDBC");  // 注册driver
            connection = DriverManager.getConnection("jdbc:sqlite:test.db");
//            System.out.println("maxConn: " + connection.getMetaData().getMaxConnections());

            doInsert(connection);
            doQuery(connection);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (connection != null) {
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    public static void doInsert(Connection connection) throws SQLException {
        Statement statement = connection.createStatement();
        try {
            String sqlString = "CREATE TABLE db2 (age INT PRIMARY KEY)";
            statement.executeUpdate(sqlString);
            statement.executeUpdate("INSERT INTO db2 VALUES (3), (4), (10)");
            connection.setAutoCommit(true);
            statement.close();
        } finally {
            statement.close();
        }
    }

    public static void doQuery(Connection connection) throws SQLException {
        Statement statement = connection.createStatement();
        try {
            String queryString = "SELECT * FROM db2";

            ResultSet resultSet = statement.executeQuery(queryString);
            while (resultSet.next()) {
                int age = resultSet.getInt(1);
                System.out.println("" + age);
            }
        } finally {
            statement.close();
        }
    }
}

编译：javac TestDb.java
运行：java -cp ".:/Users/robert/software/sqlite-jdbc-3.8.11.2.jar" TestDb