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

Introduction

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

Prototype

int update(String statement, Object parameter);

Source Link

Document

Execute an update statement.

Usage

From source file:com.gordcorp.jira2db.persistence.JiraIssueDao.java

License:Open Source License

public int updateByJiraKey(JiraIssueDto jiraIssueDto) {
    SqlSession session = sf.openSession();
    int status = 0;
    try {/*from   w  w  w .j av  a  2  s .c om*/
        String query = NAMESPACE + "." + PREFIX_UPDATE_QUERY + this.type.getSimpleName() + "ByJiraKey";
        status = session.update(query, jiraIssueDto);
        session.commit();
    } finally {
        session.close();
    }
    return status;
}

---

From source file:com.gordcorp.jira2db.persistence.MyBatisDao.java

License:Open Source License

/**
 * Method updates the object by id. </br></br> You will usually override
 * this method. But it can be used for simple objects. </br> Example: </br>
 * If your DAO object is called CarInfo.java, the corresponding mapper query
 * id should be: &lt;update id="updateCarInfo" ... </br></br> SQL Executed
 * (example): update [tablename] set fieldname1 = value1 where id = #{id}
 * //from  ww  w.  j  a  v  a2 s .c o m
 */
@Override
public int update(T o) throws PersistenceException {
    SqlSession session = sf.openSession();
    int status = 0;
    try {
        String query = NAMESPACE + "." + PREFIX_UPDATE_QUERY + o.getClass().getSimpleName();
        status = session.update(query, o);
        session.commit();
    } finally {
        session.close();
    }
    return status;
}

---

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

@Override
public void updateUser(LoginAuthModel user) {
    SqlSession session = null;
    try {//from   w  w  w .  ja  v  a 2 s  .  c om
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetUsersMapper.updateOne", user);
        session.commit();
        System.out.println("commit");
    } catch (IOException ex) {
        System.out.println(ex);
        Logger.getLogger(MyBatisAdminImpl.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

---

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

@Override
public void updCategory(UserCategoryModel category) {
    SqlSession session = null;
    try {/*from   w  ww  .  j  a v a 2  s.  com*/
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetUsersCategoryMapper.updateOne", category);
        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.MyBatisGetEventsImpl.java

@Override
public void saveEdit(EventModel event) {
    SqlSession session = null;
    try {//from   w  w w.  j a v a2  s  . co  m
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetEventsModelMapper.updateOne", event);
        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.MyBatisGetLocationImpl.java

@Override
public void updLocation(UserLocationModel loc) {
    SqlSession session = null;
    try {/* w ww  . j  a v  a2  s. com*/
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetUsersLocationMapper.updateOne", 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 updSells(UserSellsModel sell) {
    SqlSession session = null;
    try {/*  w  w w.j  a  va 2s. c om*/
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetUsersSellsMapper.updateOne", 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.onnurimotors.wm.service.WmService.java

public VEHICLE toggleNotifiable(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String is_notifiable = request.getParameter("IS_NOTIFIABLE");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    if (is_notifiable.equals("on")) {
        vehicle.setIS_NOTIFIABLE(0);/*w  ww. ja v a 2  s  .  c  o  m*/
    } else {
        vehicle.setIS_NOTIFIABLE(1);
    }
    session.update("watchman.mybatis.updateVehicleIsNotifiable", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

---

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);// w w w  .  j  a v  a2s .  co m
    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();/* w  ww  .  ja  v  a 2s  . 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;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »