Create a ResultSet

In this chapter you will learn:

1. How to get ResultSet from Query

Create ResultSet

JDBC provides following connection methods to create statements with desired ResultSet:

• createStatement(int resultSetType, int resultSetConcurrencyType);
• prepareStatement(String sql, int resultSetType, int resultSetConcurrencyType);
• prepareCall(String sql, int resultSetType, int resultSetConcurrencyType);

The following code creates a Statement object which will create a forward-only, read only ResultSet object.

try {// j a v  a2s  . co m
   Statement stmt = conn.createStatement(
                           ResultSet.TYPE_FORWARD_ONLY,
                           ResultSet.CONCUR_READ_ONLY);
}
catch(Exception ex) {
   ....
}
finally {
   ....
}

Next chapter...

What you will learn in the next chapter:

1. Read data from ResultSet

Statement

    Three types of statements

    Statement interface

    Insert

    Delete records

    Drop a table

    Batch operation

PreparedStatement

    PreparedStatement

    Insert

    Delete

    Update with parameters

    Batch operation

    ParameterMetaData

    Fetch size

    Set null vaue

CallableStatement

    CallableStatement

ResultSet

    ResultSet

    ResultSet Type

    ResultSet Concurrency

    Create a ResultSet

    ResultSet reading

    ResultSet get by column name

    ResultSet get column by index

    ResultSet next row

    ResultSet table row count

    ResultSet navigation

    ResultSet cursor forward and backward

    ResultSet first

    ResultSet last

    ResultSet after last

    ResultSet before first

    ResultSet absolute(2)

    ResultSet absolute(-1)

    ResultSet relative(-2)

    ResultSet relative(-2)

    ResultSet update

    Column Names

    Column count

    Column Characteristics

ResultSetMetaData

    Column Names

    Column count

    Column Characteristics

SQL Exception, SQL Warning

    SQL Exception

    SQLException information

    Chaining SQLExceptions

    Connection Warning

    PreparedStatement SQLWarning

    Statement SQLWarning

    ResultSet warning

    SQLWarning information