利用javacc解析SQL

最新推荐文章于 2024-10-11 21:54:56 发布
最新推荐文章于 2024-10-11 21:54:56 发布
阅读量4.4k 收藏 3
点赞数
CC 4.0 BY-SA版权
文章标签： token stream underscore constructor query insert
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/xuanmu2011/article/details/7185318
本文介绍了如何利用javacc工具来解析SQL语句，通过创建JJT文件SQLParser.jjt来定义语法规则，实现对SQL查询和插入等操作的解析。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

首先编写.jjt文件SQLParser.jjt：

PARSER_BEGIN(SQLParser)
public class SQLParser{
  public static void main(String args[]) {
    System.out.println("Reading from standard input...");
    SQLParser p = new SQLParser(System.in);
    try {
      SimpleNode n = p.Start();
      n.dump("");
      System.out.println("Thank you.");
    } catch (Exception e) {
      System.out.println("Oops.");
      System.out.println(e.getMessage());
      e.printStackTrace();
    }
  }
}
PARSER_END(SQLParser)
/*定义词法分析*/
SKIP:{" "}
SKIP:{"\n"|"\r"|"\r\n"}
TOKEN:/*定义关键字*/
{
 <CREATE:"create">
 | <TABLE:"table">
 | <DROP:"drop">
 | <SELECT:"select">
 | <INSERT:"insert">
 | <WHERE:"where">
 | <FROM:"from">
 | <INTO:"into">
 | <DISTINCT:"distinct">
 | <LIKE:"like">
 | <ORDER:"order">
 | <BY:"by">
 | <VALUES:"values">
 | <AND:"and">
 | <IN:"in">
 | <INT:"int">
 | <CHAR:"char">
 | <DATE:"date">
 | <DELETE:"delete">
}
TOKEN:/*定义符号*/
{
 <UNDERSCORE:"_">
 | <COMMA:",">
 | <SEMICOLON:";">
 | <COLON:":">
 | <LEFTPARENTHESES:"(">
 | <RIGHTPARENTHESES:")">
 | <EQUAL:"=">
 | <PLUS:"+">
 | <MINUS:"-">
 | <TIMES:"*">
 | <DIVIDE:"/">
 | <LEFTQUOTATION:"\""> 
 | <LQUOTATION:"'">
}
TOKEN:/* 定义整数 */
{
 <INTEGER_LITERAL:["1"-"9"](<DIGIT>)*>
}
TOKEN:/*定义数字*/
{
 <#DIGIT:["0"-"9"]>
}
TOKEN:/* 定义标识符 */
{
 <IDENTIFIER:<LETTER>
 |<LETTER><DIGIT>
 | <LETTER>(<LETTER>
 | <DIGIT>
 | <UNDERSCORE>)*(<LETTER>
 | <DIGIT>)+>
 | <#LETTER:["a"-"z", "A"-"Z"]>
}
/* 语法解析*/
SimpleNode Start() : {}
{
  Expression() ";"
  { return jjtThis; }
}
void Expression() : {}
{
  Query()|CreT()|DropT()|DelT()|InsT()
}
void Query():{}
{
SFW()[<ORDER><BY>Attribute()]
}
void SFW():{}
{
<SELECT>[<DISTINCT>]SelList()<FROM>FromList()<WHERE>Condition()
}
void SelList():{}
{
Attribute()[(<COMMA>Attribute())+]
}
void FromList():{}
{
Relation()[(<COMMA>Relation())+]
}
void Condition():{}
{
/*[Condition()<AND>Condition()]|*/
/*[Tuple()<IN>Query()]*/
[Attribute()<EQUAL>Attribute()]
|[Attribute()<LIKE>Pattern()]
|[Attribute()<EQUAL>IDENTIFIER()]
}
void Tuple():{}
{
Attribute()
}
/*-------------------*/
void CreT():{}
{
<CREATE><TABLE>Relation()<LEFTPARENTHESES>ColList()<RIGHTPARENTHESES>
}
void ColList():{}
{
Attribute()Type()[(<COMMA>Attribute()Type())+]
}
void Type():{}
{
<INT>|<DATE>|<CHAR><LEFTPARENTHESES><INTEGER_LITERAL><RIGHTPARENTHESES>
}
/*-------------------*/
void DropT():{}
{
<DROP><TABLE>Relation()
}
void DelT():{}
{
<DELETE>DelList()<FROM>FromList()<WHERE>Condition()
}
void DelList():{}
{
Attribute()[(<COMMA>Attribute())+]
}
/*-------------------*/
void InsT():{}
{
<INSERT><INTO>Relation()<LEFTPARENTHESES>InList()<RIGHTPARENTHESES><VALUES><LEFTPARENTHESES>VList()<RIGHTPARENTHESES>
}
void InList():{}
{
Attribute()[(<COMMA>Attribute())+]
}
void VList():{}
{
<LEFTQUOTATION>IDENTIFIER()<LEFTQUOTATION>[(<COMMA><LEFTQUOTATION>IDENTIFIER()<LEFTQUOTATION>)+]
}
/*-------------------*/
void Attribute():{}
{
IDENTIFIER()
}
void Relation():{}
{
IDENTIFIER()
}
void Pattern():{}
{
<LQUOTATION>IDENTIFIER()<LQUOTATION>
}
/*-------------------*/
void IDENTIFIER():{}
{
<IDENTIFIER>
}
得到SQLParser.jj：
 
/*@bgen(jjtree) Generated By:JJTree: Do not edit this line. .\SQLParser.jj *//*@egen*/PARSER_BEGIN(SQLParser)public class SQLParser/*@bgen(jjtree)*/implements SQLParserTreeConstants/*@egen*/{/*@bgen(jjtree)*/  protected static JJTSQLParserState jjtree = new JJTSQLParserState();/*@egen*/  public static void main(String args[]) {    System.out.println("Reading from standard input...");    SQLParser p = new SQLParser(System.in);    try {      SimpleNode n = p.Start();      n.dump("");      System.out.println("Thank you.");    } catch (Exception e) {      System.out.println("Oops.");      System.out.println(e.getMessage());      e.printStackTrace();    }  }}PARSER_END(SQLParser)/*\u5b9a\u4e49\u8bcd\u6cd5\u5206\u6790*/SKIP:{" "}SKIP:{"\n"|"\r"|"\r\n"}TOKEN:/*\u5b9a\u4e49\u5173\u952e\u5b57*/{ <CREATE:"create"> | <TABLE:"table"> | <DROP:"drop"> | <SELECT:"select"> | <INSERT:"insert"> | <WHERE:"where"> | <FROM:"from"> | <INTO:"into"> | <DISTINCT:"distinct"> | <LIKE:"like"> | <ORDER:"order"> | <BY:"by"> | <VALUES:"values"> | <AND:"and"> | <IN:"in"> | <INT:"int"> | <CHAR:"char"> | <DATE:"date"> | <DELETE:"delete">}TOKEN:/*\u5b9a\u4e49\u7b26\u53f7*/{ <UNDERSCORE:"_"> | <COMMA:","> | <SEMICOLON:";"> | <COLON:":"> | <LEFTPARENTHESES:"("> | <RIGHTPARENTHESES:")"> | <EQUAL:"="> | <PLUS:"+"> | <MINUS:"-"> | <TIMES:"*"> | <DIVIDE:"/"> | <LEFTQUOTATION:"\"">  | <LQUOTATION:"'">}TOKEN:/* \u5b9a\u4e49\u6574\u6570 */{ <INTEGER_LITERAL:["1"-"9"](<DIGIT>)*>}TOKEN:/*\u5b9a\u4e49\u6570\u5b57*/{ <#DIGIT:["0"-"9"]>}TOKEN:/* \u5b9a\u4e49\u6807\u8bc6\u7b26 */{ <IDENTIFIER:<LETTER> |<LETTER><DIGIT> | <LETTER>(<LETTER> | <DIGIT> | <UNDERSCORE>)*(<LETTER> | <DIGIT>)+> | <#LETTER:["a"-"z", "A"-"Z"]>}/* \u8bed\u6cd5\u89e3\u6790*/SimpleNode Start() : {/*@bgen(jjtree) Start */  SimpleNode jjtn000 = new SimpleNode(JJTSTART);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Start */  try {/*@egen*/  Expression() ";"/*@bgen(jjtree)*/  {    jjtree.closeNodeScope(jjtn000, true);    jjtc000 = false;  }/*@egen*/  { return jjtn000; }/*@bgen(jjtree)*/  } catch (Throwable jjte000) {    if (jjtc000) {      jjtree.clearNodeScope(jjtn000);      jjtc000 = false;    } else {      jjtree.popNode();    }    if (jjte000 instanceof RuntimeException) {      throw (RuntimeException)jjte000;    }    if (jjte000 instanceof ParseException) {      throw (ParseException)jjte000;    }    throw (Error)jjte000;  } finally {    if (jjtc000) {      jjtree.closeNodeScope(jjtn000, true);    }  }/*@egen*/}void Expression() : {/*@bgen(jjtree) Expression */  SimpleNode jjtn000 = new SimpleNode(JJTEXPRESSION);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Expression */  try {/*@egen*/  Query()|CreT()|DropT()|DelT()|InsT()/*@bgen(jjtree)*/  } catch (Throwable jjte000) {    if (jjtc000) {      jjtree.clearNodeScope(jjtn000);      jjtc000 = false;    } else {      jjtree.popNode();    }    if (jjte000 instanceof RuntimeException) {      throw (RuntimeException)jjte000;    }    if (jjte000 instanceof ParseException) {      throw (ParseException)jjte000;    }    throw (Error)jjte000;  } finally {    if (jjtc000) {      jjtree.closeNodeScope(jjtn000, true);    }  }/*@egen*/}void Query():{/*@bgen(jjtree) Query */  SimpleNode jjtn000 = new SimpleNode(JJTQUERY);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Query */try {/*@egen*/SFW()[<ORDER><BY>Attribute()]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void SFW():{/*@bgen(jjtree) SFW */  SimpleNode jjtn000 = new SimpleNode(JJTSFW);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) SFW */try {/*@egen*/<SELECT>[<DISTINCT>]SelList()<FROM>FromList()<WHERE>Condition()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void SelList():{/*@bgen(jjtree) SelList */  SimpleNode jjtn000 = new SimpleNode(JJTSELLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) SelList */try {/*@egen*/Attribute()[(<COMMA>Attribute())+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void FromList():{/*@bgen(jjtree) FromList */  SimpleNode jjtn000 = new SimpleNode(JJTFROMLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) FromList */try {/*@egen*/Relation()[(<COMMA>Relation())+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void Condition():{/*@bgen(jjtree) Condition */  SimpleNode jjtn000 = new SimpleNode(JJTCONDITION);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Condition */try {/*@egen*//*[Condition()<AND>Condition()]|*//*[Tuple()<IN>Query()]*/[Attribute()<EQUAL>Attribute()]|[Attribute()<LIKE>Pattern()]|[Attribute()<EQUAL>IDENTIFIER()]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void Tuple():{/*@bgen(jjtree) Tuple */  SimpleNode jjtn000 = new SimpleNode(JJTTUPLE);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Tuple */try {/*@egen*/Attribute()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}/*-------------------*/void CreT():{/*@bgen(jjtree) CreT */  SimpleNode jjtn000 = new SimpleNode(JJTCRET);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) CreT */try {/*@egen*/<CREATE><TABLE>Relation()<LEFTPARENTHESES>ColList()<RIGHTPARENTHESES>/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void ColList():{/*@bgen(jjtree) ColList */  SimpleNode jjtn000 = new SimpleNode(JJTCOLLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) ColList */try {/*@egen*/Attribute()Type()[(<COMMA>Attribute()Type())+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void Type():{/*@bgen(jjtree) Type */  SimpleNode jjtn000 = new SimpleNode(JJTTYPE);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Type */try {/*@egen*/<INT>|<DATE>|<CHAR><LEFTPARENTHESES><INTEGER_LITERAL><RIGHTPARENTHESES>/*@bgen(jjtree)*/} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}/*-------------------*/void DropT():{/*@bgen(jjtree) DropT */  SimpleNode jjtn000 = new SimpleNode(JJTDROPT);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) DropT */try {/*@egen*/<DROP><TABLE>Relation()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void DelT():{/*@bgen(jjtree) DelT */  SimpleNode jjtn000 = new SimpleNode(JJTDELT);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) DelT */try {/*@egen*/<DELETE>DelList()<FROM>FromList()<WHERE>Condition()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void DelList():{/*@bgen(jjtree) DelList */  SimpleNode jjtn000 = new SimpleNode(JJTDELLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) DelList */try {/*@egen*/Attribute()[(<COMMA>Attribute())+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}/*-------------------*/void InsT():{/*@bgen(jjtree) InsT */  SimpleNode jjtn000 = new SimpleNode(JJTINST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) InsT */try {/*@egen*/<INSERT><INTO>Relation()<LEFTPARENTHESES>InList()<RIGHTPARENTHESES><VALUES><LEFTPARENTHESES>VList()<RIGHTPARENTHESES>/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void InList():{/*@bgen(jjtree) InList */  SimpleNode jjtn000 = new SimpleNode(JJTINLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) InList */try {/*@egen*/Attribute()[(<COMMA>Attribute())+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void VList():{/*@bgen(jjtree) VList */  SimpleNode jjtn000 = new SimpleNode(JJTVLIST);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) VList */try {/*@egen*/<LEFTQUOTATION>IDENTIFIER()<LEFTQUOTATION>[(<COMMA><LEFTQUOTATION>IDENTIFIER()<LEFTQUOTATION>)+]/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}/*-------------------*/void Attribute():{/*@bgen(jjtree) Attribute */  SimpleNode jjtn000 = new SimpleNode(JJTATTRIBUTE);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Attribute */try {/*@egen*/IDENTIFIER()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void Relation():{/*@bgen(jjtree) Relation */  SimpleNode jjtn000 = new SimpleNode(JJTRELATION);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Relation */try {/*@egen*/IDENTIFIER()/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}void Pattern():{/*@bgen(jjtree) Pattern */  SimpleNode jjtn000 = new SimpleNode(JJTPATTERN);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) Pattern */try {/*@egen*/<LQUOTATION>IDENTIFIER()<LQUOTATION>/*@bgen(jjtree)*/} catch (Throwable jjte000) {  if (jjtc000) {    jjtree.clearNodeScope(jjtn000);    jjtc000 = false;  } else {    jjtree.popNode();  }  if (jjte000 instanceof RuntimeException) {    throw (RuntimeException)jjte000;  }  if (jjte000 instanceof ParseException) {    throw (ParseException)jjte000;  }  throw (Error)jjte000;} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}/*-------------------*/void IDENTIFIER():{/*@bgen(jjtree) IDENTIFIER */  SimpleNode jjtn000 = new SimpleNode(JJTIDENTIFIER);  boolean jjtc000 = true;  jjtree.openNodeScope(jjtn000);/*@egen*/}{/*@bgen(jjtree) IDENTIFIER */try {/*@egen*/<IDENTIFIER>/*@bgen(jjtree)*/} finally {  if (jjtc000) {    jjtree.closeNodeScope(jjtn000, true);  }}/*@egen*/}
得到SQLParser.java:
/* Generated By:JJTree&JavaCC: Do not edit this line. SQLParser.java */
public class SQLParser/*@bgen(jjtree)*/implements SQLParserTreeConstants, SQLParserConstants {/*@bgen(jjtree)*/
  protected static JJTSQLParserState jjtree = new JJTSQLParserState();public static void main(String args[]) {
    System.out.println("Reading from standard input...");
    SQLParser p = new SQLParser(System.in);
    try {
      SimpleNode n = p.Start();
      n.dump("");
      System.out.println("Thank you.");
    } catch (Exception e) {
      System.out.println("Oops.");
      System.out.println(e.getMessage());
      e.printStackTrace();
    }
  }
/* 语法解析*/
  static final public SimpleNode Start() throws ParseException {
                      /*@bgen(jjtree) Start */
  SimpleNode jjtn000 = new SimpleNode(JJTSTART);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Expression();
      jj_consume_token(SEMICOLON);
    jjtree.closeNodeScope(jjtn000, true);
    jjtc000 = false;
    {if (true) return jjtn000;}
    } catch (Throwable jjte000) {
    if (jjtc000) {
      jjtree.clearNodeScope(jjtn000);
      jjtc000 = false;
    } else {
      jjtree.popNode();
    }
    if (jjte000 instanceof RuntimeException) {
      {if (true) throw (RuntimeException)jjte000;}
    }
    if (jjte000 instanceof ParseException) {
      {if (true) throw (ParseException)jjte000;}
    }
    {if (true) throw (Error)jjte000;}
    } finally {
    if (jjtc000) {
      jjtree.closeNodeScope(jjtn000, true);
    }
    }
    throw new Error("Missing return statement in function");
  }
  static final public void Expression() throws ParseException {
                     /*@bgen(jjtree) Expression */
  SimpleNode jjtn000 = new SimpleNode(JJTEXPRESSION);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case SELECT:
        Query();
        break;
      case CREATE:
        CreT();
        break;
      case DROP:
        DropT();
        break;
      case DELETE:
        DelT();
        break;
      case INSERT:
        InsT();
        break;
      default:
        jj_la1[0] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
      }
    } catch (Throwable jjte000) {
    if (jjtc000) {
      jjtree.clearNodeScope(jjtn000);
      jjtc000 = false;
    } else {
      jjtree.popNode();
    }
    if (jjte000 instanceof RuntimeException) {
      {if (true) throw (RuntimeException)jjte000;}
    }
    if (jjte000 instanceof ParseException) {
      {if (true) throw (ParseException)jjte000;}
    }
    {if (true) throw (Error)jjte000;}
    } finally {
    if (jjtc000) {
      jjtree.closeNodeScope(jjtn000, true);
    }
    }
  }
  static final public void Query() throws ParseException {
              /*@bgen(jjtree) Query */
  SimpleNode jjtn000 = new SimpleNode(JJTQUERY);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      SFW();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case ORDER:
        jj_consume_token(ORDER);
        jj_consume_token(BY);
        Attribute();
        break;
      default:
        jj_la1[1] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void SFW() throws ParseException {
            /*@bgen(jjtree) SFW */
  SimpleNode jjtn000 = new SimpleNode(JJTSFW);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(SELECT);
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case DISTINCT:
        jj_consume_token(DISTINCT);
        break;
      default:
        jj_la1[2] = jj_gen;
        ;
      }
      SelList();
      jj_consume_token(FROM);
      FromList();
      jj_consume_token(WHERE);
      Condition();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void SelList() throws ParseException {
                /*@bgen(jjtree) SelList */
  SimpleNode jjtn000 = new SimpleNode(JJTSELLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Attribute();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_1:
        while (true) {
          jj_consume_token(COMMA);
          Attribute();
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[3] = jj_gen;
            break label_1;
          }
        }
        break;
      default:
        jj_la1[4] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void FromList() throws ParseException {
                 /*@bgen(jjtree) FromList */
  SimpleNode jjtn000 = new SimpleNode(JJTFROMLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Relation();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_2:
        while (true) {
          jj_consume_token(COMMA);
          Relation();
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[5] = jj_gen;
            break label_2;
          }
        }
        break;
      default:
        jj_la1[6] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void Condition() throws ParseException {
                  /*@bgen(jjtree) Condition */
  SimpleNode jjtn000 = new SimpleNode(JJTCONDITION);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case IDENTIFIER:
        Attribute();
        jj_consume_token(EQUAL);
        Attribute();
        break;
      default:
        jj_la1[7] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void Tuple() throws ParseException {
              /*@bgen(jjtree) Tuple */
  SimpleNode jjtn000 = new SimpleNode(JJTTUPLE);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Attribute();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
/*-------------------*/
  static final public void CreT() throws ParseException {
             /*@bgen(jjtree) CreT */
  SimpleNode jjtn000 = new SimpleNode(JJTCRET);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(CREATE);
      jj_consume_token(TABLE);
      Relation();
      jj_consume_token(LEFTPARENTHESES);
      ColList();
      jj_consume_token(RIGHTPARENTHESES);
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void ColList() throws ParseException {
                /*@bgen(jjtree) ColList */
  SimpleNode jjtn000 = new SimpleNode(JJTCOLLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Attribute();
      Type();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_3:
        while (true) {
          jj_consume_token(COMMA);
          Attribute();
          Type();
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[10] = jj_gen;
            break label_3;
          }
        }
        break;
      default:
        jj_la1[11] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void Type() throws ParseException {
             /*@bgen(jjtree) Type */
  SimpleNode jjtn000 = new SimpleNode(JJTTYPE);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case INT:
        jj_consume_token(INT);
        break;
      case DATE:
        jj_consume_token(DATE);
        break;
      case CHAR:
        jj_consume_token(CHAR);
        jj_consume_token(LEFTPARENTHESES);
        jj_consume_token(INTEGER_LITERAL);
        jj_consume_token(RIGHTPARENTHESES);
        break;
      default:
        jj_la1[12] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
      }
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
/*-------------------*/
  static final public void DropT() throws ParseException {
              /*@bgen(jjtree) DropT */
  SimpleNode jjtn000 = new SimpleNode(JJTDROPT);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(DROP);
      jj_consume_token(TABLE);
      Relation();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void DelT() throws ParseException {
             /*@bgen(jjtree) DelT */
  SimpleNode jjtn000 = new SimpleNode(JJTDELT);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(DELETE);
      DelList();
      jj_consume_token(FROM);
      FromList();
      jj_consume_token(WHERE);
      Condition();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void DelList() throws ParseException {
                /*@bgen(jjtree) DelList */
  SimpleNode jjtn000 = new SimpleNode(JJTDELLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Attribute();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_4:
        while (true) {
          jj_consume_token(COMMA);
          Attribute();
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[13] = jj_gen;
            break label_4;
          }
        }
        break;
      default:
        jj_la1[14] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
/*-------------------*/
  static final public void InsT() throws ParseException {
             /*@bgen(jjtree) InsT */
  SimpleNode jjtn000 = new SimpleNode(JJTINST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(INSERT);
      jj_consume_token(INTO);
      Relation();
      jj_consume_token(LEFTPARENTHESES);
      InList();
      jj_consume_token(RIGHTPARENTHESES);
      jj_consume_token(VALUES);
      jj_consume_token(LEFTPARENTHESES);
      VList();
      jj_consume_token(RIGHTPARENTHESES);
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void InList() throws ParseException {
               /*@bgen(jjtree) InList */
  SimpleNode jjtn000 = new SimpleNode(JJTINLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      Attribute();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_5:
        while (true) {
          jj_consume_token(COMMA);
          Attribute();
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[15] = jj_gen;
            break label_5;
          }
        }
        break;
      default:
        jj_la1[16] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void VList() throws ParseException {
              /*@bgen(jjtree) VList */
  SimpleNode jjtn000 = new SimpleNode(JJTVLIST);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(LEFTQUOTATION);
      IDENTIFIER();
      jj_consume_token(LEFTQUOTATION);
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case COMMA:
        label_6:
        while (true) {
          jj_consume_token(COMMA);
          jj_consume_token(LEFTQUOTATION);
          IDENTIFIER();
          jj_consume_token(LEFTQUOTATION);
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case COMMA:
            ;
            break;
          default:
            jj_la1[17] = jj_gen;
            break label_6;
          }
        }
        break;
      default:
        jj_la1[18] = jj_gen;
        ;
      }
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
/*-------------------*/
  static final public void Attribute() throws ParseException {
                  /*@bgen(jjtree) Attribute */
  SimpleNode jjtn000 = new SimpleNode(JJTATTRIBUTE);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      IDENTIFIER();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void Relation() throws ParseException {
                 /*@bgen(jjtree) Relation */
  SimpleNode jjtn000 = new SimpleNode(JJTRELATION);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      IDENTIFIER();
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static final public void Pattern() throws ParseException {
                /*@bgen(jjtree) Pattern */
  SimpleNode jjtn000 = new SimpleNode(JJTPATTERN);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(LQUOTATION);
      IDENTIFIER();
      jj_consume_token(LQUOTATION);
    } catch (Throwable jjte000) {
  if (jjtc000) {
    jjtree.clearNodeScope(jjtn000);
    jjtc000 = false;
  } else {
    jjtree.popNode();
  }
  if (jjte000 instanceof RuntimeException) {
    {if (true) throw (RuntimeException)jjte000;}
  }
  if (jjte000 instanceof ParseException) {
    {if (true) throw (ParseException)jjte000;}
  }
  {if (true) throw (Error)jjte000;}
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
/*-------------------*/
  static final public void IDENTIFIER() throws ParseException {
                   /*@bgen(jjtree) IDENTIFIER */
  SimpleNode jjtn000 = new SimpleNode(JJTIDENTIFIER);
  boolean jjtc000 = true;
  jjtree.openNodeScope(jjtn000);
    try {
      jj_consume_token(IDENTIFIER);
    } finally {
  if (jjtc000) {
    jjtree.closeNodeScope(jjtn000, true);
  }
    }
  }
  static private boolean jj_initialized_once = false;
  static public SQLParserTokenManager token_source;
  static SimpleCharStream jj_input_stream;
  static public Token token, jj_nt;
  static private int jj_ntk;
  static private int jj_gen;
  static final private int[] jj_la1 = new int[19];
  static private int[] jj_la1_0;
  static private int[] jj_la1_1;
  static {
      jj_la1_0();
      jj_la1_1();
   }
   private static void jj_la1_0() {
      jj_la1_0 = new int[] {0x8003a0,0x8000,0x2000,0x2000000,0x2000000,0x2000000,0x2000000,0x0,0x0,0x0,0x2000000,0x2000000,0x700000,0x2000000,0x2000000,0x2000000,0x2000000,0x2000000,0x2000000,};
   }
   private static void jj_la1_1() {
      jj_la1_1 = new int[] {0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x80,0x80,0x80,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,};
   }
  public SQLParser(java.io.InputStream stream) {
     this(stream, null);
  }
  public SQLParser(java.io.InputStream stream, String encoding) {
    if (jj_initialized_once) {
      System.out.println("ERROR: Second call to constructor of static parser.  You must");
      System.out.println("       either use ReInit() or set the JavaCC option STATIC to false");
      System.out.println("       during parser generation.");
      throw new Error();
    }
    jj_initialized_once = true;
    try { jj_input_stream = new SimpleCharStream(stream, encoding, 1, 1); } catch(java.io.UnsupportedEncodingException e) { throw new RuntimeException(e); }
    token_source = new SQLParserTokenManager(jj_input_stream);
    token = new Token();
    jj_ntk = -1;
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  static public void ReInit(java.io.InputStream stream) {
     ReInit(stream, null);
  }
  static public void ReInit(java.io.InputStream stream, String encoding) {
    try { jj_input_stream.ReInit(stream, encoding, 1, 1); } catch(java.io.UnsupportedEncodingException e) { throw new RuntimeException(e); }
    token_source.ReInit(jj_input_stream);
    token = new Token();
    jj_ntk = -1;
    jjtree.reset();
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  public SQLParser(java.io.Reader stream) {
    if (jj_initialized_once) {
      System.out.println("ERROR: Second call to constructor of static parser.  You must");
      System.out.println("       either use ReInit() or set the JavaCC option STATIC to false");
      System.out.println("       during parser generation.");
      throw new Error();
    }
    jj_initialized_once = true;
    jj_input_stream = new SimpleCharStream(stream, 1, 1);
    token_source = new SQLParserTokenManager(jj_input_stream);
    token = new Token();
    jj_ntk = -1;
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  static public void ReInit(java.io.Reader stream) {
    jj_input_stream.ReInit(stream, 1, 1);
    token_source.ReInit(jj_input_stream);
    token = new Token();
    jj_ntk = -1;
    jjtree.reset();
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  public SQLParser(SQLParserTokenManager tm) {
    if (jj_initialized_once) {
      System.out.println("ERROR: Second call to constructor of static parser.  You must");
      System.out.println("       either use ReInit() or set the JavaCC option STATIC to false");
      System.out.println("       during parser generation.");
      throw new Error();
    }
    jj_initialized_once = true;
    token_source = tm;
    token = new Token();
    jj_ntk = -1;
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  public void ReInit(SQLParserTokenManager tm) {
    token_source = tm;
    token = new Token();
    jj_ntk = -1;
    jjtree.reset();
    jj_gen = 0;
    for (int i = 0; i < 19; i++) jj_la1[i] = -1;
  }
  static final private Token jj_consume_token(int kind) throws ParseException {
    Token oldToken;
    if ((oldToken = token).next != null) token = token.next;
    else token = token.next = token_source.getNextToken();
    jj_ntk = -1;
    if (token.kind == kind) {
      jj_gen++;
      return token;
    }
    token = oldToken;
    jj_kind = kind;
    throw generateParseException();
  }
  static final public Token getNextToken() {
    if (token.next != null) token = token.next;
    else token = token.next = token_source.getNextToken();
    jj_ntk = -1;
    jj_gen++;
    return token;
  }
  static final public Token getToken(int index) {
    Token t = token;
    for (int i = 0; i < index; i++) {
      if (t.next != null) t = t.next;
      else t = t.next = token_source.getNextToken();
    }
    return t;
  }
  static final private int jj_ntk() {
    if ((jj_nt=token.next) == null)
      return (jj_ntk = (token.next=token_source.getNextToken()).kind);
    else
      return (jj_ntk = jj_nt.kind);
  }
  static private java.util.Vector jj_expentries = new java.util.Vector();
  static private int[] jj_expentry;
  static private int jj_kind = -1;
  static public ParseException generateParseException() {
    jj_expentries.removeAllElements();
    boolean[] la1tokens = new boolean[41];
    for (int i = 0; i < 41; i++) {
      la1tokens[i] = false;
    }
    if (jj_kind >= 0) {
      la1tokens[jj_kind] = true;
      jj_kind = -1;
    }
    for (int i = 0; i < 19; i++) {
      if (jj_la1[i] == jj_gen) {
        for (int j = 0; j < 32; j++) {
          if ((jj_la1_0[i] & (1<<j)) != 0) {
            la1tokens[j] = true;
          }
          if ((jj_la1_1[i] & (1<<j)) != 0) {
            la1tokens[32+j] = true;
          }
        }
      }
    }
    for (int i = 0; i < 41; i++) {
      if (la1tokens[i]) {
        jj_expentry = new int[1];
        jj_expentry[0] = i;
        jj_expentries.addElement(jj_expentry);
      }
    }
    int[][] exptokseq = new int[jj_expentries.size()][];
    for (int i = 0; i < jj_expentries.size(); i++) {
      exptokseq[i] = (int[])jj_expentries.elementAt(i);
    }
    return new ParseException(token, exptokseq, tokenImage);
  }
  static final public void enable_tracing() {
  }
  static final public void disable_tracing() {
  }
}
xuanmu2011
关注
基于javacc与基于java SQL解析器实现的一点心得
haier_jiang的专栏
03-16 7576
背景 由于项目中mysql的日志格式只能选用MIXED格式（binlog存在一定的局限性，请参考），因此需要解析SQL语句。 在查找的SQL语句处理器中，都有一定的局限性，而所选中，其中一个基于javacc实现的解析器JSqlParser，使用起来方便，而且代码结构模块很好，基于其重构也比较简单。 虽然项目很久没更新与维护了，基于其改造也可以接受，因此选用了JSqlParser,而这也有了后
java mysql 语句解析器_基于javacc与基于java SQL解析器实现的一点心得 | 学步园
weixin_34321609的博客
02-06 458
背景由于项目中mysql的日志格式只能选用MIXED格式(binlog存在一定的局限性，请参考)，因此需要解析SQL语句。在查找的SQL语句处理器中，都有一定的局限性，而所选中，其中一个基于javacc实现的解析器JSqlParser，使用起来方便，而且代码结构模块很好，基于其重构也比较简单。虽然项目很久没更新与维护了，基于其改造也可以接受，因此选用了JSqlParser,而这也有了后面的SQL解...
Apache Calcite教程-SQL解析-JavaCC教程
quxiuchengdev的专栏
04-19 4190
JavaCC语法描述文件JavaCC类介绍SimpleCharStreamXXXXXConstantsXXXXXTokenManagerTokenXXXXXParseExceptionTokenMgrError常见配置 optionsJavaCC工作原理语法二义性解决JavaCC语法Java代码JAVA函数条件循环正则表达式代码示例Maven编译简单计算器简单语法示例 JavaCC 使用递归下降...
Java CC 解析 SQL 语法示例
猫猫爱吃小鱼粮
10-23 457
Java CC 解析 SQL 语法示例
java sql语法解析_Java中的SQL语句解析
weixin_31060209的博客
02-13 2581
String sql = "SELECT userId,password FROM Table_1 where userId ='" + userId +"' and password = '" + pass + "'";解析如下：第一步：userId的值为cyy和pass的值为,.SELECT userId,password FROM Table_1 where userId =cyy and ...
基于JavaCC的SQL编译器的设计与实现.pdf
09-19
### 知识点一：SQL语言和...通过EBNF，SQL编译器的设计者可以将复杂的SQL语法分解成一组简单的规则，从而简化编译器的逻辑，并使得编译器能够更加精确地解析SQL语句，验证其语法的正确性，并生成相应的抽象语法树。
JavaCC解析器生成器入门教程
通过深入学习和实践，你可以利用JavaCC生成高效且灵活的解析器和词法分析器，应用于各种需要解析字符输入的场合，如命令行解析、配置文件解析、SQL查询解析等。本书将逐步引导读者掌握JavaCC的使用方法，通过实例和...
ZQL-一个基于JavaCC的开源Java SQL解析器
对于个人和企业开发者来说，使用这样的开源SQL解析器，不仅可以减少开发成本，还可以利用社区的力量来提高软件的稳定性和性能。此外，由于遵循GPL v3许可证，开发者可以在确保所有派生作品同样开源的前提下，将其...
javacc 词法解析
04-10
在实际应用中，JavaCC常用于处理复杂的语法结构，如SQL查询、XML文档解析或自定义脚本语言。它不仅支持LL(1)解析，还支持更复杂的LL(k)和LR(k)解析策略，这使得它可以处理更广泛的语言结构。此外，JavaCC生成的解析...
javaCC_字符串解析的强大工具
06-04
JavaCC，全称为Java Compiler Compiler...通过以上步骤，开发者可以利用JavaCC的强大功能，轻松构建自己的解析解决方案。总之，JavaCC是解析任务的强大工具，无论是在学术研究还是在实际项目开发中，都能发挥重要作用。
JavaCC初探-T-SQL转换为P-SQL
yue0706的博客
06-24 347
         前段时间，研究数据库迁移工作，使用Powerdesigner实现了数据库对象之间的转换，但是由于项目中使用了大量的存储过程、函数和触发器等，想着怎么实现这些代码的迁移，网上搜了一通，大概有两个工具（SQLWays和SwisSQL，具体可以百度），后来也使用了一种工具，但是转换效果不是特别好，需要手工重新修改。这些都是后话；还有一个思路，就是使用javaCC进行在词法语法级别进...
利用JAVACC将HQL->SQL(1) -[转载]
s00n的桃花园
09-19 1331
主要是为了尝试一下JAVACC，利用编译原理的思路构造自己的语言：）首先到https://javacc.dev.java.net/?JAVACC的老家下载JAVACC我们今天的目标就是把from?Teacher转化为select?*?from?Teacher首先编写.jj文件1.定义要空开的分隔符SKIP?:{??"?"|?"/t"|?"/n"|?"/r"|?"/f"}2.定义关键字。from?为
java sql语法解析_利用Java理解sql的语法(实例讲解)
weixin_34893782的博客
02-13 467
select 相当于 for 循环select id from IDArrayLinkedList a = new LinkedList();for ( int i=0 ; ia.add(IDArray.get("id" ) );}return a;当执行子查询时，可以理解为select id, ( select name from nameArray) as names ,from Idarra...
如何实现一个SQL解析器
SmartSi
12-31 1371
在选择SQL解析器应用到我们实际的业务场景之前，我们先来了解一下SQL解析器的核心知识点。如何理解语法解析呢？语法解析我们可以这么来进行理解，在启动语法解析任务时，语法分析的任务会在词法分析的结果上将词条序列组合成不同语法短句，组成的语法短句将与相应的语法规则进行适配，若适配成功则生成对应的抽象语法树，否则报会抛出语法错误异常。比如如下SQL语句：SQL示例约定规则如下：上表中，红色的内容通常表示终结符，它们一般是大写的关键字或者符号等，小写的内容是非终结符，一般用作规则的命名，比如字段、表名等。
JavaCC
Jenkins中文社区
10-22 643
介绍 JavaCC是Java语言实现的一个语法分析器。 官网：https://javacc.java.net/ 参考 http://www.cnblogs.com/Gavin_Liu/archive/2009/03/07/1405029.html查看原文：http://surenpi.com/2015/10/22/javacc/
Apache Calcite
辛勤的搬运工_
11-05 1422
前言 Calcite 之前的名称叫做 optiq，optiq 起初在 Hive 项目中，为 Hive 提供基于成本模型的优化，2014 年 5 月 optiq 独立出来，成为 Apache 社区的孵化项目，主要作用是提供标准的SQL语言查询底层各种数据源的一个工具，可以将各种SQL语句解析成抽象语法术AST(Abstract Syntax Tree)， 之后通过操作AST就可以把SQL中所要表达的算法与关系体现在具体代码之中。 Calcite 的目标是"one size fits all "（一种方案适
理解calcite 里的Java CC
最新发布
csdn问鼎
10-11 419
JAVA CC 在calcite 的应用
javacc jjtree 写法 以及 jj写法 基本语法 以及应用
zyb243380456的专栏
02-07 9728
/***********************************************************/ >我使用的测试jjt,jj文件来自于javacc5.0版本 >dir_hier/javacc-5.0/javacc-5.0/examples/ JJTreeExamples
Java解析SQL的基本思路
java小白翻身
04-25 4164
天天在写sql，一直很好奇sql到底咋解析的，于是随便整个小demo。 比如sql是： String sql = "selectname,score,sexfromuserswherename = 'jack'andisdelete <> 1 ; "; 中间可能有1个或者多个空格，就想着怎么着也得有个分词的类，就叫做Tokenizer吧。 public class Tokenizer implements Iterator<String> { Str......
JavaCC解析器生成器详解
此外，文档可能还会包含一些实际的示例，展示如何用JavaCC解析和处理不同的输入，以及如何利用JavaCC的高级特性，如语法分析的回溯、用户定义的语法规则等。 通过阅读这份指南，开发者可以学习如何有效地使用JavaCC...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值