infoweb.
java.
.
java.
.
infoweb.
.
net.
.
.
net.
.
.
net.
.
.
org.
.
.
.
org.
.
.
.
.
28 /**
29 * 构造函数
30 */ 
31 public InfoDAOImpl
() {
...}
32 super();
33 }
34 35 36 /**
37 * 增加记录
38 * @param info Info
39 */ 40 public void setInfo
(Info info
) throws Exception {
...}
41 getHibernateTemplate().save(info);
42 }
43 44 45 /**
46 * 通过ID取得记录
47 * @param id String
48 * @return Info
49 */ 50 public Info getInfoById
(String id
) throws Exception {
...}
51 Info info = (Info) getHibernateTemplate().load(Info.class, id);
52 return info;
53 }
54 55 56 /**
57 * 修改记录
58 * @param Info info
59 */ 60 public void modifyInfo
(Info info
) throws Exception {
...}
61 getHibernateTemplate().update(info);
62 }
63 64 65 /**
66 * 删除记录
67 * @param Info info
68 */ 69 public void removeInfo
(Info info
) throws Exception {
...}
70 getHibernateTemplate().delete(info);
71 }
72 73 74 //////////////////////////////////////////////////////// 75 ///// /// 76 /////以下部份不带审核功Ä軤 /// 77 ///// /// 78 //////////////////////////////////////////////////////// 79 80 /**
81 * 取记录总数
82 * @return int
83 */ 84 public int getInfosCount
() throws Exception {
...}
85 int count = 0;
86 String queryString = "select count(*) from Info";
87 count = ((Integer) getHibernateTemplate().iterate(queryString).next()).
88 intValue();
89 return count;
90 }
91 92 93 /**
94 * 取所有记录集合
95 * @return Iterator
96 */ 97 public Iterator getAllInfos
() throws Exception {
...}
98 Iterator iterator = null;
99 String queryString = " select info from Info as info order by info.id desc";
100 List list = getHibernateTemplate().find(queryString);
101 iterator = list.iterator();
102 return iterator;
103 }
104 105 106 /**
107 * 取记录集合
108 * @return Iterator
109 * @param int position, int length
110 */ 111 public Iterator getInfos
(int position,
int length
) throws Exception {
...}
112 Iterator iterator = null;
113 String queryString = " select info from Info as info order by info.id desc";
114 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
115 //设置游标的起始点
116 query.setFirstResult(position);
117 //设置游标的长度
118 query.setMaxResults(length);
119 //记录生成
120 List list = query.list();
121 //把查询到的结果放入迭代器
122 iterator = list.iterator();
123 return iterator;
124 }
125 126 127 /**
128 * 取第一条记录
129 * @throws Exception
130 * @return Station
131 */ 132 public Info getFirstInfo
() throws Exception {
...}
133 Iterator iterator =
null;
134 Info info =
null;
135 String queryString = "select info from Info as info order by info.
id desc";
136 Query query = getHibernateTemplate
().
createQuery(getSession
(), queryString
);
137 //记录生成 138 List list = query.
list();
139 //把查询到的结果放入迭代器 140 iterator = list.
iterator();
141 if (iterator.
hasNext()) {
...}
142 info = (Info) iterator.next();
143 }
144 return info;
145 } 146 147 148 /**
149 * 取最后一条记录
150 * @throws Exception
151 * @return Station
152 */ 153 public Info getLastInfo
() throws Exception {
...}
154 Iterator iterator =
null;
155 Info info =
null;
156 String queryString = "select info from Info as info order by info.
id asc";
157 Query query = getHibernateTemplate
().
createQuery(getSession
(), queryString
);
158 //记录生成 159 List list = query.
list();
160 //把查询到的结果放入迭代器 161 iterator = list.
iterator();
162 if (iterator.
hasNext()) {
...}
163 info = (Info) iterator.next();
164 }
165 return info;
166 167 } 168 169 170 //////////////////////////////////////////////////////// 171 ///// /// 172 ///// 以下部份表中要有特定字段才能Õ吩诵袪 牳鋈撕推笠禒 /// 173 ///// /// 174 //////////////////////////////////////////////////////// 175 176 /**
177 * 取符合条件记录总数, [表中要有 isperson 字段]
178 * @return int
179 * @param int isPerson
180 */ 181 182 public int getInfosCountByIsperson
(int isPerson
) throws Exception {
...}
183 int count = 0;
184 String queryString =
185 "select count(*) from Info as info where info.isperson =" + isPerson;
186 count = ((Integer) getHibernateTemplate().iterate(queryString).next()).
187 intValue();
188 return count;
189 }
190 191 192 /**
193 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]
194 * @return Iterator
195 * @param int isPerson
196 */ 197 198 public Iterator getAllInfosByIsperson
(int isPerson
) throws Exception {
...}
199 Iterator iterator = null;
200 String queryString = " select info from Info as info where info.isperson =" +
201 isPerson + " order by info.id desc";
202 List list = getHibernateTemplate().find(queryString);
203 //把查询到的结果放入迭代器
204 iterator = list.iterator();
205 return iterator;
206 }
207 208 209 /**
210 * 取符合条件记录集合, 模糊查询条件.[表中要有 isperson 字段]
211 * @return Iterator
212 * @param int isPerson,int position, int length
213 */ 214 215 public Iterator getInfosByIsperson
(int isPerson,
int position,
int length
) throws 216 Exception {
...}
217 Iterator iterator = null;
218 String queryString = " select info from Info as info where info.isperson =" +
219 isPerson + " order by info.id desc";
220 //创建查询
221 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
222 //设置游标的起始点
223 query.setFirstResult(position);
224 //设置游标的长度
225 query.setMaxResults(length);
226 //记录生成
227 List list = query.list();
228 //把查询到的结果放入迭代器
229 iterator = list.iterator();
230 return iterator;
231 }
232 233 234 //////////////////////////////////////////////////////// 235 ///// /// 236 ///// 以下部份表中要有特定字段才能Õ吩诵袪 查询部份 /// 237 ///// /// 238 /////////////////////////////////////////////////////// 239 /**
240 * 取符合条件记录总数, 模糊查询条件.[表中要有 title 字段]
241 * @return int
242 * @param String text
243 */ 244 public int getInfosCount
(String text
) throws Exception {
...}
245 int count = 0;
246 count = ((Integer) getHibernateTemplate().iterate(
247 "select count(*) from Info as info where info.title like '%" + text +
248 "%'").next()).intValue();
249 return count;
250 }
251 252 253 /**
254 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
255 * @return Iterator
256 * @param String text
257 */ 258 259 public Iterator getAllInfos
(String text
) throws Exception {
...}
260 Iterator iterator = null;
261 String queryString =
262 " select info from Info as info where info.title like '%" + text +
263 "%' order by info.id desc";
264 //创建查询
265 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
266 //记录生成
267 List list = query.list();
268 //把查询到的结果放入迭代器
269 iterator = list.iterator();
270 return iterator;
271 }
272 273 274 /**
275 * 取符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
276 * @return Iterator
277 * @param String text,int position, int length
278 */ 279 public Iterator getInfos
(String text,
int position,
int length
) throws 280 Exception {
...}
281 Iterator iterator = null;
282 String queryString =
283 " select info from Info as info where info.title like '%" + text +
284 "%' order by info.id desc";
285
286 //创建查询
287 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
288 //设置游标的起始点
289 query.setFirstResult(position);
290 //设置游标的长度
291 query.setMaxResults(length);
292 //记录生成
293 List list = query.list();
294 //把查询到的结果放入迭代器
295 iterator = list.iterator();
296 return iterator;
297 }
298 299 300 //////////////////////////////////////////////////////// 301 ///// /// 302 ///// 以下部份表中要有特定字段才能Õ吩诵袪 犠⒉嵯喙貭 /// 303 ///// /// 304 //////////////////////////////////////////////////////// 305 306 /**
307 * 取符合条件记录总数.[ 表中要有 registername 字段]
308 * @return int
309 * @param String text
310 */ 311 public int getInfosCountByRegisterName
(String registerName
) throws Exception {
...}
312 int count = 0;
313 count = ((Integer) getHibernateTemplate().iterate(
314 "select count(*) from Info as info where info.registername = '" +
315 registerName + "'").next()).intValue();
316 return count;
317 }
318 319 320 /**
321 * 通过注册名取得一条记录,如有多条,只取第一条.[表中要有 registername字段]
322 * @param registername String
323 * @return Info
324 */ 325 public Info getInfoByRegisterName
(String registerName
) throws Exception {
...}
326 Iterator iterator =
null;
327 Info info =
null;
328 String queryString =
329 " select info from Info as info where info.
registername=
'" +
330 registerName + "' order by info.
id desc";
331 //创建查询 332 Query query = getHibernateTemplate
().
createQuery(getSession
(), queryString
);
333 //记录生成 334 List list = query.
list();
335 //把查询到的结果放入迭代器 336 iterator = list.
iterator();
337 if (iterator.
hasNext()) {
...}
338 info = (Info) iterator.next();
339 }
340 return info;
341 } 342 343 344 /**
345 * 通过注册名取得所有记录集合.[表中要有 registername字段]
346 * @param registername String
347 * @return Iterator
348 */ 349 public Iterator getAllInfosByRegisterName
(String registerName
) throws 350 Exception {
...}
351 Iterator iterator = null;
352 String queryString =
353 " select info from Info as info where info.registername='" +
354 registerName + "' order by info.id desc";
355 //创建查询
356 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
357 //记录生成
358 List list = query.list();
359 //把查询到的结果放入迭代器
360 iterator = list.iterator();
361 return iterator;
362 }
363 364 365 /**
366 * 通过注册名取得记录列表.[表中要有 registername字段]
367 * @param registername String
368 * @return Iterator
369 */ 370 public Iterator getInfosByRegisterName
(String registerName,
int position,
371 int length
) throws Exception {
...}
372 Iterator iterator = null;
373 String queryString =
374 " select info from Info as info where info.registername='" +
375 registerName + "' order by info.id desc";
376 //创建查询
377 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
378 //设置游标的起始点
379 query.setFirstResult(position);
380 //设置游标的长度
381 query.setMaxResults(length);
382 //记录生成
383 List list = query.list();
384 //把查询到的结果放入迭代器
385 iterator = list.iterator();
386 return iterator;
387 }
388 389 390 //////////////////////////////////////////////////////// 391 ///// /// 392 ///// 以下部份表中要有特定字段才能Õ吩诵袪 犑餍桶婵闋 /// 393 ///// /// 394 //////////////////////////////////////////////////////// 395 396 /**
397 * 取记录总数.[ 表中要有 board_id 字段]
398 * @return int
399 * @param String boardId
400 */ 401 public int getInfosCountByBoard
(String boardId
) throws Exception {
...}
402 int count = 0;
403
404 count = ((Integer) getHibernateTemplate().iterate(
405 "select count(*) from Info as info where info.boardId = '" + boardId +
406 "'").next()).intValue();
407
408 return count;
409 }
410 411 412 /**
413 * 通过版块名取得所有记录集合.[表中要有 board_id字段]
414 * @param BoardId String
415 * @return Iterator
416 */ 417 public Iterator getAllInfosByBoard
(String boardId
) throws Exception {
...}
418 Iterator iterator = null;
419 String queryString = " select info from Info as info where info.boardId='" +
420 boardId + "' order by info.id desc";
421 //创建查询
422 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
423 //记录生成
424 List list = query.list();
425 //把查询到的结果放入迭代器
426 iterator = list.iterator();
427 return iterator;
428 }
429 430 431 /**
432 * 通过版块名取得记录列表.[表中要有 board_id字段]
433 * @param BoardId String
434 * @return Iterator
435 */ 436 public Iterator getInfosByBoard
(String boardId,
int position,
int length
) throws 437 Exception {
...}
438 Iterator iterator = null;
439 String queryString = " select info from Info as info where info.boardId='" +
440 boardId + "' order by info.id desc";
441
442 //创建查询
443 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
444 //设置游标的起始点
445 query.setFirstResult(position);
446 //设置游标的长度
447 query.setMaxResults(length);
448 //记录生成
449 List list = query.list();
450 //把查询到的结果放入迭代器
451 iterator = list.iterator();
452
453 return iterator;
454
455 }
456 457 458 /**
459 * 取符合条件记录总数.[ 表中要有 board_id 字段,title] 模糊查询title
460 * @return int
461 * @param String boardId ,String text
462 */ 463 public int getInfosCountByBoard
(String boardId,
String text
) throws Exception {
...}
464 int count = 0;
465
466 count = ((Integer) getHibernateTemplate().iterate(
467 "select count(*) from Info as info where info.boardId='" + boardId +
468 "' and info.title like '%" + text + "%'").next()).intValue();
469
470 return count;
471
472 }
473 474 475 /**
476 * 通过版块名取得记录列表.[表中要有 board_id字段] 模糊查询title
477 * @param String boardID,int position, int length
478 * @return Iterator
479 */ 480 public Iterator getInfosByBoard
(String boardId,
int position,
int length,
481 String text
) throws Exception {
...}
482 Iterator iterator = null;
483 String queryString = " select info from Info as info where info.boardId='" +
484 boardId + "' and info.title like '%" + text +
485 "%' order by info.id desc";
486
487 //创建查询
488 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
489 //设置游标的起始点
490 query.setFirstResult(position);
491 //设置游标的长度
492 query.setMaxResults(length);
493 //记录生成
494 List list = query.list();
495 //把查询到的结果放入迭代器
496 iterator = list.iterator();
497 return iterator;
498
499 }
500 501 502 //////////////////////////////////////////////////////// 503 ///// /// 504 /////以下部份带有审核功Ä軤 /// 505 ///// /// 506 //////////////////////////////////////////////////////// 507 508 /**
509 * 取记录总数
510 * @return int
511 * @param int isAuditing
512 */ 513 public int getInfosCount
(int isAuditing
) throws Exception {
...}
514 int count = 0;
515
516 count = ((Integer) getHibernateTemplate().iterate(
517 "select count(*) from Info as info where info.isauditing=" +
518 isAuditing).next()).intValue();
519 return count;
520 }
521 522 523 /**
524 * 取所有记录集合
525 * @return Iterator
526 * @param int position, int length,int isAuditing
527 */ 528 public Iterator getAllInfos
(int isAuditing
) throws Exception {
...}
529 Iterator iterator = null;
530 String queryString =
531 " select info from Info as info where info.isauditing=" + isAuditing +
532 " order by info.id desc";
533 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
534 //记录生成
535 List list = query.list();
536 //把查询到的结果放入迭代器
537 iterator = list.iterator();
538 return iterator;
539 }
540 541 542 /**
543 * 取记录集合
544 * @return Iterator
545 * @param int position, int length,int isAuditing
546 */ 547 public Iterator getInfos
(int position,
int length,
int isAuditing
) throws 548 Exception {
...}
549 Iterator iterator = null;
550 String queryString =
551 " select info from Info as info where info.isauditing=" + isAuditing +
552 " order by info.id desc";
553
554 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
555 //设置游标的起始点
556 query.setFirstResult(position);
557 //设置游标的长度
558 query.setMaxResults(length);
559 //记录生成
560 List list = query.list();
561 //把查询到的结果放入迭代器
562 iterator = list.iterator();
563
564 return iterator;
565 }
566 567 568 //////////////////////////////////////////////////////////////// 569 ///// /// 570 ///// 以下部份表中要有特定字段才能Õ吩诵Ð 有审核功Ä軤 个人和Æ笠禒 /// 571 ///// /// 572 /////////////////////////////////////////////////////////////// 573 574 /**
575 * 取符合条件记录总数, [表中要有 isperson isAuditing 字段]
576 * @return int
577 * @param int isPerson,int isAuditing
578 */ 579 580 public int getInfosCountByIsperson
(int isPerson,
int isAuditing
) throws 581 Exception {
...}
582 int count = 0;
583
584 count = ((Integer) getHibernateTemplate().iterate(
585 "select count(*) from Info as info where info.isperson =" + isPerson +
586 " and info.isauditing=" + isAuditing).next()).intValue();
587
588 return count;
589 }
590 591 592 /**
593 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 isperson isAuditing 字段]
594 * @return Iterator
595 * @param int isPerson,int isAuditing
596 */ 597 598 public Iterator getAllInfosByIsperson
(int isPerson,
int isAuditing
) throws 599 Exception {
...}
600 Iterator iterator = null;
601 String queryString = " select info from Info as info where info.isperson =" +
602 isPerson + " and info.isauditing=" + isAuditing +
603 " order by info.id desc";
604
605 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
606 //记录生成
607 List list = query.list();
608 //把查询到的结果放入迭代器
609 iterator = list.iterator();
610
611 return iterator;
612 }
613 614 615 /**
616 * 取符合条件记录集合, 模糊查询条件.[表中要有 isperson isAuditing 字段]
617 * @return Iterator
618 * @param int isPerson,int position, int length,int isAuditing
619 */ 620 621 public Iterator getInfosByIsperson
(int isPerson,
int position,
int length,
622 int isAuditing
) throws Exception {
...}
623 Iterator iterator = null;
624 String queryString = " select info from Info as info where info.isperson =" +
625 isPerson + " and info.isauditing=" + isAuditing +
626 " order by info.id desc";
627
628 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
629 //设置游标的起始点
630 query.setFirstResult(position);
631 //设置游标的长度
632 query.setMaxResults(length);
633 //记录生成
634 List list = query.list();
635 //把查询到的结果放入迭代器
636 iterator = list.iterator();
637
638 return iterator;
639
640 }
641 642 643 //////////////////////////////////////////////////////// 644 ///// /// 645 ///// 要有特定字段才能Õ吩诵袪 有审核功Ä軤 查询部份 /// 646 ///// /// 647 /////////////////////////////////////////////////////// 648 /**
649 * 取符合条件记录总数, 模糊查询条件.[表中要有 title 字段]
650 * @return int
651 * @param String text,int isAuditing
652 */ 653 public int getInfosCount
(String text,
int isAuditing
) throws Exception {
...}
654 int count = 0;
655
656 count = ((Integer) getHibernateTemplate().iterate(
657 "select count(*) from Info as info where info.isauditing=" +
658 isAuditing + " and info.title like '%" + text + "%'").next()).
659 intValue();
660
661 return count;
662 }
663 664 665 /**
666 * 取所有符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
667 * @return Iterator
668 * @param String text,int isAuditing
669 */ 670 671 public Iterator getAllInfos
(String text,
int isAuditing
) throws Exception {
...}
672 Iterator iterator = null;
673 String queryString =
674 " select info from Info as info where info.isauditing=" + isAuditing +
675 " and info.title like '%" + text + "%' order by info.id desc";
676
677 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
678 //记录生成
679 List list = query.list();
680 //把查询到的结果放入迭代器
681 iterator = list.iterator();
682
683 return iterator;
684 }
685 686 687 /**
688 * 取符合条件记录集合, 模糊查询条件.[表中要有 title 字段]
689 * @return Iterator
690 * @param String text,int position, int length,int isAuditing
691 */ 692 public Iterator getInfos
(String text,
int position,
int length,
693 int isAuditing
) throws Exception {
...}
694 Iterator iterator = null;
695 String queryString =
696 " select info from Info as info where info.isauditing=" + isAuditing +
697 " and info.title like '%" + text + "%' order by info.id desc";
698
699 //创建查询
700 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
701 //设置游标的起始点
702 query.setFirstResult(position);
703 //设置游标的长度
704 query.setMaxResults(length);
705 //记录生成
706 List list = query.list();
707 //把查询到的结果放入迭代器
708 iterator = list.iterator();
709
710 return iterator;
711 }
712 713 714 //////////////////////////////////////////////////////// 715 ///// /// 716 ///// 要有特定字段才能Õ吩诵袪 有审核功Ä軤 注册相关 /// 717 ///// /// 718 //////////////////////////////////////////////////////// 719 720 /**
721 * 取符合条件记录总数.[ 表中要有 registername isauditing字段]
722 * @return int
723 * @param String text,int isAuditing
724 */ 725 public int getInfosCountByRegisterName
(String registerName,
int isAuditing
) throws 726 Exception {
...}
727 int count = 0;
728
729 count = ((Integer) getHibernateTemplate().iterate(
730 "select count(*) from Info as info where info.isauditing=" +
731 isAuditing + " and info.registername = '" + registerName + "'").next()).
732 intValue();
733
734 return count;
735 }
736 737 738 /**
739 * 通过注册名取得一条记录,如有多条,只取第一条.[表中要有 registername isauditing字段]
740 * @param registername String,int isAuditing
741 * @return Info
742 */ 743 public Info getInfoByRegisterName
(String registerName,
int isAuditing
) throws 744 Exception {
...}
745 Iterator iterator =
null;
746 Info info =
null;
747 748 String queryString =
749 " select info from Info as info where info.
isauditing=" + isAuditing +
750 " and info.
registername=
'" + registerName + "' order by info.
id desc";
751 752 Query query = getHibernateTemplate
().
createQuery(getSession
(), queryString
);
753 //记录生成 754 List list = query.
list();
755 //把查询到的结果放入迭代器 756 iterator = list.
iterator();
757 if (iterator.
hasNext()) {
...}
758 info = (Info) iterator.next();
759 }
760 761 return info;
762 } 763 764 765 /**
766 * 通过注册名取得所有记录集合.[表中要有 registername isauditing字段]
767 * @param registername String,int isAuditing
768 * @return Iterator
769 */ 770 public Iterator getAllInfosByRegisterName
(String registerName,
int isAuditing
) throws 771 Exception {
...}
772 Iterator iterator = null;
773
774 String queryString =
775 " select info from Info as info where info.isauditing=" + isAuditing +
776 " and info.registername='" + registerName + "' order by info.id desc";
777
778 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
779 //记录生成
780 List list = query.list();
781 //把查询到的结果放入迭代器
782 iterator = list.iterator();
783
784 return iterator;
785 }
786 787 788 /**
789 * 通过注册名取得记录列表.[表中要有 registername isauditing字段]
790 * @param registername String,int isAuditing
791 * @return Iterator
792 */ 793 public Iterator getInfosByRegisterName
(String registerName,
int position,
794 int length,
int isAuditing
) throws 795 Exception {
...}
796 Iterator iterator = null;
797 String queryString =
798 " select info from Info as info where info.isauditing=" + isAuditing +
799 " and info.registername='" + registerName + "' order by info.id desc";
800
801 //创建查询
802 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
803 //设置游标的起始点
804 query.setFirstResult(position);
805 //设置游标的长度
806 query.setMaxResults(length);
807 //记录生成
808 List list = query.list();
809 //把查询到的结果放入迭代器
810 iterator = list.iterator();
811
812 return iterator;
813 }
814 815 816 //////////////////////////////////////////////////////// 817 ///// /// 818 ///// 要有特定字段才能Õ吩诵袪 有审核功能 树型版块 /// 819 ///// /// 820 //////////////////////////////////////////////////////// 821 822 /**
823 * 取记录总数.[ 表中要有 board_id isauditing字段]
824 * @return int
825 * @param String boardId,int isAuditing
826 */ 827 public int getInfosCountByBoard
(String boardId,
int isAuditing
) throws 828 Exception {
...}
829 int count = 0;
830
831 count = ((Integer) getHibernateTemplate().iterate(
832 "select count(*) from Info as info where info.isauditing=" +
833 isAuditing + " and info.boardId = '" + boardId + "'").next()).intValue();
834
835 return count;
836 }
837 838 839 /**
840 * 通过版块名取得所有记录集合.[表中要有 board_id isauditing字段]
841 * @param BoardId String,int isAuditing
842 * @return Iterator
843 */ 844 public Iterator getAllInfosByBoard
(String boardId,
int isAuditing
) throws 845 Exception {
...}
846 Iterator iterator = null;
847
848 String queryString =
849 " select info from Info as info where info.isauditing=" + isAuditing +
850 " and info.boardId='" + boardId + "' order by info.id desc";
851
852 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
853 //记录生成
854 List list = query.list();
855 //把查询到的结果放入迭代器
856 iterator = list.iterator();
857 return iterator;
858 }
859 860 861 /**
862 * 通过版块名取得记录列表.[表中要有 board_id isauditing字段]
863 * @param BoardId String,int isAuditing
864 * @return Iterator
865 */ 866 public Iterator getInfosByBoard
(String boardId,
int position,
int length,
867 int isAuditing
) throws Exception {
...}
868 Iterator iterator = null;
869 String queryString =
870 " select info from Info as info where info.isauditing=" + isAuditing +
871 " and info.boardId='" + boardId + "' order by info.id desc";
872
873 //创建查询
874 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
875 //设置游标的起始点
876 query.setFirstResult(position);
877 //设置游标的长度
878 query.setMaxResults(length);
879 //记录生成
880 List list = query.list();
881 //把查询到的结果放入迭代器
882 iterator = list.iterator();
883
884 return iterator;
885
886 }
887 888 889 /**
890 * 取符合条件记录总数.[ 表中要有 board_id isauditing字段,title] 模糊查询title
891 * @return int
892 * @param String boardId ,String text,int isAuditing
893 */ 894 public int getInfosCountByBoard
(String boardId,
String text,
int isAuditing
) throws 895 Exception {
...}
896 int count = 0;
897
898 count = ((Integer) getHibernateTemplate().iterate(
899 "select count(*) from Info as info where info.isauditing=" +
900 isAuditing + " and info.boardId='" + boardId +
901 "' and info.title like '%" +
902 text + "%'").next()).intValue();
903
904 return count;
905
906 }
907 908 909 /**
910 * 通过版块名取得记录列表.[表中要有 board_id字段 isauditing] 模糊查询title
911 * @param String boardId,int position, int length,int isAuditing
912 * @return Iterator
913 */ 914 public Iterator getInfosByBoard
(String boardId,
int position,
int length,
915 String text,
int isAuditing
) throws Exception {
...}
916 Iterator iterator = null;
917 String queryString =
918 " select info from Info as info where info.isauditing=" + isAuditing +
919 " and info.boardId='" + boardId + "' and info.title like '%" + text +
920 "%' order by info.id desc";
921
922 //创建查询
923 Query query = getHibernateTemplate().createQuery(getSession(), queryString);
924 //设置游标的起始点
925 query.setFirstResult(position);
926 //设置游标的长度
927 query.setMaxResults(length);
928 //记录生成
929 List list = query.list();
930 //把查询到的结果放入迭代器
931 iterator = list.iterator();
932
933 return iterator;
934
935 }
936 937 938 } 
本类阅读TOP10