添加到Classpath的JDBC jar仍然收到错误 [英] JDBC jar added to Classpath still receiving error

问题描述

我正在测试我与数据库的连接。我无法正确编译。我已经通过Intellij IDE将sqljdbc4.jar添加到类路径中（可能它做错了吗？）但是它出现在Project Structures下的Open Modules的Classpath下。
如何解决这个问题？

I'm testing my connection to a database. I cannot get this to compile properly. I have added the sqljdbc4.jar to the classpath via the Intellij IDE (perhaps it was done incorrectly?) but it is showing up under Classpath from Open Modules under the Project Structures. How do I solve this?

这是我的错误：

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at Automate.dbConnect(Automate.java:16)
at Automate.main(Automate.java:34)

以下是代码：

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

class Automate {
    public void dbConnect(String db_connect_string,
                      String db_userid,
                      String db_password)
{
    try {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

        Connection conn = DriverManager.getConnection(db_connect_string,
                db_userid, db_password);
        System.out.println("connected");
        Statement statement = conn.createStatement();
        String queryString = "select * from sysobjects where type='u'";
        ResultSet rs = statement.executeQuery(queryString);
        while (rs.next()) {
            System.out.println(rs.getString(1));
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}
public static void main(String[] args)
{
    Automate connServer = new Automate();
    connServer.dbConnect("jdbc:sqlserver://SERVER, "USERNAME",
            "PASSW");
}

推荐答案

我的问题是我使用的是过时的JDBC类名。

My problem was I was using an outdated JDBC class name.

这是修复：

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

小虫...大问题

这篇关于添加到Classpath的JDBC jar仍然收到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！