org.beast.project.template.dao.storedprocedure.PersonStoredProcedure.java Source code

Introduction

Here is the source code for org.beast.project.template.dao.storedprocedure.PersonStoredProcedure.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package org.beast.project.template.dao.storedprocedure;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.object.StoredProcedure;
import org.springframework.stereotype.Component;

/**
 *
 * @author u329022
 */
//@Component
public class PersonStoredProcedure extends StoredProcedure {

    public PersonStoredProcedure() {
    }

    public PersonStoredProcedure(JdbcTemplate template) {
        super(template, "sproc_name");

        /* Declare the input Parameters */
        // declareParameter(new SqlParameter(EBSBBConstants.CALL_KEY, OracleTypes.INTEGER));

        /* Declare the output Parameters */
        // declareParameter(new SqlOutParameter(EBSBBConstants.TYPE_REF_CURSOR, OracleTypes.CURSOR, rowMapper));
        //declareParameter(new SqlOutParameter(EBSBBConstants.STATUS, OracleTypes.INTEGER));
        //declareParameter(new SqlOutParameter(EBSBBConstants.STATUS_DESC, OracleTypes.VARCHAR));

        //Compile this query. Ignores subsequent attempts to compile.
        compile();
    }
}