package?com.iblue.core.util;

/**
?*?
title:?

?*
?*?
Description:?

?*
?*?
Copyright:?Copyright?（c）?2005

?*
?*?
Company:?

?*
?*?@author?not?attributable
?*?@version?1.0
?*/
import?java.io.*;
import?java.util.*;
import?java.sql.Statement;

public?class?SqlParser?{

??public?static?final?String?INSERT?=?“insert“;
??public?static?final?String?UPDATE?=?“update“;
??public?static?final?String?SELECT?=?“select“;

??private?static?final?String?QUOTE_ESCAPE?=?“‘‘“;
??static?String?COMMA_ESCAPE?=“~#ESCAPE#~“;//‘
??static?String?COMMA_QUOTEL=“~#QUOTEL#~“;
??static?String?COMMA_QUOTER=“~#QUOTER#~“;
??static?String?COMMA_SPACE=“~#SPACE#~“;
??static?String?COMMA_AND=“~#AND#~“;
??static?String?COMMA_OR=“~#OR#~“;
??static?String?COMMA_SPLIT=“~#SPLIT#~“;

??private?ArrayList?binaryStreamobjectList?=?new?ArrayList（）;

??/**解析語句的各部分*/
??public?String?tableName;
??public?String?selectStatement;
??public?String?fromStatement;
??public?String?whereStatement;
??public?String?groupStatement;
??public?String?orderStatement;
??public?String?limitStatement;
??public?String?sqlType;
??public?String?sql;
??/**查詢表本名*/
??public?String[]?tableNames;
??/**查詢表別名*/
??public?String[]?tableAlias;
??/**查詢表標準別名tb1-100*/
??public?String[]?tableStandardAlias;
??/**表別名別名=>表名*/
??public?HashMap?tableAliasNames;
??/**標準表別名到原有別名映射標準別名=>別名*/
??public?HashMap?tableAliasMap;
??/**表別名標準別名=>表名*/
??public?HashMap?tableStandardAliasNames;
??
??
??/**字段名稱*/
??public?String[]?columnNames;
??/**字段別名*/
??public?String[]?columnAlias;
??/**列別名別名=>字段名*/
??public?HashMap?columnAliasNames;
??/**字段值*/
??public?String[]?columnValues;
??/**條件字段名稱*/
??public?String[]?columnWhereNames;
??/**條件字段值*/
??public?String[]?columnWhereValues;
??/**分組*/
??public?String[]?groupByNames;
??/**排序*/
??public?String[]?orderByNames;
??
??

??/**
???*Gets?the?tableName?attribute?of?the?SqlParser?object
???*
???*?@return????The?tableName?value
???*?@since
???*/
??public?String?getFromstatement（）?{
????return?tableName;
??}
??/*獲取select語句部分*/
??public?String?getSelectStatement（）?{
????return?this.selectStatement;
??}
??/*獲取from語句部分*/
??public?String?getFromStatement（）?{
????return?this.fromStatement;
??}
??/*獲取Where語句部分*/
??public?String?getWhereStatement（）?{
????return?this.whereStatement;
??}
??/*獲取group語句部分*/
??public?String?getGroupStatement（）?{
????return?this.groupStatement;
??}
??/*獲取order語句部分*/
??public?String?getOrderStatement（）?{
????return?this.orderStatement;
??}
??/*獲取limit語句部分*/
??public?String?getLimitStatement（）?{
????return?this.limitStatement;
??}
??public?String[]?getTableNames（）?{
????return?tableNames;
??}
??public?String[]?getTableAlias（）?{
????return?tableAlias;
??}
??public?String[]?getTableStandardAlias（）?{
????return?tableStandardAlias;
??}
??public?HashMap?getTableAliasNames（）?{
????