List of usage examples for org.springframework.web.util WebUtils getParametersStartingWith
public static Map<String, Object> getParametersStartingWith(ServletRequest request, @Nullable String prefix)
From source file:com.hihsoft.sso.sysmonitor.syslogs.web.controller.TlogDbsqlController.java
/** * * @param request/*from w ww . ja va 2 s .c o m*/ * @param response * @return * @throws Exception */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView(v_list); String sql = "select database_oid , table_name , table_operate , table_access_times , table_access_last_time , columes , u.username as userid from t_log_dbsql l , t_acl_userinfo u where l.userid=u.userid"; Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String userid = (String) filter.get("userid"); String tableName = (String) filter.get("tableName"); String columes = (String) filter.get("columes"); String beginDate = (String) filter.get("beginDate"); String endDate = (String) filter.get("endDate"); if (StringUtils.isNotEmpty(userid)) { sql += " and u.username like '%" + userid + "%'"; } if (StringUtils.isNotEmpty(tableName)) { sql += " and table_name like '%" + tableName + "%'"; } if (StringUtils.isNotEmpty(columes)) { sql += " and columes like '%" + columes + "%'"; } if (StringUtils.isNotEmpty(beginDate) && StringUtils.isNotEmpty(endDate)) { sql += " and table_access_last_time > '" + beginDate + "' and table_access_last_time < '" + endDate + "'"; } String pageSize = getParam(request, "rows"); String pageNo = getParam(request, "page"); if (pageSize == null) pageSize = "10"; if (pageNo == null) pageNo = "1"; List<TlogDbsql> list = tlogDbsqlService.getPageDataBySQL(TlogDbsql.class, sql, Integer.parseInt(pageSize), Integer.parseInt(pageNo)); int total = tlogDbsqlService.getTotalNumBySQL(sql); int rows = Integer.parseInt(pageSize); int pages = total % rows == 0 ? (total / rows) : (total / rows + 1); mv.addObject("userid", userid); mv.addObject("tableName", tableName); mv.addObject("columes", columes); mv.addObject("beginDate", beginDate); mv.addObject("endDate", endDate); mv.addObject("total", total); mv.addObject("rows", pageSize); mv.addObject("page", Integer.parseInt(pageNo)); mv.addObject("pages", pages); mv.addObject("list", list); return mv; }
From source file:com.hihsoft.sso.sysmonitor.syslogs.web.controller.TlogLoginlogController.java
/** * // ww w .jav a2 s .c o m * * @param request * @param response * @return * @throws Exception */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView("loginlog/tlogloginloglist"); String sql = "select logid, ipaddr, logintime, logouttime, onlinetime, u.username as userid, logout, o.orgname as orgid from t_log_loginlog l,t_acl_userinfo u,t_sys_org o where l.userid = u.userid and l.orgid=o.orgid"; TlogLoginlog tlogLoginlog = new TlogLoginlog(); Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String userid = (String) filter.get("userid"); String orgid = (String) filter.get("orgid"); String ipaddr = (String) filter.get("ipaddr"); String beginDate = (String) filter.get("beginDate"); String endDate = (String) filter.get("endDate"); if (StringUtils.isNotEmpty(userid)) { sql += " and u.username like '%" + userid + "%'"; } if (StringUtils.isNotEmpty(orgid)) { sql += " and o.orgname like '%" + orgid + "%'"; } if (StringUtils.isNotEmpty(ipaddr)) { sql += " and ipaddr like '%" + ipaddr + "%'"; } if (StringUtils.isNotEmpty(beginDate) && StringUtils.isNotEmpty(endDate)) { sql += " and logintime > '" + beginDate + "' and logintime < '" + endDate + "'"; } this.bind(request, tlogLoginlog); String pageSize = getParam(request, "rows"); String pageNo = getParam(request, "page"); if (pageSize == null) pageSize = "10"; if (pageNo == null) pageNo = "1"; List<TlogLoginlog> list = tlogLoginlogService.getPageDataBySQL(TlogLoginlog.class, sql, Integer.parseInt(pageSize), Integer.parseInt(pageNo)); int total = tlogLoginlogService.getTotalNumBySQL(sql); int rows = Integer.parseInt(pageSize); int pages = total % rows == 0 ? (total / rows) : (total / rows + 1); mv.addObject("beginDate", beginDate); mv.addObject("endDate", endDate); mv.addObject("userid", userid); mv.addObject("orgid", orgid); mv.addObject("ipaddr", ipaddr); mv.addObject("total", total); mv.addObject("rows", pageSize); mv.addObject("page", Integer.parseInt(pageNo)); mv.addObject("pages", pages); mv.addObject("list", list); return mv; }
From source file:com.hihsoft.sso.sysmonitor.syslogs.web.controller.TlogSysexceptionController.java
/** * * @param request/* w w w . ja v a 2 s . c o m*/ * @param response * @return * @throws Exception */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView("sysexception/tlogsysexceptionlist"); String sql = "select exception_oid, exception_times, exception_lasttime, exception_name, exception_msg, exception_class, u.username as userid from t_log_sysexception l,t_acl_userinfo u where l.userid = u.userid"; // String sql = "select * from t_log_sysexception"; Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String userid = (String) filter.get("userid"); String exceptionName = (String) filter.get("exceptionName"); String beginDate = (String) filter.get("beginDate"); String endDate = (String) filter.get("endDate"); String exceptionClass = (String) filter.get("exceptionClass"); if (StringUtils.isNotEmpty(userid)) { sql += " and u.username like '%" + userid + "%'"; } if (StringUtils.isNotEmpty(exceptionName)) { sql += " and exception_name like '%" + exceptionName + "%'"; } if (StringUtils.isNotEmpty(exceptionClass)) { sql += " and exception_class like '%" + exceptionClass + "%'"; } if (StringUtils.isNotEmpty(beginDate) && StringUtils.isNotEmpty(endDate)) { sql += " and exception_lasttime > '" + beginDate + "' and exception_lasttime < '" + endDate + "'"; } String pageSize = getParam(request, "rows"); String pageNo = getParam(request, "page"); if (pageSize == null) pageSize = "10"; if (pageNo == null) pageNo = "1"; List<TlogSysexception> list = tlogSysexceptionService.getPageDataBySQL(TlogSysexception.class, sql, Integer.parseInt(pageSize), Integer.parseInt(pageNo)); int total = tlogSysexceptionService.getTotalNumBySQL(sql); int rows = Integer.parseInt(pageSize); int pages = total % rows == 0 ? (total / rows) : (total / rows + 1); mv.addObject("userid", userid); mv.addObject("exceptionName", exceptionName); mv.addObject("beginDate", beginDate); mv.addObject("endDate", endDate); mv.addObject("exceptionClass", exceptionClass); mv.addObject("total", total); mv.addObject("rows", pageSize); mv.addObject("page", Integer.parseInt(pageNo)); mv.addObject("pages", pages); mv.addObject("list", list); return mv; }
From source file:com.hihsoft.sso.business.web.controller.TsysModuleinfoController.java
/** * /* www.ja v a 2 s . c o m*/ * * @param request * @param response * @return * @throws Exception */ @SuppressWarnings("unchecked") @RequestMapping(params = "method=list") public ModelAndView list(final HttpServletRequest request, final HttpServletResponse response) throws ControllerException { Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String orders = getParam(request, "orders"); String hql = "from TsysModuleinfo t where 1=1"; String modulename = (String) filter.get("modulename"); if (StringUtils.isNotEmpty(modulename)) { hql += " and t.modulename like '%" + modulename + "%'"; } String moduleno = (String) filter.get("moduleno"); if (StringUtils.isNotEmpty(moduleno)) { hql += " and t.moduleno like '%" + moduleno + "%'"; } if (orders != null && !"".equals(orders)) hql += " order by " + orders; addOrders(request, orders); List list = calcPage(request, tsysModuleinfoService, hql); request.setAttribute("list", list); return new ModelAndView("/module/tsysmodulelist"); }
From source file:com.hihsoft.sso.sysmonitor.syslogs.web.controller.TlogBusinesslogController.java
/** * * @param request/* w ww .j av a 2s .co m*/ * @param response * @return * @throws Exception */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView("businesslog/tlogbusinessloglist"); String sql = "select logid, create_date, custip, m.modulename as moduleid, p.operatename as operateid, o.orgname as orgid, u.username as userid from t_log_businesslog l,t_sys_moduleinfo m,t_Sys_Moduleoperate p,t_acl_userinfo u,t_sys_org o where l.moduleid=m.moduleid and l.operateid=p.operateid and l.orgid=o.orgid and l.userid=u.userid"; Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String userid = (String) filter.get("userid"); String orgid = (String) filter.get("orgid"); String custip = (String) filter.get("custip"); String beginDate = (String) filter.get("beginDate"); String endDate = (String) filter.get("endDate"); if (StringUtils.isNotEmpty(userid)) { sql += " and u.username like '%" + userid + "%'"; } if (StringUtils.isNotEmpty(orgid)) { sql += " and o.orgname like '%" + orgid + "%'"; } if (StringUtils.isNotEmpty(custip)) { sql += " and custip like '%" + custip + "%'"; } if (StringUtils.isNotEmpty(beginDate) && StringUtils.isNotEmpty(endDate)) { sql += " and create_date > '" + beginDate + "' and create_date < '" + endDate + "'"; } String pageSize = getParam(request, "rows"); String pageNo = getParam(request, "page"); if (pageSize == null) pageSize = "10"; if (pageNo == null) pageNo = "1"; List<TlogBusinesslog> list = tlogBusinesslogService.getPageDataBySQL(TlogBusinesslog.class, sql, Integer.parseInt(pageSize), Integer.parseInt(pageNo)); int total = tlogBusinesslogService.getTotalNumBySQL(sql); int rows = Integer.parseInt(pageSize); int pages = total % rows == 0 ? (total / rows) : (total / rows + 1); mv.addObject("beginDate", beginDate); mv.addObject("endDate", endDate); mv.addObject("userid", userid); mv.addObject("orgid", orgid); mv.addObject("custip", custip); mv.addObject("total", total); mv.addObject("rows", pageSize); mv.addObject("page", Integer.parseInt(pageNo)); mv.addObject("pages", pages); mv.addObject("list", list); return mv; }
From source file:com.hihsoft.sso.business.web.controller.TsysDutyController.java
/** * //from w w w . j a v a 2 s . co m * * @param request * @param response * @return * @throws ControllerException */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView("/duty/tsysdutylist"); String hql = "from TsysDuty t where 1=1"; Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String orders = getParam(request, "orders"); String dutyname = (String) filter.get("dutyname"); if (StringUtils.isNotEmpty(dutyname)) { hql += " and t.dutyname like '%" + dutyname + "%'"; } if (orders != null && !"".equals(orders)) hql += " order by " + orders; addOrders(request, orders); List<TsysDuty> list = calcPage(request, tsysDutyService, hql); convertParam(list, "dutySort", "DUTYSORT"); convertParam(list, "dutyType", "dutytype"); mv.addObject("list", list); mv.addObject("dutyname", dutyname); return mv; }
From source file:com.hihsoft.sso.business.web.controller.TaclRoleController.java
/** * /*from www.j av a2 s . co m*/ * * @param request * @param response * @return * @throws ControllerException */ @RequestMapping(params = "method=list") public ModelAndView list(HttpServletRequest request, HttpServletResponse response) throws ControllerException { ModelAndView mv = new ModelAndView("role/taclrolelist"); TaclUserinfo user = (TaclUserinfo) request.getSession().getAttribute(Consts.USER_INFO); String hql = "from TaclRole t where 1=1"; TaclRole taclRole = new TaclRole(); Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String rolename = (String) filter.get("rolename"); boolean falg = true; if (StringHelpers.notNull(rolename)) { hql += " and t.rolename like '%" + rolename + "%'"; mv.addObject("rolename", rolename); falg = false; } /*if(StringHelpers.notNull(rolesort)){ hql += " and t.rolesort = '"+rolesort+"'"; mv.addObject("rolesort",rolesort); }*/ boolean isGroup = isGroup(request, response); // ?? if (StringHelpers.notNull(user.getOrgid()) && falg) { if (isGroup) { hql += " and (t.roleSort =1 or t.roletype=1)"; } else { TsysOrg orgid = tsysOrgService.getTsysOrgById(user.getOrgid()); String orgids = orgid.getOrgid(); if (orgid.getOrgSort().equals("2")) { orgids = returnOrgId(orgid.getOrgid()); } hql += " and (t.orgid in('" + orgids + "') and t.roleSort=2) or (t.roletype in(" + getRoleTypeLower(request, response) + ") and t.roleSort=1)"; } } this.bind(request, taclRole); String pageSize = getParam(request, "rows"); String pageNo = getParam(request, "page"); String orders = getParam(request, "orders"); if (orders != null && !"".equals(orders)) hql += " order by " + orders; addOrders(request, orders); if (pageSize == null) pageSize = "15"; if (pageNo == null) pageNo = "1"; @SuppressWarnings("unchecked") List<TaclRole> list = (List<TaclRole>) taclRoleService.getPageDataByHQL(hql, Integer.parseInt(pageSize), Integer.parseInt(pageNo)); for (TaclRole role : list) { TsysOrg org = role.getTsysOrg(); if (org != null) role.setOrgid(org.getOrgname()); } int total = taclRoleService.getDataTotalNum(hql); int rows = Integer.parseInt(pageSize); int pages = total % rows == 0 ? (total / rows) : (total / rows + 1); convertParam(list, "roletype", "roleType"); convertParam(list, "roleSort", "rolesort"); List<TsysParameter> selectRole = getRoleType(request, response); mv.addObject("isGroup", isGroup); mv.addObject("selectRole", selectRole); mv.addObject("total", total); mv.addObject("rows", pageSize); mv.addObject("page", Integer.parseInt(pageNo)); mv.addObject("pages", pages); mv.addObject("list", list); mv.addObject("rolename", rolename); mv.addObject("isGroup", isGroup); return mv; }
From source file:com.xyz.util.WebDataUtil.java
/** * ?PropertyFilter??Request?,PropertyFilter. * PropertyFilter??Filter?__??./*from w w w . j a va 2 s.c o m*/ * * eg. * filter_EQUAL_name * filter_LIKE_name_OR_email */ @SuppressWarnings("unchecked") public static List<PropertyFilter> buildPropertyFilters(final HttpServletRequest request, final String filterPrefix) { List<PropertyFilter> filterList = new ArrayList<PropertyFilter>(); //request??????,?????Map. Map<String, Object> filterParamMap = WebUtils.getParametersStartingWith(request, filterPrefix); //??Map,PropertyFilter for (Map.Entry<String, Object> entry : filterParamMap.entrySet()) { String filterName = entry.getKey(); String value = entry.getValue().toString(); //value,filter. boolean omit = StringUtils.isBlank(value); if (!omit) { PropertyFilter filter = new PropertyFilter(filterName, value); filterList.add(filter); } } return filterList; }
From source file:com.hihsoft.sso.business.web.controller.TsysModuleinfoController.java
/** * /* w w w. j a v a 2 s . c o m*/ * * @param request * @param response * @return * @throws Exception * add by panyt 2013-07-21 */ @SuppressWarnings("unchecked") @RequestMapping(params = "method=queryModule") public ModelAndView queryModule(final HttpServletRequest request, final HttpServletResponse response) throws ControllerException { Map<String, Object> filter = WebUtils.getParametersStartingWith(request, "srh_");// ? String moduleId = request.getParameter("moduleid"); if (StringUtils.isBlank(moduleId)) { return null; } String hql = "from TsysModuleinfo t where t.moduleid = ?"; ModelAndView mv = new ModelAndView("/module/tsysmodulelist"); List list = calcPage(request, tsysModuleinfoService, hql, moduleId); mv.addObject("list", list); mv.addObject("moduleid", moduleId); return mv; }
From source file:com.thinkmore.framework.orm.hibernate.HibernateWebUtils.java
/** * ?PropertyFilter??Request?,PropertyFilter. * PropertyFilter??Filter?__??./*from w ww.j a v a 2s. c om*/ * * eg. * filter_EQS_name * filter_LIKES_name_OR_email */ public static List<PropertyFilter> buildPropertyFilters(final HttpServletRequest request, final String filterPrefix) { List<PropertyFilter> filterList = new ArrayList<PropertyFilter>(); //request??????,?????Map. Map<String, Object> filterParamMap = WebUtils.getParametersStartingWith(request, filterPrefix); //??Map,PropertyFilter for (Map.Entry<String, Object> entry : filterParamMap.entrySet()) { String filterName = entry.getKey(); String value = String.valueOf(entry.getValue()); //value,filter. if (StringUtils.isNotBlank(value)) { PropertyFilter filter = new PropertyFilter(filterName, value); filterList.add(filter); } } return filterList; }