🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.lang.java
Article #12359

Re: ��һ��java����sqlserver������

#12359
From: ��������~Ŭ��ÿһ��
Date: Fri, 30 Jul 2004 04:33
58 lines
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
: : 

--
���㴴����֣���
�ҵĶ�������





�� ��Դ:���Ұ��Ͽ�վ nkbbs.org ��Web[FROM: 218.69.89.76]
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!NanKai

Show 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