Example usage for com.liferay.portal.kernel.dao.orm Type FLOAT

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm Type FLOAT.

Prototype

Type FLOAT

To view the source code for com.liferay.portal.kernel.dao.orm Type FLOAT.

Click Source Link

Usage

From source file:org.tvd.thptty.service.persistence.TYStudentPointFinderImpl.java

License:Open Source License

public List<TYStudentPoint> findByAVGPointFactor(int courses, int semester, long studentId, long subjectId,
        int pointFactor) throws SystemException {

    //long classNameId = PortalUtil.getClassNameId(
    //"org.tvd.thptty.model.TYStudentPoint");
    Session session = null;//from   w ww .  j  a va  2  s  .  c  o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_AVG_POINT_FACTOR);

        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar("studentId", Type.LONG);
        q.addScalar("avgPoint", Type.FLOAT);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(courses);
        qPos.add(semester);
        qPos.add(studentId);
        qPos.add(subjectId);
        qPos.add(pointFactor);

        List<Object[]> studentAVGPoints = (List<Object[]>) QueryUtil.list(q, getDialect(), 0, 1);

        List<TYStudentPoint> temps = assemblePoints(studentAVGPoints);

        return temps;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:org.tvd.thptty.service.persistence.TYStudentPointFinderImpl.java

License:Open Source License

public List<TYStudentPoint> findByAVGPointSubject(int courses, int semester, long studentId, long subjectId)
        throws SystemException {

    //long classNameId = PortalUtil.getClassNameId(
    //"org.tvd.thptty.model.TYStudentPoint");
    Session session = null;// www  .  j ava  2 s .c om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_AVG_POINT_SUBJECT);

        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar("studentId", Type.LONG);
        q.addScalar("avgPoint", Type.FLOAT);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(courses);
        qPos.add(semester);
        qPos.add(studentId);
        qPos.add(subjectId);

        List<Object[]> studentAVGPoints = (List<Object[]>) QueryUtil.list(q, getDialect(), 0, 1);

        List<TYStudentPoint> temps = assemblePoints(studentAVGPoints);

        return temps;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:org.tvd.thptty.service.persistence.TYStudentPointFinderImpl.java

License:Open Source License

public List<TYStudentPoint> findByAVGPoint(int courses, int semester, long studentId) throws SystemException {

    //long classNameId = PortalUtil.getClassNameId(
    //"org.tvd.thptty.model.TYStudentPoint");
    Session session = null;/*w ww. ja v a 2 s . c  om*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_AVG_POINT);

        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar("studentId", Type.LONG);
        q.addScalar("avgPoint", Type.FLOAT);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(courses);
        qPos.add(semester);
        qPos.add(studentId);

        List<Object[]> studentAVGPoints = (List<Object[]>) QueryUtil.list(q, getDialect(), 0, 1);

        List<TYStudentPoint> temps = assemblePoints(studentAVGPoints);

        return temps;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:org.tvd.thptty.service.persistence.TYStudentPointFinderImpl.java

License:Open Source License

public List<TYStudentPoint> findByAVGPointOfStudents_C_S(int courses, int semester, long companyId,
        long groupId, float from, float to, int begin, int end) throws SystemException {

    //long classNameId = PortalUtil.getClassNameId(
    //"org.tvd.thptty.model.TYStudentPoint");
    Session session = null;/*from   ww w. j a  v a  2  s  .c  o m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_AVG_POINT_OF_STUDENT_C_S);

        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar("studentId", Type.LONG);
        q.addScalar("avgPoint", Type.FLOAT);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(courses);
        qPos.add(semester);
        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(from);
        qPos.add(to);

        List<Object[]> studentAVGPoints = (List<Object[]>) QueryUtil.list(q, getDialect(), begin, end);

        List<TYStudentPoint> temps = assemblePoints(studentAVGPoints);

        return temps;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:org.tvd.thptty.service.persistence.TYStudentPointFinderImpl.java

License:Open Source License

public List<TYStudentPoint> findByAVGPointOfStudents_C_S_Class(int courses, int semester, long companyId,
        long groupId, long classId, float from, float to, int begin, int end) throws SystemException {

    //long classNameId = PortalUtil.getClassNameId(
    //"org.tvd.thptty.model.TYStudentPoint");
    Session session = null;/*from   ww  w  .j a  v a  2 s. c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_AVG_POINT_OF_STUDENT_C_S_CLASS);

        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar("studentId", Type.LONG);
        q.addScalar("avgPoint", Type.FLOAT);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(courses);
        qPos.add(semester);
        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(classId);
        qPos.add(from);
        qPos.add(to);

        List<Object[]> studentAVGPoints = (List<Object[]>) QueryUtil.list(q, getDialect(), begin, end);

        List<TYStudentPoint> temps = assemblePoints(studentAVGPoints);

        return temps;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---