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

Introduction

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

Prototype

<E> List<E> selectList(String statement, Object parameter);

Source Link

Document

Retrieve a list of mapped objects from the statement key and parameter.

Usage

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 .  jav a 2s. 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);//from  w  ww.j  av a 2  s .c  om
    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 {//  www. j  av a 2 s. com
        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;/*from  w  w  w. j av  a2 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 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 . jav a 2 s.  co  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 getVehicleCondition(HttpServletRequest request, Model model) {
    if (request != null && request.getParameter("is_new") != null
            && request.getParameter("is_new").equals("1")) {
        return null;
    }//from  www. jav  a  2  s  .c  o  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);//from   w  ww  . j a  v a 2  s  .  c om
    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

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 {//from   w ww  .  j  a v a  2  s  .com
        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();
}

---

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);// w  w  w.jav a2 s  .com
    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 + "%");
        }//from   w w  w  .  ja  va 2  s  .c  om
        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;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »