|
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 ProjectConverter extends BasicConverter
21 {
22 private static final String SOURCE_SQL = "select * from groups";
23 private static final String TARGET_SQL = "insert into projectbean (id,name,description,status,options,custom_fields,create_date,last_modified) values (?,?,?,?,?,?,?,?)";
24 private static final String LAST_ID_SQL = "select max(id) from projectbean";
25
26 private Logger log = Logger.getLogger(ProjectConverter.class);
27
28 protected String getSourceQuery()
29 {
30 return SOURCE_SQL;
31 }
32
33 protected String getTargetQuery()
34 {
35 return TARGET_SQL;
36 }
37
38 protected String getIdStoreName()
39 {
40 return "project";
41 }
42
43 protected String getLastIdQuery()
44 {
45 return LAST_ID_SQL;
46 }
47
48 protected int prepareTargetStatement(PreparedStatement targetStmt, ResultSet rs) throws Exception
49 {
50 long now = (new Date ()).getTime();
51 int col = 1;
52 targetStmt.setObject(col++, rs.getObject("group_id"));
53 targetStmt.setObject(col++, rs.getObject("group_name"));
54 targetStmt.setObject(col++, rs.getObject("short_description"));
55 targetStmt.setInt(col++, 1);
56 targetStmt.setInt(col++, 6);
57 targetStmt.setInt(col++, 0);
58 targetStmt.setTimestamp(col++, getDate(rs,"register_time"));
59 targetStmt.setTimestamp(col++, new Timestamp (now));
60 return BasicConverter.OK;
61 }
62
63 protected void preConversionProcessing()
64 {
65 log.info( "Converting projects...");
66 executeUpdate(DataSourceManager.ITRACKER, "delete from projectbean");
67 }
68 }
69 |
Popular Tags |
Java API By Example, From Geeks To Geeks.