字符串有关问题

字符串问题
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 ";