oracle的parameters怎么用,OracleCommand实现Parameters方法

public bool insertSatiGrade(clsSatiGrade grade)

{

if (grade == null)

return false;

string strSQL = "insert into satiType values(satiType_seq.nextval,:gName,:gValue)";

try

{

OracleCommand cmd = new OracleCommand();

cmd.CommandText = strSQL;

OracleParameter param = new OracleParameter("gName", OracleType.VarChar, 80);

param.Value = grade.SatiTypeName;

cmd.Parameters.Add(param);

param = new OracleParameter("gValue", OracleType.Int32, 3);

param.Value = grade.SatiTypeValue;

cmd.Parameters.Add(param);

dbOp.ExecCommand(cmd);

return true;

}

catch(Exception e)

{

;       return false;

}

}

public void ExecCommand(OracleCommand cmd)

{

OracleConnection conn = GetConn();

cmd.Connection = conn;

try

{

conn.Open();

cmd.ExecuteNonQuery();

}

catch (Exception e)

{

}

finally

{

conn.Close();

conn.Dispose();

}

}