java – JDBC之间的差异JDBC

final Connection connection = ds.getConnection();
try {
    final Statement statement = connection.createStatement();
    try {
        final ResultSet resultSet = statement.executeQuery("SELECT COUNT(*) FROM Orders");
        try {
            resultSet.next();
            final int c = resultSet.getInt(1);
        } finally {
            resultSet.close();
        }
    } finally {
        statement.close();
    }
} finally {
    connection.close();
}

尝试使用资源的时候好多了：

try (
        Connection connection = ds.getConnection();
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("SELECT COUNT(*) FROM Orders");
) {
    resultSet.next();
    final int c = resultSet.getInt(1);
}

当然可以提取常用代码,并使用模板方法设计模式.有效地你会重新创建JdbcTemplate：

final int c = new JdbcTemplate(ds).queryForInt("SELECT COUNT(*) FROM Orders");

Spring JDBC还提供异常转换(不再检查sqlException和数据库/方言之间的区别)和简单的ORM功能.