[Java] JDBC連接資料庫 (五)

執行SQL Query和處理SQL執行結果
ResultSet rset = null;
try {
/**
* Enter SQL Query
*/
  rset = stmt.executeQuery("select deptid, deptname from dept");

/**
* Process SQL Query and print out
*/
while(rset.next()) {
  int deptid = rset.getInt("deptid");
  String deptname = rset.getString(2);
  System.out.println(deptid +", "+deptname);
}

} catch (SQLException e1) {
  e1.printStackTrace();
}