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.blog.business.rss;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 import java.util.ArrayList;
40 import java.util.List;
41
42
43
44
45
46
47 public class BlogResourceRssConfigDAO implements IBlogResourceRssConfigDAO
48 {
49 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT id_rss,id_portlet " + "FROM blog_rss_cf WHERE id_rss=?";
50 private static final String SQL_QUERY_INSERT = "INSERT INTO blog_rss_cf( " + "id_rss, id_portlet )" + "VALUES (?, ?)";
51 private static final String SQL_QUERY_UPDATE = "UPDATE blog_rss_cf " + "SET id_rss=?, id_portlet=?" + " WHERE id_rss=?";
52 private static final String SQL_QUERY_DELETE = "DELETE FROM blog_rss_cf WHERE id_rss=? ";
53 private static final String SQL_QUERY_FIND_ALL = "SELECT id_rss, id_portlet " + "FROM blog_rss_cf";
54
55
56
57
58 @Override
59 public synchronized void insert( BlogResourceRssConfig config, Plugin plugin )
60 {
61 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin ) )
62 {
63 int nPos = 0;
64
65 daoUtil.setInt( ++nPos, config.getIdRss( ) );
66 daoUtil.setInt( ++nPos, config.getIdPortlet( ) );
67
68 daoUtil.executeUpdate( );
69 }
70 }
71
72
73
74
75 @Override
76 public void store( BlogResourceRssConfig config, Plugin plugin )
77 {
78 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin ) )
79 {
80 int nPos = 0;
81
82 daoUtil.setInt( ++nPos, config.getIdRss( ) );
83 daoUtil.setInt( ++nPos, config.getIdPortlet( ) );
84
85 daoUtil.setInt( ++nPos, config.getIdRss( ) );
86 daoUtil.executeUpdate( );
87 }
88 }
89
90
91
92
93 @Override
94 public BlogResourceRssConfig load( int nIdRss, Plugin plugin )
95 {
96 BlogResourceRssConfig config = null;
97 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, plugin ) )
98 {
99 daoUtil.setInt( 1, nIdRss );
100
101 daoUtil.executeQuery( );
102
103 int nPos = 0;
104
105 if ( daoUtil.next( ) )
106 {
107 config = new BlogResourceRssConfig( );
108 config.setIdRss( daoUtil.getInt( ++nPos ) );
109 config.setIdPortlet( daoUtil.getInt( ++nPos ) );
110 }
111 }
112 return config;
113 }
114
115
116
117
118 @Override
119 public void delete( int nIdRss, Plugin plugin )
120 {
121 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin ) )
122 {
123 daoUtil.setInt( 1, nIdRss );
124 daoUtil.executeUpdate( );
125 }
126 }
127
128
129
130
131 @Override
132 public List<BlogResourceRssConfig> loadAll( Plugin plugin )
133 {
134 List<BlogResourceRssConfig> configList = new ArrayList<>( );
135 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_ALL, plugin ) )
136 {
137 daoUtil.executeQuery( );
138
139 int nPos = 0;
140 if ( daoUtil.next( ) )
141 {
142 BlogResourceRssConfigess/rss/BlogResourceRssConfig.html#BlogResourceRssConfig">BlogResourceRssConfig config = new BlogResourceRssConfig( );
143 config.setIdRss( daoUtil.getInt( ++nPos ) );
144 config.setIdPortlet( daoUtil.getInt( ++nPos ) );
145
146 configList.add( config );
147 }
148 }
149 return configList;
150 }
151 }