public class SQLParserTest extends TestCase {
public void test_select() throws Exception {
String sql = " SELECT COUNT(*) FROM close_plan WHERE 1=1 AND close_type = ? AND target_type = ? AND target_id = ? AND( mi_name=? ) AND end_time >= ? ";
SQLSelectParser parser = new MySqlSelectParser(sql);
SQLSelect select = parser.select();
StringBuilder out = new StringBuilder();
MySql2OracleOutputVisitor visitor = new MySql2OracleOutputVisitor(out);
select.accept(visitor);