1.增
public void addReport() {
// 根据分区情况添加数据
DistrictCtrls.Load_DEF_ENTS("user", report.class, disctrictType.BALANCE_LOAD);
IDatabase database = DistrictCtrls.get_Insert_DB("user", report.class);
report _report = new report("sdgdfsgsd", "美胸", "", "", "", "", "");
int result = _report.Insert(database);
this.WriteUTF8JSONDATAMSG(result, result==1?"成功":"失败", new JSONObject());
}
2.删
public void rmReport (){
String name = this.getParams("name");
// 遍历分区
for (String clusterkeys : DataBaseCluster.clusters.get("user").keySet()) {
IDatabase databs = DataBaseCluster.Get_READ_SERVER("user", clusterkeys);
//查询对应数据删除
int result = report.E().Where(report.reportname.Equals(name)).Delete(databs);
if (result == 1) {
this.WriteUTF8JSONDATAMSG(result, "success", new JSONObject());
return;
}
}
this.WriteUTF8JSONDATAMSG(-1, "删除失败", "");
}
3.改
public void changeReport() {
String name = this.getParams("name");
String name1 = this.getParams("name1");
for (String clusterkeys : DataBaseCluster.clusters.get("user").keySet()) {
IDatabase databs = DataBaseCluster.Get_READ_SERVER("user", clusterkeys);
int result = report.E().Where(report.reportname.Equals(name)).Update(databs, report.reportname.SET(name1));
if (result == 1) {
this.WriteUTF8JSONDATAMSG(result, "success", new JSONObject());
return;
}
}
this.WriteUTF8JSONDATAMSG(-1, "修改失败", "");
}
2.查
public void findReportList () {
// redis缓存对象
RedisObjects _redisObject = HoyiRedisCtrls.NEWCS().GetRedis();
//读缓存是否有要的数据
String string = _redisObject.get("report");
_redisObject.del("report");
if(string==null||string.equals("")) {
List<report> list = new ArrayList<report>();
for (String clusterkeys : DataBaseCluster.clusters.get("user").keySet()) {
IDatabase databs = DataBaseCluster.Get_READ_SERVER("user", clusterkeys);
List<customers> arr = customers.E().Select(databs);
list.addAll(arr);
}
_redisObject.set("report", JSONArray.fromObject(list).toString());
this.WriteUTF8JSONDATAMSG(1, "成功", list);
}else {
JSONArray fromObject = JSONArray.fromObject(string);
this.WriteUTF8JSONDATAMSG(1, "成功", fromObject);
}
}
}