sidemengyi 2014-10-29 07:21 采纳率: 33.3%
浏览 664

请问大神这个程序问题出在哪里啊

这样是没问题的
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC {
public static void main(String[] args) throws ClassNotFoundException,SQLException {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=HYGJ_0922";
Connection conn = DriverManager.getConnection(url, "sa", "123");z
Statement smst = conn.createStatement();
ResultSet rs = smst.executeQuery("select * from TBL_COURSE");
while (rs.next()) {
System.out.print(rs.getString("COU_NO") + ":");
System.out.println(rs.getString("COU_NAME"));
}
rs.close();
smst.close();
conn.close();
}
}
但是加上TRY语句块的话 就会报错
java.sql.SQLException: No suitable driver found for jdbc:sqlserver:localhost:1433;DatabaseName=HYGJ_0922
代码如下,谢谢大神
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC2 {
public static void main(String[] args) {
ResultSet rs = null;
Statement stmt = null;
Connection conn = null;
try {

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver:localhost:1433;DatabaseName=HYGJ_0922";
        conn = DriverManager.getConnection(url, "sa", "123");
        stmt = conn.createStatement();
        rs = stmt.executeQuery("select * from TBL_COURSE");

        while (rs.next()) {
            System.out.println("TRE_NAME");
        }

    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (stmt != null) {
                stmt.close();
                stmt = null;
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

}

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配
    • ¥15 Power query添加列问题
    • ¥50 Kubernetes&Fission&Eleasticsearch
    • ¥15 報錯:Person is not mapped,如何解決?
    • ¥15 c++头文件不能识别CDialog
    • ¥15 Excel发现不可读取的内容