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
35 package fr.paris.lutece.plugins.directory.modules.exportfile.business;
36
37 import fr.paris.lutece.portal.service.plugin.Plugin;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40 import java.util.ArrayList;
41 import java.util.Collection;
42
43
44
45
46
47 public final class FileNameDAO implements IFileNameDAO
48 {
49
50 private static final String SQL_QUERY_SELECT = "SELECT mapping_entry, attribute, number_char, order_name FROM exportfile_fileName WHERE mapping_entry = ?";
51 private static final String SQL_QUERY_INSERT = "INSERT INTO exportfile_fileName ( mapping_entry, attribute, number_char, order_name ) VALUES ( ?, ?, ?, ? ) ";
52 private static final String SQL_QUERY_DELETE = "DELETE FROM exportfile_fileName WHERE mapping_entry=? AND attribute = ?";
53 private static final String SQL_QUERY_DELETE_BY_IDMAPPING = "DELETE FROM exportfile_fileName WHERE mapping_entry=? ";
54
55
56
57
58 @Override
59 public void insert( FileName fileName, Plugin plugin )
60 {
61
62 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin );
63
64 daoUtil.setInt( 1, fileName.getMappingEntry( ) );
65 daoUtil.setString( 2, fileName.getAttribute( ) );
66 daoUtil.setInt( 3, fileName.getNumberChar( ) );
67 daoUtil.setInt( 4, fileName.getOrder( ) );
68
69 daoUtil.executeUpdate( );
70 daoUtil.free( );
71
72 }
73
74
75
76
77 @Override
78 public void store( FileName fileName, Plugin plugin )
79 {
80
81
82 }
83
84
85
86
87 @Override
88 public void delete( FileName fileName, Plugin plugin )
89 {
90 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin );
91 daoUtil.setInt( 1, fileName.getMappingEntry( ) );
92 daoUtil.setString( 1, fileName.getAttribute( ) );
93 daoUtil.executeUpdate( );
94 daoUtil.free( );
95 }
96
97
98
99
100 @Override
101 public void delete( int nKey, Plugin plugin )
102 {
103 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE_BY_IDMAPPING, plugin );
104 daoUtil.setInt( 1, nKey );
105 daoUtil.executeUpdate( );
106 daoUtil.free( );
107 }
108
109 @Override
110 public Collection<FileName> selectFilesNameList( int nMappingEntry, Plugin plugin )
111 {
112 Collection<FileName> fileNameList = new ArrayList<FileName>( );
113 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin );
114 daoUtil.setInt( 1, nMappingEntry );
115 daoUtil.executeQuery( );
116
117 while ( daoUtil.next( ) )
118 {
119 FileName fileName = new FileName( );
120
121 fileName.setMappingEntry( daoUtil.getInt( 1 ) );
122 fileName.setAttribute( daoUtil.getString( 2 ) );
123 fileName.setNumberChar( daoUtil.getInt( 3 ) );
124 fileName.setOrder( daoUtil.getInt( 4 ) );
125
126 fileNameList.add( fileName );
127 }
128
129 daoUtil.free( );
130 return fileNameList;
131 }
132 }