代码如下:
import java.sql.*;public class JDBCTest { public static void main(String[] args) throws Exception{
String id=null;
String name=null;
String sql="select * from table2";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=My Database","sa","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
id=rs.getString(1);
name=rs.getString(2);
System.out.println("id"+id);
System.out.println("name"+name);
}
rs.close();
stmt.close();
}
}出现的错误是:
Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at test.JDBCTest.main(JDBCTest.java:19)我已经C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 下面的3个jar文件拷贝到jre\lib\ext下面,并且在环境变量里面设置了,为什么还是出现这样的问题?
请多指教
import java.sql.*;public class JDBCTest { public static void main(String[] args) throws Exception{
String id=null;
String name=null;
String sql="select * from table2";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=My Database","sa","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
id=rs.getString(1);
name=rs.getString(2);
System.out.println("id"+id);
System.out.println("name"+name);
}
rs.close();
stmt.close();
}
}出现的错误是:
Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at test.JDBCTest.main(JDBCTest.java:19)我已经C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 下面的3个jar文件拷贝到jre\lib\ext下面,并且在环境变量里面设置了,为什么还是出现这样的问题?
请多指教
------
提示找不到