数组和StringBuilder 的运用

青旅半醒 2022-06-02 01:38 114阅读 0赞

/\*\*  
\*   量测生意-解密流量-流量口分析-7天总数  
\*  http://223.6.252.143:30005/yanShulcsyData1/servencount?thedate=20170609,20170616&seller\_id=601879343  
\* @param datetime  
\* @param sellerid  
\* @return  
\* 7天总数  
\*/  
@RequestMapping(value="/servencount",method = \{ RequestMethod.POST,  
RequestMethod.GET \}, produces = "text/json;charset=UTF-8")  
public String  findServencount(@RequestParam("thedate")Object\[\] datetime,@RequestParam("seller\_id") String sellerid)\{  
String  startdate=null;  
String  enddate=null;  
for(int i=0;i<datetime.length;i++)\{  
startdate=datetime\[0\].toString();  
enddate=datetime\[1\].toString();  
System.out.println("startdate=="+startdate+"startdate==="+startdate);  
\}  
System.out.println("seller\_id="+sellerid);  
if(!AppUtil.isNullorEmpty(startdate)&&!AppUtil.isNullorEmpty(enddate)&&!AppUtil.isNullorEmpty(sellerid))\{  
//7天总数据  
 StringBuilder sb=new StringBuilder();  
           sb.append(" select sum(uv) as 访客数, sum(pv) as 浏览量 ,  round(sum(cast(pv as float))").append("/").append("sum(cast(uv as float)),4) as 平均访问深度   ,sum(visit\_repeat\_num) as 新访客数  from  \[dbo\].\[ysf\_ShopTraffic\] where thedate between ? and ? and seller\_id=?");  
          String sql= sb.toString();  
        //20170705   20170712 1036319921  
        String\[\] params=\{startdate,enddate,sellerid\};   
        Map<String, Object> mps = new Tables().findliangce(sql, params);  
        if(AppUtil.isNullorEmpty(mps))\{  
SupperJason jason=new SupperJason();  
jason.setResult("0");  
return JSON.toJSONString(jason);  
\}  
else\{  
// System.out.println("maps=="+maps.toString());  
return JSON.toJSONString(mps);  
\}  
\}  
return  null ;  
\}