Asp.net(c#)数据库操作类

来源：互联网发布：淘宝收藏软件手机版编辑：程序博客网时间：2024/05/16 01:50

document.write(baiduCproIFrame());-->

usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
usingSystem.Data.SqlClient;
namespaceMysqlserver
{
   ///<summary>
   ///SqlServerDataBase的摘要说明
   ///</summary>
   publicclassSqlServerDataBase
   {
       privatestringstrError=null;
       privateintintCount=0;
       publicSqlServerDataBase()
       {
           //
           //TODO:在此处添加构造函数逻辑
           //
       }
       ///<summary>
       ///公开方法DBConn，返回数据库连接
       ///</summary>
       ///<returns></returns>
       publicSqlConnectionDBconn()
       {
           stringstrConn="Server=(local);Database=GlobalMeetings;Uid=sa;pwd=";
           try
           {
               returnnewSqlConnection(strConn);
           }
           catch(Exception)
           {
               returnnull;
           }
       }
       ///<summary>
       ///公开属性ErrorMessage，返回错误信息
       ///</summary>
       publicstringErrorMessage
       {
           get
           {
               returnstrError;
           }
       }

       ///<summary>
       ///根据查询语句从数据库检索数据
       ///</summary>
       ///<paramname="strSelect">查询语句</param>
       ///<paramname="SqlConn">数据库连接</param>
       ///<returns>有数据则返回DataSet对象，否则返回null</returns>
       publicDataSetSelect(stringSelectString,SqlConnectionsqlConn)
       {
           strError="";
           SqlConnectionconn;
           if(sqlConn==null)
           {
               conn=DBconn();
           }
           else
           {
               conn=sqlConn;
           }
           try
           {
               //若数据库连接的当前状态是关闭的，则打开连接
               if(conn.State==ConnectionState.Closed)
               {
                   conn.Open();
               }
               SqlDataAdaptermySqlDataAdapter=newSqlDataAdapter();
               SqlCommandselectCommand=newSqlCommand(SelectString,conn);
               selectCommand.CommandType=CommandType.Text;
               mySqlDataAdapter.SelectCommand=selectCommand;
               DataSetmyDS=newDataSet();
               mySqlDataAdapter.Fill(myDS);
               returnmyDS;
           }
           catch(Exceptione)
           {
               strError="数据检索失败："+e.Message;
               returnnull;
           }
           finally
           {
               if(conn.State!=ConnectionState.Closed)
               {
                   conn.Close();
               }
           }
       }
       ///<summary>
       ///更新数据库
       ///</summary>
       ///<paramname="UpdateString">UpdateSql语句</param>
       ///<paramname="SqlConn">数据库连接</param>
       ///<returns>更新成功返回true</returns>
       publicboolUpdate(stringUpdateString,SqlConnectionSqlConn)
       {
           returnudiDataBase(UpdateString,SqlConn);
       }
       ///<summary>
       ///从数据库中删除数据
       ///</summary>
       ///<paramname="DeleteString">DeleteSql语句</param>
       ///<paramname="SqlConn">数据库连接</param>
       ///<returns>删除成功返回true</returns>
       publicboolDelete(stringDeleteString,SqlConnectionSqlConn)
       {
           returnudiDataBase(DeleteString,SqlConn);
       }
       ///<summary>
       ///把数据插入数据库
       ///</summary>
       ///<paramname="InsertString">InsertSql语句</param>
       ///<paramname="SqlConn">数据库连接</param>
       ///<returns>插入成功返回true</returns>
       publicboolInsert(stringInsertString,SqlConnectionSqlConn)
       {
           returnudiDataBase(InsertString,SqlConn);
       }
       ///<summary>
       ///根据Sql语句更新数据库
       ///</summary>
       ///<paramname="UDIString">更新语句</param>
       ///<paramname="SqlConn">数据库连接</param>
       ///<returns>更新成功则返回true</returns>
       publicbooludiDataBase(stringUDIString,SqlConnectionSqlConn)
       {
           strError="";
           SqlConnectionconn;
           if(SqlConn==null)
           {
               conn=DBconn();
           }
           else
           {
               conn=SqlConn;
           }
           try
           {
               if(conn.State==ConnectionState.Closed)
               {
                   conn.Open();
               }
               SqlCommandcmd=newSqlCommand(UDIString,conn);
               cmd.CommandType=CommandType.Text;
               intCount=cmd.ExecuteNonQuery();
               return!(intCount<1);
           }
           catch(Exceptione)
           {
               strError="更新数据库失败："+e.Message;
               returnfalse;
           }
           finally
           {
               if(conn.State!=ConnectionState.Closed)
               {
                   conn.Close();
               }
           }
       }
   }
}
-----------------------------
两种调用方法
1、                   stringstrUserPsw=UserPsw.Text.Trim();
                   stringUserPassword=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(strUserPsw,"MD5");//md5加密
                   SqlServerDataBaseobj=newSqlServerDataBase();
                   obj.Insert("insertintoasUserInfo(UserName,UserPassword,Question,Answer,CreateTime)values('"+UserName.Text.Trim()+"','"+UserPassword+"','"+Question.Text.Trim()+"','"+Answer.Text.Trim()+"','"+DateTime.Now.ToString()+"')",null);
2、       privateboolIsUsernameExist(stringstrUsername)
       {
           boolbRet=true;
           SqlServerDataBasedb=newSqlServerDataBase();
           DataSetds=db.Select("select*fromasUserInfowhereUserName='"+strUsername+"'",null);
           if(ds==null||ds.Tables.Count==0||ds.Tables[0].Rows.Count==0)
           {
               bRet=false;
           }
           else
           {
               bRet=true;
           }

returnbRet;
}