package com.allanlxf.jdbc.core;

import java.sql.*;
import com.allanlxf.jdbc.util.ConnectionFactory;

public class TestCallableStatement
{
    public static void main(String[] args) throws Exception
    {
        Connection con = ConnectionFactory.getConnection();
        CallableStatement cs = con.prepareCall("{call getAccountOwner(?,?)}");
        cs.setInt(1, 2172);
        cs.registerOutParameter(2, Types.VARCHAR);
        
        cs.execute();
        String accountOwner = cs.getString(2);
        System.out.println(accountOwner);
        cs.close();
        con.close();
    }
}