token.java

用JAVA实现了,将DB装入内存,内存由DBMS控制,实现简单数据库的创建、数据表的创建、记录插入、查询以及表的删除。

    static final String T_VARYING = "VARYING";                      //reserved
    static final String T_WHEN = "WHEN";                         //reserved
    static final String T_WHENEVER = "WHENEVER";                     //reserved
    static final String T_WHERE = "WHERE";                        //reserved
    static final String T_WHILE = "WHILE";                        //reserved
    static final String T_WINDOW = "WINDOW";                       //reserved
    static final String T_WITH = "WITH";                         //reserved
    static final String T_WITHIN = "WITHIN";                       //reserved
    static final String T_WITHOUT = "WITHOUT";                      //reserved
    static final String T_YEAR = "YEAR";                         //reserved

    // other tokens
    static final String T_ALWAYS = "ALWAYS";
    static final String T_ACTION = "ACTION";
    static final String T_ADMIN = "ADMIN";
    static final String T_AFTER = "AFTER";
    static final String T_ALIAS = "ALIAS";
    static final String T_ASC = "ASC";
    static final String T_AUTOCOMMIT = "AUTOCOMMIT";
    static final String T_AVG = "AVG";
    static final String T_BACKUP = "BACKUP";
    static final String T_BEFORE = "BEFORE";
    static final String T_CACHED = "CACHED";
    static final String T_CASCADE = "CASCADE";
    static final String T_CASEWHEN = "CASEWHEN";
    static final String T_CHECKPOINT = "CHECKPOINT";
    static final String T_CLASS = "CLASS";
    static final String T_COALESCE = "COALESCE";
    static final String T_COLLATION = "COLLATION";
    static final String T_COMPACT = "COMPACT";
    public static final String T_COMPRESSED = "COMPRESSED";
    static final String T_CONVERT = "CONVERT";
    static final String T_COUNT = "COUNT";
    static final String T_DATABASE = "DATABASE";
    static final String T_DEFRAG = "DEFRAG";
    static final String T_DESC = "DESC";
    static final String T_EVERY = "EVERY";
    static final String T_EXPLAIN = "EXPLAIN";
    static final String T_EXTRACT = "EXTRACT";
    static final String T_GENERATED = "GENERATED";
    static final String T_IFNULL = "IFNULL";
    static final String T_IGNORECASE = "IGNORECASE";
    static final String T_IMMEDIATELY = "IMMEDIATELY";
    static final String T_INCREMENT = "INCREMENT";
    static final String T_INDEX = "INDEX";
    static final String T_INITIAL = "INITIAL";
    static final String T_KEY = "KEY";
    static final String T_LIMIT = "LIMIT";
    static final String T_LOGSIZE = "LOGSIZE";
    static final String T_MAX = "MAX";
    static final String T_MAXROWS = "MAXROWS";
    static final String T_MEMORY = "MEMORY";
    static final String T_MERGE = "MERGE";
    static final String T_MIN = "MIN";
    static final String T_MINUS = "MINUS";
    static final String T_NOW = "NOW";
    static final String T_NOWAIT = "NOWAIT";
    static final String T_NULLIF = "NULLIF";
    static final String T_NVL = "NVL";
    static final String T_OFFSET = "OFFSET";
    static final String T_PASSWORD = "PASSWORD";
    public static final String T_SCHEMA = "SCHEMA";
    static final String T_PLAN = "PLAN";
    static final String T_PRESERVE = "PRESERVE";
    static final String T_PRIVILEGES = "PRIVILEGES";
    static final String T_POSITION = "POSITION";
    static final String T_PROPERTY = "PROPERTY";
    static final String T_PUBLIC = "PUBLIC";
    static final String T_QUEUE = "QUEUE";
    static final String T_READONLY = "READONLY";
    static final String T_REFERENTIAL_INTEGRITY = "REFERENTIAL_INTEGRITY";
    static final String T_RENAME = "RENAME";
    static final String T_RESTART = "RESTART";
    static final String T_RESTRICT = "RESTRICT";
    static final String T_ROLE = "ROLE";
    static final String T_SCRIPT = "SCRIPT";
    static final String T_SCRIPTFORMAT = "SCRIPTFORMAT";
    static final String T_SEQUENCE = "SEQUENCE";
    static final String T_SHUTDOWN = "SHUTDOWN";
    public static final String T_SOURCE = "SOURCE";
    static final String T_STDDEV_POP = "STDDEV_POP";
    static final String T_STDDEV_SAMP = "STDDEV_SAMP";
    static final String T_SUBSTRING = "SUBSTRING";
    static final String T_SUM = "SUM";
    static final String T_SYSDATE = "SYSDATE";
    static final String T_TEMP = "TEMP";
    static final String T_TEMPORARY = "TEMPORARY";
    public static final String T_TEXT = "TEXT";
    static final String T_TODAY = "TODAY";
    static final String T_TOP = "TOP";
    static final String T_TRIM = "TRIM";
    static final String T_VAR_POP = "VAR_POP";
    static final String T_VAR_SAMP = "VAR_SAMP";
    static final String T_VIEW = "VIEW";
    static final String T_WORK = "WORK";
    static final String T_WRITE_DELAY = "WRITE_DELAY";
    public static final String T_OFF = "OFF";

    // SQL 200n token values
    static final int ADD = 1;
    static final int ALL = 2;
    static final int ALLOCATE = 3;
    static final int ALTER = 4;
    static final int AND = 5;
    static final int ANY = 6;
    static final int ARE = 7;
    static final int ARRAY = 8;
    static final int AS = 9;
    static final int ASENSITIVE = 10;
    static final int ASYMMETRIC = 11;
    static final int AT = 12;
    static final int ATOMIC = 13;
    static final int AUTHORIZATION = 14;
    static final int BEGIN = 15;
    static final int BETWEEN = 16;
    static final int BIGINT = 17;
    static final int BINARY = 18;
    static final int BLOB = 19;
    static final int BOOLEAN = 20;
    static final int BOTH = 21;
    static final int BY = 22;
    public static final int CALL = 23;
    static final int CALLED = 24;
    static final int CASCADED = 25;
    static final int CASE = 26;
    static final int CAST = 27;
    static final int CHAR = 28;
    static final int CHARACTER = 29;
    static final int CHECK = 30;
    static final int CLOB = 31;
    static final int CLOSE = 32;
    static final int COLLATE = 33;
    static final int COLUMN = 34;
    static final int COMMIT = 35;
    static final int CONDITION = 36;
    static final int CONNECT = 37;
    static final int CONSTRAINT = 38;
    static final int CONTINUE = 39;
    static final int CORRESPONDING = 40;
    static final int CREATE = 41;
    static final int CROSS = 42;
    static final int CUBE = 43;
    static final int CURRENT = 44;
    static final int CURRENT_DATE = 45;
    static final int CURRENT_DEFAULT_TRANSFORM_GRO = 46;
    static final int CURRENT_PATH = 47;
    static final int CURRENT_ROLE = 48;
    static final int CURRENT_TIME = 49;
    static final int CURRENT_TIMESTAMP = 50;
    static final int CURRENT_TRANSFORM_GROUP_FOR_T = 51;
    static final int CURRENT_USER = 52;
    static final int CURSOR = 53;
    static final int CYCLE = 54;
    static final int DATE = 55;
    static final int DAY = 56;
    static final int DEALLOCATE = 57;
    static final int DEC = 58;
    static final int DECIMAL = 59;
    static final int DECLARE = 60;
    static final int DEFAULT = 61;
    public static final int DELETE = 62;
    static final int DEREF = 63;
    static final int DESCRIBE = 64;
    static final int DETERMINISTIC = 65;
    static final int DISCONNECT = 66;
    static final int DISTINCT = 67;
    static final int DO = 68;
    static final int DOUBLE = 69;
    static final int DROP = 70;
    static final int DYNAMIC = 71;
    static final int EACH = 72;
    static final int ELEMENT = 73;
    static final int ELSE = 74;
    static final int ELSEIF = 75;
    static final int END = 76;
    static final int ESCAPE = 77;
    static final int EXCEPT = 78;
    static final int EXEC = 79;
    static final int EXECUTE = 80;
    static final int EXISTS = 81;
    static final int EXIT = 82;
    static final int EXTERNAL = 83;
    static final int FALSE = 84;
    static final int FETCH = 85;
    static final int FILTER = 86;
    static final int FLOAT = 87;
    static final int FOR = 88;
    static final int FOREIGN = 89;
    static final int FREE = 90;
    static final int FROM = 91;
    static final int FULL = 92;
    static final int FUNCTION = 93;
    static final int GET = 94;
    static final int GLOBAL = 95;
    static final int GRANT = 96;
    static final int GROUP = 97;
    static final int GROUPING = 98;
    static final int HANDLER = 99;
    static final int HAVING = 100;
    static final int HOLD = 101;
    static final int HOUR = 102;
    static final int IDENTITY = 103;
    static final int IF = 104;
    static final int IMMEDIATE = 105;
    static final int IN = 106;
    static final int INDICATOR = 107;
    static final int INNER = 108;
    static final int INOUT = 109;
    static final int INPUT = 110;
    static final int INSENSITIVE = 111;
    public static final int INSERT = 112;
    static final int INT = 113;
    static final int INTEGER = 114;
    static final int INTERSECT = 115;
    static final int INTERVAL = 116;
    static final int INTO = 117;
    static final int IS = 118;
    static final int ITERATE = 119;
    static final int JOIN = 120;
    static final int LANGUAGE = 121;
    static final int LARGE = 122;
    static final int LATERAL = 123;
    static final int LEADING = 124;
    static final int LEAVE = 125;
    static final int LEFT = 126;
    static final int LIKE = 127;
    static final int LOCAL = 128;
    static final int LOCALTIME = 129;
    static final int LOCALTIMESTAMP = 130;
    static final int LOOP = 131;
    static final int MATCH = 132;
    static final int MEMBER = 133;
    static final int MERGE = 134;
    static final int METHOD = 135;
    static final int MINUTE = 136;
    static final int MODIFIES = 137;
    static final int MODULE = 138;
    static final int MONTH = 139;
    static final int MULTISET = 140;
    static final int NATIONAL = 141;
    static final int NATURAL = 142;
    static final int NCHAR = 143;
    static final int NCLOB = 144;
    static final int NEW = 145;
    static final int NO = 146;
    static final int NONE = 147;
    static final int NOT = 148;
    static final int NULL = 149;
    static final int NUMERIC = 150;
    static final int OF = 151;
    static final int OLD = 152;
    static final int ON = 153;
    static final int ONLY = 154;
    static final int OPEN = 155;
    static final int OR = 156;
    static final int ORDER = 157;
    static final int OUT = 158;
    static final int OUTER = 159;
    static final int OUTPUT = 160;
    static final int OVER = 161;
    static final int OVERLAPS = 162;
    static final int PARAMETER = 163;
    static final int PARTITION = 164;
    static final int PRECISION = 165;
    static final int PREPARE = 166;
    static final int PRIMARY = 167;
    static final int PROCEDURE = 168;
    static final int RANGE = 169;
    static final int READS = 170;