Example usage for org.apache.ibatis.session SqlSession close

List of usage examples for org.apache.ibatis.session SqlSession close

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. close

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession close.

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

From source file:com.oneops.cms.transmitter.BaseEventReader.java

License:Apache License

public List<CMSEvent> getEvents() {

    SqlSession session = null;
    List<CMSEvent> cmsEvents = new ArrayList<>();

    try {/*from w  w  w  .  j  a v  a 2s  .  com*/

        session = sqlsf.openSession();
        EventMapper eventMapper = session.getMapper(EventMapper.class);

        if (!eventMapper.good2run(getLockName(), processId, PROCESS_TIMEOUT_SECONDS)) {
            if (iamActiveProcess == null || iamActiveProcess) {
                logger.info(">>>>>>>>>Other process has a lock " + getLockName() + ", will wait");
                iamActiveProcess = false;
            }
            session.commit(true);
            return cmsEvents;
        } else {
            if (iamActiveProcess == null || !iamActiveProcess) {
                logger.info(">>>>>>>>>Acquired lock " + getLockName() + ", I'm the active process now");
                iamActiveProcess = true;
            }
            session.commit(true);
        }

        if (isCmsPubActive()) {
            for (CMSEventRecord record : getEvents(eventMapper)) {
                CMSEvent event = populateEvent(record);
                if (event != null) {
                    cmsEvents.add(event);
                }
            }
        }
    } catch (Exception e) {
        if (e instanceof PersistenceException) {
            logger.error("Problem connecting to the postgres db, I will try reconnect...");
            logger.error(e.getMessage());
        } else {
            e.printStackTrace();
            throw new RuntimeException(e);
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }

    return cmsEvents;

}

From source file:com.onnurimotors.wm.service.WmService.java

public Object visit(HttpServletRequest request) {
    SqlSession session = sqlSession();
    String license = request.getParameter("license").replaceAll("\\s+", "");
    int is_new_customer;
    String title, msg;//from   w w  w. j  a  v  a 2  s.  c  o  m
    Date date = new Date();
    Calendar cal = Calendar.getInstance();
    cal.setTime(date);
    cal.add(Calendar.HOUR_OF_DAY, 9);
    date = cal.getTime();
    DateFormat format_date = new SimpleDateFormat("yyyy-MM-dd");
    DateFormat format_time = new SimpleDateFormat("HH:mm:ss");
    VEHICLE vehicle = new VEHICLE();
    HISTORY history = new HISTORY();
    vehicle.setLICENSE(license);
    vehicle.setVEHICLE_ID(-1);

    // retrieve vehicle list which match license
    ArrayList<VEHICLE> result = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle",
            vehicle);

    // if there is no matched vehicle
    if (result.size() == 0) {
        vehicle = new VEHICLE();
        vehicle.setIS_NOTIFIABLE(1);
        vehicle.setLICENSE(license);
        vehicle.setMODEL("");
        vehicle.setUSER_NAME("");
        vehicle.setBIRTH("");
        vehicle.setPHONE_NUMBER("");
        vehicle.setCOMMENT("");
        session.insert("watchman.mybatis.insertVehicle", vehicle);
        session.commit();
        is_new_customer = 1;
    } else {
        vehicle = result.get(0);
        is_new_customer = 0;
    }

    history.setVEHICLE_ID(vehicle.getVEHICLE_ID());
    history.setDATE_VISIT(format_date.format(date));
    history.setTIME_VISIT(format_time.format(date));
    session.insert("watchman.mybatis.insertHistory", history);
    session.commit();

    // msg to app used by employee of onnurimotors
    title = "";
    msg = "";
    if (vehicle.getIS_NOTIFIABLE() == 1) {
        if (is_new_customer == 0) {
            title = title + " ?\n";
            msg = msg + " ?\n";
        } else {
            title = title + "?  ?\n";
            msg = msg + " ?\n";
        }
        msg = msg + ": " + vehicle.getLICENSE() + "\n";
        msg = msg + "?: " + vehicle.getMODEL() + "\n";
        msg = msg + "??: " + vehicle.getUSER_NAME() + "\n";
        msg = msg + "??: " + vehicle.getBIRTH() + "\n";
        msg = msg + ": " + vehicle.getCOMMENT() + "\n";

        /*ArrayList<VEHICLE_HISTORY> result2 = (ArrayList<VEHICLE_HISTORY>) session.selectList("watchman.mybatis.selectAllHistoryVehicle", vehicle);
        for(int i = 0; i < result2.size(); i++) {
           msg = msg + result2.get(i).getDATE_VISIT() + " " + result2.get(i).getTIME_VISIT() + "<br />";
        }*/

        PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
        parameter_vehicle.setVEHICLE_ID(vehicle.getVEHICLE_ID());
        ArrayList<MANAGEMENT_DATE> result3 = (ArrayList<MANAGEMENT_DATE>) session
                .selectList("watchman.mybatis.selectManagementDateOfVehicle", parameter_vehicle);
        msg = msg + "<? >\n";
        for (int i = 0; i < 10 && i < result3.size(); i++) {
            msg = msg + result3.get(i).getDATE_VISIT() + " " + result3.get(i).getCOMMENT() + "\n";
        }

        ArrayList<EMPLOYEE> employees = (ArrayList<EMPLOYEE>) session
                .selectList("watchman.mybatis.selectReceivers");
        for (int i = 0; i < employees.size(); i++) {
            pService.sendPushNotification(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
            pService.sendPush(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
        }
    }

    session.close();

    // if is_notifiable is false, return empty message
    return msg;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object getAlerts(Model model) {
    SqlSession session = sqlSession();
    ArrayList<ALERT> alerts = new ArrayList<ALERT>();
    ALERT alert;/*from   w w  w. ja v  a2  s. c  o m*/
    VEHICLE_HISTORY vh = new VEHICLE_HISTORY();
    long diff;
    Date date = new Date();
    DateFormat format_datetime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    ArrayList<VEHICLE_HISTORY> vhs = (ArrayList<VEHICLE_HISTORY>) session
            .selectList("watchman.mybatis.selectRecentHistoryVehicle");

    try {
        for (int i = 0; i < vhs.size(); i++) {
            alert = new ALERT();
            vh = vhs.get(i);
            String datetime_str = vh.getDATE_VISIT() + " " + vh.getTIME_VISIT();
            diff = (date.getTime() - format_datetime.parse(datetime_str).getTime()) / 1000;
            if (diff > 60) {
                diff = diff / 60;
                if (diff > 60) {
                    diff = diff / 60;
                    alert.setTIME_PASSED(diff + " ");
                } else {
                    alert.setTIME_PASSED(diff + " ");
                }
            } else {
                alert.setTIME_PASSED(diff + " ");
            }
            alert.setLICENSE(vh.getLICENSE());
            alerts.add(alert);
        }
    } catch (ParseException e) {
        e.printStackTrace();
    }

    if (model != null) {
        model.addAttribute("alerts", alerts);
    }

    session.close();

    return alerts;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object getHistory(HttpServletRequest request, Model model) {
    SqlSession session = sqlSession();
    ArrayList<HISTORY> historys = null;
    PARAMETER_HISTORY param = new PARAMETER_HISTORY();

    String history_id = request.getParameter("HISTORY_ID");
    param.setHISTORY_ID(-1);/*w w  w  .j  av  a2 s  . c  o m*/
    if (history_id != null && !history_id.equals("")) {
        param.setHISTORY_ID(Integer.parseInt(history_id));
    }
    param.setDATE_VISIT("");
    param.setVEHICLE_ID(-1);

    String page = request.getParameter("PAGE");
    String size_page = request.getParameter("SIZE_PAGE");
    param.setPAGE(0);
    param.setSIZE_PAGE(10);
    if (page != null && !page.equals("")) {
        if (size_page != null && !size_page.equals("")) {
            param.setPAGE((Integer.parseInt(page) - 1) * Integer.parseInt(size_page));
            param.setSIZE_PAGE(Integer.parseInt(size_page));
        } else {
            param.setPAGE((Integer.parseInt(page) - 1) * 10);
        }
        historys = (ArrayList<HISTORY>) session.selectList("watchman.mybatis.selectHistory", param);
    } else if (size_page != null && !size_page.equals("")) {
        param.setSIZE_PAGE(Integer.parseInt(size_page));
        historys = (ArrayList<HISTORY>) session.selectList("watchman.mybatis.selectHistory", param);
    } else {
        historys = (ArrayList<HISTORY>) session.selectList("watchman.mybatis.selectAllHistory", param);
    }

    if (model != null) {
        model.addAttribute("historys", historys);
    }

    session.close();

    return historys;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object getVehicle(HttpServletRequest request, Model model, int vid) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    vehicle.setLICENSE("");
    vehicle.setVEHICLE_ID(-1);/*from  www. j a va2s  .co  m*/
    if (request != null) {
        String license = request.getParameter("license");
        String vehicle_id = request.getParameter("vehicle_id");
        if (license != null && !license.equals("")) {
            vehicle.setLICENSE("%" + license + "%");
            if (model != null) {
                model.addAttribute("license", license);
            }
        } else {
            if (model != null) {
                model.addAttribute("license", "");
            }
        }
        if (vehicle_id != null && !vehicle_id.equals("")) {
            vehicle.setVEHICLE_ID(Integer.parseInt(vehicle_id));
        }
    }
    if (vid != -1) {
        vehicle.setVEHICLE_ID(vid);
    }
    List<VEHICLE> vehicles = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle", vehicle);

    if (model != null) {
        model.addAttribute("vehicles", vehicles);
    }

    session.close();

    return vehicles;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object getHistoryManagement(HttpServletRequest request, Model model) {
    SqlSession session = sqlSession();
    HISTORY_MANAGEMENT history_management = new HISTORY_MANAGEMENT();
    history_management.setDATE_VISIT("");
    history_management.setMANAGEMENT_ID(-1);
    ArrayList<HISTORY_MANAGEMENT> history_managements = (ArrayList<HISTORY_MANAGEMENT>) session
            .selectList("watchman.mybatis.selectHistoryManagement", history_management);

    if (model != null) {
        model.addAttribute("history_managements", history_managements);
    }//from ww w  .j  a  va2s .  co  m

    session.close();

    return history_managements;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object getManagement(HttpServletRequest request, Model model) {
    SqlSession session = sqlSession();
    MANAGEMENT management = new MANAGEMENT();
    management.setMANAGEMENT_ID(-1);//w w  w .jav  a  2s.c o m
    ArrayList<MANAGEMENT> managements = (ArrayList<MANAGEMENT>) session
            .selectList("watchman.mybatis.selectManagement", management);

    if (model != null) {
        model.addAttribute("vehicle_managements", managements);
    }

    session.close();

    return managements;
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object listHistory(HttpServletRequest request, Model model, int hid) {
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    String license = request.getParameter("license");
    String fdate = request.getParameter("fdate");
    String tdate = request.getParameter("tdate");
    String flimit = request.getParameter("flimit");
    String nlimit = request.getParameter("nlimit");
    parameter_vehicle.setHISTORY_ID(hid);
    if (license != null && !license.equals("")) {
        parameter_vehicle.setLICENSE(license);
    } else {/*from  w  w  w. j  a  va 2s.c o m*/
        parameter_vehicle.setLICENSE("");
    }
    if (fdate != null && !fdate.equals("")) {
        parameter_vehicle.setFROM_DATE(fdate);
    } else {
        parameter_vehicle.setFROM_DATE("");
    }
    if (tdate != null && !tdate.equals("")) {
        parameter_vehicle.setTO_DATE(tdate);
    } else {
        parameter_vehicle.setTO_DATE("");
    }
    if (flimit != null && !flimit.equals("")) {
        parameter_vehicle.setFROM_LIMIT(Integer.parseInt(flimit));
    } else {
        parameter_vehicle.setFROM_LIMIT(0);
    }
    if (nlimit != null && !nlimit.equals("")) {
        parameter_vehicle.setNUM_LIMIT(Integer.parseInt(nlimit));
    } else {
        parameter_vehicle.setNUM_LIMIT(10);
    }

    ArrayList<VEHICLE_HISTORY> vhs = (ArrayList<VEHICLE_HISTORY>) session
            .selectList("watchman.mybatis.selectHistoryVehicleCondition", parameter_vehicle);

    if (model != null) {
        model.addAttribute("histories", vhs);
    }

    session.close();

    return vhs;
}

From source file:com.onnurimotors.wm.service.WmService.java

public void getManagementCondition(HttpServletRequest request, Model model) {
    if (request != null && request.getParameter("is_new") != null
            && request.getParameter("is_new").equals("1")) {
        return;/* w  w w.  ja  v a 2 s . c o  m*/
    }
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    String vehicle_id = request.getParameter("vehicle_id");
    String management_id = request.getParameter("management_id");
    if (vehicle_id != null && !vehicle_id.equals("")) {
        parameter_vehicle.setVEHICLE_ID(Integer.parseInt(vehicle_id));
    } else {
        parameter_vehicle.setVEHICLE_ID(-1);
    }
    if (management_id != null && !management_id.equals("")) {
        parameter_vehicle.setMANAGEMENT_ID(Integer.parseInt(management_id));
    } else {
        parameter_vehicle.setMANAGEMENT_ID(-1);
    }

    List<MANAGEMENT> managements = (ArrayList<MANAGEMENT>) session
            .selectList("watchman.mybatis.selectManagementOfVehicle", parameter_vehicle);

    System.out.println("managements size: " + managements.size());

    model.addAttribute("managements", managements);

    session.close();
}

From source file:com.onnurimotors.wm.service.WmService.java

public VEHICLE toggleNotifiable(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String is_notifiable = request.getParameter("IS_NOTIFIABLE");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    if (is_notifiable.equals("on")) {
        vehicle.setIS_NOTIFIABLE(0);//from  w ww. j  a v a  2  s  .  com
    } else {
        vehicle.setIS_NOTIFIABLE(1);
    }
    session.update("watchman.mybatis.updateVehicleIsNotifiable", vehicle);
    session.commit();

    session.close();

    return vehicle;
}