SAP ABAP ADBC和Java JDBC的使用比较

REPORT zjerry_adbc.
CLASS demo DEFINITION.
  PUBLIC SECTION.
    CLASS-METHODS main.
  PRIVATE SECTION.
    CLASS-DATA: BEGIN OF result_line,
                  carrid TYPE sflight-carrid,
                  connid TYPE sflight-connid,
                  fldate TYPE sflight-fldate,
                END OF result_line,
                result_tab LIKE TABLE OF result_line.
ENDCLASS.
CLASS demo IMPLEMENTATION.
  METHOD main.
    DATA: carrid    TYPE sflight-carrid VALUE 'AA',
          cols      TYPE adbc_column_tab,
          lv_carrid TYPE string,
          con_ref   TYPE REF TO cl_sql_connection,
          con_name  TYPE dbcon-con_name VALUE 'DEFAULT'.
    cols = VALUE #( ( CONV adbc_name( 'CARRID' ) )
                    ( CONV adbc_name( 'CONNID' ) )
                    ( CONV adbc_name( 'FLDATE' ) ) ).
    lv_carrid = cl_abap_dyn_prg=>quote( to_upper( carrid ) ).
    TRY.
        con_ref = cl_sql_connection=>get_connection( con_name ).
        DATA(statement) = con_ref->create_statement( ).
        DATA(lv_query) = `SELECT carrid, connid, fldate ` &&
         `FROM sflight ` &&
         `WHERE mandt  = ` && `'` && sy-mandt && `' AND` &&
         `      carrid = ` &&  lv_carrid.
        DATA(result) = statement->execute_query( lv_query ).
        result->set_param_table( itab_ref = REF #( result_tab )
                                 corresponding_fields = cols ).
        IF result->next_package( ) > 0.
          SORT result_tab BY carrid connid fldate.
          WRITE:/ 'Number of lines found: ', lines( result_tab ).
        ENDIF.
        con_ref->close( ).
      CATCH cx_sql_exception INTO DATA(err).
    ENDTRY.
  ENDMETHOD.
ENDCLASS.
START-OF-SELECTION.
  demo=>main( ).

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
public class PostgreSQLJDBC {
  private Connection connection = null;
  private void select() {
    try {
      int index = 0;
      Class.forName("org.postgresql.Driver");
      connection = DriverManager.getConnection(
          "jdbc:postgresql://localhost:9812/zproduct", "postgres", "XXXXXX");
      Statement stmt = connection.createStatement();
      String query = "SELECT * FROM public.comm_product;";
      ResultSet rs = stmt.executeQuery(query);
           while ( rs.next() ) {
            System.out.println("Row index: " + index++);
            String  client = rs.getString("client");
              System.out.println("Client: " + client);
              String  guid = rs.getString("product_guid");
              System.out.println("Product guid: " + guid);
              Timestamp validFrom = rs.getTimestamp("valid_from");
              System.out.println("Valid from: " + validFrom);
           }
           rs.close();
           stmt.close();
           connection.close();
    } catch (Exception e) {
      e.printStackTrace();
    } 
  }
  public static void main(String args[]) {
    PostgreSQLJDBC jdbcTest = new PostgreSQLJDBC();
    jdbcTest.select();
  }
}