java sql 登录失败_数据库连接失败 java.sql.SQLException

代码:

public static void main(String[] args) {

// TODO Auto-generated method stub

//定义需要的对象

PreparedStatement ps=null;

Connection ct=null;

ResultSet rs=null;

try {

//初始化我们的对象

//1.加载驱动

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

//2.得到链接

ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.102:1433;databaseName=test");

//3.创建火箭车

ps=ct.prepareStatement("select * from emp");

//执行(如果是增加，删除，修改 ,executUpdate()。如果是查询 executeQuery())

rs=ps.executeQuery();

//循环的取出(名字，薪水，部门号)

while(rs.next()){

String name=rs.getString(2);

float sal=rs.getFloat(6);

int deptNo=rs.getInt(8);

System.out.println(name+" "+sal+" "+deptNo);

}

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

}

异常:

java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://192.168.102:1433;databaseName=test

at java.sql.DriverManager.getConnection(DriverManager.java:602)

at java.sql.DriverManager.getConnection(DriverManager.java:207)

at com.test2.Test3.main(Test3.java:26)

Win7旗舰版，sql server2012