WebPortal_Lib/01.Lib/com/util/common/DBUtil.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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.Collections.Generic;
using System.Text;

using com.constant;
using com.constant.common;

namespace com.util.common
{
    /// <summary>
    /// DBUtil:数据库操作类
    /// </summary>
    public class DBUtil
    {
        public static string connectionString = ConfigurationManager.AppSettings["connectionString"].ToString();
        
        #region 构造函数
        public DBUtil()
        {

         }
        #endregion

        #region 执行sql语句,名称：executeSql
        /// <summary>
        /// 执行sql语句
        /// </summary>
        /// <param name="_rows">
        /// 所影响的行数
        /// </param>
        public static bool executeSql(string strSql,out int _rows, out string _output)
        {
            _output = "";
            _rows = -1;
            bool flag = true;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand cmd = new SqlCommand(strSql, connection))
                {
                    try
                    {
                        connection.Open();
                        _rows = cmd.ExecuteNonQuery();

                    }
                    catch (Exception e)
                    {
                        flag = false;
                        connection.Close();
                        _output = e.Message.ToString();