SQLParserTest.java

package com.alipay.zdal.test.ut.sqlparser.mysql;

import com.alipay.zdal.parser.sql.ast.statement.SQLSelect;
import com.alipay.zdal.parser.sql.dialect.mysql.parser.MySqlSelectParser;
import com.alipay.zdal.parser.sql.dialect.mysql.visitor.MySql2OracleOutputVisitor;
import com.alipay.zdal.parser.sql.parser.SQLSelectParser;

import junit.framework.TestCase;

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);

        System.out.println(out);
    }


}