写一个函数获取SQL语句的查询部分

String sql = "select sname,sage,student.sno from student,sc where student.sno=sc.sno  and student.sno in( select sno from sc group by sc.sno having count(*)>=3)";
        //从第六个字符select后面的空格开始
        int start = 6;
        int end = 0;
        for (int i = 0; i < sql.length(); i++) {
            String tempStr = "";
            for (int j = i; j < i+4; j++) {
                tempStr+=String.valueOf(sql.charAt(j));
            }
            if(tempStr.equals("from")){
                end = i;
                break;
            }
        }
        String answer = "";
        String select = sql.substring(start,end).trim();
        if(select.contains(",")){
            String[] split = select.split(",");
            for (int i = 0; i < split.length; i++) {
                split[i] = split[i].trim();
                if((split[i].contains(" ")&&split[i].contains("'"))||(split[i].contains(" ")&&split[i].contains("'")&&split[i].contains("as"))||(split[i].contains(" ")&&split[i].contains("'")&&split[i].contains("AS"))){

                    int tempStart = 0;
                    int tempEnd = split[i].lastIndexOf("'");
                    for (int j = 0; j < split[i].length(); j++) {
                        if(String.valueOf(split[i].charAt(j)).equals("'")){
                            tempStart = j+1;
                            break;
                        }
                    }
                    split[i] = split[i].substring(tempStart,tempEnd);
                }
                if(split[i].contains(".")){
                    String[] tempSplit = split[i].split("\\.");
                    split[i] = tempSplit[1];
                }
            }
            for (int i = 0; i < split.length; i++) {
                answer+=split[i];
                if(i!=split.length-1){
                    answer+=",";
                }
            }
            System.out.println(answer);
        }else{
            System.out.println(select);
        }