代码如下:
import java.sql.*;
public class Jdbc{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
Connection con = DriverManager.getConnection(url, "admin", "xyz");
con.setCatalog("bookTest");
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
编译没有问题,执行的时候出现了如下问题:F:\javalesson\database>java Jdbc
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at Jdbc.main(Jdbc.java:5)我已经安装了sql server 2000的jdbc驱动程序,而且classpath也设置了,请问是什么原因?
import java.sql.*;
public class Jdbc{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
Connection con = DriverManager.getConnection(url, "admin", "xyz");
con.setCatalog("bookTest");
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
编译没有问题,执行的时候出现了如下问题:F:\javalesson\database>java Jdbc
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at Jdbc.main(Jdbc.java:5)我已经安装了sql server 2000的jdbc驱动程序,而且classpath也设置了,请问是什么原因?
看看classpath是否有了jdbc的那个.jar文件
mssqlserver.jar
msbase.jar
书上说只要这三个文件就可以了,这三个文件我都有了
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
三个.jar文件的路径