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

public void guardarHistorialContrato(Historial h) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  w w w  . java 2  s . c om
        session.insert("RegistroInversion.guardar_historialContrato", h);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroInversion.guardar_historialContrato");
        System.out.println(e.getMessage());
        e.printStackTrace();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

public void guardarHistorialAdicional(Historial h) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*w  w w . j  a v a2s .  c  om*/
        session.insert("RegistroInversion.guardar_historialAdicDeduc", h);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroInversion.guardar_historialAdicDeduc");
        System.out.println(e.getMessage());
        e.printStackTrace();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

@Override
public void guardarDocumento(NuevosDocumentos dato) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/* ww  w  .j a v a 2 s.  c  om*/
        session.insert("RegistroInversion.insert_nuevoDoc", dato);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroInversion.insert_nuevoDoc");
        System.out.println(e.getMessage());
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

@Override
public void guardarContrato(NuevosDocumentos dato) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from ww w  .  ja v  a 2s.  co m*/
        session.insert("RegistroInversion.insert_nuevoDocContrato", dato);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroInversion.insert_nuevoDocContrato");
        System.out.println(e.getMessage());
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public void registrarHistorial(HistorialMontoViab hm) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  ww  w .j a  va 2 s.com
        session.insert("RegistroPreInversion.insert_hmv", hm);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroPreInversion.insertar_histmov");
        System.out.println(e.getMessage());
        e.printStackTrace();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public void RegistrarAspecGeneral(AspectosGenerales contact) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from   www  .j  a  v  a  2  s.c  om*/
        session.insert("RegistroPreInversion.insert_ag", contact);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroPreInversion.insert_ag");
        System.out.println(e.getMessage());
        e.printStackTrace();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public void RegistrarComponentes(Componentes contact) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from ww  w . j  a v a 2 s. c  om*/
        session.insert("RegistroPreInversion.insert_comp", contact);
        session.commit();
    } catch (Exception e) {
        System.out.println("RegistroPreInversion.insert_comp");
        System.out.println(e.getMessage());
    } finally {
        session.close();
    }
}

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

License:Apache License

private void logActivity(final SqlSession session) {
    session.insert("logActivity", getActivity());
}

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