KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > geinuke > dao > UploadFileDAO


1
2
3  /*
4  -- GeiNuke --
5 Copyright (c) 2005 by Roberto Sidoti [geinuke@users.sourceforge.net]
6  http://www.hostingjava.it/-geinuke/
7
8 This file is part of GeiNuke.
9
10     GeiNuke is free software; you can redistribute it and/or modify
11     it under the terms of the GNU General Public License as published by
12     the Free Software Foundation; either version 2 of the License, or
13     (at your option) any later version.
14
15     GeiNuke is distributed in the hope that it will be useful,
16     but WITHOUT ANY WARRANTY; without even the implied warranty of
17     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18     GNU General Public License for more details.
19
20     You should have received a copy of the GNU General Public License
21     along with GeiNuke; if not, write to the Free Software
22     Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
23 */
24 package com.geinuke.dao;
25
26 import java.util.List JavaDoc;
27
28 import com.geinuke.vo.UploadFileVO;
29
30 public class UploadFileDAO extends GeiDAO{
31
32     
33     public UploadFileDAO() throws Exception JavaDoc {
34         super();
35         
36     }
37     
38     
39     public List JavaDoc getUploadFilesByUID(int waid)throws Exception JavaDoc{
40         List JavaDoc list=null;
41         try{
42             this.sqlMap().startTransaction();
43             list=this.sqlMap().queryForList("getUploadFilesByUID",new Integer JavaDoc(waid));
44             this.sqlMap().commitTransaction();
45         }finally{
46             this.sqlMap().endTransaction();
47         }
48         return list;
49         
50     }
51     
52     
53     
54     public UploadFileVO getUploadFileByUFID(int ufid)throws Exception JavaDoc{
55         UploadFileVO wf=null;
56         try{
57             this.sqlMap().startTransaction();
58             wf=(UploadFileVO)this.sqlMap().queryForObject("getUploadFileByUFID",new Integer JavaDoc(ufid));
59             this.sqlMap().commitTransaction();
60         }finally{
61             this.sqlMap().endTransaction();
62         }
63         return wf;
64         
65     }
66     
67     
68     
69     public void insertUploadFile(UploadFileVO f) throws Exception JavaDoc{
70         
71         try{
72             this.sqlMap().startTransaction();
73             this.sqlMap().insert("insUploadFile",f);
74             this.sqlMap().commitTransaction();
75         }finally{
76             this.sqlMap().endTransaction();
77         }
78         
79     }
80     
81     public void deleteUploadFileByUFID(int id) throws Exception JavaDoc{
82         
83         try{
84             this.sqlMap().startTransaction();
85             this.sqlMap().delete("deleteUploadFileByUFID",new Integer JavaDoc(id));
86             this.sqlMap().commitTransaction();
87         }finally{
88             this.sqlMap().endTransaction();
89         }
90         
91     }
92     
93         
94 }
95
96
Popular Tags