Commonly Used JDBC Class Methods

JDBC for SQL Server - Herong's Tutorial Examples

∟Microsoft JDBC Driver - Query Statements and Result Sets

∟Commonly Used JDBC Class Methods

This section lists some commonly used JDBC classes and methods.

Most of the time, the JDBC interface is used to run SELECT queries and parsing through the returning result sets. If you are look at Java documentation, you will find these JDBC classes methods that you need to use most of the time:

DriverManager.getConnection() - Establish and return a connection object.
Connection.close() - Closes the connection to the database server.
Connection.getMetaData() - Returns meta data from the database server to provide information like table structures, stored procedures and connection settings.
Connection.createStatement() - Returns a statement object to execute SQL statements.
Statement.executeUpdate() - Execute a SQL statement (non-SELECT statement) that returns no result set.
Statement.executeQuery() - Execute a SQL SELECT statement and returns a result set object.
Statement.close() - Closes the resources used by this statement object.
ResultSet.first() - Moves the cursor to the first row in this ResultSet object.
ResultSet.last() - Moves the cursor to the last row in this ResultSet object.
ResultSet.next() - Moves the cursor forward one row from its current position.
ResultSet.previous() - Moves the cursor to the previous row in this ResultSet object.
ResultSet.getBoolean() - Returns the value as boolean of a given column.
ResultSet.getByte() - Returns the value as byte of a given column.
ResultSet.getDate() - Returns the value as Date of a given column.
ResultSet.getDouble() - Returns the value as double of a given column.
ResultSet.getFloat() - Returns the value as float of a given column.
ResultSet.getInt() - Returns the value as int of a given column.
ResultSet.getLong() - Returns the value as long of a given column.
ResultSet.getString() - Returns the value as String of a given column.
ResultSet.wasNull() - Returns true if the column fetched by the last get*() method has a null value.
ResultSet.close() - Closes the resources used by this ResultSet object.