新写的jsp,选多人的条件，列表数据加连接

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.velcro.base.BaseContext" %>
<%@ include file="/vbase/init.jsp"%>
<%@ page import="com.velcro.workflow.report.service.ReportdefService"%>
<%@ page import="com.velcro.workflow.report.model.Reportdef"%>
<%@ page import="com.velcro.base.Page"%>
<%@ page import="com.velcro.base.selectitem.model.Selectitem"%>
<%@ page import="com.velcro.base.selectitem.service.SelectitemService"%>
<%@ page import="com.velcro.kernel.base.IDataService" %>
<%@ page import="com.velcro.kernel.workflow.report.service.IReportdefService" %>
<%@ page import="static org.nutz.mvc.Mvcs.getServletContext" %>
<%@ page import="com.velcro.base.orgunit.service.OrgunitService" %>
<%@ page import="com.velcro.document.base.service.DocbaseService" %>
<%
    IDataService  dateservice= (IDataService) BaseContext.getBean(request,"dataService");
    HumresService humresService= (HumresService)BaseContext.getBean(request,"humresService");
    OrgunitService orgunitService = (OrgunitService)BaseContext.getBean(request,"orgunitService");
    SelectitemService selectitemService=(SelectitemService)BaseContext.getBean(request,"selectitemService");
    DocbaseService docbaseService = (DocbaseService) BaseContext.getBean(getServletContext(), "docbaseService");

    String nameid = StringHelper.null2String(request.getParameter("nameid"));//企业名称id
    String bMentorid = StringHelper.null2String(request.getParameter("bMentorid"));  //企业导师id
    String sMentorid = StringHelper.null2String(request.getParameter("sMentorid"));  //学术导师id
    String createdates = StringHelper.null2String(request.getParameter("createdate"));//开始时间
    String createdates_1 = StringHelper.null2String(request.getParameter("createdate_1"));//结束时间

    String selectSql = "select * from ufe4f3l71655105091655 where 1=1 and (isdelete is null or isdelete=0) ";

    if (StringHelper.isNotEmpty(createdates)){
        selectSql=selectSql + "and field012 >='"+createdates+"' ";
    }
    if (StringHelper.isNotEmpty(createdates_1)){
        selectSql=selectSql + "and field012 <='"+createdates_1+"' ";
    }
    //合作机构
    if (StringHelper.isNotEmpty(nameid)){
        selectSql=selectSql + "and field002 ='"+nameid+"' ";
    }
    String nameidspan=dateservice.getValue("select field001 from ufe7q3i81625135784770 where id='"+nameid+"'");

    //获取企业导师id
    String bMentoridname="";
    if (StringHelper.isNotEmpty(bMentorid)){
        String[] objnames = new String[0];
        objnames = bMentorid.split(",");
        String bMentorids="";
        for (int i=0;i<objnames.length;i++){
            if (i==objnames.length-1){
                bMentorids=bMentorids+"'"+objnames[i]+"'";
            }else {
                bMentorids=bMentorids+"'"+objnames[i]+"'"+",";
            }
        }
        selectSql=selectSql + " and field005 like '%"+bMentorid+"%' ";
        bMentoridname=dateservice.getValue("select objname from humres where id in ("+bMentorids+")");//企业导师名称
    }

    //学视导师名称
    String sMentoridspan="";
    if (StringHelper.isNotEmpty(sMentorid)){
        String[] objnames = new String[0];
        objnames = sMentorid.split(",");
        String sMentorids="";
        for (int i=0;i<objnames.length;i++){
            if (i== objnames.length -1){
                sMentorids=sMentorids+"'"+objnames[i]+"'";
            }else {
                sMentorids=sMentorids+"'"+objnames[i]+"'"+",";
            }
        }
        selectSql=selectSql + " and field006 like '%"+sMentorid+"%' ";
        sMentoridspan=dateservice.getValue("select objname from humres where id in ("+sMentorids+")");
    }

    selectSql=selectSql+" order by field001 asc";
//    System.out.println(selectSql);

    int pageno = NumberHelper.string2Int((String) request.getParameter("pageno"), 1);
    int pagesize = NumberHelper.string2Int((String) request.getParameter("pagesize"), 10);
    Page pageObject = (Page) dateservice.pagedQuery(selectSql, pageno, pagesize);
    List list = new ArrayList();
    if (pageObject.getTotalSize() != 0) {
        list = (List) pageObject.getResult();
    }

%>
<html>
<head>
    <script type="text/javascript" src="/vjs/sack.js"></script>
    <script type="text/javascript" src="/vjs/base/ShowHide.js"></script>
    <script type="text/javascript" src="/vjs/base/ListTable.js"></script>
    <script src="/kms/js/My97DatePicker/WdatePicker.js"></script>
    <script src="/vjs/base/InputMsg.js" type="text/javascript"></script>
    <script src="/vjs/base/DataHelper.js" type="text/javascript"></script>
    <script src="/vjs/browser.js" type="text/javascript"></script>
    <script src="/vjs/selectitemjs.js" type="text/javascript"></script>
    <script type="text/javascript"
            src="/vkm/vnc/treeframe/knowledge/js/jquery-latest.js"></script>
    <script type="text/javascript"
            src="/vkm/vnc/treeframe/knowledge/js/jquery-ui-latest.js"></script>
    <script type="text/javascript"
            src="/vkm/vnc/treeframe/knowledge/js/jquery.layout-latest.js"></script>
    <script language="JScript.Encode" src="/vjs/rtxint.js"></script>
    <script language="JScript.Encode" src="/vjs/browinfo.js"></script>
    <link rel="stylesheet" href="/vcss/doc/reset.css">
    <link rel="stylesheet" href="/vcss/doc/iconfont.css">
    <link rel="stylesheet" href="/vcss/doc/mail.css">
    <link href="/kms/css/kms-datagrid.css" rel="stylesheet" type="text/css">
    <link href="/kms/js/My97DatePicker/skin/WdatePicker.css" rel="stylesheet" type="text/css">
    <style>
        .direct-search{
            margin: 10px 0px 10px 0px;
            display: flex;
        }
    </style>

</head>
<body>
<div class="mW2">
    <div class="pB">
        <form action="" id="velcroForm" name="VelcroForm" method="post">
            <div class="direct-right-search">
                <button  class="btn" id="button_S" accesskey="S" onclick="javascript:onSubmit() " type="button">搜索(s)</button>
                <button type="button" id="button_C" class="btn" accesskey="C" onclick="javascript:window.open('/ServiceAction/com.velcro.workflow.workflow.servlet.WfViewAction?pipeid=4028848f814bb35801815c05d1a7065e&amp;targeturl=') ">新增(C)</button>
            </div>
            <div class="direct-search">
                <span>企业名称:</span>
                <input name="nameid" id="nameid" type="hidden" value="<%=nameid%>">
                <input id="nameidspan" type="text" readOnly="readonly" value="<%=nameidspan%>">
                <button class="icoR iRSin" onclick="javascript:getrefobjwf('nameid','nameidspan','4028848f7a2d942c017a61ab992a1769','','0');" type="button"></button>

                <span>企业导师:</span>
                <input name="bMentorid" id="bMentorid" type="hidden" value="<%=bMentorid%>">
                <input id="bMentoridsspan" type="text" readOnly="readonly" value="<%=bMentoridname%>">
                <button class="icoR iRSin" onclick="javascript:getrefobjwf('bMentorid','bMentoridsspan','4028848f7bf3eefd017c10a49a3a16f2','','0');" type="button"></button>

                <span>学术导师:</span>
                <input name="sMentorid" id="sMentorid" type="hidden" value="<%=sMentorid%>">
                <input id="sMentoridspan" type="text" readOnly="readonly" value="<%=sMentoridspan%>">
                <button class="icoR iRSin" onclick="javascript:getrefobjwf('sMentorid','sMentoridspan','4028848f7bf3eefd017c10a49a3a16f2','','0');" type="button"></button>


                <span>填报日期:</span>
                <input name="createdate" class="dateIpt" id="createdate" type="text" value="<%=createdates%>">
                <button class="icoR iRDat" onclick="WdatePicker({el:$dp.$('createdate')})" type="button"></button>
                -
                <input name="createdate_1" class="dateIpt" id="createdate_1" type="text" value="<%=createdates_1%>">
                <button class="icoR iRDat" onclick="WdatePicker({el:$dp.$('createdate_1')})" type="button">
                </button>
            </div>

                <div class="direct-right-table">
                    <div class="right-table-wrap">
                        <table id="tb_1">
                            <tr class="direct-table-tr">
                                <th  style="width:4%;text-align: left;!important;border: 1px solid #c5d1ee">序号</th>
                                <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">企业名称 </th>
                                <th style="width:16%;text-align: left;!important;border: 1px solid #c5d1ee">企业介绍 </th>
                                <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">企业导师</th>
                                <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">学术导师</th>
                                <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">学生名单</th>
                                <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">课题资料</th>
                               <th style="width:10%;text-align: left;!important;border: 1px solid #c5d1ee">课题成果 </th>
                            </tr>
                            <%
                                int h=0;
                                for (int i = 0; i < list.size(); i++) {
                                    Map map = (Map) list.get(i);
                                    String ids=StringHelper.null2String(map.get("id"));
                                    String noid=StringHelper.null2String(map.get("field001"));//序号
                                    String businessName=StringHelper.null2String(map.get("field002"));   //企业名称
                                    String introduce=StringHelper.null2String(map.get("field004"));//企业介绍
                                    String businessMentor=StringHelper.null2String(map.get("field005"));//企业导师
                                    String scienceMentor=StringHelper.null2String(map.get("field006"));//学术导师
                                    String students=StringHelper.null2String(map.get("field007"));//学生名单
                                    String subjectData=StringHelper.null2String(map.get("field008"));//课题资料
                                    String achievements=StringHelper.null2String(map.get("field009"));//课题成果

                                    //企业名称
                                    String qyid="select field001 from ufe7q3i81625135784770 where id='"+businessName+"' ";
                                    String qyname = dateservice.getValue(qyid);

                                    //企业导师名称
                                    String[] bmids = new String[0];
                                    bmids = businessMentor.split(",");
                                    String bmnames="";
                                    for (int j=0;j<bmids.length;j++){
                                        String sql="select objname from humres where id='"+bmids[j]+"'";
                                        String hname = dateservice.getValue(sql);
                                        String append="<a href='/kms/expert/view.do?id="+bmids[j]+"' target='_blank'>"+hname+"</a>";
                                        if (j == bmids.length -1){
                                            bmnames+=append;
                                        }else {
                                            bmnames+=append+",";
                                        }

                                    }

                                    //学术导师名称
                                    String[] smids = new String[0];
                                    smids = scienceMentor.split(",");
                                    String smnames="";
                                    for (int j=0;j<smids.length;j++){
                                        String sql="select objname from humres where id='"+smids[j]+"'";
                                        String hname = dateservice.getValue(sql);
                                        String append="<a href='/kms/expert/view.do?id="+smids[j]+"' target='_blank'>"+hname+"</a>";
                                        if (j == smids.length -1 ){
                                            smnames+=append;
                                        }else {
                                            smnames+=append+",";
                                        }

                                    }

                                    //学生名单
                                    String[] studentids = new String[0];
                                    studentids = students.split(",");
                                    String stnames="";
                                    for (int j=0;j<studentids.length;j++){
                                        String sql="select objname from humres where id='"+studentids[j]+"'";
                                        String hname = dateservice.getValue(sql);
                                        String append="<a href='/ServiceAction/com.velcro.nc.vbase.action.urlLinkRequestAction?action=personView&id="+studentids[j]+"' target='_blank'>"+hname+"</a>";
                                        if (j == studentids.length -1 ){
                                            stnames+=append;
                                        }else {
                                            stnames+=append+",";
                                        }

                                    }

                                    //企业介绍多个introduce的id
                                    String[] introduceids=new String[0];
                                    introduceids=introduce.split(",");
                                    String intrNames="";
                                    for (int j=0; j<introduceids.length;j++){
                                        String sql="select subject from docbase where id='"+introduceids[j]+"'";
                                        String sname= dateservice.getValue(sql);
                                        String append="<a target='_blank' href='/vdocument/base/docbaseview.jsp?id="+introduceids[j]+"'>"+sname+"</a>";
                                        if (j==introduceids.length-1){
                                            intrNames+=append;
                                        }else {
                                            intrNames+=append+",";
                                        }
                                    }


                            %>
                            <tr>
                                <td><%=i+1%></td>
                                <td><a target="_blank" href="/kms/educourse/organizationview.jsp?id=<%=businessName%>&formid=4028848f814bb35801815bf3f7170629"><%=qyname%></a></td>
                                <td><%=StringHelper.convertHtmlString(intrNames.toString())%></td>
                                <td><%=StringHelper.convertHtmlString(bmnames.toString())%></td>
                                <td><%=StringHelper.convertHtmlString(smnames.toString())%></td>
                                <td><%=stnames%></td>
                                <td><%=subjectData%></td>
                                <td><%=achievements%></td>
                            </tr>

                            <%}
                            %>
                        </table>

                    </div>
                </div>
                <%@ include file="/vbase/pagenavigator.jsp"%>
        </form>
    </div>
</div>
<%--<script src="/vjs/jquery/jquery.min.js" type="text/javascript"></script>--%>
<%--<script src="/home/js/mail.js"></script>--%>
<script language="javascript" type="text/javascript">
    function onSubmit(){
        document.VelcroForm.pageno.value="1";
        document.VelcroForm.submit();
    }
    new vjs.base.ListTable({table:'#vTable'});
</script>
<script type="text/javascript">
    var tTD; //用来存储当前更改宽度的Table Cell,避免快速移动鼠标的问题
    var table = document.getElementById("tb_1");
    for (j = 0; j < table.rows[0].cells.length; j++) {
        table.rows[0].cells[j].onmousedown = function () {
            //记录单元格
            tTD = this;
            if (event.offsetX > tTD.offsetWidth - 10) {
                tTD.mouseDown = true;
                tTD.oldX = event.x;
                tTD.oldWidth = tTD.offsetWidth;
            }
            //记录Table宽度
            //table = tTD; while (table.tagName != ‘TABLE') table = table.parentElement;
            //tTD.tableWidth = table.offsetWidth;
        };
        table.rows[0].cells[j].onmouseup = function () {
            //结束宽度调整
            if (tTD == undefined) tTD = this;
            tTD.mouseDown = false;
            tTD.style.cursor = 'default';
        };
        table.rows[0].cells[j].onmousemove = function () {
            //更改鼠标样式
            if (event.offsetX > this.offsetWidth - 10)
                this.style.cursor = 'col-resize';
            else
                this.style.cursor = 'default';
            //取出暂存的Table Cell
            if (tTD == undefined) tTD = this;
            //调整宽度
            if (tTD.mouseDown != null && tTD.mouseDown == true) {
                tTD.style.cursor = 'default';
                if (tTD.oldWidth + (event.x - tTD.oldX) > 0)
                    tTD.width = tTD.oldWidth + (event.x - tTD.oldX);
                //调整列宽
                tTD.style.width = tTD.width;
                tTD.style.cursor = 'col-resize';
                //调整该列中的每个Cell
                table = tTD; while (table.tagName != 'TABLE') table = table.parentElement;
                for (j = 0; j < table.rows.length; j++) {
                    table.rows[j].cells[tTD.cellIndex].width = tTD.width;
                }
                //调整整个表
                //table.width = tTD.tableWidth + (tTD.offsetWidth – tTD.oldWidth);
                //table.style.width = table.width;
            }
        };
    }
</script>


</body>
</html>