weixin_47560301 2021-04-29 16:50 采纳率: 0%
浏览 43

IDEA连接SQL报错

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

public class Test {
    private static Connection dbConn = null;

    public static void main(String[] args) {
        String dbURL = "jdbc:sqlserver://192.168.1.125:1433;DatabaseName=sa";

        try {
            //1.加载驱动
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            System.out.println("加载驱动成功!");
            //2.连接
            dbConn = DriverManager.getConnection(dbURL, "sa", "123");
            System.out.println("连接数据库成功!");
            String sql="select * from school";
            PreparedStatement statement=null;
            statement=dbConn.prepareStatement(sql);
            ResultSet res = statement.executeQuery();
            while(res.next()){
                String title=res.getString("name");
                System.out.println(title);
            }
        }catch(Exception e) {
            e.printStackTrace();
            System.out.println("连接数据库失败!");
        }

    }
}

以上是我的代码
代码是正确的也能识别出来,但是运行的时候就一直在报下面这个错误,是不是版本之类的问题呀?求求大佬帮我看看!感谢!

Exception in thread "main" java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 59.0), this version of the Java Runtime only recognizes class file versions up to 52.0
 

  • 写回答

5条回答

  • 有问必答小助手 2021-04-29 19:01
    关注

    您好,我是有问必答小助手,您的问题已经有小伙伴解答了,您看下是否解决,可以追评进行沟通哦~

    如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~

    ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632

    评论

报告相同问题?