|
1
2
23 package com.geinuke.dao;
24
25 import java.util.ArrayList  ;
26 import java.util.List ;
27
28 import com.geinuke.vo.WikiArticleVO;
29 import com.geinuke.vo.WikiFileVO;
30 import com.geinuke.vo.WikiMenuVO;
31
32 public class WikiDAO extends GeiDAO{
33
34
35 public WikiDAO() throws Exception {
36 super();
37
38 }
39
40 public WikiArticleVO getWikiArticleByName(String name) throws Exception {
41 WikiArticleVO res=null;
42 try{
43 this.sqlMap().startTransaction();
44 res=(WikiArticleVO)this.sqlMap().queryForObject("getWikiArticleByName",name);
45 this.sqlMap().commitTransaction();
46 }finally{
47 this.sqlMap().endTransaction();
48 }
49 return res;
50 }
51
52 public WikiArticleVO getWikiArticleById(int id) throws Exception {
53 WikiArticleVO res=null;
54 try{
55 this.sqlMap().startTransaction();
56 res=(WikiArticleVO)this.sqlMap().queryForObject("getWikiArticleById",new Integer (id));
57 this.sqlMap().commitTransaction();
58 }finally{
59 this.sqlMap().endTransaction();
60 }
61 return res;
62 }
63
64 public List getWikiFilesByWAID(int waid)throws Exception {
65 List list=null;
66 try{
67 this.sqlMap().startTransaction();
68 list=this.sqlMap().queryForList("getWikiFilesByWAID",new Integer (waid));
69 this.sqlMap().commitTransaction();
70 }finally{
71 this.sqlMap().endTransaction();
72 }
73 return list;
74
75 }
76
77 public ArrayList getAllWikiArticles()throws Exception {
78 ArrayList ll=null;
79 List list=null;
80 try{
81 this.sqlMap().startTransaction();
82 list=this.sqlMap().queryForList("getAllWikiArticles",null);
83 this.sqlMap().commitTransaction();
84 }finally{
85 this.sqlMap().endTransaction();
86 }
87 return new ArrayList (list);
88
89 }
90
91 public ArrayList getWikiArticlesByText(String words)throws Exception {
92 ArrayList ll=null;
93 List list=null;
94 words="%"+words+"%";
95 try{
96 this.sqlMap().startTransaction();
97 list=this.sqlMap().queryForList("getWikiArticlesByText",words);
98 this.sqlMap().commitTransaction();
99 }finally{
100 this.sqlMap().endTransaction();
101 }
102 return new ArrayList (list);
103
104 }
105
106 public ArrayList getWikiArticlesByName(String words)throws Exception {
107 ArrayList ll=null;
108 List list=null;
109 words="%"+words+"%";
110 try{
111 this.sqlMap().startTransaction();
112 list=this.sqlMap().queryForList("getWikiArticlesByName",words);
113 this.sqlMap().commitTransaction();
114 }finally{
115 this.sqlMap().endTransaction();
116 }
117 return new ArrayList (list);
118
119 }
120
121 public ArrayList getWikiArticlesByNameOrText(String words)throws Exception {
122 ArrayList ll=null;
123 List list=null;
124 words="%"+words+"%";
125 try{
126 this.sqlMap().startTransaction();
127 list=this.sqlMap().queryForList("getWikiArticlesByNameOrText",words);
128 this.sqlMap().commitTransaction();
129 }finally{
130 this.sqlMap().endTransaction();
131 }
132 return new ArrayList (list);
133
134 }
135
136 public WikiFileVO getWikiFileByWFID(int wfid)throws Exception {
137 WikiFileVO wf=null;
138 try{
139 this.sqlMap().startTransaction();
140 wf=(WikiFileVO)this.sqlMap().queryForObject("getWikiFileByWFID",new Integer (wfid));
141 this.sqlMap().commitTransaction();
142 }finally{
143 this.sqlMap().endTransaction();
144 }
145 return wf;
146
147 }
148
149 public void insertWikiArticle(WikiArticleVO t) throws Exception {
150
151 try{
152 this.sqlMap().startTransaction();
153 this.sqlMap().insert("insWikiArticle",t);
154 this.sqlMap().commitTransaction();
155 }finally{
156 this.sqlMap().endTransaction();
157 }
158
159 }
160
161 public void insertWikiFile(WikiFileVO f) throws Exception {
162
163 try{
164 this.sqlMap().startTransaction();
165 this.sqlMap().insert("insWikiFile",f);
166 this.sqlMap().commitTransaction();
167 }finally{
168 this.sqlMap().endTransaction();
169 }
170
171 }
172
173 public void deleteWikiFileByWFID(int id) throws Exception {
174
175 try{
176 this.sqlMap().startTransaction();
177 this.sqlMap().delete("deleteWikiFileByWFID",new Integer (id));
178 this.sqlMap().commitTransaction();
179 }finally{
180 this.sqlMap().endTransaction();
181 }
182
183 }
184
185 public void deleteWikiArticleByWAID(int id) throws Exception {
186
187 try{
188 this.sqlMap().startTransaction();
189 this.sqlMap().delete("deleteWikiArticleByWAID",new Integer (id));
190 this.sqlMap().commitTransaction();
191 }finally{
192 this.sqlMap().endTransaction();
193 }
194
195 }
196
197 public void updateWikiArticle(WikiArticleVO wa) throws Exception {
198
199 try{
200 this.sqlMap().startTransaction();
201 this.sqlMap().update("updateWikiArticle",wa);
202 this.sqlMap().commitTransaction();
203 }finally{
204 this.sqlMap().endTransaction();
205 }
206
207 }
208
209 public void updateWikiMenu(WikiMenuVO wm) throws Exception {
210
211 try{
212 this.sqlMap().startTransaction();
213 this.sqlMap().update("updateWikiMenu",wm);
214 this.sqlMap().commitTransaction();
215 }finally{
216 this.sqlMap().endTransaction();
217 }
218
219 }
220
221 public WikiMenuVO getWikiMenu() throws Exception {
222 WikiMenuVO res=null;
223 try{
224 this.sqlMap().startTransaction();
225 res=(WikiMenuVO)this.sqlMap().queryForObject("getWikiMenu","");
226 this.sqlMap().commitTransaction();
227 }finally{
228 this.sqlMap().endTransaction();
229 }
230 return res;
231 }
232 }
233 |
Popular Tags |
Java API By Example, From Geeks To Geeks.