/**
* 将bean对象更新进数据库
*
* @return 返回更新条数，-1为更新失败
* @throws AttributeException
* @throws InvokeException
* @throws DbPropertyException
* @throws SQLException
*/
public Integer update()
throws InvokeException, AttributeException, DbPropertyException, SQLException {
String tableName = getMapTableName();
List<String> keyList = super.getKeys();
BuildSql sqlHelper = new BuildSql();
Map<String, Object> valueMap = getMapValuesMap();
Map<String, Object> filteMap = new HashMap<String, Object>();
Map<String, Object> values = new HashMap<String, Object>();
Iterator<String> it = valueMap.keySet().iterator();
while (it.hasNext()) {
String key = it.next();
if (keyList.contains(key)) {
filteMap.put(key, valueMap.get(key));
} else {
values.put(key, valueMap.get(key));
}
}
BuildSql buildSql = new BuildSql();
buildSql.setTableName(tableName);
buildSql.setFilterMap(filteMap);
buildSql.setValueMap(values);
buildSql.BuildUpdateSql();
DbCon db = new DbCon();
return db.updateSql(buildSql);
}
/**
* 更新或者新增(根据主键条件判断新增或者更新)
*
* @return 返回更新条数，-1为更新失败
* @throws InvokeException
* @throws AttributeException
* @throws DbPropertyException
* @throws SQLException
* @throws DynConfigException
*/
public Integer saveOrUpdate()
throws InvokeException, AttributeException, DbPropertyException, SQLException {
String tableName = getMapTableName();
Map<String, String> mappingMap = super.getMappingMap();
List<String> keyList = super.getKeys();
List<String> excluList = super.getExclusiveList();
BuildSql sqlHelper = new BuildSql();
Map<String, Object> filteMap = new HashMap<String, Object>();
Map<String, Object> valuesMap = new HashMap<String, Object>();
Iterator<String> it = super.getMap().keySet().iterator();
while (it.hasNext()) {
String fieldName = it.next();
Object value = super.getMap().get(fieldName);
String name = fieldName;
if (!excluList.contains(fieldName)) { // 如果不在排除列中
if (mappingMap.containsKey(fieldName)) { // 如果存在映射关系
name = mappingMap.get(fieldName);
}
if (keyList.contains(fieldName)) {
filteMap.put(name, value);
} else {
valuesMap.put(name, value);
}
}
}
BuildSql buildSql = new BuildSql();
buildSql.setTableName(tableName);
buildSql.BuildSaveOrUpdateSql(filteMap, valuesMap);
DbCon db = new DbCon();
return db.updateSql(buildSql);
}
/**
* 将Map对象插入数据库
*
* @throws AttributeException
* @throws InvokeException
* @throws SQLException
* @throws DbPropertyException
*/
public Integer insert()
throws InvokeException, AttributeException, DbPropertyException, SQLException {
List<String> keyList = this.getKeys();
Map<String, Object> valueMap = super.getMap();
for (String str : keyList) {
if (super.getMap().get(str) == null) {
super.getMap().put(str, StringUtil.getUUID());
}
}
BuildSql buildSql = new BuildSql();
String tableName = getMapTableName();
buildSql.setValueMap(getMapValuesMap());
buildSql.setTableName(tableName);
buildSql.BuildInsertSql();
DbCon db = new DbCon();
return db.updateSql(buildSql);
}
/**
* 查询满足bean对象主键值的集合
*
* @return
* @throws InvokeException
* @throws AttributeException
* @throws DbPropertyException
* @throws SQLException
*/
public List<Map<String, Object>> query()
throws InvokeException, AttributeException, DbPropertyException, SQLException {
String tableName = getMapTableName();
List<String> keyList = super.getKeys();
List<String> excluList = super.getExclusiveList();
List<String> likeFilterCol = super.getLikeFilterCol();
Map<String, String> mappingMap = super.getMappingMap();
BuildSql buildSql = new BuildSql();
List<String> colList = new ArrayList<String>();
Map<String, Object> filteMap = new HashMap<String, Object>();
Map<String, String> likeFilterMap = new HashMap<String, String>(); // 模糊查询对象
Iterator<String> it = super.getMap().keySet().iterator();
while (it.hasNext()) {
String fieldName = it.next();
String name = fieldName;
Object value = super.getMap().get(fieldName);
if (!excluList.contains(fieldName)) { // 如果不在排除列中
if (mappingMap.containsKey(fieldName)) { // 如果存在映射关系
name = mappingMap.get(fieldName);
}
// colList.add(name) ;
if (likeFilterCol.contains(fieldName)) {
if (value != null) {
likeFilterMap.put(name, StringUtil.objectToString(value));
}
} else if (keyList.contains(fieldName)) {
if (value != null) {
filteMap.put(name, value);
}
}
}
}
if (colList.size() > 0) {
buildSql.setColList(colList);
}
buildSql.setTableName(tableName);
buildSql.setFilterMap(filteMap);
buildSql.setLikeFilterMap(likeFilterMap);
buildSql.setOrderList(super.getOrderList());
buildSql.BuildQuerySql();
DbCon db = new DbCon();
return db.querySql(buildSql);
}