Question

myeclipse链接sqlserver2000

我的代码是这样
package com.lw.tool;
import java.sql.*;
public class JDBConnection {
private final String url="jdbc:microsoft:sqlserver://localhost:1433; databaseName=db_BlodMay";
private final String userName = "sa";
private final String password = "123";
private Connection con = null;
static {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
然后报错如图：

Answer 1

package mybean;

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=CarCtrl";
String
userName = "sa";
String userPwd =
"";
try
{
Class.forName(driverName);
DriverManager.getConnection(dbURL,
userName, userPwd);
System.out.println("Connection
Successful!");
}
catch (Exception
e)
{
e.printStackTrace();
}
}
}