ProtocolSkin.java
4.68 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
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
package it.softecspa.fileproxy.db.skins;
/*
* @(#)ProtocolSkin.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.ProtocolCriteria;
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 T015_PROTOCOL
* 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 ProtocolSkin extends UpdatableRow implements Cloneable {
// Table name: T015_PROTOCOL
public static final String NAME = "t015_protocol";
public static final String ALIAS = "t015";
protected Logger log = Logger.getLogger(ProtocolSkin.class);
// N_PROTOCOL - INT UNSIGNED(10) NOT NULL PK
protected Integer protocol;
// V_NAME - VARCHAR(50) NOT NULL
protected String name;
// V_SERVER_VERSION - VARCHAR(50) NOT NULL
protected String serverVersion;
// D_RECORD - DATETIME NOT NULL
protected EnterpriseCalendar record;
protected EnterpriseCalendar old_d_record;
protected ProtocolSkin() {
super();
}
/**
* Extract bean using key
*/
protected ProtocolSkin(ConnectionManager cm, Integer protocol) throws NoRecordFoundException, SQLException {
this();
// Setup key filter values
ProtocolCriteria filter = new ProtocolCriteria(cm);
filter.setProtocol(protocol);
readRow(cm, filter.getSelect().costruisciSelect());
}
public Integer getProtocol() {
return this.protocol;
}
public void setProtocol(Integer value) {
this.protocol = value;
}
public String getName() {
return this.name;
}
public void setName(String value) {
this.name = value;
}
public String getServerVersion() {
return this.serverVersion;
}
public void setServerVersion(String value) {
this.serverVersion = value;
}
public EnterpriseCalendar getRecord() {
return this.record;
}
public void setRecord(EnterpriseCalendar value) {
this.record = value;
}
@Override
public ProtocolSkin clone() throws CloneNotSupportedException {
ProtocolSkin c = (ProtocolSkin) super.clone();
//
// Not primitive or not immutable objects
if (this.record!=null) c.record = (EnterpriseCalendar) this.record.clone();
if (this.old_d_record!=null) c.old_d_record = (EnterpriseCalendar) this.old_d_record.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("n_protocol" , sql.fNum(this.protocol));
sql.addValue("v_name" , sql.fStr(this.name));
sql.addValue("v_server_version" , sql.fStr(this.serverVersion));
sql.addValue("d_record" , (this.record==null?Query.toSQL(Query.getFunCurrentDateTime(dbs.getDBMS())):Query.toSQLDateTime(dbs.getDBMS(), this.record)));
int _retval = dbs.execute(sql.costruisciInsert());
return _retval;
} else if (updateType == UPDATE) {
sql.addColumnSET("v_name" , sql.fStr(this.name));
sql.addColumnSET("v_server_version" , sql.fStr(this.serverVersion));
sql.addColumnSET("d_record" , (this.record==null || this.record.equals(this.old_d_record)?Query.toSQL(Query.getFunCurrentDateTime(dbs.getDBMS())):Query.toSQLDateTime(dbs.getDBMS(), this.record)));
sql.addWhere("n_protocol = " +sql.fNum(this.protocol));
return dbs.execute(sql.costruisciUpdate());
} else if (updateType == DELETE) {
sql.addWhere("n_protocol = " +sql.fNum(this.protocol));
return dbs.execute(sql.costruisciDelete());
}
return 0;
}
protected void readRow(ResultSet rs) throws SQLException {
setProtocol(SqlWriter.getInteger(rs, "n_protocol"));
// -------
setName(rs.getString("v_name"));
setServerVersion(rs.getString("v_server_version"));
setRecord(EnterpriseCalendar.newInstance(rs.getTimestamp("d_record")));
this.old_d_record = getRecord(); // Cache della colonna D_RECORD
}
}