🚀 go-pugleaf

/**
 * ��ݿ��Ѿ��Ӻ��ˣ�����ÿ�����е�:
 * String user = myResultSet.getString("first_name");
 * ʱ�ͻ����:
 * Error code = 17011
 * Error message = �þ���Resultset
 * ���λ��Ϻָ��!!!
 */

// import the standard JDBC package
  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:oracle",
    "system",
    "system");
    myStatement = myConnection.createStatement();
    ResultSet myResultSet = myStatement.executeQuery(
    "SELECT *" +
    "FROM customers"
    );
    myResultSet.next();
    String user = myResultSet.getString("first_name");
    /**
     *  ������Ϣ :
     *  Error code = 17011
     *  Error message = �þ��� Resultset
     */
    Timestamp currentDataTime = myResultSet.getTimestamp("sysdate");
    System.out.println("Hello " + user +
    ", the current date ad time is "+ currentDataTime);

   myResultSet.close();
  }catch(SQLException e){
    System.out.println("Error code = " + e.getErrorCode() );
    System.out.println("Error message = " + e.getMessage());
  }finally{
    try{
      if( myStatement != null ){
        myStatement.close();
      }
      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()
}



--
��������������
������������
��֪���������
��������Ѱ��Ѱ
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.59.213]