Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver : JDBC ODBC « Database SQL JDBC « Java





Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver

  

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

public class CallableStmt {
  public static void main(String args[]) throws Exception {
    String storedProc = "create procedure SHOW_ORDERS_BY_STATE @State CHAR (2) as "
        + "select c.Last_Name+', '+c.First_Name AS Name,o.Order_Number "
        + "from CUSTOMERS c, ORDERS o where c.Customer_Number = o.Customer_Number "
        + "AND c.State = @State order by c.Last_Name;";

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection("jdbc:odbc:Customers");
    Statement stmt = con.createStatement();
    stmt.executeUpdate(storedProc);
    CallableStatement cs = con.prepareCall("{call SHOW_ORDERS_BY_STATE(?)}");
    cs.setString(1, "NJ");
    ResultSet rs = cs.executeQuery();
    while (rs.next()) {
      String name = rs.getString("Name");
      int orderNo = rs.getInt("Order_Number");
      System.out.println(name + ": " + orderNo);
    }
  }
}

   
  










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.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