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:gp.daoImpl.BusqPreInversionDaoImpl.java

@Override
public void actualizarMontoViab(Integer idProy, Double nuevMontoViab) {
    SqlSession session = sqlSessionFactory.openSession();
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("idproyecto", idProy);
    map.put("montoViab", nuevMontoViab);
    try {//from  w  ww. j av a 2  s.  co  m
        session.update("BusqPreInversion.update_montoViab", map);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.BusqPreInversionDaoImpl.java

@Override
public void actualizarComponentes(Componentes c) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from www .j  a  v  a  2  s.  c om
        session.update("BusqPreInversion.update_Co", c);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.BusqPreInversionDaoImpl.java

@Override
public void actualizarAspectosGenerales(AspectosGenerales ag) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//  w ww  .  java 2 s  . c o  m
        session.update("BusqPreInversion.update_Ag", ag);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.BusquedaInversionDaoImpl.java

@Override
public void actualizarMontoModif(ExpedienteTecnico e) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w w w  . ja v  a 2  s.  co m
        int a = session.update("BusquedaInversion.actualizarMontoModif", e);
        session.commit();
        System.out.println("se han actualizado: " + a);
    } catch (Exception ex) {
        System.out.println(ex.getMessage());
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.BusquedaInversionDaoImpl.java

@Override
public void ActualizarExpedienteTecnico(ExpedienteTecnico e) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/* ww  w.j  a  v  a 2 s  .  c om*/
        int a = session.update("BusquedaInversion.actualizarExpTecn", e);
        session.commit();
        System.out.println("se han actualizado: " + a);
    } catch (Exception ex) {
        System.out.println(ex.getMessage());
    } finally {
        session.close();
    }

}

From source file:gp.daoImpl.gestionUsuarioDaoImpl.java

@Override
public void actualizarUsario(actualizarUsuario u) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*  w w  w  .jav  a  2s.c o m*/
        int a = session.update("UsuarioData.actualizar_usu", u);
        session.commit();
        System.out.println("se han actualizado: " + a);
    } catch (Exception ex) {
        System.out.println(ex.getMessage());
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

@Override
public void actualizarEstadoExpTecn(String etapa, String proyecto) {
    Map<String, String> map = new HashMap<String, String>();
    map.put("etapa", etapa);
    map.put("proyecto", proyecto);
    SqlSession session = sqlSessionFactory.openSession();
    try {// www.j a  v  a  2s . c o m
        session.update("RegistroInversion.update_ExpTecn", map);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:in.flipbrain.dao.MyBatisDao.java

License:Apache License

public int saveTrail(TrailDto trail) {
    int rows = 0;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w  w w. j  a  va2 s  .  c  o  m
        if (trail.trailId < 1 && !trail.isDeleted()) {
            rows += session.insert("insertTrail", trail);
        } else if (trail.isDeleted()) {
            rows += session.delete("deleteTrail", trail.trailId);
        } else {
            rows += session.delete("updateTrail", trail);
        }
        ArrayList<TrailItemDto> items = new ArrayList<TrailItemDto>();
        items.addAll(trail.resources);
        items.addAll(trail.videos);
        int seq = 0;
        for (TrailItemDto t : items) {
            t.trailId = trail.trailId;
            if (t.itemId < 1 && !t.isDeleted()) {
                t.seqNo = seq++;
                rows += session.insert("insertTrailItem", t);
            } else if (t.isDeleted()) {
                rows += session.delete("deleteTrailItem", t.itemId);
            } else {
                rows += session.update("updateTrailItem", t);
            }
        }
        for (TrailAssessmentDto ta : trail.assessments) {
            ta.trailId = trail.trailId;
            if (ta.trailAssessId < 1 && !ta.isDeleted()) {
                session.insert("insertTrailAssessment", ta);
            } else if (ta.isDeleted()) {
                session.delete("deleteTrailAssessment", ta.trailAssessId);
            }
        }
        logActivity(session);
        session.commit();
    } finally {
        session.close();
    }
    return rows;
}

From source file:in.flipbrain.dao.MyBatisDao.java

License:Apache License

public void saveAssessmentSubmission(AssessmentSubmissionDto dto) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from ww  w. j  ava 2 s. c o m
        boolean isNew = dto.submissionId < 1 && !dto.isDeleted();
        if (isNew) {
            session.insert("insertAssessmentSubmission", dto);
        } else if (dto.isDeleted()) {
            session.delete("deleteAssessmentSubmission", dto);
        } else {
            session.update("updateAssessmentSubmission", dto);
            session.delete("deleteResponsesForSubmission", dto.submissionId);
        }

        if (!dto.isDeleted()) {
            for (SubmissionResponseDto r : dto.responses) {
                r.submissionId = dto.submissionId;
                if (r.responseId < 1 && !r.isDeleted()) {
                    session.insert("insertSubmissionResponse", r);
                }
            }
        }
        session.commit();
    } finally {
        session.close();
    }
}

From source file:in.flipbrain.dao.MyBatisDao.java

License:Apache License

public void saveQuestion(QuestionDto dto) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w ww .  j  av a 2s  .  co m
        if (dto.questionId < 1 && !dto.isDeleted()) {
            session.insert("insertQuestion", dto);
        } else if (dto.isDeleted()) {
            session.delete("deleteQuestion", dto);
        } else {
            session.update("updateQuestion", dto);
        }
        for (AnswerOptionDto opt : dto.answerOptions) {
            opt.questionId = dto.questionId;
            opt.author = dto.author;
            if (opt.answerOptId < 1 && !opt.isDeleted()) {
                session.insert("insertAnswerOption", opt);
            } else if (opt.isDeleted()) {
                session.delete("deleteAnswerOption", opt);
            } else {
                session.update("updateAnswerOption", opt);
            }
        }
        session.commit();
    } finally {
        session.close();
    }
}