DBHelper2
来源:互联网 发布:vs2017 mysql驱动 编辑:程序博客网 时间:2024/06/11 19:06
/// <summary>
/// 数据库连接对象
/// </summary>
static SqlConnection conn;
public static SqlConnection Conn {
get {
string connString = "server=.;database=pubs;uid=sa;pwd=";
if (conn == null) {
conn = new SqlConnection(connString);
conn.Open();
} else if (conn.State == System.Data.ConnectionState.Closed) {
conn.Open();
} else if (conn.State == System.Data.ConnectionState.Broken) {
conn.Close();
conn.Open();
}
return conn;
}
}
/// <summary>
/// 更新sql Command
/// </summary>
/// <param name="safeSql">safeSql</param>
/// <returns>更新影响的行数</returns>
public static int ExecuteCommand(string safeSql) {
SqlCommand cmd = new SqlCommand(safeSql, Conn);
int result = cmd.ExecuteNonQuery();
if (conn != null) {
conn.Close();
}
return result;
}
/// <summary>
/// 更新sql Command
/// </summary>
/// <param name="sql">sql</param>
/// <param name="values">SqlParameter 参数</param>
/// <returns>更新影响的行数</returns>
public static int ExecuteCommand(string sql, params SqlParameter[] values) {
SqlCommand cmd = new SqlCommand(sql, Conn);
cmd.Parameters.AddRange(values);
int count = cmd.ExecuteNonQuery();
if (conn != null) {
conn.Close();
}
return count;
}
/// <summary>
/// 获得查询的第一行第一列的值
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static Object GetScalar(string safeSql) {
SqlCommand cmd = new SqlCommand(safeSql, Conn);
return cmd.ExecuteScalar();
}
/// <summary>
/// 获得查询的第一行第一列的值
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static object GetScalar(string sql, params SqlParameter[] values) {
SqlCommand cmd = new SqlCommand(sql, Conn);
cmd.Parameters.AddRange(values);
return cmd.ExecuteScalar();
}
/// <summary>
/// 获得查询的SqlDataReader
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static SqlDataReader GetReader(string safeSql) {
SqlCommand cmd = new SqlCommand(safeSql, Conn);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
/// <summary>
/// 获得查询的SqlDataReader
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static SqlDataReader GetReader(string sql, params SqlParameter[] values) {
SqlCommand cmd = new SqlCommand(sql, Conn);
cmd.Parameters.AddRange(values);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
/// <summary>
/// 获得查询的DataTable
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static DataTable GetDataSet(string safeSql) {
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, Conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (conn != null) {
conn.Close();
}
return ds.Tables[0];
}
/// <summary>
/// 获得查询的DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static DataTable GetDataSet(string sql, params SqlParameter[] values) {
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(sql, Conn);
cmd.Parameters.AddRange(values);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (conn != null) {
conn.Close();
}
return ds.Tables[0];
}
- DBHelper2
- 2008年03月《安全天下事》
- 存储过程的例子.
- 在Word中发布blog测试
- 用prctl给线程命名
- How to select the data type in SQLserver database such as varchar, nvarchar
- DBHelper2
- dm9000x.c注释
- 高级 Linux 命令精通指南,第 3 部分:资源管理
- ArcGIS 9.3破解安装(window7)
- Android启动脚本init.rc
- 使用Native Wifi API查找無線網絡信息
- 调试快捷键,Visual C++ 6.0 默认快捷键
- GTK Gossip: GtkProgressBar
- RPG&SRPG伤害式计算方式杂谈