摘要: mysql> update tab_json set data = json_set(data,"$.address","Guangzhou") where id = 1; #对id = 1的行的address的键值进行修改.Query OK, 1 row affected (0.26 sec)Ro 阅读全文
posted @ 2019-05-30 12:11 Struts-pring 阅读(1051) 评论(0) 推荐(0) 编辑
摘要: dao类 /** * 自定义sql查询 * @param sqlContent * @return */ public List<LinkedHashMap<String, Object>> customQueryItem(String sqlContent); mapper.xml <select 阅读全文
posted @ 2019-05-30 11:37 Struts-pring 阅读(426) 评论(0) 推荐(0) 编辑