Mysql语句转义

String sqlStr = "SELECT * FROM t_sys_dic WHERE idPath LIKE" + "'" + "/19/20/%" + "'" +" AND flag =1 AND isLeaf =1 AND attribute LIKE '" + "%\"branch\":1%'"

 \"branch\"  即 "branch"

posted @ 2018-12-21 18:53  Peter.Jones  阅读(1016)  评论(0)    收藏  举报