1 import java.sql.*;
2 public class JoltReport {
3 public static void main (String args[]) {
4 String URL = “jdbc:odbc:CafeJolt”;
5 String username = ””;
6 String password = ””;
7 try {
8 Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
9 } catch (Exception e) {
10 System.out.println(“Error”);
11 return;
12 }
13 Statement stmt = null;
14 Connection con=null;
15 try {
16 con = DriverManager.getConnection (
17 URL, username, password);
18 stmt = con.createStatement();
19 } catch (Exception e) {System.err.println(“problems 20 connecting to”+URL);
21 }
22 try {
23 ResultSet result = stmt.executeQuery(
24 “SELECT programmer, cups FROM JoltData ORDER BY cups 25 DESC;”);
26 result.next();
27 String name = result.getString(“programmer”);
28 int cups = result.getInt(“cups”);
29 System.out.println(“Programmer”+name+
30 “consumed the most coffee:”+cups+” cups.”);
31 result = stmt.executeQuery(
32 “SELECT cups FROM JoltData;”);
33 cups = 0;
34 while(result.next()) {
35 cups += result.getInt(“cups”);
36 }
37 System.out.println(“Resultado total”+cups);
38 con.close();
39 }
40 catch (Exception e) {
41 e.printStackTrace();
42 }
43 }
44 }
2 public class JoltReport {
3 public static void main (String args[]) {
4 String URL = “jdbc:odbc:CafeJolt”;
5 String username = ””;
6 String password = ””;
7 try {
8 Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
9 } catch (Exception e) {
10 System.out.println(“Error”);
11 return;
12 }
13 Statement stmt = null;
14 Connection con=null;
15 try {
16 con = DriverManager.getConnection (
17 URL, username, password);
18 stmt = con.createStatement();
19 } catch (Exception e) {System.err.println(“problems 20 connecting to”+URL);
21 }
22 try {
23 ResultSet result = stmt.executeQuery(
24 “SELECT programmer, cups FROM JoltData ORDER BY cups 25 DESC;”);
26 result.next();
27 String name = result.getString(“programmer”);
28 int cups = result.getInt(“cups”);
29 System.out.println(“Programmer”+name+
30 “consumed the most coffee:”+cups+” cups.”);
31 result = stmt.executeQuery(
32 “SELECT cups FROM JoltData;”);
33 cups = 0;
34 while(result.next()) {
35 cups += result.getInt(“cups”);
36 }
37 System.out.println(“Resultado total”+cups);
38 con.close();
39 }
40 catch (Exception e) {
41 e.printStackTrace();
42 }
43 }
44 }
Internet< www.java.sun>.
Considerando o trecho de código apresentado acima, julgue o próximo item.
As linhas de 7 a 12 permitem carregar o driver que informa às classes JDBC como se comunicar com a fonte de dados. No código, é usada a classe JdbcOdbcDriver e a linha 10 informa a ocorrência de erro no carregamento do driver JDBC/ODBC.
