SqlHelper类
来源:互联网 发布:网络型数据采集机 编辑:程序博客网 时间:2024/05/21 07:48
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data;using System.Data.SqlClient;namespace SqlHelper{ /// <summary> /// Copyright (C) 2015-2016 GVegetables /// Create 20150906 GVegetables /// 数据访问基础类(基于SqlServer) /// </summary> public static class SqlHelper { /// <summary> /// 连接字符串 /// </summary> public static string connString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString; /// <summary> /// 把insert/update/ select /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="pms"></param> /// <returns></returns> public static int ExecuteNonQuery(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection conn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } conn.Open(); return cmd.ExecuteNonQuery(); } } } /// <summary> /// 执行返回单个值的方法 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="pms"></param> /// <returns></returns> public static object ExecuteSclar(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection conn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } conn.Open(); return cmd.ExecuteScalar(); } } } /// <summary> /// 返回SqlDataReader方法 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="pms"></param> /// <returns></returns> public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms) { SqlConnection conn = new SqlConnection(connString); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } try { conn.Open(); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch { conn.Close(); conn.Dispose(); throw; } } } /// <summary> /// 返回DataTable /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="pms"></param> /// <returns></returns> public static DataTable ExecuteTable(string sql,CommandType cmdType,params SqlParameter[] pms) { DataTable dt = new DataTable(); using (SqlDataAdapter adapter = new SqlDataAdapter(sql,connString)) { adapter.SelectCommand.CommandType = cmdType; if (pms != null) { adapter.SelectCommand.Parameters.AddRange(pms); } adapter.Fill(dt); return dt; } } }}
备注:自己用的数据库访问基础类,现在功能还比较弱,一直会持续更新。
0 0
- SQLHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- sqlhelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SQLHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper 类
- SqlHelper类
- SqlHelper类
- SQLHelper类
- CRF分词的纯Java实现
- flash乱码解决方案
- c++primer之顺序容器(添加元素)
- leetcode 275: H-Index II
- 有图有话 | 高效人士的一天,你能做到几条?
- SqlHelper类
- eclipse启动闪退总结
- 内部类
- iOS8的远程推送
- (决策分析思考)Decision Analytic Thinking
- 欢迎使用CSDN-markdown编辑器
- Java线程:线程栈模型与线程的变量
- MapReduce 的工作机制
- Web开发为什么要使用Struts2和Spring这样的框架?