🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

[jdbc]����sqlserver������

#20434
From: nick
Date: Thu, 18 Dec 2003 03:25
51 lines
2451 bytes
��������
import java.sql.*;
import java.io.*;
import java.util.*;


public class SQLDemo{

   public static void main(String args[]) throws Exception{
       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
       Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://SKY:1433;user=sa;Password=");
       Statement st=conn.createStatement();
       String s="select * from c_card";
       ResultSet rs=st.executeQuery(s);
       while (rs.next())
       {
         System.out.println(rs.getString(1)+"<br>");
         System.out.println(rs.getString(2)+"<br>");
       }
   }
}
 
����ʱ�������´���

Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.j
sqlserver.SQLServerDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:141)
        at SQLDemo.main(SQLDemo.java:9)
Press any key to continue...

�Ѱ�װThe SQL Server 2000 Driver for JDBC 

classpathҲ�Ѿ�����

������ʲôԭ�򰡣�

3x


 

--
�� ��Դ:��Ʈ��ˮ�Ƽ� Freecity.dhs.org��[FROM: cimxml]
Technical Details
Message-ID: <49gZE3$ASJ@Freecity.dhs.org>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!Freecity

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB
X-Google-Thread: f6cb0,d86923ccbcd294ca,start
X-Google-Attributes: gidf6cb0,public
X-Google-ArrivalTime: 2003-12-17 19:26:44 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!Freecity
From: cimxml.bbs@Freecity.dhs.org (nick)
Newsgroups: cn.bbs.comp.lang.java
Subject: [jdbc]����sqlserver������
Date: 18 Dec 2003 03:25:32 GMT
Organization: Ʈ��ˮ�Ƽ�
Message-ID: <49gZE3$ASJ@Freecity.dhs.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Java/M.1071717795.A