我正在我的项目中,我必须将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.SQLServerDriver
或com.microsoft.jdbc.sqlserver.sqlserverdriver
类。
Check system requirements here
Both jdk 7 and jdk 8 compatible jar file