|
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 ComponentConverter extends BasicConverter
21 {
22 private static final String SOURCE_SQL = "select * from bug_category";
23 private static final String TARGET_SQL = "insert into componentbean (id,name,description,status,create_date,last_modified, project_id) values (?,?,?,?,?,?,?)";
24 private static final String LAST_ID_SQL = "select max(id) from componentbean";
25
26 private Logger log = Logger.getLogger(ComponentConverter.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 "component";
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("bug_category_id"));
53 targetStmt.setObject(col++, rs.getObject("category_name"));
54 targetStmt.setObject(col++, rs.getObject("category_name"));
55 targetStmt.setInt(col++, 1);
56 targetStmt.setTimestamp(col++, new Timestamp (now));
57 targetStmt.setTimestamp(col++, new Timestamp (now));
58 targetStmt.setInt(col++, rs.getInt("group_id"));
59 return BasicConverter.OK;
60 }
61
62 protected void preConversionProcessing()
63 {
64 log.info( "Converting categories...");
65 executeUpdate(DataSourceManager.ITRACKER, "delete from componentbean");
66 }
67 }
68 |
Popular Tags |
Java API By Example, From Geeks To Geeks.