数据库连接整理
来源:互联网 发布:开机windows损坏的图像 编辑:程序博客网 时间:2024/06/14 19:03
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
/// SqlHelper 的摘要说明
/// </summary>
public static class SqlHelper1
{
// readonly static string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
readonly static string constr = "data source=10.1.1.247;database=haitian_MSCRM;uid=ht_crmselect;pwd=htpass@228";
/// <summary>
/// 提交返回数据集
/// </summary>
/// <param name="commandtype">选择执行方式的枚举</param>
/// <param name="commandtext">sql语句或者存储过程名称</param>
/// <param name="sps">参数的数组</param>
/// <returns></returns>
public static DataTable ExecuteDataSet(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
}
}
/// <summary>
/// 用于执行insert、update、delete
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static int ExecuteNonQuery(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
int count = cmd.ExecuteNonQuery();
con.Close();
return count;
}
}
}
/// <summary>
/// 返回聚合函数值
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static object ExecuteScalar(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
object o = cmd.ExecuteScalar(); //sql的聚合函数 Count(*)
con.Close();
return o;
}
}
}
/// <summary>
/// 用于返回一行数据
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static SqlDataReader ExecuteReader(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
SqlConnection con = new SqlConnection(constr);
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //关闭读取器,将自动关闭该读取器上的连接对象
return dr;
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
/// SqlHelper 的摘要说明
/// </summary>
public static class SqlHelper1
{
// readonly static string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
readonly static string constr = "data source=10.1.1.247;database=haitian_MSCRM;uid=ht_crmselect;pwd=htpass@228";
/// <summary>
/// 提交返回数据集
/// </summary>
/// <param name="commandtype">选择执行方式的枚举</param>
/// <param name="commandtext">sql语句或者存储过程名称</param>
/// <param name="sps">参数的数组</param>
/// <returns></returns>
public static DataTable ExecuteDataSet(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
}
}
/// <summary>
/// 用于执行insert、update、delete
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static int ExecuteNonQuery(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
int count = cmd.ExecuteNonQuery();
con.Close();
return count;
}
}
}
/// <summary>
/// 返回聚合函数值
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static object ExecuteScalar(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
object o = cmd.ExecuteScalar(); //sql的聚合函数 Count(*)
con.Close();
return o;
}
}
}
/// <summary>
/// 用于返回一行数据
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static SqlDataReader ExecuteReader(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
SqlConnection con = new SqlConnection(constr);
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //关闭读取器,将自动关闭该读取器上的连接对象
return dr;
}
}
}
- 数据库连接整理
- 数据库连接整理
- 数据库连接整理
- 数据库连接字符串整理
- 数据库连接字符串整理
- 数据库连接字符串整理
- 数据库连接字符串整理
- 数据库连接字符串大全整理
- Informix数据库连接使用方法整理
- 数据库连接整理(转)
- 数据库连接池dbcp整理
- 数据库连接池 java 整理
- Hibernate 数据库连接配置整理
- Spring 数据库连接整理
- Spring 数据库连接整理
- 数据库连接字符串整理
- Java数据库连接(JDBC)【整理】
- 数据库连接技术整理
- webbrowers用法集
- UIUC同学Jia-Bin Huang收集的计算机视觉代码合集(ZZ)
- ajax技术示例
- insmod: error inserting './sctp.ko': -1 Unknown symbol in module
- datagridview的RowPostPaint事件
- 数据库连接整理
- linux shell判断条件和系统变量
- in与exists别乱用
- 使用fastdb的感受
- 网上找到的统计代码行数
- 计算机视觉领域的一些牛人博客,超有实力的研究机构等的网站链接
- wince下EBOOT详解
- 第十四周任务二指针链表
- 使用串口管理linux主机