public static void main(String[] args) {
// 装载SQL驱动程序
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String urlString="jdbc:microsoft:sqlserver://localhost:1433;DataBasename=master";
Connection connection=DriverManager.getConnection(urlString, "sa", "9028");
Statement statement=connection.createStatement();
String strSql="select * from spt_values";
ResultSet rSet=statement.executeQuery(strSql);
while(rSet.next())
{
System.out.println(rSet.getInt(0));
System.out.println(rSet.getInt(1));
}
} catch (Exception e) { 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 emar.shop.demo.ConnSql.main(ConnSql.java:14)
请问各位大侠们,什么原因会导致这样的错误。
// 装载SQL驱动程序
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String urlString="jdbc:microsoft:sqlserver://localhost:1433;DataBasename=master";
Connection connection=DriverManager.getConnection(urlString, "sa", "9028");
Statement statement=connection.createStatement();
String strSql="select * from spt_values";
ResultSet rSet=statement.executeQuery(strSql);
while(rSet.next())
{
System.out.println(rSet.getInt(0));
System.out.println(rSet.getInt(1));
}
} catch (Exception e) { 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 emar.shop.demo.ConnSql.main(ConnSql.java:14)
请问各位大侠们,什么原因会导致这样的错误。
检查classpath里是否有该jar包
找不到数据库驱动,
可能是你的数据库的驱动犯错位置了,或者直接就没有驱动
而且 好像2005跟2000的jar包是不一样的
要去下对应的jar包
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");同时检查是否存在驱动包