NutzCN Logo
问答 为什么生成的sql部分有双引号,部分没有呢
发布于 1611天前 作者 mulhyac 901 次浏览 复制 上一个帖子 下一个帖子
标签:

为什么生成的sql部分有双引号,部分没有呢


org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO movie("director","screenwriter","main_actor","movie_type","official_website","country","language","release_date","movie_length","alias_title","imdb",director_json,actor_json,title,one_star,two_star,three_star,four_star,five_star,movie_type,release_date,imdb,movie_year,movie_intro,average_score,score_num,source_id) VALUES('["安东尼·罗素", "乔·罗素"]','["克里斯托弗·马库斯", "斯蒂芬·麦克菲利", "斯坦·李", "杰克·科比", "吉姆·斯特林"]','["小罗伯特·唐尼", "克里斯·埃文斯", "马克·鲁弗洛", "克里斯·海姆斯沃斯", "斯嘉丽·约翰逊", "杰瑞米·雷纳", "保罗·路德", "凯伦·吉兰", "唐·钱德尔", "布丽·拉尔森", "布莱德利·库珀", "泰莎·汤普森", "汤姆·赫兰德", "伊丽莎白·奥尔森", "本尼迪克特·康伯巴奇", "蒂尔达·斯文顿", "格温妮斯·帕特洛", "蕾妮·罗素", "约翰·斯拉特里", "查德维克·博斯曼", "安东尼·麦凯", "塞巴斯蒂安·斯坦", "克里斯·帕拉特", "汤姆·希德勒斯顿", "佐伊·索尔达娜", "丹娜·奎里拉", "本尼迪克特·王", "庞·克莱门捷夫", "戴夫·巴蒂斯塔", "利蒂希娅·赖特", "伊万杰琳·莉莉", "乔恩·费儒", "海莉·阿特维尔", "娜塔莉·波特曼", "玛丽莎·托梅", "塔伊加·维迪提", "安吉拉·贝塞特", "迈克尔·道格拉斯", "米歇尔·菲佛", "威廉·赫特", "寇碧·史莫德斯", "肖恩·古恩", "温斯顿·杜克", "琳达·卡德里尼", "马克斯米利亚诺·赫尔南德斯", "弗兰克·格里罗", "真田广之", "汤姆-沃恩-劳勒", "詹姆斯·达西", "雅各布·巴特朗", "范·迪塞尔", "罗伯特·雷德福", "乔什·布洛林", "塞缪尔·杰克逊", "伊薇特·尼科尔·布朗", "卡梅伦·布鲁姆布罗", "蒂莫西·卡尔", "凯瑞·康顿", "迈克尔·A·库克", "凯莉·库恩", "艾玛·福尔曼", "雷纳·加拉赫", "丹妮拉·加斯基", "郑肯", "小弗洛伊德·安东尼·约翰", "斯坦·李", "罗斯·马昆德", "布伦特·麦吉", "迈克尔·皮耶里诺·米勒", "卡兰·马尔韦", "泰瑞·诺塔里", "吉米·雷·皮肯斯", "迈克尔·詹姆斯·肖", "泰·辛普金斯", "格雷格·蒂芬"]','["动作", "科幻", "奇幻", "冒险"]','["www.marvel.com/movies/avengers-endgame"]','["美国"]','["英语 / 日语 / 科萨语"]','["2019-04-24(中国大陆)", "2019-04-26(美国)"]','["181分钟"]','["复仇者联盟3:无尽之战(下) / 复联4 / Avengers: Infinity War - Part II / The Avengers 3: Part 2 / The Avengers 4: Endgame / AVG4"]','["tt4154796"]','[{"@type":"Person","url":"/celebrity/1321812/","name":"安东尼·罗素 Anthony Russo"}, {"@type":"Person","url":"/celebrity/1320870/","name":"乔·罗素 Joe Russo"}]','[{"@type":"Person","url":"/celebrity/1016681/","name":"小罗伯特·唐尼 Robert Downey Jr."}, {"@type":"Person","url":"/celebrity/1017885/","name":"克里斯·埃文斯 Chris Evans"}, {"@type":"Person","url":"/celebrity/1040505/","name":"马克·鲁弗洛 Mark Ruffalo"}, {"@type":"Person","url":"/celebrity/1021959/","name":"克里斯·海姆斯沃斯 Chris Hemsworth"}, {"@type":"Person","url":"/celebrity/1054453/","name":"斯嘉丽·约翰逊 Scarlett Johansson"}, {"@type":"Person","url":"/celebrity/1013770/","name":"杰瑞米·雷纳 Jeremy Renner"}, {"@type":"Person","url":"/celebrity/1002667/","name":"保罗·路德 Paul Rudd"}, {"@type":"Person","url":"/celebrity/1036344/","name":"凯伦·吉兰 Karen Gillan"}, {"@type":"Person","url":"/celebrity/1053573/","name":"唐·钱德尔 Don Cheadle"}, {"@type":"Person","url":"/celebrity/1027194/","name":"布丽·拉尔森 Brie Larson"}, {"@type":"Person","url":"/celebrity/1013757/","name":"布莱德利·库珀 Bradley Cooper"}, {"@type":"Person","url":"/celebrity/1027395/","name":"泰莎·汤普森 Tessa Thompson"}, {"@type":"Person","url":"/celebrity/1325351/","name":"汤姆·赫兰德 Tom Holland"}, {"@type":"Person","url":"/celebrity/1129847/","name":"伊丽莎白·奥尔森 Elizabeth Olsen"}, {"@type":"Person","url":"/celebrity/1009405/","name":"本尼迪克特·康伯巴奇 Benedict Cumberbatch"}, {"@type":"Person","url":"/celebrity/1025152/","name":"蒂尔达·斯文顿 Tilda Swinton"}, {"@type":"Person","url":"/celebrity/1018985/","name":"格温妮斯·帕特洛 Gwyneth Paltrow"}, {"@type":"Person","url":"/celebrity/1004610/","name":"蕾妮·罗素 Rene Russo"}, {"@type":"Person","url":"/celebrity/1022661/","name":"约翰·斯拉特里 John Slattery"}, {"@type":"Person","url":"/celebrity/1327680/","name":"查德维克·博斯曼 Chadwick Boseman"}, {"@type":"Person","url":"/celebrity/1027217/","name":"安东尼·麦凯 Anthony Mackie"}, {"@type":"Person","url":"/celebrity/1021985/","name":"塞巴斯蒂安·斯坦 Sebastian Stan"}, {"@type":"Person","url":"/celebrity/1017967/","name":"克里斯·帕拉特 Chris Pratt"}, {"@type":"Person","url":"/celebrity/1004596/","name":"汤姆·希德勒斯顿 Tom Hiddleston"}, {"@type":"Person","url":"/celebrity/1047985/","name":"佐伊·索尔达娜 Zoe Saldana"}, {"@type":"Person","url":"/celebrity/1308787/","name":"丹娜·奎里拉 Danai Gurira"}, {"@type":"Person","url":"/celebrity/1301179/","name":"本尼迪克特·王 Benedict Wong"}, {"@type":"Person","url":"/celebrity/1313255/","name":"庞·克莱门捷夫 Pom Klementieff"}, {"@type":"Person","url":"/celebrity/1014003/","name":"戴夫·巴蒂斯塔 Dave Bautista"}, {"@type":"Person","url":"/celebrity/1356810/","name":"利蒂希娅·赖特 Letitia Wright"}, {"@type":"Person","url":"/celebrity/1021963/","name":"伊万杰琳·莉莉 Evangeline Lilly"}, {"@type":"Person","url":"/celebrity/1027164/","name":"乔恩·费儒 Jon Favreau"}, {"@type":"Person","url":"/celebrity/1000051/","name":"海莉·阿特维尔 Hayley Atwell"}, {"@type":"Person","url":"/celebrity/1054454/","name":"娜塔莉·波特曼 Natalie Portman"}, {"@type":"Person","url":"/celebrity/1047974/","name":"玛丽莎·托梅 Marisa Tomei"}, {"@type":"Person","url":"/celebrity/1076354/","name":"塔伊加·维迪提 Taika Waititi"}, {"@type":"Person","url":"/celebrity/1025214/","name":"安吉拉·贝塞特 Angela Bassett"}, {"@type":"Person","url":"/celebrity/1053620/","name":"迈克尔·道格拉斯 Michael Douglas"}, {"@type":"Person","url":"/celebrity/1035642/","name":"米歇尔·菲佛 Michelle Pfeiffer"}, {"@type":"Person","url":"/celebrity/1031849/","name":"威廉·赫特 William Hurt"}, {"@type":"Person","url":"/celebrity/1000018/","name":"寇碧·史莫德斯 Cobie Smulders"}, {"@type":"Person","url":"/celebrity/1022552/","name":"肖恩·古恩 Sean Gunn"}, {"@type":"Person","url":"/celebrity/1362864/","name":"温斯顿·杜克 Winston Duke"}, {"@type":"Person","url":"/celebrity/1010545/","name":"琳达·卡德里尼 Linda Cardellini"}, {"@type":"Person","url":"/celebrity/1339359/","name":"马克斯米利亚诺·赫尔南德斯 Maximiliano Hernández"}, {"@type":"Person","url":"/celebrity/1100321/","name":"弗兰克·格里罗 Frank Grillo"}, {"@type":"Person","url":"/celebrity/1027879/","name":"真田广之 Hiroyuki Sanada"}, {"@type":"Person","url":"/celebrity/1332428/","name":"汤姆-沃恩-劳勒 Tom Vaughan-Lawlor"}, {"@type":"Person","url":"/celebrity/1049713/","name":"詹姆斯·达西 James D'Arcy"}, {"@type":"Person","url":"/celebrity/1376777/","name":"雅各布·巴特朗 Jacob Batalon"}, {"@type":"Person","url":"/celebrity/1041020/","name":"范·迪塞尔 Vin Diesel"}, {"@type":"Person","url":"/celebrity/1053617/","name":"罗伯特·雷德福 Robert Redford"}, {"@type":"Person","url":"/celebrity/1004568/","name":"乔什·布洛林 Josh Brolin"}, {"@type":"Person","url":"/celebrity/1054408/","name":"塞缪尔·杰克逊 Samuel L. Jackson"}, {"@type":"Person","url":"/celebrity/1210466/","name":"伊薇特·尼科尔·布朗 Yvette Nicole Brown"}, {"@type":"Person","url":"/celebrity/1392731/","name":"卡梅伦·布鲁姆布罗 Cameron Brumbelow"}, {"@type":"Person","url":"/celebrity/1392730/","name":"蒂莫西·卡尔 Timothy Carr"}, {"@type":"Person","url":"/celebrity/1013874/","name":"凯瑞·康顿 Kerry Condon"}, {"@type":"Person","url":"/celebrity/1392741/","name":"迈克尔·A·库克 Michael A. Cook"}, {"@type":"Person","url":"/celebrity/1342808/","name":"凯莉·库恩 Carrie Coon"}, {"@type":"Person","url":"/celebrity/1321687/","name":"艾玛·福尔曼 Emma Fuhrmann"}, {"@type":"Person","url":"/celebrity/1392734/","name":"雷纳·加拉赫 Renah Gallagher"}, {"@type":"Person","url":"/celebrity/1392732/","name":"丹妮拉·加斯基 Daniela Gaskie"}, {"@type":"Person","url":"/celebrity/1275017/","name":"郑肯 Ken Jeong"}, {"@type":"Person","url":"/celebrity/1392722/","name":"小弗洛伊德·安东尼·约翰 Floyd Anthony Johns Jr."}, {"@type":"Person","url":"/celebrity/1013888/","name":"斯坦·李 Stan Lee"}, {"@type":"Person","url":"/celebrity/1348037/","name":"罗斯·马昆德 Ross Marquand"}, {"@type":"Person","url":"/celebrity/1392739/","name":"布伦特·麦吉 Brent McGee"}, {"@type":"Person","url":"/celebrity/1392737/","name":"迈克尔·皮耶里诺·米勒 Michael Pierino Miller"}, {"@type":"Person","url":"/celebrity/1126747/","name":"卡兰·马尔韦 Callan Mulvey"}, {"@type":"Person","url":"/celebrity/1341026/","name":"泰瑞·诺塔里 Terry Notary"}, {"@type":"Person","url":"/celebrity/1133195/","name":"吉米·雷·皮肯斯 Jimmy Ray Pickens"}, {"@type":"Person","url":"/celebrity/1344984/","name":"迈克尔·詹姆斯·肖 Michael James Shaw"}, {"@type":"Person","url":"/celebrity/1322702/","name":"泰·辛普金斯 Ty Simpkins"}, {"@type":"Person","url":"/celebrity/1392736/","name":"格雷格·蒂芬 Greg Tiffan"}, {"@type":"Person","url":"/celebrity/1415181/","name":"艾娃·罗素 Ava Russo"}, {"@type":"Person","url":"/celebrity/1320870/","name":"乔·罗素 Joe Russo"}, {"@type":"Person","url":"/celebrity/1392738/","name":"玛丽亚·Z·威尔逊 Maria Z. Wilson"}, {"@type":"Person","url":"/celebrity/1392735/","name":"本杰明·韦弗 Benjamin Weaver"}, {"@type":"Person","url":"/celebrity/1392728/","name":"劳尔·阿尔坎塔 Raul Alcantar"}, {"@type":"Person","url":"/celebrity/1392727/","name":"雅各布·埃文斯 Jacob Evans"}, {"@type":"Person","url":"/celebrity/1411163/","name":"何塞·阿尔弗雷多·费尔南德斯 José Alfredo Fernandez"}, {"@type":"Person","url":"/celebrity/1392726/","name":"布伦特·莫雷尔·加斯金斯 Brent Moorer Gaskins"}, {"@type":"Person","url":"/celebrity/1266890/","name":"安东尼·B·哈里斯 Anthony B. Harris"}, {"@type":"Person","url":"/celebrity/1392740/","name":"肖恩·麦克米伦 Shaun McMillan"}, {"@type":"Person","url":"/celebrity/1392724/","name":"罗伯特·佩恩 Robert Payen"}, {"@type":"Person","url":"/celebrity/1392725/","name":"麦克斯威尔·海史密斯 Maxwell Highsmith"}, {"@type":"Person","url":"/celebrity/1402482/","name":"罗伯特·廷斯利 Robert Tinsley"}, {"@type":"Person","url":"/celebrity/1393240/","name":"费斯·洛根 Faith Logan"}, {"@type":"Person","url":"/celebrity/1392723/","name":"保罗·皮尔斯伯里 Paul Pillsbury"}, {"@type":"Person","url":"/celebrity/1392752/","name":"特拉维斯·汤普森 Travis Thompson"}, {"@type":"Person","url":"/celebrity/1415276/","name":"亚历珊德拉\\u2027瑞秋·拉贝 Alexandra Rachael Rabe"}, {"@type":"Person","url":"/celebrity/1392777/","name":"贾迈尔·钱伯斯 Jamel Chambers"}, {"@type":"Person","url":"/celebrity/1412334/","name":"杰克逊·艾顿 Jackson A. Dunn"}]','复仇者联盟4:终局之战 Avengers: Endgame','47.8%','34.7%','14.9%','1.8%','0.8%','["动作", "科幻", "奇幻", "冒险"]','["2019-04-24(中国大陆)", "2019-04-26(美国)"]','www.marvel.com/movies/avengers-endgame','2019','  一声响指,宇宙间半数生命灰飞烟灭。几近绝望的复仇者们在惊奇队长(布丽·拉尔森 Brie Larson 饰)的帮助下找到灭霸(乔什·布洛林 Josh Brolin 饰)归隐之处,却得知六颗无限宝石均被销毁,希望彻底破灭。如是过了五年,迷失在量子领域的蚁人(保罗·路德 Paul Rudd 饰)意外回到现实世界,他的出现为幸存的复仇者们点燃了希望。与美国队长(克里斯·埃文斯 Chris Evans 饰)冰释前嫌的托尼(小罗伯特·唐尼 Robert Downey Jr. 饰)找到了穿越时空的方法,星散各地的超级英雄再度集结,他们分别穿越不同的时代去搜集无限宝石。而在这一过程中,平行宇宙的灭霸察觉了他们的计划。   注定要载入史册的最终决战,超级英雄们为了心中恪守的信念前仆后继……','8.5','710881','30') ' PreparedStatement: 'INSERT INTO movie("director","screenwriter","main_actor","movie_type","official_website","country","language","release_date","movie_length","alias_title","imdb",director_json,actor_json,title,one_star,two_star,three_star,four_star,five_star,movie_type,release_date,imdb,movie_year,movie_intro,average_score,score_num,source_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ' CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"director","screenwriter","main_actor","movie_type","official_website","country"' at line 1
Record basic = getVideo(record, document);
        basic.put("source_id", record.getInt("source_id"));
        int count = dao.count("movie", Cnd.where("source_id", "=", basic.getInt("source_id")));
        if (count == 0) {
            basic.put(".table", "movie");
            basic.put("source_id", record.getString("source_id"));
            dao.insert(basic);
        }
2 回复

把basic的内容贴一下

我觉得是你的json的key值就带了双引号,不是key外面是双引号,是key值本身就带了双引号

例如

{
    "\"abc\"": 123
}

不带双引号那些key才是正确的,mysql的insert没有双引号

添加回复
请先登陆
回到顶部