MS SQL Server、Oracle、Mysql各环境下的如何连接

1、java语言

        hibernate框架连接Oracle

database.driverClassName=oracle.jdbc.driver.OracleDriver
#dev
#database.url=jdbc:oracle:thin:@{IP}:1521:服务
#database.username=sa
#database.password=123456

        Mybatis框架连接MS SQL Server

url: jdbc:sqlserver://{IP}:1433;SelectMethod=cursor;DatabaseName=DBName
username: sa
password: 123456

2、domino语言

        ADO连接Oracle

    Dim conn As Variant
    Dim constr As String
    
    '链接Oracle数据库
    constr = " Provider=OraOLEDB.Oracle;Password=" + orgdoc.Password(0) _
    & ";User ID=" + orgdoc.UserName(0) + ";Data Source=" _
    & "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST =" + orgdoc.ServerIP(0) + ")(PORT=1521)))" _
    & " (CONNECT_DATA=(SERVICE_NAME=" + orgdoc.DBName(0) + ")));" _
    & " Persist Security Info=True "
    Set Conn = CreateObject("ADODB.Connection") 
    Conn.CommandTimeout = 10
    Conn.Open constr
    conn.CursorLocation=3

        ADO连接MS SQL Server

    Dim strConn As String
    strConn = "driver={SQL Server};"
    strConn = strConn + "server=" + sqldoc.ServerIP(0) + ";"
    strConn = strConn + "database=" + sqldoc.DBName(0) + ";"
    strConn = strConn + "UID=" + sqldoc.UserName(0) + ";"
    strConn = strConn + "PWD=" + sqldoc.Password(0) + ";"
    conn.Connectionstring = strConn
    conn.Connectiontimeout = 6000
    Call conn.open

        JDBC连接Mysql

    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
    static final String DB_URL = "jdbc:mysql://localhost:3306/test?autoReconnect=true";
    static final String USER = "sa";
    static final String PASS = "123";
 
    public void NotesMain() {
        Connection conn = null;
        try{
            session = getSession();
            curdb = session.getCurrentDatabase();
            conn = DriverManager.getConnection(DB_URL,USER,PASS);        
        }catch(SQLException se){
            // 处理 JDBC 错误
            se.printStackTrace();
        }catch(Exception e){
            // 处理 Class.forName 错误
            e.printStackTrace();
        }finally{
            try{
                if(conn!=null) conn.close();
            }catch(SQLException se){
                se.printStackTrace();
            }
        }
    }

3、C#

       连接MS SQL Server

配置

<add key="DataConnect" value="server={IP};database=DBPRD;uid=sa;pwd=123" />

使用

using System.Data.SqlClient;

private SqlConnection conn { get; set; }

public EnityDataHelper()
{
        connectionStr = System.Configuration.ConfigurationManager.AppSettings["DataConnect"];
        conn = new SqlConnection(connectionStr);
        conn.Open();
}

using (EnityDataHelper dataHelper = new EnityDataHelper("DataConnect"))
{
    object obj = dataHelper.RunScalarQueryCommand(string.Format("exec P_QuerySn '{0}'", sn), null);
}

        连接Mysql

配置

  <appSettings>
    <add key="MySqlConnecton" value="server=palo.bigdata;Database=dbname;User Id=sa;Password=123;charset=utf8;pooling=true"/>
  </appSettings>

使用

using MySql.Data.MySqlClient;

public static string ConnectionStr = System.Configuration.ConfigurationManager.AppSettings["MySqlDbConnecton"];

using (MySqlConnection conn = new MySqlConnection(ConnectionStr))
{
}

        连接redis

配置

  <appSettings>
    <add key="RedisConnection" value="{IP}:6379,password=123,allowadmin=true" />
  </appSettings> 

使用

StackExchange.Redis.dll

ConnectionMultiplexer.Connect(ConnectionStr);