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

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

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

Introduction

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

Prototype

void commit();

Source Link

Document

Flushes batch statements and commits database connection.

Usage

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.  ja  va  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);/*from www.  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);//from  www  .jav a 2 s.c  o m
    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 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);/*w w w .j a  v  a 2 s.c  om*/
    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

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);/*from   w  ww .  j av  a  2s  .c  om*/
    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();

    session.close();/*www .j ava2  s.  c o  m*/

    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);//from  w  w  w .  j a  v  a2 s . co 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  www .  j a va 2s  .  c  o  m
    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);//from   w  w w. ja  v a 2  s  . c  om
    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);/*from  ww  w  .j  a  v  a2 s  .c o  m*/
    session.delete("watchman.mybatis.deleteManagement", hm);
    session.commit();
    session.close();
}