rule1.txt

一个用JAVA语言实现的SQL编译器。能够迅速实现对SQL语言的解析。

0 $ select null 3,4,5,6,7,8,172
1 $ insert null 84
2 $ create null 99
3 select all create:select 29,30,31,32
4 select distinct create:select 33,34,35,36
5 select ( create:select 9,10,11,12
6 select function create:select 14
7 select number create:select 19
8 select letters create:select 22,23,24,38
9 ( function left++ 14
10 ( number left++ 19,20,37
11 ( letters left++ 22,23
12 ( ( left++ 9,10,11,12
13 ( letters left++ 15
14 function ( assign:fuction=& 13,78
15 letters ) assign:column=& 174
16 ) op right++;right>left? 25,26,27,28
17 ) ) right++;right>left? 16,17,18,39
18 ) from right++;right>left? 40
19 number op inStack:& 25,26,27,28
20 number ) inStack:& 16,17,18
21 number from inStack:& 40
22 letters op assign:column=& 25,26,27,28
23 letters ) assign:column=& 16,17,18,39
24 letters from assign:column=& 40
25 op function inStack:& 14
26 op letters inStack:& 22,23,24,38
27 op number inStack:& 19,20,21,37
28 op ( inStack 9,10,11,12
29 all ( distinct=false 9,10,11,12
30 all function distinct=false 14
31 all number distinct=false 19,20
32 all letters distinct=false 22,23,24,38
33 distinct ( distinct=true 9,10,11,12
34 distinct function distinct=true 14
35 distinct number distinct=true 19,20
36 distinct letters distinct=true 22,23,24,38
37 number , inStack:& 41,42,43,44
38 letters , assign:column=& 41,42,43,44
39 ) , right++;right>left? 41,42,43,44
40 from letters left==right?left=right=0; 45,46,47,48,49
41 , number left==right?left=right=0 19,20
42 , ( left==right?left=right=0 9,10,11,12
43 , letters left==right?left=right=0 22,23,24,38,64
44 , function left==right?left=right=0 14
45 letters , assign:tablename=& 50
46 letters where assign:tablename=& 51,66
47 letters ; assign:tablename=& -1
48 letters group assign:tablename=& 62
49 letters order assign:tablename=& 69
50 , letters null 45,46,47,48,49
51 where letters null 52
52 letters ref assign:standard=& 53,54
53 ref letters assign:ref=& 55,81,83
54 ref number assign:ref=& 56,77,80,61
55 letters and assign:value=& 57
56 number and assign:value=& 57
57 and letters assign:conj=& 52
58 letters group null 62
59 letters order null 68
60 number group assign:value=& 62
61 number order assign:value=& 68
62 group by null 63
63 by letters null 38,64
64 letters having null 65
65 having letters null 52
66 where function null 14
67 ) ref null 53,54
68 order by null 69,70
69 by number null 75,178,179
70 by letters null 71,72,76
71 letters asc assign:by=& 73
72 letters desc assign:by=& 74
73 asc ; assign:order=& -1
74 desc ; assign:order=& -1
75 number ; assign:by=& -1
76 letters ; assign:by=& -1
77 number or assign:value=& 82
78 ( op left++ 79
79 op ) examine3=& 174
80 number ; assign:value=& -1
81 letters or assign:value=& 82
82 or letters assign:conj=& 52
83 letters ; assign:value=& -1
84 insert into null 85
85 into letters create:insert 86,87
86 letters ( assign:tablename=& 88
87 letters values assign:tablename=& 93
88 ( letters null 89,90
89 letters , assign:column=& 91
90 letters ) assign:column=& 92
91 , letters null 89,90
92 ) values null 93
93 values ( null 94,132,168
94 ( letters null 95,96
95 letters , assign:value=& 97,135,170
96 letters ) assign:value=& 98
97 , letters null 95,96
98 ) ; null -1
99 create table null 100
100 table letters create:table 101
101 letters ( assign:tablename=& 102,132
102 ( letters null 103
103 letters datatype assign:column=& 104,105,106,130,131
104 datatype not assign:type=& 107
105 datatype unique assign:type=& 111,112
106 datatype primary assign:type=& 113
107 not null null 108,109,110
108 null unique assign:notnull=1 111,112
109 null , assign:notnull=1 116,117
110 null ) assign:notnull=1 129
111 unique , assign:unique=1 116,117
112 unique ) assign:unique=1 120
113 primary key null 114,115
114 key , assign:pk=1 116,117
115 key ) assign:pk=1 129
116 , letters examine1 103
117 , foreign examine1 118
118 foreign key null 119
119 key ( null 120
120 ( letters null 121
121 letters ) assign:fk=& 122
122 ) references null 123
123 references letters null 124
124 letters ( assign:fk=& 125
125 ( letters null 126
126 letters ) assign:fk=& 127,128
127 ) , null 117
128 ) ) null 129
129 ) ; null -1
130 datatype , assign:type=& 116,117
131 datatype ) assign:type=& 127,128,129
132 ( number null 133,134
133 number , assign:value=& 97,135,170
134 number ) assign:value=& 98
135 , number null 133,134
136 $ delete null 137
137 delete from create:delete 138
138 from letters null 139,140
139 letters ; assign:tablename=& -1
140 letters where assign:tablename=& 51
141 $ update null 142
142 update letters create:update 143
143 letters set assign:tablename=& 144
144 set letters null 145
145 letters ref assign:column=& 146,147,148
146 ref letters examine2=& 158,160,165
147 ref number examine2=& 155,157,164
148 ref ( examine2=& 149,150,151
149 ( number left++ 155
150 ( letters left++ 157
151 ( ( left++ 149,150,151
152 ) op right++;right>left? 161,162,163
153 ) ) right++;right>left? 152,153,154,166
154 ) where right++;right>left? 51
155 number op assign:value1=& 161,162,163
156 number ) inStack:& 152,153,154,166
157 number where assign:value1=& 51
158 letters op assign:value1=& 161,162,163
159 letters ) null 152,153,154,166
160 letters where assign:value1=& 51
161 op letters inStack:& 158,159,160,165
162 op number inStack:& 155,156,157,164
163 op ( inStack 149,150,151
164 number , assign:value1=& 167
165 letters , assign:value1=& 167
166 ) , right++;right>left? 167
167 , letters left==right?left=right=0 145
168 ( null null 169,171
169 null , assign:value=& 97,135,170
170 , null null 169,171
171 null ) assign:value=& 98
172 select op create:select 173
173 op from examine3=& 40
174 ) as null 175
175 as letters null 176,177
176 letters , assign:othername=& 44
177 letters from assign:othername=& 40
178 number asc assign:by=& 73
179 number desc assign:by=& 74