使用泛型参数传递对数据库进行增删改查

来源：互联网发布：mac root mima 编辑：程序博客网时间：2024/06/05 07:55

使用泛型参数传递对数据库进行增删改查

string sql = "insert into WisdomInformation(title,contents,type)values('@title','@contents','@type')";//一定需要加单引号，我曾经在这上面犯过错

Dictionary<string, string> dic = new Dictionary<string, string>();

dic.Add("@content", contents);
dic.Add("@type",option);

dic.Add("@title", title);

int rows = SqlHelper.ExecuteNonQuey1(sql, dic);//自己写的方法

方法1

public static int ExecuteNonQuey1(string sql, Dictionary<string ,string> dic )
        {
                SqlParameter[] ps = new SqlParameter[dic.Count];
                int index = 0;
                foreach (var item in dic)
                {
                    ps[index++] = new SqlParameter(item.Key, item.Value);
                }
              return ExecuteNonQuery2(sql,CommandType.Text, ps);//方法2

        }

方法2

public   static int ExecuteNonQuery2(string sql,CommandType type, SqlParameter []ps)
        {
          int rows=0;
           using (SqlConnection con = Getcon())
            {
            con.Open();
            foreach (SqlParameter var in ps)
            {
                sql = sql.Replace(var.ParameterName, var.Value.ToString());
            }
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.CommandType = type;
            cmd.Parameters.AddRange(ps);
            rows = cmd.ExecuteNonQuery();
             }
        return rows;

        }

0 0