executeQuery() 和 select

package com.wangguan;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class Test2Jdbc {
    public static void main(String[] args) {
        Connection con = null;
        Statement  sta = null;
        ResultSet     rs = null;
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String url = "jdbc:sqlserver://127.0.1:1433;databaseName=studentManager";
            con = DriverManager.getConnection(url, "sa", "wangguan");
            sta = con.createStatement();
            String sql = "select " +
                        "    stuId, stuName, address, stuTel, age " +
                        "from " +
                        "    student";
            rs = sta.executeQuery(sql);
            while (rs.next()) {
                int i = 1;
                int stuId = rs.getInt(i ++);
                String stuName = rs.getString(i ++);
                String address = rs.getString(i ++);
                String stuTel = rs.getString(i ++);
                int age = rs.getInt(i ++);
                System.out.println(stuId + " " +stuName + " " + address + " " + stuTel + " " +age);
            }
            
            rs.close();
            sta.close();
            con.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if(rs != null) {
                    rs.close();
                    rs = null;
                }
                if(sta != null) {
                    sta.close();
                    sta = null;
                }
                if(con != null) {
                    con.close();
                    con = null;
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}