|
var tempdata = this.comp("tempData");
//var temp = this.comp("tempbut").label;
//console.log(temp);
station =this.comp("StationSel").val();
var StationDate= station;
console.log(StationDate);
var params = {};
if (StationDate) {
params = {
StationDate : StationDate
};
console.log(StationDate);
}
justep.Baas.sendRequest({
"url" : "/ll/m",
"action" : "queryTemp",
"async" : false,
"params" : params,
"success" : function(data) {
tempdata.deleteAllData();
tempdata.loadData(data);
}
});
java:
public static JSONObject queryTempIfo(JSONObject params, ActionContext context) throws SQLException, NamingException, java.sql.SQLException {
Connection conn = context.getConnection(DATASOURCE_LX);
String StationDate = params.getString("StationtDate");
System.out.println(StationDate);
//WindTime wt = new WindTime();
//String nowtime = wt.gettime();//当天的0时刻
Table table = null;
String sql = "";
String m="W9154";
try{
if(StationDate != null){
sql = "SELECT ObservTimes,DryBulTemp,MaxTemp,MinTemp FROM Observation WHERE StationNum= '"+StationDate+"'AND ObservTimes <'"+201809260015l+"'";
table = DataUtils.queryData(conn, sql,null, null, null, null);}
else{
sql = "SELECT ObservTimes,DryBulTemp,MaxTemp,MinTemp FROM Observation WHERE StationNum= '"+m+"'AND ObservTimes <'"+201809260015l+"'";
table = DataUtils.queryData(conn, sql,null, null, null, null);
}
return Transform.tableToJson(table);
} finally {
conn.close();
}
} |
|