JDBC连接数据库和连接池

public static void main(String[] args) throws Exception {
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8";
    Connection connection = DriverManager.getConnection(url, "root", "123456");
    String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
    PreparedStatement psInsert = connection.prepareStatement(sqlInsert);
    psInsert.setString(1,"小明");
    psInsert.setString(2,"123456");
    psInsert.executeUpdate();

    String sqlSelect = "select * from tbl_user";
    PreparedStatement psSelect = connection.prepareStatement(sqlSelect);
    ResultSet resultSet = psSelect.executeQuery();
    while (resultSet.next()) {
        System.out.println(resultSet.getString(2)+"-"+resultSet.getString(3));
    }
    resultSet.close();
    psInsert.close();psSelect.close();
    connection.close();
}

PrepareStatement批处理

public static void main(String[] args) throws Exception {
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true";
    Connection connection = DriverManager.getConnection(url, "root", "123456");
    String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
    PreparedStatement psInsert = connection.prepareStatement(sqlInsert);
    for (int i = 0; i < 10; i++) {
        psInsert.setString(1,"小明"+i);
        psInsert.setString(2,"123456");
        psInsert.addBatch();
    }
    psInsert.executeBatch();
    psInsert.close();
    connection.close();
}

JDBC事务

public static void main(String[ ] args) throws Exception {
    Connection connection = null;PreparedStatement psInsert =null;PreparedStatement psSelect = null;ResultSet resultSet = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8";
        connection = DriverManager.getConnection(url, "root", "123456");
        connection.setAutoCommit(false);
        String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
        psInsert = connection.prepareStatement(sqlInsert);
        psInsert.setString(1,"小明");
        psInsert.setString(2,"123456");
        psInsert.executeUpdate();

        String sqlSelect = "select * from tbl_user";
        psSelect = connection.prepareStatement(sqlSelect);
        resultSet = psSelect.executeQuery();
        while (resultSet.next()) {
            System.out.println(resultSet.getString(2)+"-"+resultSet.getString(3));
        }
        connection.commit();
    } catch (Exception e) {
        connection.rollback();
    } finally {
        if (resultSet != null) resultSet.close();
        if (psInsert != null) psInsert.close();
        if (psSelect != null) psSelect.close();
        if (connection != null) connection.close();
    }
}