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

public VEHICLE updateVehicleModel(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String model = request.getParameter("MODEL");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setMODEL(model);/*from  w ww  .j av a  2  s. com*/
    session.update("watchman.mybatis.updateVehicleModel", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public MANAGEMENT submitManagement(HttpServletRequest request) {
    SqlSession session = sqlSession();
    MANAGEMENT management = new MANAGEMENT();
    management.setCOMMENT(request.getParameter("COMMENT"));
    if (request.getParameter("IS_NEW").equals("1")) {
        HISTORY_MANAGEMENT hm = new HISTORY_MANAGEMENT();
        session.insert("watchman.mybatis.insertManagement", management);
        session.commit();//from  ww w . ja v a2  s .  co m
        hm.setMANAGEMENT_ID(management.getMANAGEMENT_ID());
        hm.setDATE_VISIT(request.getParameter("DATE_VISIT"));
        hm.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
        session.insert("watchman.mybatis.insertHistoryManagement", hm);
        session.commit();
    } else {
        management.setMANAGEMENT_ID(Integer.parseInt(request.getParameter("MANAGEMENT_ID")));
        session.update("watchman.mybatis.updateManagement", management);
        session.commit();
    }
    session.close();

    return management;
}

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

public VEHICLE getOneVehicle(int vehicle_id) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    vehicle.setVEHICLE_ID(vehicle_id);// www.ja v  a 2  s  . c o m
    vehicle.setLICENSE("");
    vehicle = (VEHICLE) session.selectOne("watchman.mybatis.selectVehicle", vehicle);

    session.close();

    return vehicle;
}

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

public Object insertVehicle(HttpServletRequest request) {
    SqlSession session = sqlSession();
    ArrayList<VEHICLE> vehicles = null;
    VEHICLE vehicle = new VEHICLE();
    vehicle.setLICENSE(request.getParameter("LICENSE"));
    vehicle.setVEHICLE_ID(-1);/*ww w. j av a  2  s.c  o  m*/
    vehicles = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle", vehicle);
    if (vehicles.size() == 0) {
        vehicle.setIS_NOTIFIABLE(Integer.parseInt(request.getParameter("IS_NOTIFIABLE")));
        String model = request.getParameter("MODEL");
        if (model != null && !model.equals("")) {
            vehicle.setMODEL(model);
        } else {
            vehicle.setMODEL("");
        }
        String user_name = request.getParameter("USER_NAME");
        if (user_name != null && !user_name.equals("")) {
            vehicle.setUSER_NAME(user_name);
        } else {
            vehicle.setUSER_NAME("");
        }
        String birth = request.getParameter("BIRTH");
        if (birth != null && !birth.equals("")) {
            vehicle.setBIRTH(birth);
        } else {
            vehicle.setBIRTH("");
        }
        String phone_number = request.getParameter("PHONE_NUMBER");
        if (phone_number != null && !phone_number.equals("")) {
            vehicle.setPHONE_NUMBER(phone_number);
        } else {
            vehicle.setPHONE_NUMBER("");
        }
        String comment = request.getParameter("COMMENT");
        if (comment != null && !comment.equals("")) {
            vehicle.setCOMMENT(comment);
        } else {
            vehicle.setCOMMENT("");
        }
        session.insert("watchman.mybatis.insertVehicle", vehicle);
        session.commit();
    } else {
        vehicle.setIS_NOTIFIABLE(-1);
    }

    session.close();

    return vehicle;
}

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

public Object updateVehicle(HttpServletRequest request, int vid) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();

    vehicle.setVEHICLE_ID(vid);//w  ww  .  ja  v  a2s  .  co  m
    if (vid == -1) {
        vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    }
    vehicle.setIS_NOTIFIABLE(Integer.parseInt(request.getParameter("IS_NOTIFIABLE")));
    vehicle.setMODEL(request.getParameter("MODEL"));
    vehicle.setUSER_NAME(request.getParameter("USER_NAME"));
    vehicle.setBIRTH(request.getParameter("BIRTH"));
    vehicle.setPHONE_NUMBER(request.getParameter("PHONE_NUMBER"));
    vehicle.setCOMMENT(request.getParameter("COMMENT"));

    session.update("watchman.mybatis.updateVehicle", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public Object deleteVehicle(int vehicle_id) {
    VEHICLE vehicle = new VEHICLE();
    vehicle.setVEHICLE_ID(vehicle_id);/* w ww.java  2  s  .c  om*/
    deleteHistoryByVehicle(vehicle_id);
    SqlSession session = sqlSession();
    session.delete("watchman.mybatis.deleteVehicle", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public Object getVehicleCondition(HttpServletRequest request, Model model) {
    if (request != null && request.getParameter("is_new") != null
            && request.getParameter("is_new").equals("1")) {
        return null;
    }/*from   w  w w . ja v  a  2 s.  co  m*/
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("vehicle_id")));
    vehicle.setLICENSE("");
    ArrayList<VEHICLE> vehicles = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle",
            vehicle);

    session.close();

    model.addAttribute("vehicles", vehicles);

    return vehicles;
}

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

public Object getVehicleHistory(HttpServletRequest request) {
    SqlSession session = sqlSession();
    ArrayList<VEHICLE_HISTORY> historys = null;
    PARAMETER_HISTORY param = new PARAMETER_HISTORY();

    String history_id = request.getParameter("HISTORY_ID");
    param.setHISTORY_ID(-1);//  www . j a  va 2  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);
        }
    } else if (size_page != null && !size_page.equals("")) {
        param.setSIZE_PAGE(Integer.parseInt(size_page));
    }

    historys = (ArrayList<VEHICLE_HISTORY>) session.selectList("watchman.mybatis.selectHistory", param);

    session.close();

    return historys;
}

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

public Object deleteHistory(HttpServletRequest request, Model model, int hid) {
    SqlSession session = sqlSession();
    PARAMETER_HISTORY parameter_history = new PARAMETER_HISTORY();
    parameter_history.setHISTORY_ID(hid);
    parameter_history.setDATE_VISIT("");
    parameter_history.setVEHICLE_ID(-1);
    parameter_history.setPAGE(0);/*www .ja  v  a  2s. c o m*/
    parameter_history.setSIZE_PAGE(1);
    HISTORY history = (HISTORY) session.selectOne("watchman.mybatis.selectHistory", parameter_history);
    session.delete("watchman.mybatis.deleteHistory", history);
    session.commit();

    HISTORY_MANAGEMENT hm = new HISTORY_MANAGEMENT();
    hm.setMANAGEMENT_ID(-1);
    hm.setDATE_VISIT(history.getDATE_VISIT());
    hm.setVEHICLE_ID(history.getVEHICLE_ID());
    System.out.println(hm.getDATE_VISIT() + ":" + hm.getVEHICLE_ID() + ":" + hm.getMANAGEMENT_ID());
    session.delete("watchman.mybatis.deleteManagement", hm);
    session.commit();

    session.delete("watchman.mybatis.deleteHistoryManagement", hm);
    session.commit();

    session.close();

    return history;
}

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

private int getHistoryCount(HttpServletRequest request) {
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    String fdate = request.getParameter("fdate");
    String tdate = request.getParameter("tdate");
    if (fdate != null && !fdate.equals("")) {
        parameter_vehicle.setFROM_DATE(fdate);
    } else {//  w  ww  .j a va2s  .c o m
        parameter_vehicle.setFROM_DATE("");
    }
    if (tdate != null && !tdate.equals("")) {
        parameter_vehicle.setTO_DATE(tdate);
    } else {
        parameter_vehicle.setTO_DATE("");
    }
    ArrayList<HISTORY> historys = (ArrayList<HISTORY>) session
            .selectList("watchman.mybatis.selectAllHistoryInDate", parameter_vehicle);
    session.close();
    return historys.size();
}