OracleCommand实现Parameters方法

来源：互联网发布：淘宝内部优惠券返利编辑：程序博客网时间：2024/06/07 06:44

       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();
            }
        }