zhsoft.jsp

一个利用javabeanjsp产生联动分布的源代码

            break;
        }
    }
    if (found==false&&group_rr.length>0) {
        group_id = group_rr[0].getValue(COLUMN_NAME_OF_VALUE);
    }

    //候选列表框信息初始化
    if (candidate_pageno<1||candidate.isInit()==false||apply_flag>0) {
        candidate.init("SELECT * FROM TEST_USER WHERE ID NOT IN ( SELECT USER_ID FROM GROUP_USER WHERE GROUP_ID='"+group_id+"' )",LINES_PER_PAGE);
        if (apply_flag>0) {
            if (candidate_pageno<1) {
                candidate_pageno = 1;
            } else {
                if (candidate_pageno>candidate.getTotalPages()) {
                    candidate_pageno = candidate.getTotalPages();
                }
            }
        } else {
            candidate_pageno = 1;
        }
    } else {
        if (candidate_pageno>candidate.getTotalPages()) {
            candidate_pageno = candidate.getTotalPages();
        }
    }
    candidate_rr = candidate.getPage(candidate_pageno);

    //当前列表框信息初始化
    if (current_pageno<1||current.isInit()==false||apply_flag>0) {
        current.init("SELECT * FROM TEST_USER WHERE ID IN ( SELECT USER_ID FROM GROUP_USER WHERE GROUP_ID='"+group_id+"' )",LINES_PER_PAGE);
        if (apply_flag>0) {
            if (current_pageno<1) {
                current_pageno = 1;
            } else {
                if (current_pageno>current.getTotalPages()) {
                    current_pageno = current.getTotalPages();
                }
            }
        } else {
            current_pageno = 1;
        }
    } else {
        if (current_pageno>current.getTotalPages()) {
            current_pageno = current.getTotalPages();
        }
    }
    current_rr = current.getPage(current_pageno);
   
%>
<table width="100%" border="0">
<tr>
<td align="center" colspan=3><font color=red><u>联动式分页列表框示范页面</u></font></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align=right style="font-size:16px">作者：<b>雨亦奇</b>([e-mail])</td>
<td>&nbsp;</td>
</tr>
</table>
<table width="100%" border="1" cellpadding="1" bgcolor="#FFCC66" >
  <tr align=center > 
    <td width="32%">可供选择的组(<%= group_pageno %>/<%= group.getTotalPages() %>)</td>
    <td width="29%">不在当前组中的用户(<%= candidate_pageno %>/<%= candidate.getTotalPages() %>)</td>
    <td width="11%">操作</td>
    <td width="28%">当前组中的用户(<%= current_pageno %>/<%= current.getTotalPages() %>)</td>
  </tr>
  <tr valign="middle"> 
    <td height="313"><table width="100%" height="310" border="0" cellpadding="1">
        <tr valign="middle"> 
          <td width="90%"><form action="" method="post" name="formGroup" id="formGroup">
              <select name="group_id" size="<%= SELECT_LINES %>" class="chooserList" onchange="submit()">
              <%
                for (int i=0;i<group_rr.length;i++) {
              %>
              <option value="<%= group_rr[i].getValue(COLUMN_NAME_OF_VALUE) %>" <% if (group_rr[i].getValue(COLUMN_NAME_OF_VALUE).equals(group_id)) out.print("selected"); %>><%= group_rr[i].getValue(COLUMN_NAME_OF_LABEL) %></option>
              <%
                }
              %>
              </select>
            <input type=hidden name="group_pageno" value="<%= group_pageno %>">
            <input type=hidden name="candidate_pageno" value="0">
            <input type=hidden name="current_pageno" value="0">
            </form></td>
          <td width="10%"><form name="formGroupButtonUp" method="post" action="" onsubmit="return verify(formGroupButtonUp);">
<%
    if (group_pageno==1) {
%>
              <input disabled name="up" type="image" src="images/arrowUp_disabled.gif" alt="上一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="up" type="image" src="images/arrowUp.gif" alt="上一页" width="24" height="24" border="0">
              <input type="hidden" name="group_pageno" value="<%= (group_pageno-1) %>">
              <input type=hidden name="candidate_pageno" value="0">
              <input type=hidden name="current_pageno" value="0">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
</form>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
<form name="formGroupButtonDown" method="post" action="" onsubmit="return verify(formGroupButtonDown);">
<%
    if (group_pageno==group.getTotalPages()) {
%>
              <input disabled name="down" type="image" src="images/arrowDown_disabled.gif" alt="下一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="down" type="image" src="images/arrowDown.gif" alt="下一页" width="24" height="24" border="0">
              <input type="hidden" name="group_pageno" value="<%= (group_pageno+1) %>">
              <input type=hidden name="candidate_pageno" value="0">
              <input type=hidden name="current_pageno" value="0">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
            </form>
</td>
        </tr>
      </table></td>
    <td>
<table width="100%" height="310" border="0" cellpadding="1">
        <tr valign="middle"> 
          <td width="90%"><form action="" method="post" name="formCandidate" id="formCandidate">
              <select name="select" size="<%= SELECT_LINES %>" multiple class="chooserList"  onChange="clearSelected(formCurrent.select);buttonChanged('del','add');">
                <%
                    for (int i=0;i<candidate_rr.length;i++) {
                %>
                <option value="<%= candidate_rr[i].getValue(COLUMN_NAME_OF_VALUE) %>"><%= candidate_rr[i].getValue(COLUMN_NAME_OF_LABEL) %></option>
                <%
                    }
                %>
              </select>
            </form></td>
          <td width="10%"><form name="formCandidateButtonUp" method="post" action="" onsubmit="return verify(formCandidateButtonUp);">
<%
    if (candidate_pageno==1) {
%>
              <input disabled name="up" type="image" src="images/arrowUp_disabled.gif" alt="上一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="up" type="image" src="images/arrowUp.gif" alt="上一页" width="24" height="24" border="0">
              <input type=hidden name="group_pageno" value="<%= group_pageno %>">
              <input type=hidden name="candidate_pageno" value="<%= (candidate_pageno-1) %>">
              <input type=hidden name="current_pageno" value="<%= current_pageno %>">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
</form>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
<form name="formCandidateButtonDown" method="post" action="" onsubmit="return verify(formCandidateButtonDown);">
<%
    if (candidate_pageno==candidate.getTotalPages()) {
%>
              <input disabled name="down" type="image" src="images/arrowDown_disabled.gif" alt="下一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="down" type="image" src="images/arrowDown.gif" alt="下一页" width="24" height="24" border="0">
              <input type=hidden name="group_pageno" value="<%= group_pageno %>">
              <input type=hidden name="candidate_pageno" value="<%= (candidate_pageno+1) %>">
              <input type=hidden name="current_pageno" value="<%= current_pageno %>">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
            </form>
</td>
        </tr>
      </table>	
	</td>
    <td align="center" valign="middle"><form name="formAction" method="post" action="apply.jsp">
          <input disabled id="add" name="add" type="image" src="images/arrowRight_disabled.gif" alt="添加" width="24" height="24" border="0" onClick="myadd();return false;">
          <br>
        <br>
        <input disabled id="del" name="del" type="image" src="images/arrowLeft_disabled.gif" alt="删除" width="24" height="24" border="0" onClick="mydel();return false;">
        <br>
        <br>
              <input type=hidden name="group_pageno" value="<%= group_pageno %>">
              <input type=hidden name="candidate_pageno" value="<%= candidate_pageno %>">
              <input type=hidden name="current_pageno" value="<%= current_pageno %>">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
              <input disabled id="apply" type="button" name="apply" value="确认" onClick="apply_change();submit();">
        <br>
      </form></td>
    <td>
<table width="100%" height="310" border="0" cellpadding="1">
        <tr valign="middle"> 
          <td width="90%"><form action="" method="post" name="formCurrent" id="formCurrent">
              <select name="select" size="<%= SELECT_LINES %>" multiple class="chooserList" onChange="clearSelected(formCandidate.select);buttonChanged('add','del');">
                <%
                    for (int i=0;i<current_rr.length;i++) {
                %>
                <option value="<%= current_rr[i].getValue(COLUMN_NAME_OF_VALUE) %>"><%= current_rr[i].getValue(COLUMN_NAME_OF_LABEL) %></option>
                <%
                    }
                %>
              </select>
            </form></td>
          <td width="10%"><form name="formCurrentButtonUp" method="post" action="" onsubmit="return verify(formCurrentButtonUp);">
<%
    if (current_pageno==1) {
%>
              <input disabled name="up" type="image" src="images/arrowUp_disabled.gif" alt="上一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="up" type="image" src="images/arrowUp.gif" alt="上一页" width="24" height="24" border="0">
              <input type=hidden name="group_pageno" value="<%= group_pageno %>">
              <input type=hidden name="candidate_pageno" value="<%= candidate_pageno %>">
              <input type=hidden name="current_pageno" value="<%= (current_pageno-1) %>">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
</form>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <br>
<form name="formCurrentButtonDown" method="post" action="" onsubmit="return verify(formCurrentButtonDown);">
<%
    if (current_pageno==current.getTotalPages()) {
%>
              <input disabled name="down" type="image" src="images/arrowDown_disabled.gif" alt="下一页" width="24" height="24" border="0">
<%
    } else {
%>
              <input name="down" type="image" src="images/arrowDown.gif" alt="下一页" width="24" height="24" border="0">
              <input type=hidden name="group_pageno" value="<%= group_pageno %>">
              <input type=hidden name="candidate_pageno" value="<%= candidate_pageno %>">
              <input type=hidden name="current_pageno" value="<%= (current_pageno+1) %>">
              <input type=hidden name="group_id" value="<%= group_id %>">
              <input type=hidden name="added" value="">
              <input type=hidden name="deleted" value="">
<%
    }
%>
            </form>
</td>
        </tr>
      </table>	
	</td>
  </tr>
</table>
</body>
<script>
/* 记录下当前列表框的原始数据，以供比较用。 */
for (i=0;i<formCurrent.select.options.length;i++)
{
  old_options[i]=formCurrent.select.options[i];
}
</script>
</html>