JAVA调用DB2过程

  Connection conn = getSession().connection();
        //返回标志，0:执行成功，否则执行失败
        int flag = 1; 
        CallableStatement stmt = null;
        try
        {
            stmt = conn.prepareCall("{call " + funcName + "(?,?,?)}");
            if (stmt != null)
            {
                stmt.setString(1, name);
                stmt.setString(2, user);
                stmt.setInt(3, 0);
                //第3个参数作为输出参数
                stmt.registerOutParameter(3, Types.INTEGER);
                stmt.execute();
                if (StringUtils.isNotEmpty(stmt.getString(5)))
                    flag = Integer.parseInt(stmt.getString(5));
            }
        }
        catch (Exception e)
        {
            flag = 1;
        }
        finally
        {
            if (stmt != null)
                try
                {
                    stmt.close();
                }
                catch (SQLException e)
                {
                    e.printStackTrace();
                }
        }