Please enable JavaScript.

Coggle requires JavaScript to display documents.

Chapter 10. JDBC (Obtaining a Statement (ResultSet Type (TYPE_SENSITIVE…

- - - - CAN go backward
      - NO see latest data from database table
    - - CAN go backward
      - See latest data from database table
      - NOT supported by most Drivers
    - - Default
      - CANNOT go backward
      - NO see latest data from database table
  - - - NOT supported by all driver
- - - - boolean isResultSet = stmt.execute(sql);
        if (isResultSet) {
        　ResultSet rs = stmt.getResultSet();
        　System.out.println("ran a query");
        } else {
        　int result = stmt.getUpdateCount();
        　System.out.println("ran an update");
        }
- - - - Sample
        
        jdbc:postgres://localhost:5432/zoo
      - Protocol
        
        jdbc
      - Product/Vendor Name
        
        postgres
      - Connection Details
        
        //localhost:5432/zoo
  - - - Connection conn = DriverManager.getConnection(<JDBC_URL>,<Username>,<Password>);
      - Connection conn = DriverManager.getConnection(<JDBC_URL>);
    - - JDBC <= 3.0 Driver
        
        ○　Use java.sql.Driver file if present
        
        ○　Required to use Class.forName
        
        ×　Required to contain java.sql.Driver
        
        ○　Allowed to use Class.forName
      - JDBC >= 4.0 Driver
        
        ○　Use java.sql.Driver file if present
        
        ×　Required to use Class.forName
        
        ○　Required to contain java.sql.Driver
        
        ○　Allowed to use Class.forName
- - - - rs.next()
      - rs.previous()
      - rs.beforeFirst()
      - rs.afterLast()
      - rs.last()
      - rs.first()
      - rs.absolute(<Row Number>)
        
        Row number is positive
        
        Move the cursor to the numbered row
        
        0: Location immediately before the first row
        
        Row number is negative
        
        Start counting from the end
        
        -1: Last row
      - rs.relative(<Number of Row>)
        
        Move forward or backward
    - - getBoolean
      - getDate
      - getDouble
      - getInt
      - getObject
      - getString
      - getTime
      - getLong
      - getTimeStamp
- - - - Return a human-readable message
    - - Return code as to what went wrong
    - - Database-specific code