Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver : JDBC ODBC « Database SQL JDBC « Java





Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver

  

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class PreparedStmt {
  public static void main(String args[]) throws Exception {

    String query = "SELECT * FROM Stock WHERE Item_Number = ?";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection("jdbc:odbc:Inventory");
    PreparedStatement pstmt = con.prepareStatement(query);
    pstmt.setInt(1, 2);
    ResultSet rs = pstmt.executeQuery();
    while (rs.next()) {
      String name = rs.getString("Name");
      String desc = rs.getString("Description");
      int qty = rs.getInt("Qty");
      float cost = rs.getFloat("Cost");
      System.out.println(name + ", " + desc + "\t: " + qty + "\t@ $" + cost);
    }
  }
}

   
  










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.Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver
6.Retrieving a ResultSet from JdbcOdbcDriver
7.Getting an output parameter from a stored procedure
8.Opening an updatable ResultSet
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