java - 将 Microsoft SQL 与 Java 连接起来？

Question

我正在处理我的项目，我必须将 Microsoft SQL 与 Java 连接起来。我想从我的数据库中提取信息。我不断收到此错误:

 SEVERE: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at SendEmails.main(SendEmails.java:22)

我的驱动程序出了问题。我不明白是什么。也许我走错了路或者其他什么。这是我的代码:

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

public class SendEmails {

    public static void main(String[] args) {

        Connection conn = null;
        String dbName = "Student";
        String serverip="109.45.100.100";
        String serverport="1433";
        String url = "jdbc:sqlserver://"+serverip+"\\SQLEXPRESS:"+serverport+";databaseName="+dbName+"";
        Statement stmt = null;
        ResultSet result = null;
        String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String databaseUserName = "student";
        String databasePassword = "admin";
        try {
            Class.forName(driver).newInstance();
            conn = DriverManager.getConnection(url, databaseUserName, databasePassword);
            stmt = conn.createStatement();
            result = null;
            String pa,us;
            result = stmt.executeQuery("Select Top 45 * From Students ");

            while (result.next()) {
                us=result.getString("uname");
                pa = result.getString("pass");              
                System.out.println(us+"  "+pa);
            }

            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

如果有人知道我的代码有什么问题，请告诉我。

Answer 1

类路径中缺少 jar 文件。

将类路径设置为sqlserverjdbc.jar。

其中包含com.microsoft.jdbc.sqlserver.sqlserverdriver类。

首先检查您的 jar 文件是否包含 com.microsoft.sqlserver.jdbc.SQLServerDriver 或 com.microsoft.jdbc.sqlserver.sqlserverdriver 类。

Check system requirements here

Both jdk 7 and jdk 8 compatible jar file