代码中的mysql语法问题

今天在代码中写了mysql的删除语句

1    String lpinsuredSQL=" delete from lpinsured a where a.insuredid='?InsuredID?' and a.edorcode='?EdorCode?' and a.edorno='?EdorNo?' ";
2    SQLwithBindVariables sqlbv3=new SQLwithBindVariables();
3    sqlbv3.sql(lpinsuredSQL);
4    sqlbv3.put("InsuredID",mInsuredID);
5    sqlbv3.put("EdorCode","BC");
6    sqlbv3.put("EdorNo",mEdorNo);
7    mMap.put(lpinsuredSQL,"DELETE");//将lpinsured表中的数据删除

这样写完之后，在运行代码的时候，莫名其妙的报错了。

最后自己将别名去掉，在数据库进行执行，执行成功。

 delete from lpinsured where insuredid='testMGU000054' and edorcode='BC' and edorno='EN20190926001' 

所以，以后自己要这样写：

1    String lpinsuredSQL=" delete from lpinsured where insuredid='?InsuredID?' and edorcode='?EdorCode?' and edorno='?EdorNo?' ";
2    SQLwithBindVariables sqlbv3=new SQLwithBindVariables();
3    sqlbv3.sql(lpinsuredSQL);
4    sqlbv3.put("InsuredID",mInsuredID);
5    sqlbv3.put("EdorCode","BC");
6    sqlbv3.put("EdorNo",mEdorNo);
7    mMap.put(lpinsuredSQL,"DELETE");//将lpinsured表中的数据删除

 

posted @ 2019-10-07 10:16  ~码铃薯~  阅读(222)  评论(0)  编辑  收藏  举报