🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: �й�JDBC�����⣬����

#23542
From: flyal
Date: Mon, 21 Jul 2003 13:43
61 lines
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.*;
: .................������ʡ�ԣ�

--
��������������
������������
��֪���������
��������Ѱ��Ѱ
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.59.213]
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!SJTU

Show 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