注册 登录
编程论坛 J2EE论坛

java连sql server 菜鸟问题

xweiweix 发布于 2007-12-16 18:04, 1009 次点击
import java.sql.*;

public class TestDB {
    public static void main(String[] args) {
        String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
        String userName = "sa";
        String userPwd = "";
        Connection dbConn;

        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
            System.out.println("Connection Successful!");
        } catch (Exception e) {
            e.printStackTrace();

        }
    }
}
如何才能连上呢???
运行结果:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
    at (Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at (Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
2 回复
#2
sea72007-12-16 20:18
没有加驱动把??
#3
guoxhvip2007-12-16 23:22
确认你的驱动(*.jar)有没有
还有sp4补丁安装没
1