SqlHelper其實(shí)是我們自己編寫(xiě)的一個(gè)類(lèi)，使用這個(gè)類(lèi)目的就是讓使用者更方便、更安全的對(duì)數(shù)據(jù)庫(kù)的操作，既
是除了在SqlHelper類(lèi)以外的所有類(lèi)將不用引用對(duì)數(shù)據(jù)庫(kù)操作的任何類(lèi)與語(yǔ)句，無(wú)須擔(dān)心數(shù)據(jù)庫(kù)的連接與關(guān)閉的問(wèn)題。

{ 
    public class SQLHelper 
    { 
        private string strConn = null; 
        private SqlConnection Conn = null; 
        private SqlCommand Cmd = null; 
        private SqlDataReader Sqlsdr = null; 
        public SQLHelper() 
        { 
            //利用反射連接數(shù)據(jù)庫(kù) 
            strConn = ConfigurationManager.ConnectionStrings["strConn"].ConnectionString; 
            //strConn = "data source=192.168.24.83;initial catalog=NewsSystem;user id=sa;password=123456"; 
            Conn = new SqlConnection(strConn); 
        } 
   
        /// <summary> 
        /// 狀態(tài) 
        /// </summary> 
        /// <returns>SqlConnection</returns> 
        private SqlConnection GetConn() 
        { 
            if (Conn.State == ConnectionState.Closed) 
            { 
                Conn.Open(); 
            } 
            return Conn; 
        } 
   
        /// <summary> 
        /// 執(zhí)行不帶參數(shù)的增刪改操作 
        /// </summary> 
        /// <param name="CmdText">執(zhí)行的SQL語(yǔ)句或存儲(chǔ)過(guò)程</param> 
        /// <param name="CmdType">類(lèi)型</param> 
        /// <returns>增刪改的操作數(shù)</returns> 
   
        public int ExecuteNonQuery(string CmdText, CommandType CmdType) 
        { 
            //數(shù)據(jù)庫(kù)連接語(yǔ)句 
            int res; 
            try 
            { 
                Cmd = new SqlCommand(CmdText, GetConn()); 
                Cmd.CommandType = CmdType; 
                res = Cmd.ExecuteNonQuery(); 
   
            } 
            catch (Exception ex) 
            { 
   
                throw ex; 
            } 
            finally 
            { 
                if (Conn.State == ConnectionState.Open) 
                { 
                    Conn.Close(); 
                } 
            } 
            return res; 
        } 
   
        /// <summary> 
        /// 執(zhí)行帶參數(shù)的增刪改操作 
        /// </summary> 
        /// <param name="CmdText">執(zhí)行的SQL語(yǔ)句或存儲(chǔ)過(guò)程</param> 
        /// <param name="Parameters">參數(shù)</param> 
        /// <param name="CmdType">類(lèi)型（SQL語(yǔ)句或存儲(chǔ)過(guò)程）</param> 
        /// <returns>增刪改的操作數(shù)</returns> 
        public int ExecuteNonQuery(string CmdText, SqlParameter[] Parameters, CommandType CmdType) 
        { 
            int res; 
            try 
            { 
                Cmd.Parameters.AddRange(Parameters); 
                Cmd = new SqlCommand(CmdText, GetConn()); 
                Cmd.CommandType = CmdType; 
                res = Cmd.ExecuteNonQuery(); 
            } 
            catch (Exception ex) 
            { 
   
                throw ex; 
            } 
            finally 
            { 
                if (Conn.State == ConnectionState.Open) 
                { 
                    Conn.Close(); 
                } 
            } 
            return res; 
        } 
   
   
        /// <summary> 
        /// 不帶參數(shù)的查詢 
        /// </summary> 
        /// <param name="CmdText">執(zhí)行的SQL語(yǔ)句或存儲(chǔ)過(guò)程</param> 
        /// <param name="CmdType">類(lèi)型</param> 
        /// <returns>查詢的數(shù)據(jù)</returns> 
        public DataTable ExecuteQuery(string CmdText, CommandType CmdType) 
        { 
            DataTable dt = new DataTable(); 
   
            using (Sqlsdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection)) 
            { 
                Cmd = new SqlCommand(CmdText, GetConn()); 
                Cmd.CommandType = CmdType; 
                dt.Load(Sqlsdr); 
            } 
            return dt; 
        } 
   
        /// <summary> 
        /// 帶參數(shù)的查詢 
        /// </summary> 
        /// <param name="CmdText">SQL語(yǔ)句或存儲(chǔ)過(guò)程</param> 
        /// <param name="Parameters">參數(shù)</param> 
        /// <param name="CmdType">類(lèi)型</param> 
        /// <returns>查詢的數(shù)據(jù)</returns> 
        public DataTable ExecuteQuery(string CmdText, SqlParameter[] Parameters, CommandType CmdType) 
        { 
            DataTable dt = new DataTable(); 
   
            using (Sqlsdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection)) 
            { 
                Cmd = new SqlCommand(CmdText, GetConn()); 
                Cmd.CommandType = CmdType; 
                Cmd.Parameters.AddRange(Parameters); 
                dt.Load(Sqlsdr); 
            } 
            return dt; 
        } 
    } 
}

標(biāo)簽： 安全 數(shù)據(jù)庫(kù)

版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請(qǐng)聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點(diǎn)！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請(qǐng)與原作者聯(lián)系。