我已把msbase.jar,mssqlsever.jar,msutil.jar这三个包放在了JBuilder安装目录下的lib文件夹下,并在Configure Libraries 将这三个包添加在其中,最后在Enterprise Setup 设置了相应的DataBase
Drivers,可运行时还是提示找不到该驱动,请问是为什么?程序如下
package swing;import java.sql.*;
public class SQLJdbc {
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,"sa","");
con.setCatalog("bookTest");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
{
System.out.print(rs.getString(1)+" "+rs.getString(2)+" "
+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
} }
}
错误信息如下:
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 swing.SQLJdbc.main(SQLJdbc.java:7)
请各位指教.
Drivers,可运行时还是提示找不到该驱动,请问是为什么?程序如下
package swing;import java.sql.*;
public class SQLJdbc {
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,"sa","");
con.setCatalog("bookTest");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
{
System.out.print(rs.getString(1)+" "+rs.getString(2)+" "
+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
} }
}
错误信息如下:
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 swing.SQLJdbc.main(SQLJdbc.java:7)
请各位指教.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货