Cacher is the code snippet organizer for pro developers

// ドライバクラスのロード  
Class.forName("oracle.jdbc.OracleDriver");  
  
// DBとの接続  
String url = "jdbc:oracle:thin:@dbhost:1521:sid";  
String user = "dbuser";  
String password = "dbpassword";  
Connection conn = DriverManager.getConnection(url, user, password);  
  
String sql = "select ID, NAME from SHAIN";  
Statement stmt = null;  
ResultSet rset = null;  
  
try {  
    // SQL発行  
    stmt = conn.createStatement();  
    rset = stmt.executeQuery(sql);  
  
    // 結果の取得  
    while (rset.next()) {  
        String shainId = rset.getString("ID");  
        String shainName = rset.getString("NAME");  
    }  
} finally {  
    // 各種オブジェクトを閉じる  
    try { rset.close(); } catch(Exception e) {}  
    try { stmt.close(); } catch(Exception e) {}  
    try { conn.close(); } catch(Exception e) {}  
}