Opening an updatable ResultSet : JDBC ODBC « Database SQL JDBC « Java

Opening an updatable ResultSet


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class PrintResultSet {
  public static void main(String args[]) throws Exception {
    Connection con = DriverManager.getConnection("jdbc:odbc: Contacts");
    Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet rs = stmt.executeQuery("SELECT Name,Description,Qty,Cost FROM Stock");
    ResultSetMetaData md = rs.getMetaData();

    if (rs.getConcurrency() == ResultSet.CONCUR_UPDATABLE)

    int nColumns = md.getColumnCount();
    for (int i = 1; i <= nColumns; i++) {
      System.out.print(md.getColumnLabel(i) + ((i == nColumns) ? "\n" : "\t"));
    while ( {
      rs.updateString("Street", "123 Main");
      for (int i = 1; i <= nColumns; i++) {
        System.out.print(rs.getString(i) + ((i == nColumns) ? "\n" : "\t"));


Related examples in the same category

1.jdbc:odbc bridge
2.JdbcOdbc Connect
3.jdbc odbc bridge connection string
4.Simple example of JDBC-ODBC functionality
5.Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver
6.Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver
7.Retrieving a ResultSet from JdbcOdbcDriver
8.Getting an output parameter from a stored procedure
9.Using ResultSetMetaData from jdbc:odbc
10.Creating a table using JdbcOdbcDriver
11.Using INSERT with JdbcOdbcDriver
12.Using UPDATE with JdbcOdbcDriver
13.Creating and dropping indexes
14.Using DSN-less connection