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

Introduction

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

Prototype

<T> T selectOne(String statement, Object parameter);

Source Link

Document

Retrieve a single row mapped from the statement key and parameter.

Usage

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public boolean validarProyecto(Integer codigo) {
    boolean esta = false;
    String var = "";
    SqlSession session = sqlSessionFactory.openSession();
    try {//w w w  .ja v a2s.  c o m
        var = session.selectOne("RegistroPreInversion.validarProy", codigo);
        System.out.println("VALIDACION: " + var);
        if (var == null) {
            esta = false;
        } else {
            esta = true;
        }
    } catch (Exception e) {
        System.out.println(e.getMessage());

    }
    return esta;
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public String getMontoViab(String codigo) {
    String montoViab = "";
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w ww .  ja va2  s . c  o m
        montoViab = session.selectOne("RegistroPreInversion.getMontoViab", codigo);
        session.commit();
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    System.out.println(montoViab);
    return montoViab;
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public Integer getId_Origen(String nombre) {
    Integer idorigen = 0;//from w w w.  jav  a  2s  . c o  m
    System.out.println(nombre);
    SqlSession session = sqlSessionFactory.openSession();
    try {
        idorigen = (session.selectOne("RegistroPreInversion.getIdOrigen", nombre));
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    System.out.println(idorigen);
    return idorigen;
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public Integer getId_Opi(String nombre) {
    Integer idopi = 0;//from  w  w w  . j a  v  a 2s . co m
    SqlSession session = sqlSessionFactory.openSession();
    try {
        idopi = session.selectOne("RegistroPreInversion.getIdOpi", nombre);

    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    System.out.println(idopi);
    return idopi;
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public Integer getId_Nivel(String nombre) {
    Integer idnivel = 0;/*from  w  ww .  j  a v a  2 s .c o m*/
    SqlSession session = sqlSessionFactory.openSession();
    try {
        idnivel = session.selectOne("RegistroPreInversion.getIdNivel", nombre);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    System.out.println(idnivel);
    return idnivel;
}

From source file:gp.daoImpl.RegistroPreInversionDaoImpl.java

@Override
public Integer getId_Usuario(String nombre) {
    Integer idusuario = 0;// w ww.  j  av a  2s .co m
    SqlSession session = sqlSessionFactory.openSession();
    try {
        idusuario = session.selectOne("RegistroPreInversion.getIdUsuario", nombre);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    System.out.println(idusuario);
    return idusuario;
}

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

License:Apache License

public TrailDto getUserTrailById(TrailDto t) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  w  w w . j  a v a  2 s .c o  m
        logActivity(session);
        TrailDto trail = session.selectOne("getUserTrailById", t);
        if (trail != null) {
            trail.videos = session.selectList("getVideosForTrail", t.trailId);
            trail.resources = session.selectList("getResourcesForTrail", t.trailId);
            trail.assessments = session.selectList("getAssessmentsForTrail", t.trailId);
        }
        return trail;
    } finally {
        session.close();
    }
}

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

License:Apache License

public TrailDto getTrailForView(int tid) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w  w  w  . j a v  a  2 s.c  om
        logActivity(session);
        TrailDto t = session.selectOne("getTrailById", tid);
        if (t != null) {
            t.videos = session.selectList("getVideosForTrail", tid);
            t.resources = session.selectList("getResourcesForTrail", tid);
            t.assessments = session.selectList("getAssessmentsForTrail", tid);
            //Get the stats
            t.viewsCount = session.selectOne("getTrailViewsCount", tid);
            t.commentsCount = session.selectOne("getTrailCommentsCount", tid);
            t.subsCount = session.selectOne("getTrailSubsCount", tid);
        }
        return t;
    } finally {
        session.close();
    }
}

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

License:Apache License

protected <P, R> R getEntity(String stmtId, P dto) {
    SqlSession session = sqlSessionFactory.openSession();
    R result;//from  w w  w . j a  v  a  2  s . c o m
    try {
        logActivity(session);
        result = session.selectOne(stmtId, dto);
        session.commit();
    } finally {
        session.close();
    }
    return result;
}

From source file:io.starter.datamodel.ContentData.java

License:Open Source License

/**
 * returns the average rating for the content item
 * /*from w  ww  .ja v  a2  s  .  c  o  m*/
 * this is the content "score"
 * 
 * @param id
 * @param servletRequest
 * @throws IOException
 * @throws JSONException
 * @throws ServletException
 * @throws org.json.JSONException 
 */
@GET
@Path("rating")
@Produces(MediaType.APPLICATION_JSON)
public String getRating(@PathParam("contentId") int id, @Context HttpServletRequest servletRequest)
        throws IOException, JSONException, ServletException, org.json.JSONException {

    SqlSession session = (SqlSession) servletRequest.getAttribute(SESSION_VAR_SQLSESSION);

    Content content = session.selectOne("io.starter.dao.ContentMapper.selectObjByPrimaryKey", id);

    JSONObject job = new JSONObject();
    job.put("rating", content.getRating());
    return job.toString();
}