我正在我的项目中,我必须将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();
        }
    }
}


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

最佳答案

您的类路径中缺少jar文件。

将类路径设置为sqlserverjdbc.jar

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

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

Check system requirements here

Both jdk 7 and jdk 8 compatible jar file

09-09 23:32
查看更多