package com.simon.springbootprocedure;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author Simon
 */
@Component
public class MybatisCommand {

    @Resource
    DataMapper dataMapper;

    @Autowired
    public void run() {
        test_exe_procedure(true);
//        test_exe_procedure(false);
    }

    private void test_exe_procedure(boolean callType) {
        int _pageindex = 1;
        int _pageSize = 10;
        String _tables = "employee";
        String _fields = "*";

        HashMap<String, Object> mm = new HashMap<>();
        mm.put("_pageindex", _pageindex);
        mm.put("_pageSize", _pageSize);
        mm.put("_tables", _tables);
        mm.put("_fields", _fields);
        mm.put("_where", null);
        mm.put("_orderby", null);
        mm.put("_sumfields", null);
        if (callType) {
            System.out.println("test_exe_procedure1...");
            List<Map<String, Object>> result = dataMapper.test_exe_procedure1(mm);
            for (Map<String, Object> entry : result) {
                for (Map.Entry<String, Object> data : entry.entrySet()) {
                    System.out.println(data.getKey() + " : " + data.getValue());
                }
            }
        } else {
            System.out.println("test_exe_procedure2...");
            dataMapper.test_exe_procedure2(mm);
        }
        System.out.println("Get _pageindex: " + mm.get("_pageindex"));
        System.out.println("Get _pageSize: " + mm.get("_pageSize"));
        System.out.println("Get _tables: " + mm.get("_tables"));
        System.out.println("Get _fields: " + mm.get("_fields"));
        System.out.println("Get _totalcount: " + mm.get("_totalcount"));
        System.out.println("Get _pagecount: " + mm.get("_pagecount"));
        System.out.println("Get _sumresult: " + mm.get("_sumresult"));
        return;
    }
}