「Java」try-with-resources文のjava.sql.Statementオブジェクトの使い方

2020年7月31日

書式
try　(Statement stmt = conn.createStatement();
ResultSet rslt = stmt.executeQuery(query);) {
//処理コード
}

Javaコード

public static void getEmpInfo(Connection con) throws SQLException {

  String query = "SELECT USER_NAME, USER_ID, SALARY, AGE FROM EMP_TBL";

  try (Statement stmt = conn.createStatement();
          ResultSet rslt = stmt.executeQuery(query);) {
    while (rslt.next()) {
      String coffeeName = rs.getString("USER_NAME");
      int userID = rs.getInt("USER_ID");
      float salary= rs.getFloat("SALARY");
      int age = rs.getInt("AGE");
      int total = rs.getInt("TOTAL");
      System.out.println(coffeeName + ", " + userID + ", " + salary +
                         ", " + age );
    }
  } catch (Exception e) {
    throw new SQLException("error",e);
  }
}