java 数据库连接问题
逝火 2013-08-11 11:31:38 程序代码如下:
import java.sql.*;
public class JdbcWay {
public static void main(String[] args) {
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=YUBINlibrary");
ps=ct.prepareStatement("select 借阅证号,姓名,类型from USERS");
rs=ps.executeQuery();
while(rs.next())
{
String num=rs.getString(1);
String name=rs.getString(2);
int type=rs.getInt(3);
System.out.println(num+" "+name+" "+type);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
try {
ct.close();
ps.close();
rs.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
**************************************
报错:java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;databasename=YUBINlibrary
本人新手,已经被虐,求高手解答,救小弟一命!