expressManager.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
  1. package com.example.xiaoshiweixinback.business.utils.parseQueryToTree;
  2. import java.util.ArrayList;
  3. import java.util.HashMap;
  4. import java.util.List;
  5. import java.util.Stack;
  6. public class expressManager {
  7. HashMap<String, Symbol> hSymbols = new HashMap<String, Symbol>();
  8. private static expressManager instance = new expressManager();
  9. private expressManager() {
  10. //#region 添加逻辑符号
  11. operate oAnd = new operate();
  12. oAnd.Code = "AND";
  13. oAnd.ShowName = "AND";
  14. oAnd.type = enuType.Logic;
  15. oAnd.priorityVale = 11;
  16. oAnd.operateValue = 2;
  17. hSymbols.put(oAnd.Code, oAnd);
  18. operate oOR = new operate();
  19. oOR.Code = "OR";
  20. oOR.ShowName = "OR";
  21. oOR.type = enuType.Logic;
  22. oOR.priorityVale = 11;
  23. oOR.operateValue = 2;
  24. hSymbols.put(oOR.Code, oOR);
  25. oOR = new operate();
  26. oOR.Code = "NOT";
  27. oOR.ShowName = "NOT";
  28. oOR.type = enuType.Logic;
  29. oOR.priorityVale = 12;
  30. oOR.operateValue = 1;
  31. hSymbols.put(oOR.Code, oOR);
  32. oOR = new operate();
  33. oOR.Code = "TO";
  34. oOR.ShowName = "TO";
  35. oOR.type = enuType.Logic;
  36. oOR.priorityVale = 21;
  37. oOR.operateValue = 2;
  38. hSymbols.put(oOR.Code, oOR);
  39. oOR = new operate();
  40. oOR.Code = "~";
  41. oOR.ShowName = "TO";
  42. oOR.type = enuType.Logic;
  43. oOR.priorityVale = 21;
  44. oOR.operateValue = 2;
  45. hSymbols.put(oOR.Code, oOR);
  46. oOR = new operate();
  47. oOR.Code = "=";
  48. oOR.ShowName = "=";
  49. oOR.type = enuType.Assignment;
  50. oOR.priorityVale = 20;
  51. oOR.operateValue = 2;
  52. hSymbols.put(oOR.Code, oOR);
  53. oOR = new operate();
  54. oOR.Code = ">";
  55. oOR.ShowName = ">";
  56. oOR.type = enuType.Assignment;
  57. oOR.priorityVale = 20;
  58. oOR.operateValue = 2;
  59. hSymbols.put(oOR.Code, oOR);
  60. oOR = new operate();
  61. oOR.Code = "<";
  62. oOR.ShowName = "<";
  63. oOR.type = enuType.Assignment;
  64. oOR.priorityVale = 20;
  65. oOR.operateValue = 2;
  66. hSymbols.put(oOR.Code, oOR);
  67. oOR = new operate();
  68. oOR.Code = ">=";
  69. oOR.ShowName = ">=";
  70. oOR.type = enuType.Assignment;
  71. oOR.priorityVale = 20;
  72. oOR.operateValue = 2;
  73. hSymbols.put(oOR.Code, oOR);
  74. oOR = new operate();
  75. oOR.Code = "<=";
  76. oOR.ShowName = "<=";
  77. oOR.type = enuType.Assignment;
  78. oOR.priorityVale = 20;
  79. oOR.operateValue = 2;
  80. hSymbols.put(oOR.Code, oOR);
  81. oOR = new operate();
  82. oOR.Code = "CONTAIN";
  83. oOR.ShowName = " LIKE ";
  84. oOR.type = enuType.Assignment;
  85. oOR.priorityVale = 20;
  86. oOR.operateValue = 2;
  87. hSymbols.put(oOR.Code, oOR);
  88. oOR = new operate();
  89. oOR.Code = "≡";
  90. oOR.ShowName = " LIKE ";
  91. oOR.type = enuType.Assignment;
  92. oOR.priorityVale = 20;
  93. oOR.operateValue = 2;
  94. hSymbols.put(oOR.Code, oOR);
  95. //#endregion
  96. //#region 添加成对出现的符号
  97. pairSymbol first = new pairSymbol();
  98. first.Code = "(";
  99. first.isEndSymbol = false;
  100. pairSymbol end = new pairSymbol();
  101. end.Code = ")";
  102. end.previewSymbol = first;
  103. end.isEndSymbol = true;
  104. hSymbols.put(first.Code, first);
  105. hSymbols.put(end.Code, end);
  106. pairSymbol first1 = new pairSymbol();
  107. first1.Code = "[";
  108. first1.isEndSymbol = false;
  109. pairSymbol end1 = new pairSymbol();
  110. end1.Code = "]";
  111. end1.previewSymbol = first1;
  112. end1.isEndSymbol = true;
  113. hSymbols.put(first1.Code, first1);
  114. hSymbols.put(end1.Code, end1);
  115. end = new pairSymbol();
  116. end.Code = "\"";
  117. end.previewSymbol = end;
  118. hSymbols.put(end.Code, end);
  119. //#endregion
  120. }
  121. public static expressManager getInstance() {
  122. return instance;
  123. }
  124. public Symbol getSymbol(String strSymbol) {
  125. String strKey = strSymbol.trim().toUpperCase();
  126. if ((strKey != null && !strKey.trim().equals("")) && hSymbols.containsKey(strKey)) {
  127. return hSymbols.get(strKey);
  128. } else {
  129. return null;
  130. }
  131. }
  132. /// <summary>
  133. /// 解析表达式字符串,返回表达式树
  134. /// </summary>
  135. /// <param name="strExpress">表达式字符串</param>
  136. /// <param name="isAnd">如果输入的是多个条件,之间的关系是and还是or,true为and,false为or</param>
  137. /// <returns>表达式树节点</returns>
  138. public treeNode Parse(String strExpress, boolean isAnd) throws Exception {
  139. ArrayList<String> Tokens = GetTokens(strExpress);
  140. Stack<Symbol> symbolStack = new Stack<Symbol>();
  141. Stack<treeNode> valueStack = new Stack<treeNode>();
  142. for (String strTem : Tokens) {
  143. Symbol temSymbol = expressManager.getInstance().getSymbol(strTem);
  144. if (temSymbol != null) {
  145. if (temSymbol instanceof operate) {
  146. //#region 如果是操作符,从操作符堆栈中取出优先级大于等于该操作符的结合值堆栈生成节点后压入值堆栈,然后将该操作符压入堆栈
  147. operate temOperate = (operate) temSymbol;
  148. if (symbolStack.size() > 0) {
  149. Symbol lastSymbol = symbolStack.peek();
  150. while (lastSymbol instanceof operate && ((operate) lastSymbol).priorityVale >= temOperate.priorityVale) {
  151. operateNode temSymbolNode = new operateNode();
  152. temSymbolNode.operate = (operate) lastSymbol;
  153. if (((operate) lastSymbol).operateValue == 1) {
  154. temSymbolNode.Right = valueStack.pop();
  155. } else {
  156. temSymbolNode.Right = valueStack.pop();
  157. temSymbolNode.Left = valueStack.pop();
  158. }
  159. valueStack.push(temSymbolNode);
  160. symbolStack.pop();
  161. if (symbolStack.size() > 0) {
  162. lastSymbol = symbolStack.peek();
  163. } else {
  164. break;
  165. }
  166. }
  167. }
  168. symbolStack.push(temSymbol);
  169. //#endregion
  170. } else {
  171. //#region 括号处理
  172. if (temSymbol instanceof pairSymbol && ((pairSymbol) temSymbol).isEndSymbol) {
  173. Symbol lastSymbol = symbolStack.peek();
  174. if (lastSymbol == null) {
  175. throw new Exception("无效的括号!");
  176. }
  177. while (lastSymbol instanceof operate ||
  178. (lastSymbol instanceof pairSymbol && ((pairSymbol) lastSymbol).Code != ((pairSymbol) temSymbol).previewSymbol.Code)) {
  179. operateNode temSymbolNode = new operateNode();
  180. temSymbolNode.operate = (operate) lastSymbol;
  181. if (((operate) lastSymbol).operateValue == 1) {
  182. temSymbolNode.Right = valueStack.pop();
  183. } else {
  184. temSymbolNode.Right = valueStack.pop();
  185. temSymbolNode.Left = valueStack.pop();
  186. }
  187. valueStack.push(temSymbolNode);
  188. symbolStack.pop();
  189. lastSymbol = symbolStack.peek();
  190. }
  191. if ((lastSymbol instanceof pairSymbol && ((pairSymbol) temSymbol).previewSymbol.Code == ((pairSymbol) lastSymbol).Code)) {
  192. symbolStack.pop();
  193. } else {
  194. throw new Exception("无效的括号");
  195. }
  196. } else {
  197. symbolStack.push(temSymbol);
  198. }
  199. //#endregion
  200. }
  201. } else {
  202. valueNode temNode = new valueNode();
  203. temNode.value = strTem;
  204. valueStack.push(temNode);
  205. }
  206. }
  207. while (symbolStack.size() > 0) {
  208. Symbol temSymbol = symbolStack.pop();
  209. if (temSymbol instanceof operate) {
  210. operateNode temNode = new operateNode();
  211. temNode.operate = (operate) temSymbol;
  212. if (((operate) temSymbol).operateValue == 1) {
  213. temNode.Right = valueStack.pop();
  214. } else {
  215. temNode.Right = valueStack.pop();
  216. temNode.Left = valueStack.pop();
  217. }
  218. valueStack.push(temNode);
  219. } else {
  220. throw new Exception("无效的括号!");
  221. }
  222. }
  223. if (valueStack.size() == 1) {
  224. return valueStack.pop();
  225. } else {
  226. if (valueStack.size() > 1) {
  227. List<treeNode> lstValues = new ArrayList<treeNode>();
  228. while (valueStack.size() > 0) {
  229. treeNode temNode = valueStack.pop();
  230. if (temNode instanceof valueNode) {
  231. lstValues.add(temNode);
  232. } else {
  233. throw new Exception("无效的检索式!");
  234. }
  235. }
  236. treeNode retNode = null;
  237. for (treeNode temNode : lstValues) {
  238. if (retNode == null) {
  239. retNode = temNode;
  240. } else {
  241. operateNode sNode = new operateNode();
  242. if (!isAnd) {
  243. sNode.operate = (operate) expressManager.getInstance().getSymbol("OR");
  244. } else {
  245. sNode.operate = (operate) expressManager.getInstance().getSymbol("AND");
  246. }
  247. sNode.Left = retNode;
  248. sNode.Right = temNode;
  249. retNode = sNode;
  250. }
  251. }
  252. return retNode;
  253. }
  254. throw new Exception("无效的检索式!");
  255. }
  256. }
  257. /// <summary>
  258. /// 语法分析,将表达式字符按照空格分开,
  259. /// 且将双引号或者是括号从字符串中拿出来
  260. /// </summary>
  261. /// <param name="strExpress"></param>
  262. /// <returns></returns>
  263. public ArrayList<String> GetTokens(String strExpress) {
  264. if (strExpress != null) {
  265. ArrayList<String> Tokens = new ArrayList<String>();
  266. //#region
  267. String strTem = strExpress.trim();
  268. String strTemToken = "";
  269. Boolean isFindingEndYinHao = false;
  270. int step = -1;
  271. for (int i = 0; i < strTem.length(); i++) {
  272. char c = strTem.charAt(i);
  273. switch (c) {
  274. case '"':
  275. if (!isFindingEndYinHao) {
  276. isFindingEndYinHao = true;
  277. step = i;
  278. } else {
  279. if ((i < strTem.length() - 1 && strTem.charAt(i + 1) == ' ')
  280. || (i < strTem.length() - 1 && strTem.charAt(i + 1) == ')')
  281. || (i < strTem.length() - 1 && strTem.charAt(i + 1) == ']')
  282. || i == strTem.length() - 1) {
  283. strTemToken = strTem.substring(step + 1, i);
  284. Tokens.add(strTemToken);
  285. step = i;
  286. isFindingEndYinHao = false;
  287. }
  288. }
  289. break;
  290. case ' ':
  291. if (!isFindingEndYinHao) {
  292. if (step == (i - 1)) {
  293. step = i;
  294. } else {
  295. strTemToken = strTem.substring(step + 1, i);
  296. Tokens.add(strTemToken);
  297. step = i;
  298. }
  299. }
  300. break;
  301. case '(':
  302. case '[':
  303. if (i == 0 || strTem.charAt(i - 1) == ' ' || (Tokens.size() > 0 && Tokens.get(Tokens.size() - 1) == String.valueOf(c)) || strTem.charAt(i - 1) == '=') {
  304. Tokens.add(String.valueOf(c));
  305. step = i;
  306. }
  307. break;
  308. case ')':
  309. case ']':
  310. if ((i < strTem.length() - 1 && (strTem.charAt(i + 1) == ' ' || strTem.charAt(i + 1) == c)) || i == strTem.length() - 1) {
  311. Boolean isAdd = false;
  312. for (int index = Tokens.size() - 1; index >= 0; index--) {
  313. if ((c == ')' && Tokens.get(index).equals("(")) || (c == ']' && Tokens.get(index).equals("["))) {
  314. isAdd = true;
  315. break;
  316. }
  317. }
  318. if (isAdd) {
  319. strTemToken = strTem.substring(step + 1, i);
  320. if (strTemToken != null && !strTemToken.equals("")) {
  321. Tokens.add(strTemToken);
  322. }
  323. Tokens.add(String.valueOf(c));
  324. step = i;
  325. }
  326. }
  327. break;
  328. case '=':
  329. case '~':
  330. case '>':
  331. case '>':
  332. case '<':
  333. case '<':
  334. strTemToken = strTem.substring(step + 1, i);
  335. if (strTemToken != null && strTemToken != "") {
  336. Tokens.add(strTemToken);
  337. }
  338. if (strTem.charAt(i + 1) == '=') {
  339. Tokens.add(String.valueOf(c) + "=");
  340. step = i + 1;
  341. i++;
  342. } else {
  343. Tokens.add(String.valueOf(c));
  344. step = i;
  345. }
  346. break;
  347. }
  348. }
  349. if (step < strTem.length() - 1) {
  350. Tokens.add(strTem.substring(step + 1));
  351. }
  352. //#endregion
  353. return Tokens;
  354. } else {
  355. return null;
  356. }
  357. }
  358. }