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 getVehicleCount(HttpServletRequest request) {
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    String license = request.getParameter("license");
    String vehicle_id = request.getParameter("vehicle_id");
    String flimit = request.getParameter("flimit");
    String nlimit = request.getParameter("nlimit");
    parameter_vehicle.setLICENSE("");
    parameter_vehicle.setVEHICLE_ID(-1);
    parameter_vehicle.setFROM_LIMIT(0);/*from  www  . j  av a2 s.  c  om*/
    parameter_vehicle.setNUM_LIMIT(10);
    if (license != null && !license.equals("")) {
        parameter_vehicle.setLICENSE(license);
    }
    if (vehicle_id != null && !vehicle_id.equals("")) {
        parameter_vehicle.setVEHICLE_ID(Integer.parseInt(vehicle_id));
    }
    if (flimit != null && !flimit.equals("")) {
        parameter_vehicle.setFROM_LIMIT(Integer.parseInt(flimit));
    }
    if (nlimit != null && !nlimit.equals("")) {
        parameter_vehicle.setNUM_LIMIT(Integer.parseInt(nlimit));
    }
    ArrayList<HISTORY> historys = (ArrayList<HISTORY>) session.selectList("watchman.mybatis.selectAllVehicle",
            parameter_vehicle);
    session.close();
    return historys.size();
}

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

public Object getVehiclePage(HttpServletRequest request, Model model) {
    SqlSession session = sqlSession();
    PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
    if (request != null) {
        String license = request.getParameter("license");
        String vehicle_id = request.getParameter("vehicle_id");
        String flimit = request.getParameter("flimit");
        String nlimit = request.getParameter("nlimit");
        parameter_vehicle.setLICENSE("");
        parameter_vehicle.setVEHICLE_ID(-1);
        parameter_vehicle.setFROM_LIMIT(0);
        parameter_vehicle.setNUM_LIMIT(10);
        if (license != null && !license.equals("")) {
            parameter_vehicle.setLICENSE("%" + license + "%");
        }//  www  . ja v  a2 s . c o  m
        if (vehicle_id != null && !vehicle_id.equals("")) {
            parameter_vehicle.setVEHICLE_ID(Integer.parseInt(vehicle_id));
        }
        if (flimit != null && !flimit.equals("")) {
            parameter_vehicle.setFROM_LIMIT(Integer.parseInt(flimit));
        }
        if (nlimit != null && !nlimit.equals("")) {
            parameter_vehicle.setNUM_LIMIT(Integer.parseInt(nlimit));
        }
    }
    ArrayList<VEHICLE> vehicles = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehiclePage",
            parameter_vehicle);

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

    session.close();

    return vehicles;
}

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

public VEHICLE updateVehicleUserName(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String user_name = request.getParameter("USER_NAME");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setUSER_NAME(user_name);/*w ww  .ja  va 2s  .co  m*/
    session.update("watchman.mybatis.updateVehicleUserName", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public VEHICLE updateVehiclePhoneNumber(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String phone_number = request.getParameter("PHONE_NUMBER");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setPHONE_NUMBER(phone_number);
    session.update("watchman.mybatis.updateVehiclePhoneNumber", vehicle);
    session.commit();//from   ww w  . j ava  2s .  c om

    session.close();

    return vehicle;
}

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

public VEHICLE updateVehicleBirth(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String birth = request.getParameter("BIRTH");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setBIRTH(birth);/*ww w . j  av  a 2  s . c o m*/
    session.update("watchman.mybatis.updateVehicleBirth", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public VEHICLE updateVehicleComment(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String comment = request.getParameter("COMMENT");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setCOMMENT(comment);//from   ww  w.ja  v a  2s  . c  om
    session.update("watchman.mybatis.updateVehicleComment", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

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

public void deleteManagement(int mid) {
    HISTORY_MANAGEMENT hm = new HISTORY_MANAGEMENT();
    hm.setMANAGEMENT_ID(mid);/*  w  w  w .  j  av  a  2  s . c o m*/
    hm.setVEHICLE_ID(-1);
    hm.setDATE_VISIT("");

    deleteHistoryManagement(hm);

    SqlSession session = sqlSession();
    session.delete("watchman.mybatis.deleteManagement", hm);
    session.commit();

    session.close();
}

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

public void deleteManagementByVehicle(HISTORY_MANAGEMENT hm) {
    SqlSession session = sqlSession();
    hm.setMANAGEMENT_ID(-1);/*w ww  .j a  va 2s .  co  m*/
    session.delete("watchman.mybatis.deleteManagement", hm);
    session.commit();
    session.close();
}

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

private void deleteHistoryManagement(HISTORY_MANAGEMENT hm) {
    SqlSession session = sqlSession();
    session.delete("watchman.mybatis.deleteHistoryManagement", hm);
    session.commit();/*from  w ww.j  a  v a2 s  . co m*/
    session.close();
}

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

public Object getEmployeePage(HttpServletRequest request, Model model) {
    SqlSession session = sqlSession();
    EMPLOYEE employee = new EMPLOYEE();
    if (request != null) {
        String name = request.getParameter("name");
        String employee_id = request.getParameter("employee_id");
        String flimit = request.getParameter("flimit");
        String nlimit = request.getParameter("nlimit");
        employee.setNAME("");
        employee.setEMPLOYEE_ID(-1);/*w  w w .j  av a2 s  .co m*/
        employee.setFROM_LIMIT(0);
        employee.setNUM_LIMIT(10);
        if (name != null && !name.equals("")) {
            employee.setNAME(name);
        }
        if (employee_id != null && !employee_id.equals("")) {
            employee.setEMPLOYEE_ID(Integer.parseInt(employee_id));
        }
        if (flimit != null && !flimit.equals("")) {
            employee.setFROM_LIMIT(Integer.parseInt(flimit));
        }
        if (nlimit != null && !nlimit.equals("")) {
            employee.setNUM_LIMIT(Integer.parseInt(nlimit));
        }
    }
    ArrayList<EMPLOYEE> employees = (ArrayList<EMPLOYEE>) session
            .selectList("watchman.mybatis.selectEmployeePage", employee);

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

    session.close();

    return employees;
}