ADO.NET 操作类

using System;
using System.Data;
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;
using System.Data.SqlClient;
using System.Security.Cryptography;//MD5加密引入的命名空间
namespace Register.ValidateCode
{
    public class DB
    {
        public SqlConnection GetCon()//数据库连接对象
        {
            return new SqlConnection(ConfigurationManager.AppSettings[SQLCONNECTIONSTRING].ToString());
        }

        public int SqlEX(string cmdstr)  //执行SQL命令并返回受影响行，成功返回1，失败返回0
        {
            SqlConnection con = GetCon();
            con.Open();
            SqlCommand cmd = new SqlCommand(cmdstr, con);
            try
            {
                cmd.ExecuteNonQuery();//执行并返回受影响行
                return 1;//成功返回1
            }
            catch (System.Exception e)
            {
                return 0;//失败返回0
            }
            finally
            {
                con.Dispose();//释放连接
            }
        }

        ///<summary>
        /// 通过sql语句查询，将查询的结果存储在dataset对象中
        ///</summary>
        public DataTable rdDt(string cmdstr)
        {
            SqlConnection con = GetCon();
            SqlDataAdapter da = new SqlDataAdapter(cmdstr,con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return (ds.Tables[0]);
        }

        ///<summary>
        ///将执行结果存储在一个sqldatareader中，执行查询处理
        ///</summary>
        public SqlDataReader reDr(string str)
        {
            SqlConnection conn = GetCon();
            conn.Open();
            SqlCommand com = new SqlCommand(str,conn);
            SqlDataReader dr = com.ExecuteReader(CommandBehavior.CloseConnection);
            return dr;
        }

        ///<summary>
        ///MD5加密，使密码不被查看
        ///</summary>
        public string MD5_Str(string strPwd)
        {
            MD5 md5=new MD5CryptoServiceProvider();
            byte[] data = System.Text.Encoding.Default.GetBytes(strPwd);
            byte[] md5data = md5.ComputeHash(data);
            md5.Clear();
            string str = "";
            for (int i = 0; i < md5data.Length - 1;i++ )
            {
                str += md5data[i].ToString("x").PadLeft(2, '0');
            }
            return str;
        }
    }
}

 

说明：其中MD5 加密在.NET安全机制中也提供了方法。需要引入命名空间 System.Web.Security。具体方法如下：

　　　public static string MD5Hash(this string s)

        {

            return FormsAuthentication.HashPasswordForStoringInConfigFile(s,"MD5");

        }