DBCommonMethods.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674
  1. package com.persagy.old.dao;
  2. import com.persagy.old.common.DateUtil;
  3. import com.persagy.old.common.ToolsUtil;
  4. import com.sagacloud.json.JSONArray;
  5. import com.sagacloud.json.JSONObject;
  6. import net.minidev.json.JSONValue;
  7. import org.slf4j.Logger;
  8. import org.slf4j.LoggerFactory;
  9. import java.util.Arrays;
  10. public class DBCommonMethods {
  11. private static final Logger log = LoggerFactory.getLogger(DBCommonMethods.class);
  12. /**
  13. *
  14. * 功能描述:插入记录
  15. * @param tableName
  16. * @param jsonStr
  17. * @return
  18. * @创建者 wanghailong
  19. * @邮箱 wanghailong@persagy.com
  20. * @修改描述
  21. */
  22. public static String insertRecord(String tableName, String jsonStr) {
  23. return insertRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  24. }
  25. /**
  26. *
  27. * 功能描述:插入记录,指定操作的数据库
  28. * @param Database
  29. * @param tableName
  30. * @param jsonStr
  31. * @return
  32. * @创建者 wanghailong
  33. * @邮箱 wanghailong@persagy.com
  34. * @修改描述
  35. */
  36. public static String insertRecord(String Database, String tableName, String jsonStr) {
  37. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  38. JSONObject insertObject = (JSONObject) dataJson.get("insertObject");
  39. insertObject = processInsertObj(insertObject);
  40. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  41. bodyNode.put("QueryType", "insert");
  42. bodyNode.put("Database", Database);
  43. bodyNode.put("Datatable", tableName);
  44. bodyNode.put("InsertObject", dataJson.get("insertObject"));
  45. log.info(bodyNode.toString());
  46. try {
  47. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  48. // log.info(result);
  49. return result;
  50. } catch (Exception e) {
  51. e.printStackTrace();
  52. log.error("请求异常:",e);
  53. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  54. }
  55. }
  56. /**
  57. *
  58. * 功能描述:插入记录,指定操作的数据库
  59. * @param Database
  60. * @param tableName
  61. * @param jsonStr
  62. * @return
  63. * @创建者 wanghailong
  64. * @邮箱 wanghailong@persagy.com
  65. * @修改描述
  66. */
  67. public static String insertRecord(String Database, String tableName, String jsonStr, boolean notUpdateTime) {
  68. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  69. JSONObject insertObject = (JSONObject) dataJson.get("insertObject");
  70. // insertObject = processInsertObj(insertObject);
  71. // 添加数据有效状态,true-有效,false-无效
  72. insertObject.put(DBConst.TABLE_FIELD_VALID, true);
  73. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  74. bodyNode.put("QueryType", "insert");
  75. bodyNode.put("Database", Database);
  76. bodyNode.put("Datatable", tableName);
  77. bodyNode.put("InsertObject", dataJson.get("insertObject"));
  78. log.info(bodyNode.toString());
  79. try {
  80. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  81. // log.info(result);
  82. return result;
  83. } catch (Exception e) {
  84. e.printStackTrace();
  85. log.error("请求异常:",e);
  86. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  87. }
  88. }
  89. /**
  90. *
  91. * 功能描述:插入一批记录,指定操作的数据库
  92. * @param tableName
  93. * @param jsonStr
  94. * @return
  95. * @创建者 wanghailong
  96. * @邮箱 wanghailong@persagy.com
  97. * @修改描述
  98. */
  99. public static String insertBatchRecord(String tableName, String jsonStr) {
  100. return insertBatchRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  101. }
  102. /**
  103. *
  104. * 功能描述:插入一批记录,指定操作的数据库
  105. * @param Database
  106. * @param tableName
  107. * @param jsonStr
  108. * @return
  109. * @创建者 wanghailong
  110. * @邮箱 wanghailong@persagy.com
  111. * @修改描述
  112. */
  113. public static String insertBatchRecord(String Database, String tableName, String jsonStr) {
  114. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  115. JSONArray insertObjects = (JSONArray) dataJson.get("insertObjects");
  116. insertObjects = processInsertArray(insertObjects);
  117. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  118. bodyNode.put("QueryType", "batch_insert");
  119. bodyNode.put("Database", Database);
  120. bodyNode.put("Datatable", tableName);
  121. bodyNode.put("InsertObjects", insertObjects);
  122. log.info(bodyNode.toString());
  123. try {
  124. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  125. // log.info(result);
  126. return result;
  127. } catch (Exception e) {
  128. e.printStackTrace();
  129. log.error("请求异常:",e);
  130. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  131. }
  132. }
  133. /**
  134. *
  135. * 功能描述:修改记录
  136. * @param tableName
  137. * @param jsonStr
  138. * @return
  139. * @创建者 wanghailong
  140. * @邮箱 wanghailong@persagy.com
  141. * @修改描述
  142. */
  143. public static String updateRecord(String tableName, String jsonStr) {
  144. return updateRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  145. }
  146. /**
  147. *
  148. * 功能描述:修改记录
  149. * @param Database
  150. * @param tableName
  151. * @param jsonStr
  152. * @return
  153. * @创建者 wanghailong
  154. * @邮箱 wanghailong@persagy.com
  155. * @修改描述
  156. */
  157. public static String updateRecord(String Database, String tableName, String jsonStr) {
  158. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  159. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  160. JSONObject set = (JSONObject) dataJson.get("set");
  161. // 添加更新时间
  162. set.put(DBConst.TABLE_FIELD_UPDATE_TIME, DateUtil.getNowTimeStr());
  163. bodyNode.put("QueryType", "update");
  164. bodyNode.put("Database", Database);
  165. bodyNode.put("Datatable", tableName);
  166. bodyNode.put("Criteria", dataJson.get("criteria"));
  167. bodyNode.put("Set", set);
  168. log.info(bodyNode.toString());
  169. try {
  170. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  171. // log.info(result);
  172. return result;
  173. } catch (Exception e) {
  174. e.printStackTrace();
  175. log.error("请求异常:",e);
  176. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  177. }
  178. }
  179. /**
  180. *
  181. * 功能描述:修改记录
  182. * @param Database
  183. * @param tableName
  184. * @param jsonStr
  185. * @return
  186. * @创建者 wanghailong
  187. * @邮箱 wanghailong@persagy.com
  188. * @修改描述
  189. */
  190. public static String updateRecord(String Database, String tableName, String jsonStr, boolean notUpdateTime) {
  191. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  192. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  193. JSONObject set = (JSONObject) dataJson.get("set");
  194. bodyNode.put("QueryType", "update");
  195. bodyNode.put("Database", Database);
  196. bodyNode.put("Datatable", tableName);
  197. bodyNode.put("Criteria", dataJson.get("criteria"));
  198. bodyNode.put("Set", set);
  199. log.info(bodyNode.toString());
  200. try {
  201. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  202. // log.info(result);
  203. return result;
  204. } catch (Exception e) {
  205. e.printStackTrace();
  206. log.error("请求异常:",e);
  207. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  208. }
  209. }
  210. public static String updateBatchRecord(String tableName, String jsonStr){
  211. return updateBatchRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  212. }
  213. /**
  214. *
  215. * Description: 批量更新sop发布版本(仅物理世界对象改变时使用,不更新update_time)
  216. * @param tableName
  217. * @param jsonStr
  218. * @return String
  219. * @author yuecaipu
  220. * @since 2018年5月29日: 上午11:15:23
  221. * Update By yuecaipu 2018年5月29日: 上午11:15:23
  222. */
  223. public static String updateBatchPublishStatus(String tableName, String jsonStr){
  224. return updateBatchPublishStatus(DBConst.DATABASE_NAME, tableName, jsonStr);
  225. }
  226. public static String updateBatchRecord(String Database, String tableName, String jsonStr){
  227. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  228. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  229. JSONObject set = (JSONObject) dataJson.get("set");
  230. // 添加更新时间
  231. set.put(DBConst.TABLE_FIELD_UPDATE_TIME, DateUtil.getNowTimeStr());
  232. bodyNode.put("QueryType", "batch_update");
  233. bodyNode.put("Database", Database);
  234. bodyNode.put("Datatable", tableName);
  235. bodyNode.put("Criterias", dataJson.get("criterias"));
  236. bodyNode.put("Set", set);
  237. log.info(bodyNode.toString());
  238. try {
  239. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  240. // log.info(result);
  241. return result;
  242. } catch (Exception e) {
  243. e.printStackTrace();
  244. log.error("请求异常:",e);
  245. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  246. }
  247. }
  248. public static String updateBatchPublishStatus(String Database, String tableName, String jsonStr){
  249. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  250. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  251. JSONObject set = (JSONObject) dataJson.get("set");
  252. bodyNode.put("QueryType", "batch_update");
  253. bodyNode.put("Database", Database);
  254. bodyNode.put("Datatable", tableName);
  255. bodyNode.put("Criterias", dataJson.get("criterias"));
  256. bodyNode.put("Set", set);
  257. log.info(bodyNode.toString());
  258. try {
  259. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  260. // log.info(result);
  261. return result;
  262. } catch (Exception e) {
  263. e.printStackTrace();
  264. log.error("请求异常:",e);
  265. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  266. }
  267. }
  268. /**
  269. *
  270. * 功能描述:删除数据
  271. * @param tableName
  272. * @param jsonStr
  273. * @return
  274. * @创建者 wanghailong
  275. * @邮箱 wanghailong@persagy.com
  276. * @修改描述
  277. */
  278. public static String deleteRecord(String tableName, String jsonStr) {
  279. return deleteRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  280. }
  281. /**
  282. *
  283. * 功能描述:删除数据
  284. * @param Database
  285. * @param tableName
  286. * @param jsonStr
  287. * @return
  288. * @创建者 wanghailong
  289. * @邮箱 wanghailong@persagy.com
  290. * @修改描述
  291. */
  292. public static String deleteRecord(String Database, String tableName, String jsonStr) {
  293. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  294. JSONObject setNode = (JSONObject) JSONValue.parse("{}");
  295. setNode.put(DBConst.TABLE_FIELD_VALID, false);
  296. setNode.put(DBConst.TABLE_FIELD_UPDATE_TIME, DateUtil.getNowTimeStr());
  297. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  298. bodyNode.put("QueryType", "update");
  299. bodyNode.put("Database", Database);
  300. bodyNode.put("Datatable", tableName);
  301. bodyNode.put("Criteria", dataJson.get("criteria"));
  302. bodyNode.put("Set", setNode);
  303. log.info(bodyNode.toString());
  304. try {
  305. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  306. // log.info(result);
  307. return result;
  308. } catch (Exception e) {
  309. e.printStackTrace();
  310. log.error("请求异常:",e);
  311. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  312. }
  313. }
  314. /**
  315. * 功能描述:批量删除数据
  316. * @param tableName
  317. * @param jsonStr
  318. * @return
  319. */
  320. public static String deleteBatchRecord(String tableName, String jsonStr){
  321. return deleteBatchRecord(DBConst.DATABASE_NAME, tableName, jsonStr);
  322. }
  323. /**
  324. * 功能描述:批量删除数据
  325. * @param Database
  326. * @param tableName
  327. * @param jsonStr
  328. * @return
  329. */
  330. public static String deleteBatchRecord(String Database, String tableName, String jsonStr){
  331. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  332. JSONObject setNode = (JSONObject) JSONValue.parse("{}");
  333. setNode.put(DBConst.TABLE_FIELD_VALID, false);
  334. setNode.put(DBConst.TABLE_FIELD_UPDATE_TIME, DateUtil.getNowTimeStr());
  335. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  336. bodyNode.put("QueryType", "batch_update");
  337. bodyNode.put("Database", Database);
  338. bodyNode.put("Datatable", tableName);
  339. bodyNode.put("Criterias", dataJson.get("criterias"));
  340. bodyNode.put("Set", setNode);
  341. log.info(bodyNode.toString());
  342. try {
  343. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  344. // log.info(result);
  345. return result;
  346. } catch (Exception e) {
  347. e.printStackTrace();
  348. log.error("请求异常:",e);
  349. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  350. }
  351. }
  352. /**
  353. *
  354. * 功能描述:根据主键查询一条记录数据
  355. * @param tableName
  356. * @param jsonStr
  357. * @return
  358. * @创建者 wanghailong
  359. * @邮箱 wanghailong@persagy.com
  360. * @修改描述
  361. */
  362. public static String getRecordBykey(String tableName, String jsonStr) {
  363. return getRecordBykey(DBConst.DATABASE_NAME, tableName, jsonStr);
  364. }
  365. /**
  366. *
  367. * 功能描述:根据主键查询一条记录数据
  368. * @param Database
  369. * @param tableName
  370. * @param jsonStr
  371. * @return
  372. * @创建者 wanghailong
  373. * @邮箱 wanghailong@persagy.com
  374. * @修改描述
  375. */
  376. public static String getRecordBykey(String Database, String tableName, String jsonStr) {
  377. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  378. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  379. bodyNode.put("QueryType", "get");
  380. bodyNode.put("Database", Database);
  381. bodyNode.put("Datatable", tableName);
  382. bodyNode.put("Key", dataJson.get("Key"));
  383. log.info(bodyNode.toString());
  384. try {
  385. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  386. // log.info(result);
  387. return result;
  388. } catch (Exception e) {
  389. e.printStackTrace();
  390. log.error("请求异常:",e);
  391. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  392. }
  393. }
  394. /**
  395. *
  396. * 功能描述:根据主键查询多条记录数据
  397. * @param tableName
  398. * @param jsonStr
  399. * @return
  400. * @创建者 wanghailong
  401. * @邮箱 wanghailong@persagy.com
  402. * @修改描述
  403. */
  404. public static String getBatchRecordBykeys(String tableName, String jsonStr) {
  405. return getBatchRecordBykeys(DBConst.DATABASE_NAME, tableName, jsonStr);
  406. }
  407. /**
  408. *
  409. * 功能描述:根据主键查询多条记录数据
  410. * @param Database
  411. * @param tableName
  412. * @param jsonStr
  413. * @return
  414. * @创建者 wanghailong
  415. * @邮箱 wanghailong@persagy.com
  416. * @修改描述
  417. */
  418. public static String getBatchRecordBykeys(String Database, String tableName, String jsonStr) {
  419. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  420. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  421. bodyNode.put("QueryType", "batch_get");
  422. bodyNode.put("Database", Database);
  423. bodyNode.put("Datatable", tableName);
  424. bodyNode.put("Keys", dataJson.get("keys"));
  425. bodyNode.put("ReturnColumns", dataJson.get("ReturnColumns"));
  426. log.info(bodyNode.toString());
  427. try {
  428. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  429. // log.info(result);
  430. return result;
  431. } catch (Exception e) {
  432. e.printStackTrace();
  433. log.error("请求异常:",e);
  434. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  435. }
  436. }
  437. /**
  438. *
  439. * 功能描述:查询所有数据,包括无效数据
  440. * @param tableName
  441. * @return
  442. * @创建者 wanghailong
  443. * @邮箱 wanghailong@persagy.com
  444. * @修改描述
  445. */
  446. public static String queryAllRecord( String tableName) {
  447. String jsonStr = "{\"criteria\":{}}" ;
  448. return queryRecordByCriteria(DBConst.DATABASE_NAME, tableName, jsonStr);
  449. }
  450. /**
  451. *
  452. * 功能描述:查询所有数据,包括无效数据
  453. * @param tableName
  454. * @return
  455. * @创建者 wanghailong
  456. * @邮箱 wanghailong@persagy.com
  457. * @修改描述
  458. */
  459. public static String queryAllRecord(String dataSource, String tableName) {
  460. String jsonStr = "{\"criteria\":{}}" ;
  461. return queryRecordByCriteria(dataSource, tableName, jsonStr);
  462. }
  463. /**
  464. *
  465. * 功能描述:查询所有有效数据
  466. * @param tableName
  467. * @return
  468. * @创建者 wanghailong
  469. * @邮箱 wanghailong@persagy.com
  470. * @修改描述
  471. */
  472. public static String queryAllValidRecord( String tableName) {
  473. String jsonStr = "{\"criteria\":{}}" ;
  474. return queryValidRecordByCriteria(DBConst.DATABASE_NAME, tableName, jsonStr);
  475. }
  476. /**
  477. *
  478. * 功能描述:查询符合条件的数据,包括无效数据
  479. * @param tableName
  480. * @param jsonStr
  481. * @return
  482. * @创建者 wanghailong
  483. * @邮箱 wanghailong@persagy.com
  484. * @修改描述
  485. */
  486. public static String queryRecordByCriteria( String tableName, String jsonStr) {
  487. return queryRecordByCriteria(DBConst.DATABASE_NAME, tableName, jsonStr);
  488. }
  489. /**
  490. *
  491. * 功能描述:查询符合条件的数据,包括无效数据
  492. * @param Database
  493. * @param tableName
  494. * @param jsonStr
  495. * @return
  496. * @创建者 wanghailong
  497. * @邮箱 wanghailong@persagy.com
  498. * @修改描述
  499. */
  500. public static String queryRecordByCriteria(String Database, String tableName, String jsonStr) {
  501. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  502. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  503. bodyNode.put("QueryType", "select");
  504. bodyNode.put("Database", Database);
  505. bodyNode.put("Datatable", tableName);
  506. bodyNode.put("Criteria", dataJson.get("criteria"));
  507. log.info(bodyNode.toString());
  508. try {
  509. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  510. // log.info(result);
  511. return result;
  512. } catch (Exception e) {
  513. e.printStackTrace();
  514. log.error("请求异常:",e);
  515. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  516. }
  517. }
  518. /**
  519. * 功能描述:批量查询符合条件的数据,并合并,包括无效数据
  520. * @param tableName
  521. * @param jsonStr
  522. * @return
  523. */
  524. public static String queryBathchMergeRecordByCriterias(String tableName, String jsonStr){
  525. return queryBathchMergeRecordByCriterias(DBConst.DATABASE_NAME, tableName, jsonStr);
  526. }
  527. /**
  528. * 功能描述:批量查询符合条件的数据,并合并,包括无效数据
  529. * @param dataBase
  530. * @param tableName
  531. * @param jsonStr
  532. * @return
  533. */
  534. public static String queryBathchMergeRecordByCriterias(String dataBase, String tableName, String jsonStr){
  535. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  536. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  537. bodyNode.put("QueryType", "batch_select_merge");
  538. bodyNode.put("Database", dataBase);
  539. bodyNode.put("Datatable", tableName);
  540. bodyNode.put("Criterias", dataJson.get("criterias"));
  541. log.info(bodyNode.toString());
  542. try {
  543. String result = DBAgent.GetAgent().Query(bodyNode).toString();
  544. // log.info(result);
  545. return result;
  546. } catch (Exception e) {
  547. e.printStackTrace();
  548. log.error("请求异常:",e);
  549. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  550. }
  551. }
  552. /**
  553. *
  554. * 功能描述:查询符合条件的有效数据
  555. * @param tableName
  556. * @param jsonStr
  557. * @return
  558. * @创建者 wanghailong
  559. * @邮箱 wanghailong@persagy.com
  560. * @修改描述
  561. */
  562. public static String queryValidRecordByCriteria( String tableName, String jsonStr) {
  563. return queryValidRecordByCriteria(DBConst.DATABASE_NAME, tableName, jsonStr);
  564. }
  565. /**
  566. *
  567. * 功能描述:查询符合条件的有效数据
  568. * @param Database
  569. * @param tableName
  570. * @param jsonStr
  571. * @return
  572. * @创建者 wanghailong
  573. * @邮箱 wanghailong@persagy.com
  574. * @修改描述
  575. */
  576. public static String queryValidRecordByCriteria(String Database, String tableName, String jsonStr) {
  577. JSONObject dataJson = (JSONObject) JSONValue.parse(jsonStr);
  578. JSONObject bodyNode = (JSONObject) JSONValue.parse("{}");
  579. bodyNode.put("QueryType", "select");
  580. bodyNode.put("Database", Database);
  581. bodyNode.put("Datatable", tableName);
  582. bodyNode.put("Criteria", dataJson.get("criteria"));
  583. log.info(bodyNode.toString());
  584. try {
  585. JSONObject resJson = DBAgent.GetAgent().Query(bodyNode);
  586. JSONArray arr = (JSONArray) resJson.get("Content");
  587. int removeCount = 0;
  588. for (int i = arr.size() - 1; i > -1; i--) {
  589. JSONObject node = (JSONObject) arr.get(i);
  590. if(node.get(DBConst.TABLE_FIELD_VALID) != null && !(Boolean) node.get(DBConst.TABLE_FIELD_VALID)){
  591. arr.remove(i);
  592. removeCount += 1;
  593. }
  594. }
  595. resJson.put("Count", (Long)resJson.get("Count")- removeCount);
  596. // log.info(resJson.toString());
  597. return resJson.toString();
  598. } catch (Exception e) {
  599. e.printStackTrace();
  600. log.error("请求异常:",e);
  601. return ToolsUtil.errorJsonMsg(Arrays.toString(e.getStackTrace()));
  602. }
  603. }
  604. /**
  605. *
  606. * 功能描述:处理新增数据
  607. * @param node
  608. * @return
  609. * @创建者 wanghailong
  610. * @邮箱 wanghailong@persagy.com
  611. * @修改描述
  612. */
  613. private static JSONObject processInsertObj(JSONObject node) {
  614. if(!node.containsKey(DBConst.TABLE_FIELD_CTEATE_TIME)){
  615. // 添加创建时间
  616. node.put(DBConst.TABLE_FIELD_CTEATE_TIME, DateUtil.getNowTimeStr());
  617. }
  618. // 添加更新时间
  619. node.put(DBConst.TABLE_FIELD_UPDATE_TIME, DateUtil.getNowTimeStr());
  620. // 添加数据有效状态,true-有效,false-无效
  621. node.put(DBConst.TABLE_FIELD_VALID, true);
  622. return node;
  623. }
  624. /**
  625. *
  626. * 功能描述:处理新增数据
  627. * @param nodes
  628. * @return
  629. * @创建者 wanghailong
  630. * @邮箱 wanghailong@persagy.com
  631. * @修改描述
  632. */
  633. private static JSONArray processInsertArray(JSONArray nodes) {
  634. JSONArray array = new JSONArray();
  635. for(int i=0; i<nodes.size(); i++){
  636. array.add(processInsertObj((JSONObject) nodes.get(i)));
  637. }
  638. return array;
  639. }
  640. }