ConfigPropertiesSkin.java
3.63 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
package it.softecspa.fileproxy.db.skins;
/*
* @(#)ConfigPropertiesSkin.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.UpdatableRow;
import it.softecspa.fileproxy.db.criterias.ConfigPropertiesCriteria;
import it.softecspa.kahuna.sql.SqlWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.log4j.Logger;
/**
* Abstract manager for table T001_CONFIG_PROPERTIES
* 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 ConfigPropertiesSkin extends UpdatableRow implements Cloneable {
// Table name: T001_CONFIG_PROPERTIES
public static final String NAME = "t001_config_properties";
public static final String ALIAS = "t001";
protected Logger log = Logger.getLogger(ConfigPropertiesSkin.class);
// V_KEY - VARCHAR(50) NOT NULL PK
protected String key;
// V_VALUE - VARCHAR(256) NOT NULL
protected String value;
// V_DESCRIPTION - VARCHAR(100) nullable
protected String description;
protected ConfigPropertiesSkin() {
super();
}
/**
* Extract bean using key
*/
protected ConfigPropertiesSkin(ConnectionManager cm, String key) throws NoRecordFoundException, SQLException {
this();
// Setup key filter values
ConfigPropertiesCriteria filter = new ConfigPropertiesCriteria(cm);
filter.setKey(key);
readRow(cm, filter.getSelect().costruisciSelect());
}
public String getKey() {
return this.key;
}
public void setKey(String value) {
this.key = value;
}
public String getValue() {
return this.value;
}
public void setValue(String value) {
this.value = value;
}
public String getDescription() {
return this.description;
}
public void setDescription(String value) {
this.description = value;
}
@Override
public ConfigPropertiesSkin clone() throws CloneNotSupportedException {
ConfigPropertiesSkin c = (ConfigPropertiesSkin) super.clone();
//
// Not primitive or not immutable objects
//
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_key" , sql.fStr(this.key));
sql.addValue("v_value" , sql.fStr(this.value));
sql.addValue("v_description" , sql.fStr(this.description));
int _retval = dbs.execute(sql.costruisciInsert());
return _retval;
} else if (updateType == UPDATE) {
sql.addColumnSET("v_value" , sql.fStr(this.value));
sql.addColumnSET("v_description" , sql.fStr(this.description));
sql.addWhere("v_key = " +sql.fStr(this.key));
return dbs.execute(sql.costruisciUpdate());
} else if (updateType == DELETE) {
sql.addWhere("v_key = " +sql.fStr(this.key));
return dbs.execute(sql.costruisciDelete());
}
return 0;
}
protected void readRow(ResultSet rs) throws SQLException {
setKey(rs.getString("v_key"));
// -------
setValue(rs.getString("v_value"));
setDescription(rs.getString("v_description"));
}
}