SqlHelper代码
这里分成三个方法,单行单列、查询集合、增删改通用方法
单行单列
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
/// <summary> /// 单行单列查询方法 /// </summary> /// <param name="sql">需要执行的sql语句</param> /// <param name="pms">可变的参数</param> /// <returns>返回的值</returns> public object DHDL(string sql, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteScalar(); } } } |
增删改
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
/// <summary> /// 增删改封装方法 /// </summary> /// <param name="sql">需要执行的sql语句</param> /// <param name="pms">可变的sql参数</param> /// <returns>操作成功与否</returns> public bool ZSG(string sql,params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteNonQuery()>0; } } } |
查询集合
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
/// <summary> /// 集合查询方法封装 /// </summary> /// <param name="sql">需要执行的sql语句</param> /// <param name="pms">可变的sql参数</param> /// <returns>返回的值</returns> public DataTable selectAll(string sql, params SqlParameter[] pms) { DataTable td = new DataTable(); using (SqlConnection con = new SqlConnection(constr)) { using (SqlDataAdapter cmd = new SqlDataAdapter(sql, con)) { if (pms != null) { cmd.SelectCommand.Parameters.AddRange(pms); } con.Open(); cmd.Fill(td); return td; } } } |
constr是连接字符串
1 |
private static readonly string constr="data source=.;initial catalog=Report;user id=sa;password=123456"; |
评论