日期:2014-05-19  浏览次数:20437 次

字符串问题
private   void   ExecuteTransaction(String   newName,   String   newOtherName)
        {
                String   cmdText= "UPDATE   Users   SET   UserAccount= " '   +   newName   +   ' "           WHERE   UserID=3 ";
  ...

newName这个字符串变量怎么加到SQL语句中

------解决方案--------------------

String cmdText= "UPDATE Users SET UserAccount= ' " + newName + " ' WHERE UserID=3 ";
------解决方案--------------------
= "UPDATE Users SET UserAccount= " ' + newName + ' " WHERE UserID=3 ";


--> >


= "UPDATE Users SET UserAccount= ' " + newName + " ' WHERE UserID=3 ";