key words : hibernate spring dao
come from :
http://lpacec.javaeye.com/blog/46220
1. package infoweb.dao;
2.
3. import java.util.List;
4. import java.util.Iterator;
5.
6. import infoweb.pojo.Info;
7.
8. import net.sf.hibernate.HibernateException;
9. import net.sf.hibernate.Query;
10. import net.sf.hibernate.Session;
11.
12. import org.springframework.orm.hibernate.HibernateCallback;
13. import org.springframework.orm.hibernate.support.HibernateDaoSupport;
14.
15. /** *//**
16. *
Title:
17. *
Description:
18. *
Copyright: Copyright (c) 2004
19. *
Company:
20. * @author 段洪杰
21. * @version 1.0
22. */
23.
24. public class InfoDAOImpl extends HibernateDaoSupport implements IInfoDAO 
{
25. /** *//**
26. * 構造函數
27. */
28. public InfoDAOImpl() {
29. super();
30. }
31.
32. /** *//**
33. * 增加記錄
34. * @param info Info
35. */
36. public void setInfo(Info info) throws Exception {
37. getHibernateTemplate().save(info);
38. }
39.
40. /** *//**
41. * 通過ID取得記錄
42. * @param id String
43. * @return Info
44. */
45. public Info getInfoById(String id) throws Exception {
46. Info info = (Info) getHibernateTemplate().load(Info.class, id);
47. return info;
48. }
49.
50. /** *//**
51. * 修改記錄
52. * @param Info info
53. */
54. public void modifyInfo(Info info) throws Exception {
55. getHibernateTemplate().update(info);
56. }
57.
58. /** *//**
59. * 刪除記錄
60. * @param Info info
61. */
62. public void removeInfo(Info info) throws Exception {
63. getHibernateTemplate().delete(info);
64. }
65.
66. ////////////////////////////////////////////////////////
67. ///// ///
68. /////以下部份不帶審核功能 ///
69. ///// ///
70. ////////////////////////////////////////////////////////
71.
72. /** *//**
73. * 取記錄總數
74. * @return int
75. */
76. public int getInfosCount() throws Exception {
77. int count = 0;
78. String queryString = "select count(*) from Info";
79. count = ((Integer) getHibernateTemplate().iterate(queryString).next()).
80. intValue();
81. return count;
82. }
83.
84. /** *//**
85. * 取所有記錄集合
86. * @return Iterator
87. */
88. public Iterator getAllInfos() throws Exception {
89. Iterator iterator = null;
90. String queryString = " select info from Info as info order by info.id desc";
91. List list = getHibernateTemplate().find(queryString);
92. iterator = list.iterator();
93. return iterator;
94. }
95.
96. /** *//**
97. * 取記錄集合
98. * @return Iterator
99. * @param int position, int length
100. */
101. public Iterator getInfos(int position, int length) throws Exception {
102. Iterator iterator = null;
103. String queryString = " select info from Info as info order by info.id desc";
104. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
105. //設置游標的起始點
106. query.setFirstResult(position);
107. //設置游標的長度
108. query.setMaxResults(length);
109. //記錄生成
110. List list = query.list();
111. //把查詢到的結果放入迭代器
112. iterator = list.iterator();
113. return iterator;
114. }
115.
116. /** *//**
117. * 取第一條記錄
118. * @throws Exception
119. * @return Station
120. */
121. public Info getFirstInfo() throws Exception {
122. Iterator iterator = null;
123. Info info = null;
124. String queryString = "select info from Info as info order by info.id desc";
125. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
126. //記錄生成
127. List list = query.list();
128. //把查詢到的結果放入迭代器
129. iterator = list.iterator();
130. if (iterator.hasNext()) {
131. info = (Info) iterator.next();
132. }
133. return info;
134. }
135.
136. /** *//**
137. * 取最后一條記錄
138. * @throws Exception
139. * @return Station
140. */
141. public Info getLastInfo() throws Exception {
142. Iterator iterator = null;
143. Info info = null;
144. String queryString = "select info from Info as info order by info.id asc";
145. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
146. //記錄生成
147. List list = query.list();
148. //把查詢到的結果放入迭代器
149. iterator = list.iterator();
150. if (iterator.hasNext()) {
151. info = (Info) iterator.next();
152. }
153. return info;
154.
155. }
156.
157. ////////////////////////////////////////////////////////
158. ///// ///
159. ///// 以下部份表中要有特定字段才能正確運行 個人和企業 ///
160. ///// ///
161. ////////////////////////////////////////////////////////
162.
163. /** *//**
164. * 取符合條件記錄總數, [表中要有 isperson 字段]
165. * @return int
166. * @param int isPerson
167. */
168.
169. public int getInfosCountByIsperson(int isPerson) throws Exception {
170. int count = 0;
171. String queryString =
172. "select count(*) from Info as info where info.isperson =" + isPerson;
173. count = ((Integer) getHibernateTemplate().iterate(queryString).next()).
174. intValue();
175. return count;
176. }
177.
178. /** *//**
179. * 取所有符合條件記錄集合, 模糊查詢條件.[表中要有 isperson 字段]
180. * @return Iterator
181. * @param int isPerson
182. */
183.
184. public Iterator getAllInfosByIsperson(int isPerson) throws Exception {
185. Iterator iterator = null;
186. String queryString = " select info from Info as info where info.isperson =" +
187. isPerson + " order by info.id desc";
188. List list = getHibernateTemplate().find(queryString);
189. //把查詢到的結果放入迭代器
190. iterator = list.iterator();
191. return iterator;
192. }
193.
194. /** *//**
195. * 取符合條件記錄集合, 模糊查詢條件.[表中要有 isperson 字段]
196. * @return Iterator
197. * @param int isPerson,int position, int length
198. */
199.
200. public Iterator getInfosByIsperson(int isPerson, int position, int length) throws
201. Exception {
202. Iterator iterator = null;
203. String queryString = " select info from Info as info where info.isperson =" +
204. isPerson + " order by info.id desc";
205. //創建查詢
206. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
207. //設置游標的起始點
208. query.setFirstResult(position);
209. //設置游標的長度
210. query.setMaxResults(length);
211. //記錄生成
212. List list = query.list();
213. //把查詢到的結果放入迭代器
214. iterator = list.iterator();
215. return iterator;
216. }
217.
218. ////////////////////////////////////////////////////////
219. ///// ///
220. ///// 以下部份表中要有特定字段才能正確運行 查詢部份 ///
221. ///// ///
222. ///////////////////////////////////////////////////////
223. /** *//**
224. * 取符合條件記錄總數, 模糊查詢條件.[表中要有 title 字段]
225. * @return int
226. * @param String text
227. */
228. public int getInfosCount(String text) throws Exception {
229. int count = 0;
230. count = ((Integer) getHibernateTemplate().iterate(
231. "select count(*) from Info as info where info.title like '%" + text +
232. "%'").next()).intValue();
233. return count;
234. }
235.
236. /** *//**
237. * 取所有符合條件記錄集合, 模糊查詢條件.[表中要有 title 字段]
238. * @return Iterator
239. * @param String text
240. */
241.
242. public Iterator getAllInfos(String text) throws Exception {
243. Iterator iterator = null;
244. String queryString =
245. " select info from Info as info where info.title like '%" + text +
246. "%' order by info.id desc";
247. //創建查詢
248. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
249. //記錄生成
250. List list = query.list();
251. //把查詢到的結果放入迭代器
252. iterator = list.iterator();
253. return iterator;
254. }
255.
256. /** *//**
257. * 取符合條件記錄集合, 模糊查詢條件.[表中要有 title 字段]
258. * @return Iterator
259. * @param String text,int position, int length
260. */
261. public Iterator getInfos(String text, int position, int length) throws
262. Exception {
263. Iterator iterator = null;
264. String queryString =
265. " select info from Info as info where info.title like '%" + text +
266. "%' order by info.id desc";
267.
268. //創建查詢
269. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
270. //設置游標的起始點
271. query.setFirstResult(position);
272. //設置游標的長度
273. query.setMaxResults(length);
274. //記錄生成
275. List list = query.list();
276. //把查詢到的結果放入迭代器
277. iterator = list.iterator();
278. return iterator;
279. }
280.
281. ////////////////////////////////////////////////////////
282. ///// ///
283. ///// 以下部份表中要有特定字段才能正確運行 注冊相關 ///
284. ///// ///
285. ////////////////////////////////////////////////////////
286.
287. /** *//**
288. * 取符合條件記錄總數.[ 表中要有 registername 字段]
289. * @return int
290. * @param String text
291. */
292. public int getInfosCountByRegisterName(String registerName) throws Exception {
293. int count = 0;
294. count = ((Integer) getHibernateTemplate().iterate(
295. "select count(*) from Info as info where info.registername = '" +
296. registerName + "'").next()).intValue();
297. return count;
298. }
299.
300. /** *//**
301. * 通過注冊名取得一條記錄,如有多條,只取第一條.[表中要有 registername字段]
302. * @param registername String
303. * @return Info
304. */
305. public Info getInfoByRegisterName(String registerName) throws Exception {
306. Iterator iterator = null;
307. Info info = null;
308. String queryString =
309. " select info from Info as info where info.registername='" +
310. registerName + "' order by info.id desc";
311. //創建查詢
312. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
313. //記錄生成
314. List list = query.list();
315. //把查詢到的結果放入迭代器
316. iterator = list.iterator();
317. if (iterator.hasNext()) {
318. info = (Info) iterator.next();
319. }
320. return info;
321. }
322.
323. /** *//**
324. * 通過注冊名取得所有記錄集合.[表中要有 registername字段]
325. * @param registername String
326. * @return Iterator
327. */
328. public Iterator getAllInfosByRegisterName(String registerName) throws
329. Exception {
330. Iterator iterator = null;
331. String queryString =
332. " select info from Info as info where info.registername='" +
333. registerName + "' order by info.id desc";
334. //創建查詢
335. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
336. //記錄生成
337. List list = query.list();
338. //把查詢到的結果放入迭代器
339. iterator = list.iterator();
340. return iterator;
341. }
342.
343. /** *//**
344. * 通過注冊名取得記錄列表.[表中要有 registername字段]
345. * @param registername String
346. * @return Iterator
347. */
348. public Iterator getInfosByRegisterName(String registerName, int position,
349. int length) throws Exception {
350. Iterator iterator = null;
351. String queryString =
352. " select info from Info as info where info.registername='" +
353. registerName + "' order by info.id desc";
354. //創建查詢
355. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
356. //設置游標的起始點
357. query.setFirstResult(position);
358. //設置游標的長度
359. query.setMaxResults(length);
360. //記錄生成
361. List list = query.list();
362. //把查詢到的結果放入迭代器
363. iterator = list.iterator();
364. return iterator;
365. }
366.
367. ////////////////////////////////////////////////////////
368. ///// ///
369. ///// 以下部份表中要有特定字段才能正確運行 樹型版塊 ///
370. ///// ///
371. ////////////////////////////////////////////////////////
372.
373. /** *//**
374. * 取記錄總數.[ 表中要有 board_id 字段]
375. * @return int
376. * @param String boardId
377. */
378. public int getInfosCountByBoard(String boardId) throws Exception {
379. int count = 0;
380.
381. count = ((Integer) getHibernateTemplate().iterate(
382. "select count(*) from Info as info where info.boardId = '" + boardId +
383. "'").next()).intValue();
384.
385. return count;
386. }
387.
388. /** *//**
389. * 通過版塊名取得所有記錄集合.[表中要有 board_id字段]
390. * @param BoardId String
391. * @return Iterator
392. */
393. public Iterator getAllInfosByBoard(String boardId) throws Exception {
394. Iterator iterator = null;
395. String queryString = " select info from Info as info where info.boardId='" +
396. boardId + "' order by info.id desc";
397. //創建查詢
398. Query query = getHibernateTemplate().createQuery(getSession(), queryString);
399. //記錄生成
400. List list = query.list();
401. //把查詢到的結果放入迭代器
402. iterator = list.iterator();
403. return iterator;