一个简单的数据库调用不成功？

Question

<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:testDB";
Connection con=DriverManager.getConnection(url,"","");
Statement statement=con.createStatement();
String query="select * from testTable";
ResultSet result=statement.executeQuery(query);
while(result.next())
         {
  out.println(result.getString(1));
}
      }
catch(Exception ex)
        {
System.out.println(ex);
}
        
%>

Answer 1

按照java code conventions写：
try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url = "jdbc:odbc:testDB";
    Connection con = DriverManager.getConnection(url, "", "");
    Statement statement = con.createStatement();
    String query = "select * from testTable";
    ResultSet result = statement.executeQuery(query);
    while (result.next()) {
        out.println(result.getString(1));
    }
} catch (Exception ex) {
    System.out.println(ex);
}

Answer 2

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:testDB";
Connection con=DriverManager.getConnection(url,"","");
Statement statement=con.createStatement();
String query="select * from testTable";
ResultSet result=statement.executeQuery(query);
while(result.next()){
out.println(result.getString(1));
}}catch(Exception ex){                         //此行好似少了一个'}'
System.out.println(ex);
}
        }

Answer 3

    对啊，在catch前面确实少了一个}，
    而System.out.println(ex);后又多了一个}

Answer 4

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:testDB";
Connection con=DriverManager.getConnection(url,"","");
Statement statement=con.createStatement();
String query="select * from testTable";
ResultSet result=statement.executeQuery(query);
while(result.next()){
out.println(result.getString(1));
}}catch(Exception ex){         
System.out.println(ex);
}
        }细心一点，先找出笔误，还有{}是不是成对~~~