Java 和DotNet建立数据库连接的语句

最新推荐文章于 2022-04-06 07:45:00 发布

大蹦

最新推荐文章于 2022-04-06 07:45:00 发布

阅读量754

点赞数

分类专栏： Java web Java Dotnet 文章标签： java 数据库 exception sqlserver oracle security

本文链接：https://blog.csdn.net/haqer0825/article/details/7950413

版权

Java web 同时被 3 个专栏收录

38 篇文章 0 订阅

订阅专栏

Java

29 篇文章 0 订阅

订阅专栏

Dotnet

17 篇文章 0 订阅

订阅专栏

DotNet 连SQLServer:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data.SqlClient;
using System.Data;

namespace ConsoleApplication1
{
    class Program
    {
        DbConnection _Conn;
        public static void func() 
        {
            DbConnection _Conn =new SqlConnection(@"Data Source=10.133.72.43\TEST;Initial Catalog=ElecTagdb;Persist Security Info=True;User ID=haq;Password=sa");
            if (_Conn != null && _Conn.State != ConnectionState.Open)
            {
                try
                {
                    _Conn.Open();
                    Console.Write("suc");

		   _Conn.Close();
                }
                catch (Exception e) 
                {
                    Console.Write(e.Message);
                    
                }
            }

        }
        static void Main(string[] args)
        {
            func();
            Console.Read();
        }
    }
}

Java建立Oracle连接:

    public static Connection getCommonConnection() throws Exception {
        Connection connection = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");    
            connection = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl,"用户名","密码");
        } catch (Exception e) {
            e.printStackTrace();
            throw new QMLMPException(e);
        } 

      return connection;
 
    }