＋设为首页 ＋添加到收藏夹
import java.sql.*;
class reDB
{
public static void main(String[] args){
String url = "jdbc.microsoft:sqlserver://localhost:143;DatabaseName=hoson";
String user = "hoson";
String strpw = "hoson";
Statement stmt;
try{
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection(url,user,strpw);
//Connection conn = DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "SELECT ctg_ID, ctg_descrption FROM tb_ctg";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.println("::" + rs.getString("ctg_ID") + rs.getString("ctg_descrption"));
}
}catch(Exception e){
e.getMessage();
e.printStackTrace();
}
}
}
出现如下的错误:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at reDB.main(reDB.java:14)
请问如何解决!谢谢
改用ｊｔｄｓ的驱动试试
