Hi,Could someone help write a regex parsing sql str for me:)

[jimmy]

the sql :$B!!!!(Bselect * from (select * from tbl) a where c1 = 1 order
by c2 desc, c3 asc

I want to parse the 'order by' clause to get the column-order pair,
the result would be looks like:


['c2','c3'] ['desc','asc']


Greatly appreciated!

 

[hiwa]

the sql :$B!!!!(Bselect * from (select * from tbl) a where c1 = 1 order
by c2 desc, c3 asc

I want to parse the 'order by' clause to get the column-order pair,
the result would be looks like:

['c2','c3'] ['desc','asc']

Greatly appreciated!

public class Jimmy{
public static void main(String[] args){
String qry = "select * from (select * from tbl) a where c1 = 1
order by c2 desc, c3 asc ";
String lead = "^.+order\\s+by\\s+";
String pairs = qry.replaceAll(lead, "");
pairs = pairs.trim();
String[] elements = pairs.split(",?\\s+");

String c;
String o;
c = o = "['";
for (int i = 0; i < (elements.length - 1); i += 2){
c += elements + "','";
o += elements[i + 1] + "','";
}
int ic = c.lastIndexOf(",'");
int io = o.lastIndexOf(",'");
c = c.substring(0, ic) + "]"; // trim the last ",'" and add a ']'
o = o.substring(0, io) + "]";

System.out.println(c + " " + o);
}
}