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

Introduction

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

Prototype

int delete(String statement, Object parameter);

Source Link

Document

Execute a delete statement.

Usage

From source file:fr.cph.stock.dao.PortfolioDaoImpl.java

License:Apache License

@Override
public final void delete(final Portfolio portfolio) {
    SqlSession session = getSqlSessionFactory();
    try {//  www.j a  va2  s  . c  om
        session.delete("PortfolioDao.deleteOnePortfolio", portfolio);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:fr.cph.stock.dao.ShareValueDaoImpl.java

License:Apache License

@Override
public final void delete(final ShareValue shareValue) {
    SqlSession session = getSqlSessionFactory();
    try {/*from  w  ww.ja v a2s  .com*/
        session.delete("ShareValue.deleteOneShareValue", shareValue);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:fr.cph.stock.dao.UserDaoImpl.java

License:Apache License

@Override
public final void delete(final User user) {
    SqlSession session = getSqlSessionFactory();
    try {/*w  ww  .j a  va2 s . c om*/
        session.delete("UserDao.deleteOneUser", user);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.ListasGeneralesDaoImpl.java

public void eliminarNuevosDocumentos(String codigo) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from   ww w . j  a  va 2  s  .c om*/
        session.delete("EliminarProy.deleteND", codigo);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.ListasGeneralesDaoImpl.java

public void eliminarEjecucion(String codigo) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from   w  w  w . j a  va 2s  .c  o  m*/
        session.delete("EliminarProy.deleteEjecu", codigo);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.ListasGeneralesDaoImpl.java

public void eliminarExpedientesTecnicos(String codigo) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*ww  w . ja va2s.co  m*/
        session.delete("EliminarProy.deleteET", codigo);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:gp.daoImpl.ListasGeneralesDaoImpl.java

public void eliminarProy(String codigo) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from www. ja v a 2  s.  c  o m
        session.delete("EliminarProy.deleteProy", codigo);
        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 {/* w  w w .j  av 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 int deleteTrail(Long trailId, Long userId) {
    int rows = 0;
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from  w  w w. ja va  2  s.co  m*/
        HashMap<String, Object> param = new HashMap<String, Object>();
        param.put("trailId", trailId);
        param.put("createdBy", userId);
        rows = session.delete("deleteTrail", param);
        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  www .j a v  a  2  s. c om
        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();
    }
}