使用JDBC执行SQL并以ArrayList返回大写字段结果

 /**
     * 获取其他数据库连接
     * @param address 数据库ip地址
     * @param port 数据库端口号
     * @param dbName 数据库名
     * @param userName 用户名
     * @param passWord 密码
     * @param dbType 数据库类型 1：oracle ，2：mysql ，3：sql2000
     * @return 数据库连接
     * @throws java.lang.Exception
     */
    public Connection getHosSqlCon(String address,String port,String dbName,String userName,String passWord,int dbType) throws Exception {
        Connection con = null;
        String driver = "";
        String url = "";
        try{
            switch(dbType){
                case 1:
                    driver="oracle.jdbc.driver.OracleDriver";
                    url="jdbc:oracle:thin:@"+address+":"+port+":"+dbName;
                    break;
                case 2:
                    driver="org.gjt.mm.mysql.Driver";
                    url="jdbc:mysql://"+address+":"+port+"/"+dbName;
                    break;
                case 3:
                    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
                    url="jdbc:microsoft:sqlserver://"+address+":"+port+";DatabaseName="+dbName;
                    break;
            }