...
Jdbc tutorial, jdbc connection, java resultset, java, jdbc driver, java database connectivity, jdbc source code, tutorial, programming,JDBC driver, JDBC example, Jdbc examples!
Sycorax - complete tutorials
Programming Tutorials
" Java provides the industry - software companies and customer alike , an opportunity to create a true open computing environment where software is portable,
and customers benefit from increase competition. "
Java and the Future
December 1, 2008-LEJB 3.1: EJB New and Improved!
The EJB 3.0 specification was a huge improvement from what you were used to in the early versions of EJB. Available as an early draft, EJB 3.1 has many more features and is even easier to use.
December 1, 2008-Should Java Assert that Network I/O Can't Occur on the UI Thread?
Doing network I/O on the user interface (UI) thread is bad. Most developers know that and can tell you why; unfortunately, it's still done.
Register now to recieve special alert and latest technology news!
JDBC ResultSets
A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.
A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable.
The ResultSet interface provides getter methods (getBoolean, getLong, and so on) for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column.
Method Detail
public boolean next() - Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on. Returns true if the new current row is valid; false if there are no more rows .
public String getString(int columnIndex) - Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
public int getInt(int columnIndex) - Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
public String getString(String columnName) - Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
public int getInt(String columnName) - Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
public ResultSetMetaData getMetaData() - Retrieves the number, types and properties of this ResultSet object's columns.
public boolean isFirst() - Retrieves whether the cursor is on the first row of this ResultSet object.
public void beforeFirst() - Moves the cursor to the front of this ResultSet object, just before the first row. This method has no effect if the result set contains no rows.
<< Test JDBC Driver Installation & Connection || Create Table >>
