Article View: cn.bbs.comp.lang.java
Article #12359Re: ��һ��java����sqlserver������
From: ��������~Ŭ��ÿһ��
Date: Fri, 30 Jul 2004 04:33
Date: Fri, 30 Jul 2004 04:33
58 lines
3001 bytes
3001 bytes
������װ��C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC,����
ϵͳ����classpath�������C:\Program Files\Microsoft SQL Server 2000 Driver
for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000
Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000
Driver for JDBC\lib\msutil.jar
д��һ������
import java.sql.*;
public class db {
public static void main(String[] args) throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433","sa","");
Statement stmt = conn.createStatement();
String sql = "select * from pubs";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
String col1;
col1=rs.getString(1);
System.out.println(col1);
}
rs.close();
stmt.close();
}
}
��������ʱ��
Exception in thread "main" 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 db.main(db.java:5)
Press any key to continue...
�� �� xeon �Ĵ������ᵽ: ��
: classpathһֱҪ���õ�.jar
: xx.jar;xx.jar;%classpath%
: �� �� charless (��������~Ŭ��ÿһ��) �Ĵ������ᵽ: ��
: :
: : �Ұ�װ��sqlserver2000��jdbc�����������classpath����ô���DZ�
: : ClassNotFindedException
: :
--
���㴴����֣���
�ҵĶ�������
[1;33m�� ��Դ:���Ұ��Ͽ�վ nkbbs.org ��Web[FROM: 218.69.89.76][m
Technical Details
Message-ID:
<4DQQTZ$94H@bbs.nankai.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nntp-server.pubsub.com!maily.cic.tsinghua.edu.cn!news2.happynet.org!NanKaiShow Full Headers
Complete Article Headers
X-Google-Thread: f6cb0,f6ef15d11b6a0aa7 X-Google-Attributes: gidf6cb0,public X-Google-Language: ENGLISH,ASCII Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nntp-server.pubsub.com!maily.cic.tsinghua.edu.cn!news2.happynet.org!NanKai From: charless.bbs@bbs.nankai.edu.cn (��������~Ŭ��ÿһ��) Newsgroups: cn.bbs.comp.lang.java Subject: Re: ��һ��java����sqlserver������ Date: 30 Jul 2004 04:33:23 GMT Organization: �Ұ��Ͽ�վ Message-ID: <4DQQTZ$94H@bbs.nankai.edu.cn> X-Filename: Java/M.1091162003.A Lines: 58