1 package com.panogenesis.dao.hibernate;
2
3 import java.util.List;
4
5 import com.panogenesis.dao.LookupDAO;
6
7
8 /***
9 * Hibernate implementation of LookupDAO.
10 *
11 * <p><a href="LookupDAOHibernate.java.html"><i>View Source</i></a></p>
12 *
13 * @author <a href="mailto:matt@raibledesigns.com">Matt Raible</a>
14 */
15 public class LookupDAOHibernate extends BaseDAOHibernate implements LookupDAO {
16
17 /***
18 * @see com.panogenesis.dao.LookupDAO#getRoles()
19 */
20 public List getRoles() {
21 if (log.isDebugEnabled()) {
22 log.debug("retrieving all role names...");
23 }
24
25 return getHibernateTemplate().find("from Role order by name");
26 }
27
28
29
30
31 public List getProjectStatuses() {
32 if (log.isDebugEnabled()) {
33 log.debug("retrieving all project statuses...");
34 }
35 return getHibernateTemplate().find("from ProjectStatus order by id");
36 }
37
38
39
40
41 public List getIssueStatuses() {
42 if (log.isDebugEnabled()) {
43 log.debug("retrieving all issue statuses...");
44 }
45 return getHibernateTemplate().find("from IssueStatus order by order_list");
46 }
47
48
49
50
51 public List getIssueSeverities() {
52 if (log.isDebugEnabled()) {
53 log.debug("retrieving all issue severities...");
54 }
55 return getHibernateTemplate().find("from IssueSeverity order by list_order");
56 }
57
58
59
60
61 public List getIssueResolutions() {
62 if (log.isDebugEnabled()) {
63 log.debug("retrieving all issue resolutions...");
64 }
65 return getHibernateTemplate().find("from IssueResolution order by list_order");
66 }
67
68
69
70
71 public List getUsers() {
72 if (log.isDebugEnabled()) {
73 log.debug("retrieving all users...");
74 }
75 return getHibernateTemplate().find("from User order by last_name");
76 }
77 }