亲们!点击完查询按钮为什么页面不刷新新数据呢 后台运行是对的 但是页面没反应呢? 是不是缺少了必要的操作或代码来跳转刷新? 跪求指教!!! JS如下:
mainActivity.trigger1Click = function(event){
var searchInputData = justep.xbl("searchInput");//获取页面先添加临时的cdata,必须改为auto-new 为true!!!
var dateInputValue = searchInputData.getValue("dateInput");//获取页面的input的值
var params = new justep.Request.ActionParam();
params.setString("dateInputValue", dateInputValue);//把值给了ajax,字段必须和java的参数一致
var r = justep.Request.sendBizRequest(
justep.Context.getCurrentProcess(),
justep.Context.getCurrentActivity(),
"searchByDate", //action里面的方法名
params //传值参数
);
var temp = justep.Request.transformList(
justep.Request.getData(r.responseXML));
}; JAVA如下: public static Table searchByDate(String dateInputValue){
//报表查询功能
System.out.println("yzk---------dateInputValue:"+dateInputValue);
String mysql = "SELECT F_IMPORT.FFLOWERSNAME AS FNAME,F_IMPORT.FPURCHASEDATE AS FPURCHASEDATE,F_SALE.FSELLDATE AS FSELLDATE,F_IMPORT.FINSURANCEDATE AS FINSURANCEDATE,CASE WHEN (CURDATE()-F_IMPORT.FINSURANCEDATE<0) THEN '未过期' ELSE '已过期' END AS ISOUTDATE,CASE WHEN (datediff(CURDATE(),F_IMPORT.FINSURANCEDATE)<0) THEN abs(datediff(CURDATE(),F_IMPORT.FINSURANCEDATE)) ELSE CONCAT('-',datediff(CURDATE(),F_IMPORT.FINSURANCEDATE)) END AS LASTDAY,(F_IMPORT.FCOUNT-(SELECT SUM(F_SALE.FSELLCOUNT) FROM F_SALE WHERE F_SALE.FFLOWERSNAME = FNAME)) AS LASTCOUNT,F_IMPORT.FPURCHASEPRICE AS FPURCHASEPRICE,F_SALE.FSELLPRICE AS FSELLPRICE,(F_SALE.FSELLPRICE-F_IMPORT.FPURCHASEPRICE) AS PRICELIRUN FROM F_IMPORT ,F_SALE WHERE F_IMPORT.FFLOWERSNAME = F_SALE.FFLOWERSNAME AND date_format(F_SALE.FSELLDATE,'%Y-%m') = date_format('"+dateInputValue+"','%Y-%m') ORDER BY FNAME";
System.out.println(mysql);
HashMap<String,String> sqlMap = new HashMap<String,String>();
//不同的数据库选择不同的数据库驱动,这里用的是mysql
sqlMap.put(DatabaseProduct.MYSQL.name(), mysql);
return SQL.select(sqlMap,null,"/FlowerSystem/FlowerMoudle/data");
}
|