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.dbpage.business.portlet;
35
36 import fr.paris.lutece.portal.business.portlet.Portlet;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39
40
41
42
43 public final class DbPagePortletDAO implements IDbPagePortletDAO
44 {
45
46
47 private static final String SQL_QUERY_SELECT = "SELECT id_portlet, dbpage_name, dbpage_values FROM dbpage_portlet WHERE id_portlet = ? ";
48 private static final String SQL_QUERY_INSERT = "INSERT INTO dbpage_portlet ( id_portlet, dbpage_name, dbpage_values ) VALUES ( ?, ?, ? )";
49 private static final String SQL_QUERY_DELETE = "DELETE FROM dbpage_portlet WHERE id_portlet = ? ";
50 private static final String SQL_QUERY_UPDATE = "UPDATE dbpage_portlet SET id_portlet = ?, dbpage_name = ?, dbpage_values = ? WHERE id_portlet = ? ";
51 private static final String SQL_QUERY_CHECK = " SELECT dbpage_name FROM dbpage_portlet WHERE dbpage_name = ? ";
52
53
54
55
56
57
58
59
60
61 public void delete( int nPortletId )
62 {
63 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
64 daoUtil.setInt( 1, nPortletId );
65 daoUtil.executeUpdate( );
66 daoUtil.free( );
67 }
68
69
70
71
72
73
74 public void insert( Portlet portlet )
75 {
76 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
77
78 DbPagePortlet p = (DbPagePortlet) portlet;
79
80 daoUtil.setInt( 1, p.getId( ) );
81 daoUtil.setString( 2, p.getDbPageName( ) );
82 daoUtil.setString( 3, p.getDbValues( ) );
83
84 daoUtil.executeUpdate( );
85 daoUtil.free( );
86 }
87
88
89
90
91
92
93
94 public Portlet load( int nIdPortlet )
95 {
96 DbPagePortlet portlet = new DbPagePortlet( );
97 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
98 daoUtil.setInt( 1, nIdPortlet );
99 daoUtil.executeQuery( );
100
101 if ( daoUtil.next( ) )
102 {
103 portlet.setId( daoUtil.getInt( 1 ) );
104 portlet.setDbPageName( daoUtil.getString( 2 ) );
105 portlet.setValues( daoUtil.getString( 3 ) );
106 }
107
108 daoUtil.free( );
109
110 return portlet;
111 }
112
113
114
115
116
117
118 public void store( Portlet portlet )
119 {
120 DbPagePortlet p = (DbPagePortlet) portlet;
121 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
122 daoUtil.setInt( 1, p.getId( ) );
123 daoUtil.setString( 2, p.getDbPageName( ) );
124 daoUtil.setString( 3, p.getDbValues( ) );
125 daoUtil.setInt( 4, p.getId( ) );
126
127 daoUtil.executeUpdate( );
128 daoUtil.free( );
129 }
130
131
132
133
134
135
136
137 public boolean checkNoDbPagePortlet( String strDbPageId )
138 {
139 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_CHECK );
140 daoUtil.setString( 1, strDbPageId );
141 daoUtil.executeQuery( );
142
143 boolean bResult = false;
144
145 if ( daoUtil.next( ) )
146 {
147 bResult = true;
148 }
149
150 daoUtil.free( );
151
152 return bResult;
153 }
154 }