Example usage for org.apache.ibatis.session SqlSession 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.onnurimotors.wm.service.WmService.java

private int getEmployeeCount(HttpServletRequest request) {
    SqlSession session = sqlSession();
    EMPLOYEE employee = new EMPLOYEE();
    String name = request.getParameter("name");
    String employee_id = request.getParameter("employee_id");
    employee.setNAME("");
    employee.setEMPLOYEE_ID(-1);/*from   www . ja v a2 s .c o  m*/
    if (name != null && !name.equals("")) {
        employee.setNAME(name);
    }
    if (employee_id != null && !employee_id.equals("")) {
        employee.setEMPLOYEE_ID(Integer.parseInt(employee_id));
    }
    ArrayList<EMPLOYEE> employees = (ArrayList<EMPLOYEE>) session
            .selectList("watchman.mybatis.selectAllEmployee", employee);
    session.close();
    return employees.size();
}

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

public Object toggleReceivingKakao(HttpServletRequest request) {
    SqlSession session = sqlSession();
    EMPLOYEE employee = new EMPLOYEE();
    String is_receiving_kakao = request.getParameter("IS_RECEIVING_KAKAO");
    employee.setEMPLOYEE_ID(Integer.parseInt(request.getParameter("EMPLOYEE_ID")));
    if (is_receiving_kakao.equals("on")) {
        employee.setIS_RECEIVING_KAKAO(0);
    } else {//from   w w w.ja  v a 2  s. co m
        employee.setIS_RECEIVING_KAKAO(1);
    }
    session.update("watchman.mybatis.updateEmployeeIsReceivingKakao", employee);
    session.commit();

    session.close();

    return employee;
}

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

public String generateDB() {
    SqlSession session = sqlSession();

    session.insert("watchman.mybatis.createEmployeeTable");
    session.commit();/*from   w ww. j  a  v a  2  s. co m*/
    session.insert("watchman.mybatis.createManagementTable");
    session.commit();
    session.insert("watchman.mybatis.createHistoryManagementTable");
    session.commit();
    session.insert("watchman.mybatis.createVehicleTable");
    session.commit();
    session.insert("watchman.mybatis.createHistoryTable");
    session.commit();

    session.close();

    return "Success";
}

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

public MANAGEMENT_DATE getOneManagement(int mid) {
    SqlSession session = sqlSession();
    MANAGEMENT management = new MANAGEMENT();
    management.setMANAGEMENT_ID(mid);//from ww w  .j  av a  2  s. c om
    MANAGEMENT_DATE md = (MANAGEMENT_DATE) session.selectOne("watchman.mybatis.selectManagementDate",
            management);
    session.close();
    return md;
}

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

public Object getAllHistory(HttpServletRequest request, Model model, String date_visit) {
    SqlSession session = sqlSession();
    PARAMETER_HISTORY parameter_history = new PARAMETER_HISTORY();
    parameter_history.setHISTORY_ID(-1);
    if (request != null) {
        String parameter = request.getParameter("HISTORY_ID");
        if (parameter != null && !parameter.equals("")) {
            parameter_history.setHISTORY_ID(Integer.parseInt(parameter));
        }/*  w w w . j  a  v a  2s  .  c o m*/
    }
    parameter_history.setDATE_VISIT("");
    if (date_visit != null && !date_visit.equals("")) {
        parameter_history.setDATE_VISIT(date_visit);
    }

    ArrayList<HISTORY> historys = (ArrayList<HISTORY>) session.selectList("watchman.mybatis.selectAllHistory",
            parameter_history);
    session.close();

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

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

public Object getAllHistoryByVehicle(HttpServletRequest request, Model model, int vehicle_id) {
    getVehicle(request, model, vehicle_id);
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    parameter_vehicle.setVEHICLE_ID(vehicle_id);
    if (request != null) {
        String parameter = request.getParameter("vehicle_id");
        if (parameter != null && !parameter.equals("")) {
            parameter_vehicle.setVEHICLE_ID(Integer.parseInt(parameter));
        }//from   w  w  w .j av a 2s  . c  o m
    }

    ArrayList<HISTORY> historys = (ArrayList<HISTORY>) session
            .selectList("watchman.mybatis.selectAllDateVisitByVehicle", parameter_vehicle);
    session.close();

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

    return historys;
}

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

public Object getManagementByHistory(HttpServletRequest request, Map<String, Object> model, int vehicle_id,
        String date_visit) {// www .  j  a  v  a 2 s.c  o m
    SqlSession session = sqlSession();
    PARAMETER_HISTORY parameter_history = new PARAMETER_HISTORY();
    parameter_history.setDATE_VISIT(date_visit);
    parameter_history.setVEHICLE_ID(vehicle_id);
    parameter_history.setHISTORY_ID(-1);
    parameter_history.setPAGE(0);
    parameter_history.setSIZE_PAGE(1);

    PARAMETER_MANAGEMENT parameter_management = new PARAMETER_MANAGEMENT();
    parameter_management.setVEHICLE_ID(vehicle_id);
    parameter_management.setDATE_VISIT(date_visit);

    ArrayList<MANAGEMENT> managements = (ArrayList<MANAGEMENT>) session
            .selectList("watchman.mybatis.selectAllManagementByDateVisitVehicle", parameter_management);

    HISTORY history = (HISTORY) session.selectOne("watchman.mybatis.selectHistory", parameter_history);
    parameter_history.setHISTORY_ID(history.getHISTORY_ID());
    HISTORY prev_history = (HISTORY) session.selectOne("watchman.mybatis.selectPrevHistory", parameter_history);
    HISTORY next_history = (HISTORY) session.selectOne("watchman.mybatis.selectNextHistory", parameter_history);

    if (model != null) {
        model.put("history", history);
        model.put("prev_history", prev_history);
        model.put("next_history", next_history);
        model.put("managements", managements);
    }

    session.close();

    return managements;
}

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

public String regenerateDB() {
    SqlSession session = sqlSession();

    session.delete("watchman.mybatis.dropManagementTable");
    session.commit();/*from w w  w  .  j  ava  2 s .  co  m*/
    session.delete("watchman.mybatis.dropHistoryManagementTable");
    session.commit();
    session.delete("watchman.mybatis.dropVehicleTable");
    session.commit();
    session.delete("watchman.mybatis.dropHistoryTable");
    session.commit();

    session.insert("watchman.mybatis.createManagementTable");
    session.commit();
    session.insert("watchman.mybatis.createHistoryManagementTable");
    session.commit();
    session.insert("watchman.mybatis.createVehicleTable");
    session.commit();
    session.insert("watchman.mybatis.createHistoryTable");
    session.commit();

    session.close();

    return "Success";
}

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

public String modifyDB() {
    SqlSession session = sqlSession();

    //session.update("watchman.mybatis.modifyEmployeeTable");
    //session.commit();

    session.delete("watchman.mybatis.dropEmployeeTable");
    session.commit();//  www .jav a2s .c o  m

    session.insert("watchman.mybatis.createEmployeeTable");
    session.commit();

    session.close();

    return "Success";
}

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

private void deleteHistoryByVehicle(int vehicle_id) {
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    parameter_vehicle.setVEHICLE_ID(vehicle_id);
    ArrayList<HISTORY> historys = (ArrayList<HISTORY>) session
            .selectList("watchman.mybatis.selectAllHistoryByVehicle", parameter_vehicle);
    session.close();
    for (int i = 0; i < historys.size(); i++) {
        deleteHistory(null, null, historys.get(i).getHISTORY_ID());
    }//from   ww  w.  j av a  2 s.  com

}