KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > dotmarketing > portlets > webforms > factories > WebFormFactory


1 package com.dotmarketing.portlets.webforms.factories;
2
3 import java.util.ArrayList JavaDoc;
4 import java.util.List JavaDoc;
5 import java.util.Map JavaDoc;
6
7 import com.dotmarketing.db.DotConnect;
8 import com.dotmarketing.db.DotHibernate;
9 import com.dotmarketing.portlets.webforms.model.WebForm;
10 import com.dotmarketing.util.UtilMethods;
11
12 public class WebFormFactory {
13     public static List JavaDoc<WebForm> getWebFormsByType (String JavaDoc formType) {
14         String JavaDoc query = "select {web_form.*} from web_form where form_type = ?";
15         DotHibernate dh = new DotHibernate (WebForm.class);
16         dh.setSQLQuery(query);
17         dh.setParam(formType);
18         List JavaDoc<WebForm> list = dh.list();
19         return list;
20     }
21     
22     public static List JavaDoc<WebForm> getWebFormsWithOutType () {
23         String JavaDoc query = "select {web_form.*} from web_form where form_type is null or form_type = ''";
24         DotHibernate dh = new DotHibernate (WebForm.class);
25         dh.setSQLQuery(query);
26         List JavaDoc<WebForm> list = dh.list();
27         return list;
28     }
29     
30     public static void removeWebFormsByType (String JavaDoc formType) {
31         String JavaDoc query = "delete from web_form where form_type = ?";
32         DotConnect dc = new DotConnect ();
33         dc.setSQL(query);
34         dc.addParam(formType);
35         dc.getResult();
36     }
37     
38     public static void removeWebFormsWithoutType () {
39         String JavaDoc query = "delete from web_form where form_type is null or form_type = ''";
40         DotConnect dc = new DotConnect ();
41         dc.setSQL(query);
42         dc.getResult();
43     }
44     
45     public static String JavaDoc[] getWebFormsTypes () {
46         String JavaDoc query = "select distinct(form_type) as form_type from web_form";
47         DotConnect dc = new DotConnect ();
48         dc.setSQL(query);
49         List JavaDoc<Map JavaDoc> results = dc.getResults();
50         List JavaDoc<String JavaDoc> typesList = new ArrayList JavaDoc<String JavaDoc> ();
51         for (Map JavaDoc result : results) {
52             if (UtilMethods.isSet((String JavaDoc)result.get("form_type"))) {
53                 typesList.add((String JavaDoc)result.get("form_type"));
54             }
55         }
56         return typesList.toArray(new String JavaDoc[0]);
57     }
58 }
59
Popular Tags