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

Introduction

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

Prototype

int insert(String statement, Object parameter);

Source Link

Document

Execute an insert statement with the given parameter object.

Usage

From source file:com.inform.project.dao.MyBatisGetLocationImpl.java

@Override
public void setLocation(UserLocationModel loc) {
    SqlSession session = null;
    try {//www  . j  av a  2  s. c o m
        session = MyBatisSession.getInst().getSession().openSession();
        session.insert("GetUsersLocationMapper.insertOne", loc);
        session.commit();
    } catch (IOException ex) {
        Logger.getLogger(MyBatisAdminImpl.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

---

From source file:com.inform.project.dao.MyBatisGetSellsImpl.java

@Override
public void setSells(UserSellsModel sell) {
    SqlSession session = null;
    try {/*from   ww w  . j  ava  2s  .c  o  m*/
        session = MyBatisSession.getInst().getSession().openSession();
        session.insert("GetUsersSellsMapper.setSells", sell);
        session.commit();
    } catch (IOException ex) {
        Logger.getLogger(MyBatisAdminImpl.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

---

From source file:com.luxoft.mybatis.splitter.UpdateSplitterPluginTest.java

License:Apache License

private void doInsert(SqlSession sqlSession) {
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("first", "first");
    param.put("other", Arrays.asList("second", "third"));
    sqlSession.insert("multy", param);
    sqlSession.flushStatements();//w  ww  .  j a  v a  2 s .c  o m
}

---

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

public Object visit(HttpServletRequest request) {
    SqlSession session = sqlSession();
    String license = request.getParameter("license").replaceAll("\\s+", "");
    int is_new_customer;
    String title, msg;/*ww  w .ja v  a  2 s .c o m*/
    Date date = new Date();
    Calendar cal = Calendar.getInstance();
    cal.setTime(date);
    cal.add(Calendar.HOUR_OF_DAY, 9);
    date = cal.getTime();
    DateFormat format_date = new SimpleDateFormat("yyyy-MM-dd");
    DateFormat format_time = new SimpleDateFormat("HH:mm:ss");
    VEHICLE vehicle = new VEHICLE();
    HISTORY history = new HISTORY();
    vehicle.setLICENSE(license);
    vehicle.setVEHICLE_ID(-1);

    // retrieve vehicle list which match license
    ArrayList<VEHICLE> result = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle",
            vehicle);

    // if there is no matched vehicle
    if (result.size() == 0) {
        vehicle = new VEHICLE();
        vehicle.setIS_NOTIFIABLE(1);
        vehicle.setLICENSE(license);
        vehicle.setMODEL("");
        vehicle.setUSER_NAME("");
        vehicle.setBIRTH("");
        vehicle.setPHONE_NUMBER("");
        vehicle.setCOMMENT("");
        session.insert("watchman.mybatis.insertVehicle", vehicle);
        session.commit();
        is_new_customer = 1;
    } else {
        vehicle = result.get(0);
        is_new_customer = 0;
    }

    history.setVEHICLE_ID(vehicle.getVEHICLE_ID());
    history.setDATE_VISIT(format_date.format(date));
    history.setTIME_VISIT(format_time.format(date));
    session.insert("watchman.mybatis.insertHistory", history);
    session.commit();

    // msg to app used by employee of onnurimotors
    title = "";
    msg = "";
    if (vehicle.getIS_NOTIFIABLE() == 1) {
        if (is_new_customer == 0) {
            title = title + " ?\n";
            msg = msg + " ?\n";
        } else {
            title = title + "?  ?\n";
            msg = msg + " ?\n";
        }
        msg = msg + ": " + vehicle.getLICENSE() + "\n";
        msg = msg + "?: " + vehicle.getMODEL() + "\n";
        msg = msg + "??: " + vehicle.getUSER_NAME() + "\n";
        msg = msg + "??: " + vehicle.getBIRTH() + "\n";
        msg = msg + ": " + vehicle.getCOMMENT() + "\n";

        /*ArrayList<VEHICLE_HISTORY> result2 = (ArrayList<VEHICLE_HISTORY>) session.selectList("watchman.mybatis.selectAllHistoryVehicle", vehicle);
        for(int i = 0; i < result2.size(); i++) {
           msg = msg + result2.get(i).getDATE_VISIT() + " " + result2.get(i).getTIME_VISIT() + "<br />";
        }*/

        PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
        parameter_vehicle.setVEHICLE_ID(vehicle.getVEHICLE_ID());
        ArrayList<MANAGEMENT_DATE> result3 = (ArrayList<MANAGEMENT_DATE>) session
                .selectList("watchman.mybatis.selectManagementDateOfVehicle", parameter_vehicle);
        msg = msg + "<? >\n";
        for (int i = 0; i < 10 && i < result3.size(); i++) {
            msg = msg + result3.get(i).getDATE_VISIT() + " " + result3.get(i).getCOMMENT() + "\n";
        }

        ArrayList<EMPLOYEE> employees = (ArrayList<EMPLOYEE>) session
                .selectList("watchman.mybatis.selectReceivers");
        for (int i = 0; i < employees.size(); i++) {
            pService.sendPushNotification(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
            pService.sendPush(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
        }
    }

    session.close();

    // if is_notifiable is false, return empty message
    return msg;
}

---

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();/*  ww  w.j  a  v a2s . 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 Object insertVehicle(HttpServletRequest request) {
    SqlSession session = sqlSession();
    ArrayList<VEHICLE> vehicles = null;
    VEHICLE vehicle = new VEHICLE();
    vehicle.setLICENSE(request.getParameter("LICENSE"));
    vehicle.setVEHICLE_ID(-1);//from   ww  w. j  a  va2 s . com
    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.sec.ose.airs.persistence.protex.CacheKBMapperImpl.java

License:Open Source License

@Override
public void insertComponent(String componentID, String componentName) {
    SqlSession session = factory.openSession(true);
    HashMap<String, Object> map = new HashMap<String, Object>();

    map.put("componentID", componentID);
    map.put("componentName", componentName);

    try {/*from  ww w  .  j  a v  a2  s  .  c  om*/
        session.insert("insertComponent", map);
    } finally {
        session.close();
    }
}

---

From source file:com.sec.ose.airs.persistence.protex.CacheKBMapperImpl.java

License:Open Source License

@Override
public void insertComponentVersion(String componentID, String componentName, String versionID,
        String versionName) {/*from ww  w. java 2s . c om*/
    SqlSession session = factory.openSession(true);
    HashMap<String, Object> map = new HashMap<String, Object>();

    map.put("componentID", componentID);
    map.put("componentName", componentName);
    map.put("versionID", versionID);
    map.put("versionName", versionName);

    try {
        session.insert("insertComponentVersion", map);
    } finally {
        session.close();
    }
}

---

From source file:com.sec.ose.airs.persistence.protex.CacheKBMapperImpl.java

License:Open Source License

@Override
public void insertLicense(String licenseID, String licenseName) {
    SqlSession session = factory.openSession(true);
    HashMap<String, Object> map = new HashMap<String, Object>();

    map.put("licenseID", licenseID);
    map.put("licenseName", licenseName);

    try {/*from   www.  ja v  a  2  s  .  c om*/
        session.insert("insertLicense", map);
    } finally {
        session.close();
    }
}

---

From source file:com.sec.ose.airs.persistence.SPDXMapperImpl.java

License:Open Source License

@Override
public int insertPackage(SPDXPackageDTO pkg) {
    SqlSession session = factory.openSession(true);
    int result;//from  ww w.j  a  v  a  2 s  . co  m

    try {
        result = session.insert("insertPackage", pkg);
    } finally {
        session.close();
    }

    return result;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• »