日期:2014-05-17 浏览次数:20867 次
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%> <%@page import="com.ultrapower.report.component.Create"%> <%@page import="java.util.HashMap"%> <%@page import="com.ultrapower.report.rpt.session.SessionInfo"%> <%@page import="com.ultrapower.report.rpt.session.SessionManager"%> <%@page import="com.ultrapower.report.rpt.DirectTable"%> <%@page import="com.ultrapower.report.rpt.sql.ReBuildSQL"%> <%@page import="com.ultrapower.report.rpt.sql.SQLHandler"%> <% String ctxPath = request.getContextPath(); //String iam=request.getParameter("iam"); //SessionInfo sessionInfo=SessionManager.getSessionInfo(iam); String deparmentid=request.getParameter("deparmentid"); final String sqlname="nmr.tjbomc.capse.error_kpi_day"; List list=new ArrayList(); StringBuffer optionstr=new StringBuffer(); String result=""; DirectTable dt = new DirectTable(sqlname); ReBuildSQL rb = dt.getReBuildSql(); rb.setNestSQL(1, deparmentid); dt.setReturnType(SQLHandler.Return_ArrayListRow); dt.executeSql(); list=dt.getSqlResult(); for (int i=0;i<list.size();i++) {ArrayList rowlist=new ArrayList(); rowlist =(ArrayList) list.get(i); String id=(String)rowlist.get(0); String name=(String)rowlist.get(1); optionstr.append("|"+id+"$"+name); } optionstr.append("|"); result=optionstr.toString(); result="|Resperson$----全部----|"+result; out.print(result); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>My JSP 'response.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> </body> </html>