Question

关键词“where”附近有语法错误

public static int Update(Model.product info)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Product set ");

strSql.Append(" FenLeiId = '" + info.FenLeiId + "',");
strSql.Append(" FenLeiName = '" + info.FenLeiName + "',");
strSql.Append(" ProductName = '" + info.ProductName + "',");
strSql.Append(" sImg = '" + info.sImg + "',");
strSql.Append(" Content = '" + info.Content + "',");
strSql.Append(" where id=" + info.Id);
return DBConn.DB.ExecuteSql(strSql.ToString());
}
#endregion

Answer 1

set后要写上把什么字段值设置为什么,例如: update 学生表 set 奖学金=2000 where(班编号='1001' and 奖学金=1000)

Answer 2

where 前面多一个逗号

追问

还是不对啊