111

cjs

2025-06-06 03e67373c4c3bef21936ec1f9037f2ebcd434583

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace HH.AMS.Ex.MSSQLServices
{
    public enum DataBaseType
    {
        SqlServer,
        MySql,
        Oracle,
        Aceess
    }
 
    public class Connections
    {
        //public  string MsSqlConnetctionString;
 
        //public  string MySqlConnetctionString;
 
        //public  string OracleSqlConnetctionString;
 
        private static readonly Connections instance = new Connections();
 
        /// <summary>
        /// 获取单实例
        /// </summary>
        public static Connections Instance
        {
            get
            {
                return instance;
            }
        }
 
        
 
        /// <summary>
        /// 连接MSSQL
        /// </summary>
        /// <returns></returns>
        public IDbConnection GetConnection(string MsSqlConnetctionString)
        {
            //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
            SqlConnection conn = new SqlConnection(MsSqlConnetctionString);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            return conn;
        }
 
        /// <summary>
        /// 连接MYSQL
        /// </summary>
        /// <returns></returns>
        //public MySqlConnection GetMySQLConnection(string MySqlConnetctionString)
        //{
        //    //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
        //    MySqlConnection conn = new MySqlConnection(MySqlConnetctionString);
        //    if (conn.State == ConnectionState.Closed)
        //        conn.Open();
        //    return conn;
        //}
 
        /// <summary>
        /// 连接ORACLE
        /// </summary>
        /// <returns></returns>
        //public  OracleConnection GetOracleConnection()
        //{
        //    //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
        //    OracleConnection conn = new OracleConnection(OracleSqlConnetctionString);
        //    if (conn.State == ConnectionState.Closed)
        //        conn.Open();
        //    return conn;
        //}
    }
}