Connect to database and call stored procedure : Store Procedure « Database SQL JDBC « Java

Connect to database and call stored procedure

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

public class Main {
  public static void main(String[] argv) throws Exception {

    Connection con = DriverManager.getConnection("jdbc:sqlserver://MYSERVER;databaseName=MYDATABASE",
        "USERID", "PASSWORD");

    CallableStatement proc_stmt = con.prepareCall("{ call generateID(?) }");

    proc_stmt.setString(1, "employee");
    ResultSet rs = proc_stmt.executeQuery();

    if ( {
      int employeeId = rs.getInt(1);
      System.out.println("Generated employeeId: " + employeeId);
    } else {
      System.out.println("Stored procedure couldn't generate new Id");


Related examples in the same category

1.Call Stored Procedure In Oracle And Pass In Out Parameters
2.Get Stored Procedure Name And Type
3.Stored procedure utilities
4.Get Stored Procedure Signature
5.Call a stored procedure with no parameters and return value.
6.Call Stored Procedure In MySql
7.Call a procedure with one IN parameter
8.Call a procedure with one OUT parameter
9.Call a procedure with one IN/OUT parameter
10.Calling a Function in a Database: call functions with IN, OUT, and IN/OUT parameters.
11.Call a function with one IN parameter; the function returns a VARCHAR
12.Call a function with one OUT parameter; the function returns a VARCHAR
13.Creating a Stored Procedure or Function in an Oracle Database
14.Call a function with one IN/OUT parameter; the function returns a VARCHAR
15.Create procedure myprocin with an IN parameter named x.
16.Create procedure myprocout with an OUT parameter named x
17.Create procedure myprocinout with an IN/OUT parameter named x; x is an IN parameter and an OUT parameter
18.Create a function named myfunc which returns a VARCHAR value; the function has no parameter
19.Create a function named myfuncin which returns a VARCHAR value; the function has an IN parameter named x
20.Create a function named myfuncout which returns a VARCHAR value;
21.Create a function named myfuncinout that returns a VARCHAR value
22.Calling a Stored Procedure in a Database with no parameters
23.Getting the Stored Procedure Names in a Database: retrieves the names of all stored procedures in a database.
24.Call stored procedure
25.Stored procedure with Input/Output parms and a ResultSet