Skip to content

Instantly share code, notes, and snippets.

@xnrghzjh

xnrghzjh/gist:2816671

Created May 28, 2012 01:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save xnrghzjh/2816671 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save xnrghzjh/2816671 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. xnrghzjh revised this gist May 28, 2012. 1 changed file with 3 additions and 11 deletions.
    14 changes: 3 additions & 11 deletions gistfile1.java
    View file
    Original file line number Diff line number Diff line change
    @@ -1,21 +1,13 @@
    Criteria criteria = session.createCriteria(EmployeeMaster.class);

    criteria.add(Restrictions.eq("employeeKind", selectKind));

    if (dateFrom != null) {
    criteria.add(Restrictions.ge("enableDate", dateFrom));
    }

    if (dateTo != null) {
    criteria.add(Restrictions.lt("enableDate", dateTo));
    }

    criteria.add(Restrictions.isNotNull("employmentEndFlag"));
    criteria.addOrder(Order.asc("employeeNo"));
    criteria.addOrder(Order.asc("employeeDate"));

    List<EmployeeMaster> employeeList = criteria.list();
    if (dateFrom != null) criteria.add(Restrictions.ge("enableDate", dateFrom));
    if (dateTo != null) criteria.add(Restrictions.lt("enableDate", dateTo));

    for (EmployeeMaster employee :employeeList) {
    for (EmployeeMaster employee : criteria.list()) {
    System.out.println(employee);
    }
  2. xnrghzjh created this gist May 28, 2012.
    21 changes: 21 additions & 0 deletions gistfile1.java
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,21 @@
    Criteria criteria = session.createCriteria(EmployeeMaster.class);

    criteria.add(Restrictions.eq("employeeKind", selectKind));

    if (dateFrom != null) {
    criteria.add(Restrictions.ge("enableDate", dateFrom));
    }

    if (dateTo != null) {
    criteria.add(Restrictions.lt("enableDate", dateTo));
    }

    criteria.add(Restrictions.isNotNull("employmentEndFlag"));
    criteria.addOrder(Order.asc("employeeNo"));
    criteria.addOrder(Order.asc("employeeDate"));

    List<EmployeeMaster> employeeList = criteria.list();

    for (EmployeeMaster employee :employeeList) {
    System.out.println(employee);
    }