Queue 输出数据

最新推荐文章于 2024-06-08 18:24:39 发布

weixin_33860722

最新推荐文章于 2024-06-08 18:24:39 发布

阅读量440

点赞数

CC 4.0 BY-SA版权

文章标签： c/c++

原文链接：http://www.cnblogs.com/chenmfly/p/4387339.html

本文详细阐述了使用SQL Server数据库进行数据更新操作的过程，包括构造SQL字符串、设置参数、执行命令等步骤，并展示了如何通过参数绑定来提高代码的安全性和效率。

坑人的引用类型。。。。输出看看结果是什么

Queue<ParaInfo> strStranList = new Queue<ParaInfo>();

StringBuilder strSql = new StringBuilder();
                strSql.Append("Update Jia72_Members Set ");
                strSql.Append("UserName=@UserName,");
                strSql.Append("YTCardId=@YTCardId,");
                strSql.Append("CardNum=@CardNum,");
                strSql.Append("Bank=@Bank,");
                strSql.Append("BankNumber=@BankNumber,");
                strSql.Append("QQNumber=@QQNumber,");
                strSql.Append("RealName=@RealName,");
                strSql.Append("SavedOn=@SavedOn");
                strSql.Append(" Where Id=@Id ");
                string strSQLM = strSql.ToString();

                SqlParameter[] parameters = {
					new SqlParameter("@Id",SqlDbType.Int,4),					
					new SqlParameter("@UserName",SqlDbType.NVarChar,20),
					new SqlParameter("@YTCardId",SqlDbType.Int,4),
					new SqlParameter("@CardNum",SqlDbType.NVarChar,20),
					new SqlParameter("@Bank",SqlDbType.NVarChar,50),
					new SqlParameter("@BankNumber",SqlDbType.NVarChar,32),					
					new SqlParameter("@QQNumber",SqlDbType.NVarChar,50),
					new SqlParameter("@RealName",SqlDbType.NVarChar,10),			
					new SqlParameter("@SavedOn",SqlDbType.DateTime)
					 };
                parameters[0].Value = model.Id;
                parameters[1].Value = model.UserName;
                parameters[2].Value = model.YTCardId;
                parameters[3].Value = model.CardNum;
                parameters[4].Value = model.Bank;
                parameters[5].Value = model.BankNumber;
                parameters[6].Value = model.QQNumber;
                parameters[7].Value = model.RealName;
                parameters[8].Value = model.SavedOn;

                DBUtility.ParaInfo dbcom = new DBUtility.ParaInfo(strSql.ToString(), parameters);
                strStranList.Enqueue(dbcom);//绑定会员信息              

                //更新卡表
                strSql.Clear();
                strSql.Append("update Jia72_YTCard set ");
                strSql.Append("IsBind=1,");
                strSql.Append("SavedOn=getdate()");
                strSql.Append(" where Id=" + model.YTCardId);

                DBUtility.ParaInfo dbcom1 = new DBUtility.ParaInfo(strSql.ToString(), null);
                strStranList.Enqueue(dbcom1);//绑定会员信息   //更新卡表绑定

  while (strStranList.Count > 0)
                {
                    ParaInfo myDE = strStranList.Peek();
                    string cmdText = myDE.strSql.ToString();
                    Response.Write(cmdText.ToString());
                    Response.Write("<br/>");
                    if (myDE.par != null)
                    {
                        SqlParameter[] cmdParms = (SqlParameter[])myDE.par;
                        foreach (SqlParameter parm in cmdParms)
                        {
                            Response.Write(parm.ParameterName.ToString() + " " + parm.Value.ToString() + " ");
                        }
                        Response.Write("<br/>");
                    }
                    strStranList.Dequeue();
                }

转载于:https://www.cnblogs.com/chenmfly/p/4387339.html