java連接配接sqlserver的方法分享

轉自:

​​http://www.java265.com/JavaJingYan/202206/16552126983712.html​​

sqlserver:

實作思路:
    隻需使用sqljdbc4.jar檔案
   即可實作讀取sqlserver

注意事項:
   此方法可解決java連接配接sqlserver的SSL異常      

1.pom.xml 中引入jar包
<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->
<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>sqljdbc4</artifactId>
    <version>4.0</version>
</dependency>

2.編寫相應的代碼
package com.java265.testmaven;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class TestSqlServer {
    /**
     * java265.com 連接配接sqlserver的示例代碼
     */
    public static void main(String[] args) throws ClassNotFoundException {
          String connectionUrl =
                    "jdbc:sqlserver://192.168.8.88:1433;" + "database=test;"
                            + "user=sa;"
                            + "password=sapwd;";
                            //+ "encrypt=false;" + "trustServerCertificate=true;"
                            //+ "loginTimeout=10;";

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            try (Connection connection = DriverManager.getConnection(connectionUrl);) {

                // code
                System.out.println("資料庫連接配接成功！");
                
                }
                // 異常處理
            catch (SQLException e) {
                e.printStackTrace();
            }
    }
}