Article View: cn.bbs.comp.lang.java
Article #20434[jdbc]����sqlserver������
From: nick
Date: Thu, 18 Dec 2003 03:25
Date: Thu, 18 Dec 2003 03:25
51 lines
2451 bytes
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
--
[m[1;37m�� ��Դ:��Ʈ��ˮ�Ƽ� Freecity.dhs.org��[FROM: cimxml][m
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!FreecityShow 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