连接数据库,怎么用mssqlserver.jar

[erhucw]

我下了mssqlserver.jar,放在jdk的lib中,并且在classpath也写了它,最后在一个applet中写

try{
String driver_name ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
final String conString = "jdbc:microsoft qlserver://ht-cw:1433;databaseName=cw;user=sa;password=";
Class.forName(driver_name).newInstance();

Connection con = DriverManager.getConnection(conString);
PreparedStatement a= con.prepareStatement(
"select * from Signatrue");
ResultSet b = a.executeQuery();
String c;
if (b.next()) {
c = b.getString(1);
}
//关闭结果集
b.close();
//关闭语句
a.close();

}
catch (java.lang.Exception ex) {
ex.printStackTrace();
}

编译没有错.
当运行这段代码时
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
不是知道怎么回事?

[HawaiiLeo]

import java.sql.*;

public class ConnDB
{
public static void main(String argv[])
{
try
{
String driver_name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

String conString = "jdbc:microsoft:sqlserver://hrs-server:1433;databaseName=Northwind;user=dtrend;password=";

Class.forName(driver_name).newInstance();

Connection con = DriverManager.getConnection(conString);

PreparedStatement a= con.prepareStatement("select * from Orders");

ResultSet b = a.executeQuery();

String c;

if(b.next()) {
c = b.getString(1);
System.out.println(c);
}

//关闭结果集
b.close();
//关闭语句
a.close();
}
catch (java.lang.Exception ex)
{
ex.printStackTrace();
}
}
}
NOTE: Untrusted applets cannot open a socket to a machine other than the originating host.

[HawaiiLeo]

安装完Microsoft SQL Server 2000 Driver for JDBC后，要把
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\里面的三个文件加如
CLASSPATH，不过我刚加入要重启动后才生效。

[HawaiiLeo]

The Type 4 SQL Server 2000 Driver for JDBC provides JDBC access through any
Java-enabled applet, application, or application server.
~~~~~~~~~~~~~~~~~~~~~
applet 可以访问数据库吧。

[erhucw]

这三个文件我是直接copy的,需要按装吗.我重起后运行时还是出错.
E:\myclass>appletviewer b.html
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:151)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.applet.AppletClassLoader.loadClass(AppletClassLoader.java:112)
at java.lang.ClassLoader.loadClass(ClassLoader.java:262)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at Signatrue.action(Signatrue.java:83)
at java.awt.Component.handleEvent(Component.java:5262)
at java.awt.Component.postEvent(Component.java:3806)
at java.awt.Component.postEvent(Component.java:3816)
at java.awt.Component.dispatchEventImpl(Component.java:3542)
at java.awt.Component.dispatchEvent(Component.java:3367)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:445)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:190)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)
Caused by: java.io.FileNotFoundException: E:\myclass\com\microsoft\jdbc\sqlserve
r\SQLServerDriver.class (系统找不到指定的路径。)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:103)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection
.java:69)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLCon
nection.java:148)
at sun.applet.AppletClassLoader.getBytes(AppletClassLoader.java:233)
at sun.applet.AppletClassLoader.access$100(AppletClassLoader.java:40)
at sun.applet.AppletClassLoader$1.run(AppletClassLoader.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:138)
... 18 more

不知道怎么回事?

[erhucw]

ding!

[Philzzf]

晕，原来你是用appletviewer b.html来运行啊，那当然会出错了，我还当你是编译时出错呢？
对了，编译时到底通不通过啊？
运行时你也要指定这三个文件的位置才行

[erhucw]

怎么指定!

[Philzzf]

sql2000 的JDBC需要三个文件啊：msbase.jar、mssqlserver.jar、msutil.jar
把这三个文件都放到你的classpath里面，另外这样做只保证你在DOS下编译此JAVA文件通过，如果你是用JBUILDER或其它的IDE工具的话，需配置其相应的LIBRARY

另外：在APPLET下面应该不能连数据库吧

[erhucw]

我就是在dos 下编译的把另外的两个文件加上了
怎么还是找不到java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

[erhucw]

APPLET能连接数据库吗

[erhucw]

APPLET能连接数据库吗

[Philzzf]

设置好classpath要重新开一个DOS窗口classpath才会起作用

[Philzzf]

applet应该不可以连接数据库