📄 04161220774_cs.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0049)http://dl2.csdn.net/down1/20080304/04161220774.cs -->
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY><PRE>using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// 自定义数据库通用类
/// </summary>
public class DataBase
{
private string ConnStr = null;
public DataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 设置连接字符串
/// </summary>
public DataBase(string Str)
{
this.ConnStr = Str;
}
/// <summary>
/// 设置连接字符串
/// </summary>
public string ConnectionString
{
set
{
ConnStr = value;
}
get
{
return ConnStr;
}
}
/// <summary>
/// 设置数据库地址及数据的用户名、密码,数据库
/// </summary>
public DataBase(string DataBaseAddress, string DataBase, string UserID, string PassWord)
{
this.ConnStr = "server=" + DataBaseAddress + ";DataBase="+DataBase+"; User ID=" + UserID + "+;password=" + PassWord;
}
/// <summary>
/// 返回connection对象
/// </summary>
/// <returns></returns>
public SqlConnection ReturnConnection()
{
SqlConnection sconn = new SqlConnection(ConnStr);
sconn.Open();
return sconn;
}
/// <summary>
/// 返回connection对象
/// </summary>
/// <returns></returns>
public SqlConnection ReturnConnection(string ConnectionString)
{
SqlConnection sconn = new SqlConnection(ConnStr);
sconn.Open();
return sconn;
}
/// <summary>
/// 毁面connection对象
/// </summary>
/// <returns></returns>
public void Dispose(SqlConnection Conn)
{
if (Conn != null)
{
Conn.Close();
Conn.Dispose();
}
GC.Collect();
}
/// <summary>
/// 毁面connection对象
/// </summary>
/// <returns></returns>
public void Dispose()
{
if (ReturnConnection() != null)
{
ReturnConnection().Close();
ReturnConnection().Dispose();
}
GC.Collect();
}
/// <summary>
/// 运行SQL语句
/// </summary>
public void RunSQL(string CommandText)
{
SqlCommand scmd = new SqlCommand();
scmd.Connection = ReturnConnection();
scmd.CommandText = CommandText;
try
{
scmd.ExecuteNonQuery();
}
catch (Exception Err)
{
throw Err;
}
Dispose();
return;
}
/// <summary>
/// 运行SQL语句,返回影响的行数;
/// </summary>
public int RunSqlReturnAffectRow(string CommandText)
{
SqlCommand scmd = new SqlCommand();
int count = 0;
scmd.Connection = ReturnConnection();
scmd.CommandText = CommandText;
try
{
count= scmd.ExecuteNonQuery();
}
catch (Exception Err)
{
throw Err;
}
Dispose();
return count;
}
/// <summary>
/// 运行SQL语句,返回DataSet对象
/// </summary>
public DataSet GetDataSet(string CommandText, DataSet DS)
{
try
{
GetDataAdapter(CommandText).Fill(DS);
}
catch (Exception Err)
{
throw Err;
}
Dispose();
return DS;
}
/// <summary>
/// 运行SQL语句,返回DataSet对象
/// </summary>
public DataSet GetDataSet(string CommandText)
{
DataSet ds = new DataSet();
try
{
GetDataAdapter(CommandText).Fill(ds);
}
catch (Exception Err)
{
throw Err;
}
Dispose();
return ds;
}
/// <summary>
/// 运行SQL语句,返回DataSet对象
/// </summary>
public DataSet GetDataSet(string CommandText,SqlConnection Conn)
{
DataSet ds = new DataSet();
try
{
GetDataAdapter(CommandText,Conn).Fill(ds);
}
catch (Exception Err)
{
throw Err;
}
Dispose();
return ds;
}
/// <summary>
/// 运行SQL语句,返回DataSet对象
/// </summary>
public DataSet GetDataSet(string CommandText, DataSet DS, string TableName)
{
try
{
GetDataAdapter(CommandText).Fill(DS,TableName);
}
catch (Exception ex)
{
throw ex;
}
Dispose();
return DS;
}
/// <summary>
/// 生成Command对象
/// </summary>
/// <returns></returns>
public SqlCommand CreateCommand(string CommandText, SqlConnection Conn)
{
SqlCommand Cmd = new SqlCommand(CommandText, Conn);
return Cmd;
}
/// <summary>
/// 生成Command对象
/// </summary>
/// <returns></returns>
public SqlCommand CreateCommand(string CommandText)
{
SqlCommand Cmd = new SqlCommand(CommandText, ReturnConnection());
return Cmd;
}
/// <summary>
/// 运行SQL语句返回DataReader
/// </summary>
/// <returns>SqlDataReader对象.</returns>
public SqlDataReader GetReader(string CommandText)
{
SqlDataReader sdr;
sdr = CreateCommand(CommandText).ExecuteReader();
return (sdr);
}
/// <summary>
/// 运行SQL语句返回DataReader
/// </summary>
/// <returns>SqlDataReader对象.</returns>
public SqlDataReader GetReader(string CommandText,SqlConnection Conn)
{
SqlDataReader sdr;
sdr = CreateCommand(CommandText, Conn).ExecuteReader();
return (sdr);
}
/// <summary>
/// 返回DataAdapter对象
/// </summary>
/// <returns></returns>
public SqlDataAdapter GetDataAdapter(string CommandText)
{
SqlDataAdapter sda = new SqlDataAdapter(CommandText,ReturnConnection());
return (sda);
}
/// <summary>
/// 返回DataAdapter对象
/// </summary>
/// <returns></returns>
public SqlDataAdapter GetDataAdapter(string CommandText,SqlConnection Conn)
{
SqlDataAdapter sda = new SqlDataAdapter(CommandText,Conn);
return (sda);
}
/// <summary>
/// 检验是否存在数据
/// </summary>
/// <returns></returns>
public bool ExistDate(string CommandText)
{
if (GetReader(CommandText).Read())
{
Dispose();
return true;
}
else
{
Dispose();
return false;
}
}
/// <summary>
/// 返回SQL语句执行结果的第一行第一列
/// </summary>
/// <returns>字符串</returns>
public string ReturnValue(string CommandText)
{
string result="";
SqlCommand scmd = CreateCommand(CommandText);
try
{
result = Convert.ToString(scmd.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
Dispose();
return result;
}
}
</PRE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -