连接数据库,怎么用mssqlserver.jar
我下了mssqlserver.jar,放在jdk的lib中,并且在classpath也写了它,最后在一个applet中写
try{
String driver_name ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
final String conString = "jdbc:microsoft qlserver://ht-cw:1433;databaseName=cw;user=sa;password=";
Class.forName(driver_name).newInstance();
Connection con = DriverManager.getConnection(conString);
PreparedStatement a= con.prepareStatement(
"select * from Signatrue");
ResultSet b = a.executeQuery();
String c;
if (b.next()) {
c = b.getString(1);
}
//关闭结果集
b.close();
//关闭语句
a.close();
}
catch (java.lang.Exception ex) {
ex.printStackTrace();
}
编译没有错.
当运行这段代码时
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
不是知道怎么回事?