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.digglike.business;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39
40 public class DiggUserInfoDAO implements IDiggUserInfoDAO
41 {
42 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT first_name,last_name,business_mail,home_mail,login " +
43 "FROM digglike_digg_user_info WHERE lutece_user_key = ? ";
44 private static final String SQL_QUERY_INSERT = "INSERT INTO digglike_digg_user_info ( lutece_user_key,first_name,last_name,business_mail,home_mail,login ) " +
45 "VALUES(?,?,?,?,?,?)";
46 private static final String SQL_QUERY_DELETE = "DELETE FROM digglike_digg_user_info WHERE lutece_user_key= ? ";
47 private static final String SQL_QUERY_UPDATE = "UPDATE digglike_digg_user_info SET " +
48 "first_name= ?,last_name= ?,business_mail=?,home_mail=?,login= ?" + " WHERE lutece_user_key= ? ";
49
50
51
52
53 @Override
54 public void insert( DiggUserInfo diggUserInfo, Plugin plugin )
55 {
56 int ncpt = 1;
57 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin );
58
59 daoUtil.setString( ncpt++, diggUserInfo.getLuteceUserKey( ) );
60 daoUtil.setString( ncpt++, diggUserInfo.getFirstName( ) );
61 daoUtil.setString( ncpt++, diggUserInfo.getLastName( ) );
62 daoUtil.setString( ncpt++, diggUserInfo.getBusinessMail( ) );
63 daoUtil.setString( ncpt++, diggUserInfo.getHomeMail( ) );
64 daoUtil.setString( ncpt++, diggUserInfo.getLogin( ) );
65 daoUtil.executeUpdate( );
66 daoUtil.free( );
67 }
68
69
70
71
72 @Override
73 public void update( DiggUserInfo diggUserInfo, Plugin plugin )
74 {
75 int ncpt = 1;
76 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin );
77
78 daoUtil.setString( ncpt++, diggUserInfo.getFirstName( ) );
79 daoUtil.setString( ncpt++, diggUserInfo.getLastName( ) );
80 daoUtil.setString( ncpt++, diggUserInfo.getBusinessMail( ) );
81 daoUtil.setString( ncpt++, diggUserInfo.getHomeMail( ) );
82 daoUtil.setString( ncpt++, diggUserInfo.getLogin( ) );
83 daoUtil.setString( ncpt++, diggUserInfo.getLuteceUserKey( ) );
84 daoUtil.executeUpdate( );
85 daoUtil.free( );
86 }
87
88
89
90
91 @Override
92 public DiggUserInfo load( String strLuteceUserKey, Plugin plugin )
93 {
94 DiggUserInfo submitUserInfo = null;
95
96 int ncpt = 1;
97
98 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, plugin );
99
100 daoUtil.setString( 1, strLuteceUserKey );
101
102 daoUtil.executeQuery( );
103
104 if ( daoUtil.next( ) )
105 {
106 submitUserInfo = new DiggUserInfo( );
107
108 submitUserInfo.setLuteceUserKey( strLuteceUserKey );
109 submitUserInfo.setFirstName( daoUtil.getString( ncpt++ ) );
110 submitUserInfo.setLastName( daoUtil.getString( ncpt++ ) );
111 submitUserInfo.setBusinesMail( daoUtil.getString( ncpt++ ) );
112 submitUserInfo.setHomeMail( daoUtil.getString( ncpt++ ) );
113 submitUserInfo.setLogin( daoUtil.getString( ncpt++ ) );
114 }
115
116 daoUtil.free( );
117
118 return submitUserInfo;
119 }
120
121
122
123
124 @Override
125 public void delete( String strLuteceUserKey, Plugin plugin )
126 {
127 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin );
128 daoUtil.setString( 1, strLuteceUserKey );
129 daoUtil.executeUpdate( );
130 daoUtil.free( );
131 }
132 }