Connecting to Databases :Example

try { // Submit query

stmt = con.createStatement();

result = stmt.executeQuery ( "SELECT programmer, cups " + "FROM JoltData ORDER BY cups DESC;");

// Create output

PrintWriter out = response.getWriter();

while(result.next()) {

// Generate output from ResultSet

} finally

{ if (result != null) {

result.close();

}

if (stmt != null) {

stmt.close(); }

}

out.flush(); out.close();

}