之前由于工作需要，需要用到DNSPod解析大量域名，手动解析太过于麻烦，作为程序员肯定想法子偷懒，并且提高工作效率，于是便开始研究了下DNSPod提供的API，自己开发了一个DNSPod管理助手，实现域名快速解析。
SQLiteHelper
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217 |
using
System;using
System.Collections;using
System.Data.SQLite;using
System.Data;using
System.Configuration;namespace
KingSystem.DNSPod{ /// <summary> /// SQLite数据库的数据连接层 /// </summary> public
abstract class SQLiteHelper { /// <summary> /// 从App.config获取数据库连接字符串 /// </summary> private
static readonly String StrConn = ConfigurationManager.AppSettings["SQLiteConnection"]; /// <summary> /// 数据库连接字符串 /// </summary> public
static String ConnectionStringManager { get
{ return
StrConn; } } /// <summary> /// Hashtable把参数保存到缓存中 /// </summary> private
static Hashtable parmCache = Hashtable.Synchronized(new
Hashtable()); /// <summary> /// Command预设置 /// </summary> /// <param name="cmd">SQLiteCommand对象</param> /// <param name="conn">SQLiteConnection对象</param> /// <param name="trans">SQLiteTransaction对象，可为null</param> /// <param name="cmdType">CommandType，存储过程或命令行</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">SQLiteCommand参数数组，可为null</param> private
static void PrepareCommand(SQLiteCommand cmd, SQLiteConnection conn, SQLiteTransaction trans, CommandType cmdType, String cmdText, SQLiteParameter[] cmdParms) { if
(conn.State != ConnectionState.Open) conn.Open(); cmd.Connection = conn; cmd.CommandText = cmdText; if
(trans != null) cmd.Transaction = trans; cmd.CommandType = cmdType; if
(cmdParms != null) foreach
(SQLiteParameter parm in
cmdParms) cmd.Parameters.Add(parm); } #region ExecuteNonQuery执行一个没有返回结果的SQL语句 /// <summary> /// 执行一个没有返回结果的SQL语句 /// </summary> /// <param name="connStr">数据库连接字符串</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">SQLiteCommand参数数组</param> /// <returns>返回受引响的记录行数</returns> public
static int ExecuteNonQuery(String connStr, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { using
(SQLiteCommand cmd = new
SQLiteCommand()) { using
(SQLiteConnection conn = new
SQLiteConnection(connStr)) { PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); int
val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return
val; } } } /// <summary> /// 执行一个没有返回结果的SQL语句 /// </summary> /// <param name="trans">SQLiteTransaction对象</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">SQLiteCommand参数数组</param> /// <returns>返回受引响的记录行数</returns> public
static int ExecuteNonQuery(SQLiteTransaction trans, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { using
(SQLiteCommand cmd = new
SQLiteCommand()) { PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, cmdParms); int
val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return
val; } } /// <summary> /// 执行一个没有返回结果的SQL语句 /// </summary> /// <param name="conn">Connection对象</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">SQLiteCommand参数数组</param> /// <returns>返回受引响的记录行数</returns> public
static int ExecuteNonQuery(SQLiteConnection conn, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { using
(SQLiteCommand cmd = new
SQLiteCommand()) { PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); int
val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return
val; } } #endregion /// <summary> /// 执行命令或存储过程，返回一个SQLiteDataReader,只读的数据集 /// 注意SQLiteDataReader对象使用完后必须Close以释放SQLiteConnection资源 /// </summary> /// <param name="connStr">>数据库连接字符串</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">Parameter参数数组</param> /// <returns>成功则返回一个SQLiteDataReader,只读的数据集，否则抛出异常</returns> public
static SQLiteDataReader ExecuteReader(String connStr, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { SQLiteCommand cmd = new
SQLiteCommand(); SQLiteConnection conn = new
SQLiteConnection(connStr); try { PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); SQLiteDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); cmd.Parameters.Clear(); return
rdr; } catch
(Exception ex) { conn.Close(); throw
ex; } } #region ExecuteScalar执行命令，返回第一行第一列的值 /// <summary> /// 执行只返回第一行第一列的值的SQL语句 /// </summary> /// <param name="connStr">数据库连接字符串</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">Parameter参数数组</param> /// <returns>返回第一行第一列的值</returns> public
static object ExecuteScalar(String connStr, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { using
(SQLiteCommand cmd = new
SQLiteCommand()) { using
(SQLiteConnection connection = new
SQLiteConnection(connStr)) { PrepareCommand(cmd, connection, null, cmdType, cmdText, cmdParms); object
val = cmd.ExecuteScalar(); cmd.Parameters.Clear(); return
val; } } } /// <summary> /// 执行只返回第一行第一列的值的SQL语句 /// </summary> /// <param name="conn">Connection对象</param> /// <param name="cmdType">命令类型（存储过程或SQL语句）</param> /// <param name="cmdText">SQL语句或存储过程名</param> /// <param name="cmdParms">SQLiteCommand参数数组</param> /// <returns>返回第一行第一列的值</returns> public
static object ExecuteScalar(SQLiteConnection conn, CommandType cmdType, String cmdText, params
SQLiteParameter[] cmdParms) { using
(SQLiteCommand cmd = new
SQLiteCommand()) { PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); object
val = cmd.ExecuteScalar(); cmd.Parameters.Clear(); return
val; } } #endregion /// <summary> /// 将参数数组添加到缓存 /// </summary> /// <param name="cacheKey">键值</param> /// <param name="cmdParms">参数数组</param> public
static void CacheParameters(String cacheKey, params
SQLiteParameter[] cmdParms) { parmCache[cacheKey] = cmdParms; } /// <summary> /// 根据键值获取相应的参数数组 /// </summary> /// <param name="cacheKey">键值</param> /// <returns>返回参数数组</returns> public
static SQLiteParameter[] GetCachedParameters(String cacheKey) { SQLiteParameter[] cachedParms = (SQLiteParameter[])parmCache[cacheKey]; if
(cachedParms == null) return
null; SQLiteParameter[] clonedParms = new
SQLiteParameter[cachedParms.Length]; for
(int
i = 0, j = cachedParms.Length; i < j; i++) clonedParms[i] = (SQLiteParameter)((ICloneable)cachedParms[i]).Clone(); return
clonedParms; } }} |
稍后公布技术细节，这篇随笔先显示下程序效果图
原文：http://www.cnblogs.com/dobugnet/p/3544084.html