|
1
5 package com.tdsecurities.itracker.converter;
6
7 import java.sql.PreparedStatement  ;
8 import java.sql.ResultSet ;
9 import java.sql.Timestamp ;
10 import java.util.Date ;
11
12 import org.apache.log4j.Logger;
13
14 import com.tdsecurities.itracker.common.DataSourceManager;
15
16
20 public class UserPreferencesConverter extends BasicConverter
21 {
22 private static final String SOURCE_SQL = "select * from user";
23 private static final String LAST_ID_SQL = "select max(id) from userpreferencesbean";
24 private static final String TARGET_SQL = "insert into userpreferencesbean ("
25 + " id,save_login,user_locale,num_items_index,num_items_issue_list,show_closed,"
26 + " sort_column,hidden_index_sections,create_date,last_modified,user_id) values"
27 + " (?,?,?,?,?,?,?,?,?,?,?)";
28
29 private Logger log = Logger.getLogger(UserPreferencesConverter.class);
30
31 private int prefsId = 1;
32
33 protected String getSourceQuery()
34 {
35 return SOURCE_SQL;
36 }
37
38 protected String getTargetQuery()
39 {
40 return TARGET_SQL;
41 }
42
43 protected String getIdStoreName()
44 {
45 return "preferences";
46 }
47
48 protected String getLastIdQuery()
49 {
50 return LAST_ID_SQL;
51 }
52
53 protected int prepareTargetStatement(PreparedStatement targetStmt, ResultSet rs) throws Exception
54 {
55 long now = (new Date ()).getTime();
56 int col = 1;
57 targetStmt.setInt(col++, prefsId++);
58 targetStmt.setInt(col++, 0);
59 targetStmt.setString(col++, "en_US");
60 targetStmt.setInt(col++, -1);
61 targetStmt.setInt(col++, -1);
62 targetStmt.setInt(col++, 0);
63 targetStmt.setString(col++, "sev");
64 targetStmt.setInt(col++, 2);
65 targetStmt.setTimestamp(col++, new Timestamp (now));
66 targetStmt.setTimestamp(col++, new Timestamp (now));
67 targetStmt.setInt(col++, rs.getInt("user_id"));
68 return BasicConverter.OK;
69 }
70
71 protected void preConversionProcessing()
72 {
73 log.info( "Converting user preferences...");
74 executeUpdate(DataSourceManager.ITRACKER, "delete from userpreferencesbean");
75 }
76 }
77 |
Popular Tags |
Java API By Example, From Geeks To Geeks.