Article View: cn.comp.lang.java
Article #265ͨ��JDBC����SQL������
From: ����(��)
Date: Sat, 19 Nov 2005 09:02
Date: Sat, 19 Nov 2005 09:02
38 lines
2232 bytes
2232 bytes
������Ѿ�װ����JDBC����Ҳ�������µģ���������Ҳ��ȷ������
�����ǻ���������Զ�˵���ݿ⣬������ô���°���
��ʾjava.lang.ClassNotFoundException:com.microsoft.jdbc.sqlserver.SQLServerDriver
//��ԭ����
import java.sql.*;
import java.io.*;
public class TestJdbc{
public static void main(String[] args) {
try{
Class.forName(
"com.microsoft.jdbc.sqlserver.SQLServerDriver" );
Connection con = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://sea-bug.3322.org:1433;databaseName=pubs",
"sa", "coolnet" );
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select1 * from
jobs");
while(rs.next()){
System.out.print("\t��ţ�" +
rs.getString(1));
System.out.print("\t����" +
rs.getString(2));
System.out.print("\t�Ա�" +
rs.getString(3));
System.out.println();
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
Technical Details
Message-ID:
<4380e994.1812195@cnusenet.3322.org>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!news.yaako.com!cnusenet.3322.org!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10d5a2,1347d3be6115426c,start X-Google-Thread: 107c7f,1347d3be6115426c,start X-Google-Attributes: gid10d5a2,gid107c7f,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!news.yaako.com!cnusenet.3322.org!not-for-mail From: "С����(��)" <guohaicn@msn.com.discuss> Newsgroups: cn.comp.lang.java,cn.fan Subject: ͨ��JDBC����SQL������ Date: Sat, 19 Nov 2005 17:02:09 +0800 Organization: news://cnusenet.3322.org Lines: 39 Message-ID: <4380e994.1812195@cnusenet.3322.org> NNTP-Posting-Host: 60.22.207.89 Mime-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 8bit X-Trace: news.yaako.com 1132390764 30450 60.22.207.89 (19 Nov 2005 08:59:24 GMT) X-Complaints-To: usenet@news.yaako.com NNTP-Posting-Date: Sat, 19 Nov 2005 08:59:24 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548 X-Original-NNTP-Posting-Host: 61.149.4.116 X-Original-Trace: 19 Nov 2005 17:00:33 +0800, 61.149.4.116