1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 package fr.paris.lutece.plugins.folderlisting.business.portlet;
35
36 import fr.paris.lutece.portal.business.portlet.IPortletInterfaceDAO;
37 import fr.paris.lutece.portal.business.portlet.Portlet;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40
41
42
43
44 public final class FolderListingPortletDAO implements IFolderListingPortletDAO
45 {
46
47
48 private static final String SQL_QUERY_SELECT = "SELECT id_portlet, code_folder FROM folderlisting_portlet WHERE id_portlet = ? ";
49 private static final String SQL_QUERY_INSERT = "INSERT INTO folderlisting_portlet ( id_portlet, code_folder ) VALUES ( ?, ? )";
50 private static final String SQL_QUERY_DELETE = "DELETE FROM folderlisting_portlet WHERE id_portlet = ? ";
51 private static final String SQL_QUERY_UPDATE = "UPDATE folderlisting_portlet SET id_portlet = ?, code_folder = ? WHERE id_portlet = ? ";
52 private static final String SQL_QUERY_CHECK = "SELECT code_folder FROM folderlisting_portlet WHERE code_folder = ? ";
53
54
55
56
57
58
59
60
61
62 public void delete( int nPortletId )
63 {
64 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
65 daoUtil.setInt( 1, nPortletId );
66 daoUtil.executeUpdate( );
67 daoUtil.free( );
68 }
69
70
71
72
73
74
75 public void insert( Portlet portlet )
76 {
77 FolderListingPortlet p = (FolderListingPortlet) portlet;
78 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
79 daoUtil.setInt( 1, p.getId( ) );
80 daoUtil.setString( 2, p.getRootFolderId( ) );
81 daoUtil.executeUpdate( );
82 daoUtil.free( );
83 }
84
85
86
87
88
89
90
91
92 public Portlet load( int nIdPortlet )
93 {
94 FolderListingPortlet portlet = new FolderListingPortlet( );
95 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
96 daoUtil.setInt( 1, nIdPortlet );
97 daoUtil.executeQuery( );
98
99 if ( daoUtil.next( ) )
100 {
101 portlet.setId( daoUtil.getInt( 1 ) );
102
103 portlet.setRootFolderId( daoUtil.getString( 2 ) );
104 }
105
106 daoUtil.free( );
107
108 return portlet;
109 }
110
111
112
113
114
115
116 public void store( Portlet portlet )
117 {
118 FolderListingPortlet p = (FolderListingPortlet) portlet;
119 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
120 daoUtil.setInt( 1, p.getId( ) );
121
122 daoUtil.setString( 2, p.getRootFolderId( ) );
123 daoUtil.setInt( 3, p.getId( ) );
124
125 daoUtil.executeUpdate( );
126 daoUtil.free( );
127 }
128
129
130
131
132
133
134 public boolean checkNoFolderInPortlet( int nIdFolder )
135 {
136 boolean bValue = true;
137 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_CHECK );
138 daoUtil.setInt( 1, nIdFolder );
139 daoUtil.executeQuery( );
140
141 if ( daoUtil.next( ) )
142 {
143 bValue = false;
144 }
145
146 daoUtil.free( );
147
148 return bValue;
149 }
150 }