sqlhelp.cs

来源：互联网发布：淘宝5xl的裤子是多少码编辑：程序博客网时间：2024/05/15 03:02

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Collections;

using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.UI;

using System.Configuration;
namespace Conn
{
    public class Connect
    {
        private static OleDbConnection con;
        public static string connsql = ConfigurationSettings.AppSettings["treedatebaseConnectionString"];//杩炴帴鏁版嵁搴撶殑璇彞
        public static int count = 10;//鏈€澶氱殑杩炴帴涓暟
        private Connect()
        {
            con = new OleDbConnection(connsql);
          con.Open();
            con.State.ToString();
        }
        private static OleDbConnection getcon()
        {
            ArrayList array = new ArrayList();
            if (array.Count < count)
            {
                Connect conn = new Connect();
                array.Add(con);
                return con;
            }
            for (int i = 0; i < array.Count; i++)
            {
                if (((OleDbConnection)array[i]).State == ConnectionState.Closed)
                {
                    array.RemoveAt(i);
                    i--;
                }
            }
            return ((OleDbConnection)array[0]);
        }
        public static OleDbCommand executeSql(string sql)
        {
            OleDbCommand com = new OleDbCommand(sql, getcon());
            com.ExecuteNonQuery();
            return com;
        }
        public static DataSet getDataset(string sql, string tablename)
        {
            DataSet ds = null;
            ds = new DataSet();
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, getcon());
            adp.Fill(ds, tablename);
            return ds;
        }
        public static string getReader(string s)
        {
            string a = "";
            OleDbDataReader reader = executeSql(s).ExecuteReader();
            if (reader.Read())
            {
                a = reader.GetValue(0).ToString();
            }
            reader.Close();
            return a;
        }
        public static DataTable getDatatable(string sql)
        {
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, getcon());
            DataTable table = new DataTable();
            adp.Fill(table);
            return table;
        }
        public static int executesql(string sql)
        {
            OleDbCommand com = null;
            try
            {
                 com = new OleDbCommand(sql, getcon());
                 return com.ExecuteNonQuery();
            }
            catch
            {
               return 0;
            }
            finally
            {
                com.Dispose();
                con.Close();
            }
        }
    }
}

Conn.Connect.connsql = "Provider=SQLOLEDB;uid=xuwei;pwd=123456;database=treedatebase;server=.";