/*******************************************
*功能:数据库操作相关
*作者:FlashICP
*时间:2005-7-22
*******************************************/
usingSystem;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Web;
namespacemoban
{
publicclassdata
{
protectedstaticstringcon="server=[yourserver];database=[yourdata];userid=[yourid];password=[youpassword]";
//数据库字符串
protectedSystem.Data.SqlClient.SqlConnectionDataConnection;
//数据库连接对象
protectedSystem.Data.SqlClient.SqlDataAdapterDataAdapter;
//SqlDataAdapter对象
protectedSystem.Data.SqlClient.SqlCommandDataCommand;
//SqlCommand对象
protectedSystem.Data.SqlClient.SqlCommandBuilderDataComBuilder;
//SqlCommandBuilder对象
protectedSystem.Data.DataSetDataSet;
//DataSet对象
protectedSystem.Data.DataRowDataRow;
//DataRow对象
protectedSystem.Data.SqlClient.SqlDataReaderDataReader=null;
//构造函数
publicdata()
{
DataConnection=DataConn();
}
//连接数据库参数
publicstringCon
{
get{returncon;}
set{con=value;}
}
//数据库连接参数
publicSqlConnectionDataConn()
{
DataConnection=newSqlConnection(Con);
returnDataConnection;
}
//返回数据库连接对象
publicSqlDataReaderDataQuery(stringSql)
{
Sql=Sql.Replace("--","");
Sql=Sql.Replace(";","");
DataConnection=DataConn();
DataConnection.Open();
DataReader=null;
DataCommand=newSqlCommand(Sql,DataConnection);
DataReader=DataCommand.ExecuteReader();
DataCommand.Dispose();
returnDataReader;
}
//返回DataSet
publicvirtualDataSetDataSetQuery(stringSql,stringTableName)
{
DataConnection=DataConn();
DataAdapter=newSqlDataAdapter(Sql,DataConnection);
DataSet=newDataSet();
DataAdapter.Fill(DataSet,TableName);
DataAdapter.Dispose();
DataConnection.Close();
DataConnection.Dispose();
returnDataSet;
}
//返回DataSet
publicDataSetDataSetQuery(DataSetmyds,stringTableName,stringSql)
{
DataConnection=DataConn();
DataAdapter=newSqlDataAdapter(Sql,DataConnection);
DataAdapter.Fill(myds,TableName);
DataConnection.Close();
DataConnection.Dispose();
returnDataSet;
}
//返回DataSet
publicDataSetDataSetQuery(stringSql,stringTableName,intStarIndex,intCount)
{
DataConnection=DataConn();
DataConnection.Open();
DataAdapter=newSqlDataAdapter(Sql,DataConnection);
DataSet=newDataSet();
DataAdapter.Fill(DataSet,StarIndex,Count,TableName);
DataConnection.Close();
DataConnection.Dispose();
returnDataSet;
}
publicvoidDataDo(stringsqlstr)
{
DataConnection=DataConn();
SqlCommandmycom=DataConnection.CreateCommand();
mycom.CommandText=sqlstr;
DataConnection.Open();
mycom.ExecuteNonQuery();
DataConnection.Close();
}
//返回DataSet开始行到结束行
publicboolEditData(stringSql)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=newSqlCommand(Sql,DataConnection);
try
{
DataCommand.ExecuteNonQuery();
DataConnection.Close();
returntrue;
}
catch(Exceptionex)
{
System.Console.Write(ex.Message.ToString());
DataConnection.Close();
returnfalse;
}
}
//执行成功返回真,否则返回假.
publicobjectExecuteScalar(stringSql)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=newSqlCommand(Sql,DataConnection);
try
{
objectback=DataCommand.ExecuteScalar();
DataConnection.Close();
returnback;
}
catch(Exceptionex)
{
System.Console.Write(ex.Message.ToString());
DataConnection.Close();
returnnull;
}
}
//返回一个值的查询语句
publicDataSetEditData(DataSetDataSet,SqlDataAdaptermyda,stringTableName)
{
DataComBuilder=newSqlCommandBuilder(myda);
myda.UpdateCommand=DataComBuilder.GetUpdateCommand();
myda.DeleteCommand=DataComBuilder.GetDeleteCommand();
myda.InsertCommand=DataComBuilder.GetInsertCommand();
myda.Update(DataSet,TableName);
DataSet.AcceptChanges();
this.CloseConnection();
returnDataSet;
}
//修改DataSet并且修改数据库值存储过程
publicboolDataProcedure(stringProcedureName)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=newSqlCommand();
DataCommand.CommandText=ProcedureName;
DataCommand.Connection=DataConnection;
DataCommand.CommandType=System.Data.CommandType.StoredProcedure;
try
{
DataCommand.ExecuteNonQuery();
returntrue;
}
catch(Exceptionex)
{
System.Console.Write(ex.Message.ToString());
returnfalse;
}
}
//无参数存储过程的执行返回执行真假
publicvoidCloseConnection()
{
if(DataReader!=null)
{
DataReader.Close();
DataReader=null;
}
DataConnection.Close();
DataConnection.Dispose();
}
//关闭连接
}
}