【侯垒 】SQL数据库操作类
SQL数据库操作类
我把数据库操作类整理了一下,它包含了常用的数据库操作,由三种方式:简单的SQL拼接字符串的形式,SQL语句使用参数的形式和存储过程的形式,每种形式均有五个方法,并且都有事务.,可以直接调用.代码如下:
1
//======================================================================
2//
3// Copyright (C) 2007-2008 三月软件工作室
4// All rights reserved
5//
6// filename :SQLDataBase
7// description :
8//
9// created by 侯垒 at 04/14/2008 18:33:32
10// http://houleixx.cnblogs.com
11//
12//======================================================================
13
14using System;
15using System.Collections;
16using System.Collections.Specialized;
17using System.Data;
18using System.Data.SqlClient;
19using System.Configuration;
20using System.Data.Common;
21
22namespace SQLDataBase
23
{
24
/**////
25
/// 数据访问基础类(基于SQLServer)
26
///
27 class SQLDataBase
28 {
29 protected static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
30 public SQLDataBase()
31 {
32
33 }
34
35 执行简单SQL语句#region 执行简单SQL语句
36
37 /**////
38 /// 执行SQL语句，返回影响的记录数
39 ///
40 ///
41 ///
42 public int ExecuteSql(string SQLString)
43 {
44 using (SqlConnection connection = new SqlConnection(connectionString))
45 {
46 using (SqlCommand cmd = new SqlCommand(SQLString, connection))
47 {
48 try
49 {
50 connection.Open();
51 int rows = cmd.ExecuteNonQuery();
52 return rows;
53 }
54 catch (System.Data.SqlClient.SqlException E)
55 {
56 connection.Close();
57 throw new Exception(E.Message);
58 }
59 }
60 }
61 }
62
63 /**////
64 /// 执行多条SQL语句，实现数据库事务。
65 ///
66 ///
67 public void ExecuteSqlTran(ArrayList SQLStringList)
68 {
69 using (SqlConnection conn = new SqlConnection(connectionString))
70 {
71 conn.Open();
72 SqlCommand cmd = new SqlCommand();
73 cmd.Connection = conn;
74 SqlTransaction tx = conn.BeginTransaction();
75 cmd.Transaction = tx;
76 try
77 {
78 for (int n = 0; n < SQLStringList.Count; n++)
79 {
80 string strsql = SQLStringList[n].ToString();
81 if (strsql.Trim().Length > 1)
82 {
83 cmd.CommandText = strsql;
84 cmd.ExecuteNonQuery();
85 }
86 }
87 tx.Commit();
88 }
89 catch (System.Data.SqlClient.SqlException E)
90 {
91 tx.Rollback();
92 throw new Exception(E.Message);
93 }
94 }
95 }
96 /**////
97 /// 执行一条计算查询结果语句，返回查询结果（object）。
98 ///
99 ///
100 ///
101 public object GetSingle(string SQLString)
102 {
103 using (SqlConnection connection = new SqlConnection(connectionString))
104 {
105 using (SqlCommand cmd = new
//======================================================================2
//3
// Copyright (C) 2007-2008 三月软件工作室 4
// All rights reserved5
//6
// filename :SQLDataBase7
// description :8
//9
// created by 侯垒 at 04/14/2008 18:33:3210
// http://houleixx.cnblogs.com11
//12
//======================================================================13
14
using System;15
using System.Collections;16
using System.Collections.Specialized;17
using System.Data;18
using System.Data.SqlClient;19
using System.Configuration;20
using System.Data.Common;21
22
namespace SQLDataBase23
{24
/**//// 25
/// 数据访问基础类(基于SQLServer)26
/// 27
class SQLDataBase28
{29
protected static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;30
public SQLDataBase()31
{32
33
}34
35
执行简单SQL语句#region 执行简单SQL语句36
37
/**//// 38
/// 执行SQL语句，返回影响的记录数39
/// 40
/// 41
/// 42
public int ExecuteSql(string SQLString)43
{44
using (SqlConnection connection = new SqlConnection(connectionString))45
{46
using (SqlCommand cmd = new SqlCommand(SQLString, connection))47
{48
try49
{50
connection.Open();51
int rows = cmd.ExecuteNonQuery();52
return rows;53
}54
catch (System.Data.SqlClient.SqlException E)55
{56
connection.Close();57
throw new Exception(E.Message);58
}59
}60
}61
}62
63
/**//// 64
/// 执行多条SQL语句，实现数据库事务。65
/// 66
/// 67
public void ExecuteSqlTran(ArrayList SQLStringList)68
{69
using (SqlConnection conn = new SqlConnection(connectionString))70
{71
conn.Open();72
SqlCommand cmd = new SqlCommand();73
cmd.Connection = conn;74
SqlTransaction tx = conn.BeginTransaction();75
cmd.Transaction = tx;76
try77
{78
for (int n = 0; n < SQLStringList.Count; n++)79
{80
string strsql = SQLStringList[n].ToString();81
if (strsql.Trim().Length > 1)82
{83
cmd.CommandText = strsql;84
cmd.ExecuteNonQuery();85
}86
}87
tx.Commit();88
}89
catch (System.Data.SqlClient.SqlException E)90
{91
tx.Rollback();92
throw new Exception(E.Message);93
}94
}95
}96
/**//// 97
/// 执行一条计算查询结果语句，返回查询结果（object）。98
/// 99
/// 100
/// 101
public object GetSingle(string SQLString)102
{103
using (SqlConnection connection = new SqlConnection(connectionString))104
{105
using (SqlCommand cmd = new
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12639172/viewspace-343205/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
违法和不良信息举报电话:18101376593