Example usage for org.hibernate.type CalendarType INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type CalendarType INSTANCE.

Prototype

CalendarType INSTANCE

To view the source code for org.hibernate.type CalendarType INSTANCE.

Click Source Link

Usage

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYear(int month, int year, String division) throws Exception {

    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished FROM tblTicketsH "
            + "WHERE (YEAR(ApplicationDate) = :paramYear) AND (MONTH(ApplicationDate) = :paramMonth) AND (DivisionCode = :division) AND (TicketsFinished != 'D')"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();/*from  w  ww.j a v  a2 s  .c  o m*/
    return results;
}

---

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findFinish() throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy FROM   tblTicketsH  WHERE (TicketsFinished = 'F')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();/*  ww w.  j  a  va 2s  . c  o m*/
    return results;
}

---

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findFinish(String area) throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy \n"
            + "FROM APP_USER LEFT OUTER JOIN\n"
            + "tblMaster_Branch ON APP_USER.branchId = tblMaster_Branch.BranchID RIGHT OUTER JOIN\n"
            + " tblTicketsH ON APP_USER.SSO_ID = tblTicketsH.ApplicationName\n"
            + "WHERE (tblMaster_Branch.Area = '" + area + "') AND (tblTicketsH.TicketsFinished = 'F')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();//w  w  w. j a  va  2  s. co m

    return results;
}

---

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYearArea(int month, int year, String division, String area)
        throws Exception {
    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished, paidByAdmin, adminBy \n"
            + "FROM APP_USER LEFT OUTER JOIN\n"
            + "tblMaster_Branch ON APP_USER.branchId = tblMaster_Branch.BranchID RIGHT OUTER JOIN\n"
            + "tblTicketsH ON APP_USER.SSO_ID = tblTicketsH.ApplicationName\n"
            + "WHERE (tblMaster_Branch.Area = '" + area
            + "') AND (YEAR(tblTicketsH.ApplicationDate) = :paramYear) AND (MONTH(tblTicketsH.ApplicationDate) = :paramMonth) AND (tblTicketsH.DivisionCode = :division) AND (tblTicketsH.TicketsFinished != 'D')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE).addScalar("paidByAdmin", BigDecimalType.INSTANCE)
            .addScalar("adminBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();//from   www  . ja  v  a 2s. co m
    return results;

}

---

From source file:com.timesoft.kaitoo.ws.common.CoreContent.java

public static void fildHibernateParameter(final SQLQuery sqlQuery, final Map<String, Object> paramMap)
        throws HibernateException {

    Set<String> set = paramMap.keySet();
    for (Iterator<String> iter = set.iterator(); iter.hasNext();) {
        String paramName = iter.next();
        Object paramValue = paramMap.get(paramName);
        if (paramValue != null) {
            if (paramValue instanceof java.lang.String) {
                sqlQuery.setParameter(paramName, paramValue.toString().trim(), StringType.INSTANCE);
            } else if (paramValue instanceof java.lang.Character) {
                sqlQuery.setParameter(paramName, paramValue, CharacterType.INSTANCE);
            } else if (paramValue instanceof java.lang.Integer) {
                sqlQuery.setParameter(paramName, paramValue, IntegerType.INSTANCE);
            } else if (paramValue instanceof java.util.Date) {
                sqlQuery.setParameter(paramName, paramValue, DateType.INSTANCE);
            } else if (paramValue instanceof java.lang.Long) {
                sqlQuery.setParameter(paramName, paramValue, LongType.INSTANCE);
            } else if (paramValue instanceof java.sql.Timestamp) {
                sqlQuery.setParameter(paramName, paramValue, TimestampType.INSTANCE);
            } else if (paramValue instanceof java.lang.Boolean) {
                sqlQuery.setParameter(paramName, paramValue, BooleanType.INSTANCE);
            } else if (paramValue instanceof java.lang.Float) {
                sqlQuery.setParameter(paramName, paramValue, FloatType.INSTANCE);
            } else if (paramValue instanceof java.lang.Double) {
                sqlQuery.setParameter(paramName, paramValue, DoubleType.INSTANCE);
            } else if (paramValue instanceof java.lang.Byte) {
                sqlQuery.setParameter(paramName, paramValue, ByteType.INSTANCE);
            } else if (paramValue instanceof java.util.Calendar) {
                sqlQuery.setParameter(paramName, paramValue, CalendarType.INSTANCE);
            }//from ww w.  j  a  va 2  s .c  o  m
        }
    }
}

---