连接实例

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SqlConnectionExample {
		public static void main(String[] args) {
			String connectionUrl = "jdbc:sqlserver://mssqlf83eb5******.rds-mssql.ivolces.com:1433;"
					+ "database=master;"
					+ "user=veyun_user;"
					+ "password=Admin*****;"
					+ "loginTimeout=30;";
	
			ResultSet resultSet;
			try (Connection connection = DriverManager.getConnection(connectionUrl);
					Statement statement = connection.createStatement()) {
			
					String selectSql = "SELECT @@version";
					resultSet = statement.executeQuery(selectSql);
					
					while (resultSet.next()) {
						System.out.println(resultSet.getString(1));
					}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
}

using System;
using System.Data.SqlClient;

namespace SqlConnectionSSLExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // 建立连接
            // Data Source 指定目标 SQL Server 数据库服务器的地址；Initial Catalog 指定连接的目标数据库名称；User ID 指定连接数据库所需的用户名，默认为 veyun_user；Password 指定连接数据库所需的密码。
            string connectionString = "Data Source=mssqlf83eb5******.rds-mssql.ivolces.com;Initial Catalog=master;User ID=veyun_user;Password=Admin*****;";
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // 打开连接
                connection.Open();
                try
                {
                    // 执行 SQL 查询
                    SqlCommand cmd = new SqlCommand("SELECT @@version", connection);

                    string result = cmd.ExecuteScalar().ToString();

                    Console.WriteLine(result);
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Error: {ex.Message}");
                }
            }
        }
    }
}