1
using System;
2using System.Data.OleDb;
3using System.Data;
4using System.Windows.Forms;
5namespace DBAccess
6
...{
7
/**//// <summary>
8
/// 对Access2003数据库的访问、数据获取
9
/// </summary>
10 public class Access2003
11 ...{
12 static OleDbTransaction myts = null; // 事务
13 static OleDbConnection MyConnection = null; // 数据库连接
14
15 数据库打开、关闭#region 数据库打开、关闭
16 /**//// <summary>
17 /// 打开数据库
18 /// </summary>
19 public static void Open()
20 ...{
21 MyConnection = new OleDbConnection( GetConnectionStr() );
22 MyConnection.Open();
23 }
24
25 /**//// <summary>
26 /// 关闭数据库
27 /// </summary>
28 public static void Close()
29 ...{
30 MyConnection.Close();
31 }
32 #endregion
33
34 开始、提交、回滚一个数据库事务#region 开始、提交、回滚一个数据库事务
35
36 /**//// <summary>
37 /// 开始一个事务
38 /// </summary>
39 public static void BeginTransaction()
40 ...{
41 myts = MyConnection.BeginTransaction();
42 }
43
44 /**//// <summary>
45 /// 提交一个事务
46 /// </summary>
47 public static void CommitTransaction()
48 ...{
49 if( myts == null )
50 ...{
51 return;
52 }
53 myts.Commit();
54 }
55
56 /**//// <summary>
57 /// 回滚一个事务
58 /// </summary>
59 public static void RollbackTransaction()
60 ...{
61 if( myts == null )
62 ...{
63 return;
64 }
65 myts.Rollback();
66 }
67 #endregion
68
69 获取数据库连接字符串#region 获取数据库连接字符串
70
71 /**//// <summary>
72 /// 获取连接字符串
73 /// </summary>s
74 /// <returns>返回一个字符串，代表了连接信息</returns>
75 private static string GetConnectionStr()
76 ...{
77 string str = string.Empty;
78 str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ Application.StartupPath +"//Library.mdb;";
79 return str;
80 }
81 #endregion
82
83 查找数据#region 查找数据
84
85![]()
using System;2
using System.Data.OleDb;3
using System.Data;4
using System.Windows.Forms;5
namespace DBAccess6
...{7
/**//// <summary>8
/// 对Access2003数据库的访问、数据获取9
/// </summary>10
public class Access200311
...{12
static OleDbTransaction myts = null; // 事务13
static OleDbConnection MyConnection = null; // 数据库连接14
15
数据库打开、关闭#region 数据库打开、关闭16
/**//// <summary>17
/// 打开数据库18
/// </summary>19
public static void Open()20
...{21
MyConnection = new OleDbConnection( GetConnectionStr() );22
MyConnection.Open();23
}24
25
/**//// <summary>26
/// 关闭数据库27
/// </summary>28
public static void Close()29
...{30
MyConnection.Close();31
}32
#endregion 33
34
开始、提交、回滚一个数据库事务#region 开始、提交、回滚一个数据库事务35
36
/**//// <summary>37
/// 开始一个事务38
/// </summary>39
public static void BeginTransaction()40
...{41
myts = MyConnection.BeginTransaction();42
}43
44
/**//// <summary>45
/// 提交一个事务46
/// </summary>47
public static void CommitTransaction()48
...{49
if( myts == null )50
...{51
return;52
}53
myts.Commit();54
}55
56
/**//// <summary>57
/// 回滚一个事务58
/// </summary>59
public static void RollbackTransaction()60
...{61
if( myts == null )62
...{63
return;64
}65
myts.Rollback();66
}67
#endregion 68
69
获取数据库连接字符串#region 获取数据库连接字符串70
71
/**//// <summary>72
/// 获取连接字符串73
/// </summary>s74
/// <returns>返回一个字符串，代表了连接信息</returns>75
private static string GetConnectionStr()76
...{77
string str = string.Empty;78
str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ Application.StartupPath +"//Library.mdb;";79
return str;80
}81
#endregion 82
83
查找数据#region 查找数据84
85