@POST
@At("/ht/pamsave")
@Ok("json")
public JSONObject save(@Param("..") Parameter params) {
JSONObject json = new JSONObject();
json.put(Constant.SUCCESS, false);
try {
if (StringUtil.checkNotNull(params.getStationID())) {
baseService.dao.insert(params.getStationID(), cov(params, true));
// baseService.dao.insert(params) ;
json.put(Constant.SUCCESS, true);
dls.insert("01", tableName, getHTLoginUserName());
dls.insertNDY(tableName, params.getStationID(), null, params.getCreateDate());
json.put(Constant.INFO, "操作成功");
} else {
json.put(Constant.INFO, "请选择观测站或观测站ID错误");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
json.put(Constant.INFO, e.getMessage());
} finally {
return json;
}
}
@POST
@At("/ht/pamget")
@Ok("json")
public Parameter get(String table, long id) {
Parameter para = null;
if (id > 0 && StringUtil.checkNotNull(table)) {
Record rd = baseService.dao.fetch(table, Cnd.where("parameterID", "=", id));
para = this.record2Object(rd);
para.setStationID(table);
para.setParameterID(id);
}
return para;
}
@POST
@At("/ht/pamdel")
@Ok("json")
public JSONObject deleteParameter(@Param("..") Parameter params) {
JSONObject json = new JSONObject();
json.put(Constant.SUCCESS, false);
if (StringUtil.checkNotNull(params.getIds())) {
String[] ids = params.getIds().split(";");
// List<Parameter> igs = new ArrayList<Parameter>() ;
for (String id : ids) {
if (null != this.get(params.getStationID(), id)) {
baseService.dao.clear(params.getStationID(), Cnd.where("parameterID", "=", id));
}
// Parameter sa = new Parameter();
// sa.setParameterID(id) ;
/*sa = baseService.dao.fetch(sa) ;
if(null != sa){
igs.add(sa) ;
}*/
}
json.put(Constant.SUCCESS, true);
dls.insert("03", tableName, getHTLoginUserName());
/*if(null != igs && igs.size() > 0 ){
if( baseService.dao.delete(igs) == igs.size() ){
}else{
json.put(Constant.INFO, error1) ;
}
}else{
json.put(Constant.INFO, error2) ;
}*/
} else {
json.put(Constant.INFO, error3);
}
return json;
}
@POST
@At("/ht/savepamdata")
@Ok("json")
public JSONObject saveParameterDataFromAccess(
String mdbPath,
String stationId,
String mdbTableName,
String dateField,
ServletContext context) {
JSONObject json = new JSONObject();
json.put(Constant.SUCCESS, false);
// log.info("tableName:"+ mdbTableName + " timefield:" + dateField + " station:" +stationId) ;
try {
long start = System.currentTimeMillis();
AccessUtil au = new AccessUtil(this.getAppRealPath(context) + mdbPath);
Ioc ioc = Mvcs.getIoc();
if (null != ioc) {
PropertiesProxy prop = ioc.get(PropertiesProxy.class, "config");
if (StringUtil.checkNotNull(prop.get("accessdriver"))) {
au.setDburl(prop.get("accessdriver"));
}
}
log.info(au.getDburl());
Connection con = au.getConnection();
Statement stat = con.createStatement();
total = au.getTotalRowNumber(stat, mdbTableName);
long pageTotal = au.getTotalPageNumber(total);
long insertdb = 0;
String tmpl =
"select top PAGESPEED * from TABLENAME where ID >(select top 1 max(ID) from (select top BEFOREROW ID from TABLENAME order by ID asc)) order by ID asc ";
tmpl =
tmpl.replaceAll("ID", dateField)
.replaceAll("PAGESPEED", String.valueOf(au.pageSpeed))
.replaceAll("TABLENAME", mdbTableName);
for (int i = 1; i <= pageTotal; i++) {
int ii = (i - 1) * au.pageSpeed;
String sql = tmpl.replaceAll("BEFOREROW", String.valueOf(ii));
if (i == 1) {
sql = sql.substring(0, sql.indexOf("where"));
sql += "order by ID asc".replace("ID", dateField);
}
ResultSet rset = au.execSQL(stat, sql);
if (null != rset) {
// 把当前结果集中存在的fieldsName找出来
List<String> available = new ArrayList<String>();
List<String> list = au.getAllColumnName(rset.getMetaData());
for (String str : au.fieldsName) {
if (au.isExistString(list, str)) {
available.add(str);
}
}
List<Parameter> data = new ArrayList();
while (rset.next()) {
Parameter p = new Parameter();
String time = rset.getString(dateField);
p.setSrcTimestr(time);
p.setCreateDate(DateUtil.convertStringToDate(time, DateUtil.pattern5));
p.setStationID(stationId);
// StringBuilder ss = new StringBuilder(rset.getString("mytime")).append("\t");
// 遍历全部字段并存到java object 中
for (String fn : available) {
// ss.append(rset.getString(fn)).append("\t") ;
BeanUtils.setProperty(p, fn, String.valueOf(rset.getString(fn)));
}
data.add(p);
dls.insertNDY(tableName, p.getStationID(), null, p.getCreateDate());
}
// log.info("得到: " + data.size()) ;
if (null != data && data.size() > 0) {
// 把已经存在的对象删除掉
batchDeleteParameter(stationId, data);
insertdb += data.size();
for (Parameter pa : data) {
baseService.dao.insert(stationId, cov(pa, true));
}
// baseService.dao.insert(data) ;
dls.insert("01", tableName, getHTLoginUserName());
courr = insertdb;
}
}
}
// log.info("共得到: " + insertdb) ;
long end = System.currentTimeMillis();
json.put(Constant.SUCCESS, true);
json.put("usetime", (end - start) / 1000 + " 秒");
json.put("insertRow", insertdb + " 条");
// log.debug(json.get("usetime")) ;
} catch (Exception e) {
// e.printStackTrace();
json.put(Constant.INFO, e.getLocalizedMessage());
} finally {
return json;
}
}