提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
文章目录
前言
最近自己在研究学习winform,自己动手搭建了一个三层架构的winform工程,这里记载了一下简单的DB帮助工具类代码。大佬们多多指教。不喜勿喷啊。
代码详情
代码如下(示例):
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace DbUtil
{
public class SqlDBHelper
{
private static String ConnString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();
#region 不带参数的SQL语句
一、执行增删改非查询类方法(不带参数)
/// <summary>
/// 执行增删改非查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static int UPDATE(string sql) {
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally {
conn.Close();
}
}
二、返回单条结果查询类方法(不带参数)
/// <summary>
/// 返回单条结果查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static object getSingleResult(string sql)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
}
三、多条结果查询类方法(不带参数)
/// <summary>
/// 多条结果查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static SqlDataReader getReader(string sql)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
conn.Close();
throw new Exception(ex.Message);
}
}
四、返回DataSet数据集方法(不带参数)
/// <summary>
/// 返回DataSet数据集方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>结果集DataSet</returns>
public static DataSet getDataSet(string sql)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
adapter.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally {
conn.Close();
}
}
#endregion
#region 带参数SQL语句
五、执行增删改非查询类方法(带参数)
/// <summary>
/// 执行增删改非查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="param">SQl参数</param>
/// <returns></returns>
public static int UPDATE(string sql,SqlParameter[] param)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
cmd.Parameters.AddRange(param);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
}
六、返回单条结果查询类方法(带参数)
/// <summary>
/// 返回单条结果查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="param">SQL参数</param>
/// <returns></returns>
public static object getSingleResult(string sql, SqlParameter[] param)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
cmd.Parameters.AddRange(param);
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
}
七、多条结果查询类方法(带参数)
/// <summary>
/// 多条结果查询类方法
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="param">SQL参数</param>
/// <returns></returns>
public static SqlDataReader getReader(string sql,SqlParameter[] param)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
cmd.Parameters.AddRange(param);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
conn.Close();
throw new Exception(ex.Message);
}
}
#endregion