try-with-resource手动rollback

在用try-with-resource管理链接资源时，catch块中无法访问到connection，也就无法手动回滚

try (Connection con = createConnection()){ con.setAutoCommit(false); Statement stm = con.createStatement(); stm.execute(someQuery); // causes SQLException }catch(SQLException ex){ // 注意这里实际上无法访问到con con.rollback(); // do other stuff }

解决方案

try (Connection con = createConnection()){ con.setAutoCommit(false); try (Statement stm = con.createStatement()) { stm.execute(someQuery); // causes SQLException }catch(SQLException ex){ con.rollback(); con.setAutoCommit(true); throw ex; } con.commit(); con.setAutoCommit(true); }

即将try-with-resource仅仅用作管理资源的，再设置一个try-catch来做catch。