ChangeLogSkin.java
3.87 KB
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
package it.softecspa.fileproxy.db.skins;
/*
* @(#)ChangeLogSkin.java 1.7.1,126 custom 2014-06-22T22:00:00Z UTC
* Built automatically by REVERSER
*/
import it.softecspa.database.dbconnect.ConnectionManager;
import it.softecspa.database.dbconnect.DatabaseStatement;
import it.softecspa.database.dbconnect.NoRecordFoundException;
import it.softecspa.database.dbconnect.Query;
import it.softecspa.database.dbconnect.UpdatableRow;
import it.softecspa.fileproxy.db.criterias.ChangeLogCriteria;
import it.softecspa.kahuna.sql.SqlWriter;
import it.softecspa.kahuna.util.calendar.EnterpriseCalendar;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.log4j.Logger;
/**
* Abstract manager for table A001_CHANGE_LOG
* Class auto generated by REVERSER, version 1.7.1,126 custom
*
* Warning: this class will be rewrited from REVERSER
*
* @author il Vera
*/
public abstract class ChangeLogSkin extends UpdatableRow implements Cloneable {
// Table name: A001_CHANGE_LOG
public static final String NAME = "a001_change_log";
public static final String ALIAS = "a001";
protected Logger log = Logger.getLogger(ChangeLogSkin.class);
// V_CODE - VARCHAR(30) NOT NULL PK
protected String code;
// V_DESCRIPTION - VARCHAR(100) NOT NULL
protected String description;
// D_CHANGE - DATETIME NOT NULL
protected EnterpriseCalendar change;
protected ChangeLogSkin() {
super();
}
/**
* Extract bean using key
*/
protected ChangeLogSkin(ConnectionManager cm, String code) throws NoRecordFoundException, SQLException {
this();
// Setup key filter values
ChangeLogCriteria filter = new ChangeLogCriteria(cm);
filter.setCode(code);
readRow(cm, filter.getSelect().costruisciSelect());
}
public String getCode() {
return this.code;
}
public void setCode(String value) {
this.code = value;
}
public String getDescription() {
return this.description;
}
public void setDescription(String value) {
this.description = value;
}
public EnterpriseCalendar getChange() {
return this.change;
}
public void setChange(EnterpriseCalendar value) {
this.change = value;
}
@Override
public ChangeLogSkin clone() throws CloneNotSupportedException {
ChangeLogSkin c = (ChangeLogSkin) super.clone();
//
// Not primitive or not immutable objects
if (this.change!=null) c.change = (EnterpriseCalendar) this.change.clone();
//
return c;
}
/**
* Standard implementation of update method
* @param updateType operation to execute
* @param dbs DatabaseStatement that perform operation
* @return number of update rows or new autoincrement id
* @throws SQLException if there is an error in your query
*/
public int updateRecord(UpdateType updateType, DatabaseStatement dbs) throws SQLException {
SqlWriter sql = new SqlWriter();
sql.setTables(NAME);
if (updateType == INSERT) {
sql.addValue("v_code" , sql.fStr(this.code));
sql.addValue("v_description" , sql.fStr(this.description));
sql.addValue("d_change" , Query.toSQLDateTime(dbs.getDBMS(), this.change));
int _retval = dbs.execute(sql.costruisciInsert());
return _retval;
} else if (updateType == UPDATE) {
sql.addColumnSET("v_description" , sql.fStr(this.description));
sql.addColumnSET("d_change" , Query.toSQLDateTime(dbs.getDBMS(), this.change));
sql.addWhere("v_code = " +sql.fStr(this.code));
return dbs.execute(sql.costruisciUpdate());
} else if (updateType == DELETE) {
sql.addWhere("v_code = " +sql.fStr(this.code));
return dbs.execute(sql.costruisciDelete());
}
return 0;
}
protected void readRow(ResultSet rs) throws SQLException {
setCode(rs.getString("v_code"));
// -------
setDescription(rs.getString("v_description"));
setChange(EnterpriseCalendar.newInstance(rs.getTimestamp("d_change")));
}
}