为什么我的数据库类总是连接不上数据库
类如下:
开发环境:myeclipse8.6
import java.sql.*;
import java.util.*;
public class DBtest {
private String ClassName;
private String url;
private String Username;
private String Password;
private Connection conn;
public DBtest()
{
ClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=AdventureWorks";
Username="sa";
Password="111111";
}
public void loadDrive() //加载驱动
{
try
{
Class.forName(ClassName);
}
catch(ClassNotFoundException e)
{
System.out.println("加载驱动程序失败!");
e.printStackTrace();
}
}
public void getCon() //判断连接
{
loadDrive();
try
{
conn=DriverManager.getConnection(url,Username,Password);
}
catch(Exception e)
{
System.out.println("连接失败!");
e.printStackTrace();
}
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DBtest db=new DBtest();
db.getCon();
}}
类如下:
开发环境:myeclipse8.6
import java.sql.*;
import java.util.*;
public class DBtest {
private String ClassName;
private String url;
private String Username;
private String Password;
private Connection conn;
public DBtest()
{
ClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=AdventureWorks";
Username="sa";
Password="111111";
}
public void loadDrive() //加载驱动
{
try
{
Class.forName(ClassName);
}
catch(ClassNotFoundException e)
{
System.out.println("加载驱动程序失败!");
e.printStackTrace();
}
}
public void getCon() //判断连接
{
loadDrive();
try
{
conn=DriverManager.getConnection(url,Username,Password);
}
catch(Exception e)
{
System.out.println("连接失败!");
e.printStackTrace();
}
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DBtest db=new DBtest();
db.getCon();
}}
2.网上找sqlserver的驱动包 jar格式的 下载下来放到工程的lib里