java 纯JDBC连接数据库问题
package com.tamptest;
import java.sql.*;
public class test1 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
PreparedStatement psPreparedStatement=null;
Connection ct=null;
ResultSet rSet=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//加载驱动
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=examination","sa","111");
psPreparedStatement=ct.prepareStatement("select * from exam_paper from examination");
rSet=psPreparedStatement.executeQuery();//insert,delete,update用executeUpdate(),select用executeQuery()
while (rSet.next()) {
int numOne=rSet.getInt(1);
System.out.println(numOne);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}
报的错误是
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=examination
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.tamptest.test1.main(test1.java:17)
jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=examination
jdbc:microsoft:sqlserver://localhost:1433;databaseName=examination
jdbc:microsoft:sqlserver:服务器名字:1433;databaseName=examination
这三行都试过了。
sqljdbc_2.0里面的两个sqljdbc4.jar和sqljdbc.jar两个包都引了
求解决方案