Java - Ibatis - 基于角色的动态查询的mySQL

I'm using Java - Ibatis and mySQL with Flex/Flash on the front-end. I have one requirement that is to be able to dynamically add creterias and table to a query depending on the user role. here is an exampleI'm using Java - Ibatis and mySQL with Flex/Fla