Article View: cn.bbs.comp.lang.java
Article #23542Re: �й�JDBC�����⣬����
From: flyal
Date: Mon, 21 Jul 2003 13:43
Date: Mon, 21 Jul 2003 13:43
61 lines
2789 bytes
2789 bytes
// ����дʱ����
// Error code = 600
// Error message = ORA-00600:�ڲ��������,
// ����:[ttcgcshnd-1],[0],[],[],[],[],[],[]
import java.sql.*;
public class FirstExample{
public static void main( String args[]){
Connection myConnection = null;
Statement myStatement = null;
try{
DriverManager.registerDriver( new oracle.jdbc.OracleDriver() );
myConnection = DriverManager.getConnection(
"jdbc:oracle:thin:@ibm113:1521:oracleDB","system","system");
myStatement = myConnection.createStatement();
ResultSet myResultSet = myStatement.executeQuery(
"SELECT * FROM customers"
);
myResultSet.close();
System.out.println("HelloWorld!");
}catch(SQLException e){
System.out.println("Error code = " + e.getErrorCode() );
System.out.println("Error message = " + e.getMessage());
}finally{
try{
// close the Statement object using the close() method
if( myStatement != null ){
myStatement.close();
}
// close the Connection object using the close() method
if( myConnection != null ){
myConnection.close();
}
}catch( SQLException e ){
System.out.println("Error code = " + e.getErrorCode() );
System.out.println("Error message = " + e.getMessage());
}
}
}// end of main()
}
�� �� flyal (flyal) �Ĵ������ᵽ: ��
: /**
: * ��ݿ��Ѿ��Ӻ��ˣ�����ÿ�����е�:
: * String user = myResultSet.getString("first_name");
: * ʱ�ͻ����:
: * Error code = 17011
: * Error message = �þ���Resultset
: * ���λ��Ϻָ��!!!
: */
: // import the standard JDBC package
: import java.sql.*;
: .................������ʡ�ԣ�
--
��������������
������������
��֪���������
��������Ѱ��Ѱ
[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.59.213][m
Technical Details
Message-ID:
<47LgHB$AOG@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB X-Google-Thread: f6cb0,fa7f8e42846d5aaa X-Google-Attributes: gidf6cb0,public X-Google-ArrivalTime: 2003-07-21 06:44:51 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!SJTU From: flyal.bbs@bbs.sjtu.edu.cn (flyal) Newsgroups: cn.bbs.comp.lang.java Subject: Re: �й�JDBC�����⣬���� Date: 21 Jul 2003 13:43:30 GMT Organization: ��ˮ˼Դ Message-ID: <47LgHB$AOG@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Java/M.1058794811.A Lines: 61