关于一个mysql的语法有关问题别看那么多代码，只要看与数据库有关的就行.doc

关于一个mysql的语法有关问题别看那么多代码,只要看与数据库有关的就行å…?äº?ä??ä?ªmysqlçš„è??æ??é??é??ï?Œåˆ?看é‚?ä?ˆå,šä??ç•ï?Œåªè?•çœ‹ä??æ??æ??åº?有å…?çš„å??è?Œè?ƒè??çš„æ??å??ï?Œç??é?µå??ä?,æ??å??è??è?Œï?Œä?†å??å??出ç??å?‚ä?‹é??è??ï?:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear''atline1æˆ?çš„ä??ä?ªjavaç??ä??ç•å?‚ä?‹ï?šæˆ?æ??ç??é??é??出åœ?showMyCartï?ˆï?‰æ??æ??ä??ï?Œå›ä?ºæˆ?æ??æ?åº?ä??ï?Œgoodsidæ??intå?‹ï?Œè?Œåœ?è?,æ??æ??ä??çš„goodsidæ??Stringå?‹ï?Œä?†æ??å??èƒ?æ??å??è??è?Œï?Œæˆ?å?ˆçº?é??â??â??è??指æ??ï?•è??è??lassMyCar{HashMaphm=newHashMap();privateConnectionct=null;privateStatementst=null;privateResultSetrs=null;//æ??åŠè??ç‰?publicvoidaddGoods(Stringgoodsid,intgoodsnum){(goodsid,goodsnum);}//åˆé?,è??ç‰?publicvoiddelGoods(Stringgoodsid){(goodsid);}//æ?…ç?ºè??ç‰?publicvoidclear(){();}//ä??æ??è??ç‰?publicvoidupGoods(Stringgoodsid,intnewnum){(goodsid,newnum);}publicArrayListshowMyCart(){ArrayListal=newArrayList();try{//ç?„ç?‡sqlStringsql=select*fromgoodswheregoodsidin;//ä??ç??è??ä??å??Iteratorit=().iterator();Stringsub=(;while(()){StringgoodsId=(String)();//intgoodsid=(goodId);if(()){sub+=goodsId+,;}else{sub+=goodsId+);}}sql+=sub;ct=newConnDb().getConn();st=(