oracle 非法变量名,ORA-01036: 非法的变量名/编号-CSDN博客

本文介绍了一段用于更新数据库中取票单信息的代码实现。该方法通过构建SQL更新语句并使用参数化查询的方式，根据传入的取票单对象属性动态设置更新字段，确保了数据更新的安全性和灵活性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

publicboolModifyDrawBill(MDrawBill mBill)

{

StringBuilder strSQLText=newStringBuilder();

strSQLText.Append("update DrawBill set");

OracleParameter[] param={newOracleParameter("PKID", OracleType.Int32),newOracleParameter("StationId", OracleType.VarChar),newOracleParameter("BillBegin", OracleType.VarChar),newOracleParameter("BillEnd", OracleType.VarChar),newOracleParameter("SumCount", OracleType.Int32),newOracleParameter("DrawDate", OracleType.DateTime),newOracleParameter("IsConfirm", OracleType.Int32),newOracleParameter("AppUser", OracleType.NVarChar),newOracleParameter("CheckUser", OracleType.NVarChar),newOracleParameter("Memo", OracleType.NVarChar)

};//@@lwd 20110803param[0].Value=mBill.PKID;if(mBill.StationId!=null)

{

strSQLText.Append("StationId=:StationId,");

param[1].Value=mBill.StationId;

}if(mBill.BillBegin!=null)

{

strSQLText.Append("BillBegin=:BillBegin,");

param[2].Value=mBill.BillBegin;

}if(mBill.BillEnd!=null)

{

strSQLText.Append("BillEnd=:BillEnd,");

param[3].Value=mBill.BillEnd;

}if(mBill.SumCount!=null)

{

strSQLText.Append("SumCount=:SumCount,");

param[4].Value=mBill.SumCount;

}if(mBill.DrawDate!=null)

{

strSQLText.Append("DrawDate=:DrawDate,");

param[5].Value=mBill.DrawDate;

}if(mBill.IsConfirm!=null)

{

strSQLText.Append("IsConfirm=:IsConfirm,");

param[6].Value=mBill.IsConfirm;

}if(mBill.AppUser!=null)

{

strSQLText.Append("AppUser=:AppUser,");

param[7].Value=mBill.AppUser;

}if(mBill.CheckUser!=null)

{

strSQLText.Append("CheckUser=:CheckUser,");

param[8].Value=mBill.CheckUser;

}if(mBill.Memo!=null)

{

strSQLText.Append("Memo=:Memo,");

param[9].Value=mBill.Memo;

}if(strSQLText.ToString().EndsWith(","))

{

strSQLText=strSQLText.Remove(strSQLText.ToString().Length-1,1);

}

strSQLText.Append("where PKID=:PKID");returnOracleHelper.ExecuteNonQuery(OracleHelper.Connection_String, CommandType.Text, strSQLText.ToString(), param)>0;//提示“RA-01036: 非法的变量名/编号” }