我在更新文章时内容不能更新。是sql语句出的问题

Question

文章更新的问题： 我在更新文章时内容不能更新。是sql语句出的问题update newss set area=@area,author_seq=@author_seq,cited=@cited,city=@city,content=@content,daxue=@daxue,dtt=@dtt,full_address=@full_address,hits=@hits,issue=@issue,nifen=@nifen,page=@page,qikan=@qikan,title=@title,university=@university,volume=@volume,waizuo=@waizuo,zaiyao=@zaiyao,zhongzuo=@zhongzuo, where ID=@ID 象这种update 语句我觉得有问题，那又该怎么改呀
1.  public void Update(Maticsoft.Model.newss model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" update newss set ");
strSql.Append(" area=@area, ");
strSql.Append(" author_seq=@author_seq, ");
strSql.Append(" cited=@cited, ");
strSql.Append(" city=@city, ");
strSql.Append(" content=@content, ");
strSql.Append(" daxue=@daxue, ");
strSql.Append(" dtt=@dtt, ");
strSql.Append(" full_address=@full_address, ");
strSql.Append(" hits=@hits, ");
            //strSql.Append("ID=@ID,");
strSql.Append(" issue=@issue, ");
strSql.Append(" nifen=@nifen, ");
strSql.Append(" page=@page, ");
strSql.Append(" qikan=@qikan, ");
strSql.Append(" title=@title, ");
strSql.Append(" university=@university, ");
strSql.Append(" volume=@volume, ");
strSql.Append(" waizuo=@waizuo, ");
strSql.Append(" zaiyao=@zaiyao, ");
strSql.Append(" zhongzuo=@zhongzuo, ");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters = {
new OleDbParameter("@area", OleDbType.VarChar,0),
new OleDbParameter("@author_seq", OleDbType.VarChar,0),
new OleDbParameter("@cited", OleDbType.VarChar,0),
new OleDbParameter("@city", OleDbType.VarChar,0),
new OleDbParameter("@content", OleDbType.VarChar,0),
new OleDbParameter("@daxue", OleDbType.VarChar,0),
new OleDbParameter("@dtt", OleDbType.VarChar,0),
new OleDbParameter("@full_address", OleDbType.VarChar,0),
new OleDbParameter("@hits", OleDbType.VarChar,0),
new OleDbParameter("@ID", OleDbType.Integer,4),
new OleDbParameter("@issue", OleDbType.VarChar,0),
new OleDbParameter("@nifen", OleDbType.VarChar,0),
new OleDbParameter("@page", OleDbType.VarChar,0),
new OleDbParameter("@qikan", OleDbType.VarChar,0),
new OleDbParameter("@title", OleDbType.VarChar,0),
new OleDbParameter("@university", OleDbType.VarChar,0),
new OleDbParameter("@volume", OleDbType.VarChar,0),
new OleDbParameter("@waizuo", OleDbType.VarChar,0),
new OleDbParameter("@zaiyao", OleDbType.VarChar,0),
new OleDbParameter("@zhongzuo", OleDbType.VarChar,0)};
parameters[0].Value = model.area;
parameters[1].Value = model.author_seq;
parameters[2].Value = model.cited;
parameters[3].Value = model.city;
parameters[4].Value = model.content;
parameters[5].Value = model.daxue;
parameters[6].Value = model.dtt;
parameters[7].Value = model.full_address;
parameters[8].Value = model.hits;
parameters[9].Value = model.ID;
parameters[10].Value = model.issue;
parameters[11].Value = model.nifen;
parameters[12].Value = model.page;
parameters[13].Value = model.qikan;
parameters[14].Value = model.title;
parameters[15].Value = model.university;
parameters[16].Value = model.volume;
parameters[17].Value = model.waizuo;
parameters[18].Value = model.zaiyao;
parameters[19].Value = model.zhongzuo; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
}2.     public static int ExecuteSql(string SQLString, params OleDbParameter[] cmdParms)
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                using (OleDbCommand cmd = new OleDbCommand())
                {
                    try
                    {
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        int rows = cmd.ExecuteNonQuery();
                        cmd.Parameters.Clear();
                        return rows;
                    }
                    catch (System.Data.OleDb.OleDbException E)
                    {
                        throw new Exception(E.Message);
                    }
                }
            }
        }

Answer 1

zhongzuo=@zhongzuo, where ID=@ID是不是多了一个逗号？

Answer 2

zhongzuo=@zhongzuo, where ID=@ID 
 那里 不要逗号

Answer 3

zhongzuo=@zhongzuo where ID=@ID 去掉@zhongxuo后面的逗号

Answer 4

zhongzuo=@zhongzuo, where ID=@ID  多了个逗号