oracle 中插入的数据,关于C#向oracle 中插入数据的问题

这个是代码生成器生成的

///

/// 增加一条数据

///

public void Add(CitCyjw.Model.CIT_INFORMANTS model)

{

StringBuilder strSql=new StringBuilder();

strSql.Append("insert into CIT_INFORMANTS(");

strSql.Append("ID,USERNAME,PASSWORD,CNAME,SEX,PHONE,CARDID,REMARK,FLAG)");

strSql.Append(" values (");

strSql.Append(":ID,:USERNAME,:PASSWORD,:CNAME,:SEX,:PHONE,:CARDID,:REMARK,:FLAG)");

OracleParameter[] parameters = {

new OracleParameter(":ID", OracleType.Number,20),

new OracleParameter(":USERNAME", OracleType.NVarChar),

new OracleParameter(":PASSWORD", OracleType.NVarChar),

new OracleParameter(":CNAME", OracleType.NVarChar),

new OracleParameter(":SEX", OracleType.NVarChar),

new OracleParameter(":PHONE", OracleType.NVarChar),

new OracleParameter(":CARDID", OracleType.NVarChar),

new OracleParameter(":REMARK", OracleType.NVarChar),

new OracleParameter(":FLAG", OracleType.NChar)};

parameters[0].Value = model.ID;

parameters[1].Value = model.USERNAME;

parameters[2].Value = model.PASSWORD;

parameters[3].Value = model.CNAME;

parameters[4].Value = model.SEX;

parameters[5].Value = model.PHONE;

parameters[6].Value = model.CARDID;

parameters[7].Value = model.REMARK;

parameters[8].Value = model.FLAG;

OraHelper.ExecuteSql(strSql.ToString(),parameters);

}