📄 start.jsp

📁 javaWEB应用网立足于提供从WEB技术到WEB应用全方位免费 ║ ║ 共享服务。这个平台是大家学习、应用、交流WEB技术的最 ║ ║ 有力平台。我们坚信成功来源于共享和合作
💻 JSP
字号:
<%@ page contentType="text/html; charset=GBK" %>
<jsp:useBean id="newsBean" scope="session" class="sk.newsBean" />
<jsp:useBean id="start" scope="session" class="sk.start_resBean" />
<jsp:setProperty name="newsBean" property="*" />
<%@page language="java" import="java.sql.*,java.util.*" %>
<html>
<head>
<%!
ResultSet rs;
ResultSet rs1;
%>
<script language="JavaScript">

    var s12=0,s13=0;

    function c1hannel1_change(index)
    {
    p1="document.news.";
    if(s12==0)
      {
            p2="c1hannel2"+index+".style";
            p3=eval(p1+p2);
            s12=index;
            p3.display="block";
            document.news.c1hannel20.style.display="none";
       }
        else
      {
             p4="c1hannel2"+s12+".style";
            p5=eval(p1+p4);
            p5.display="none";
            p2="c1hannel2"+index+".style";
            p3=eval(p1+p2);
            s12=index;
            p3.display="block";


      }
//  document.news.channel2.selectedIndex=0;
    }
    function c1hannel2_change(index)
    {
    p1="document.news.";
    if(s13==0)
      {
            p2="c1hannel3"+index+".style";
            p3=eval(p1+p2);
            s13=index;
            p3.display="block";
            document.news.c1hannel30.style.display="none";
       }
        else
      {
            p4="c1hannel3"+s13+".style";
            p5=eval(p1+p4);
            p5.display="none";
            p2="c1hannel3"+index+".style";
            p3=eval(p1+p2);
            s13=index;
            p3.display="block";


      }
//document.news.channel2.selectedIndex=0;
    }

    function submit2(form)
{

  form.S1Level3.value=""+s13;

  return true;
}

    </script>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF">
<p>开通权限说明：</p>
<p>1。本站为树形结构，从上倒下级别为频道-&gt;专刊-&gt;专版</p>
<p>2。开通时，细分至专版。即如果开通某个频道或专刊，须通过将其下面的专版分别开通实现。 </p>
<p>该会员的编号为<font color=red><%=request.getParameter("userid")%></font> </p>
<p>他的试用期限为：<%=request.getParameter("trialtime")%></p>
<p>他的有效期限为：<%=request.getParameter("validperiod")%></p>
<form name="news" method="post" action="start_res.jsp" onsubmit="return submit2(this);">
<table>
<TR>
<TD noWrap width=159 height="19">一级频道
<SELECT name="c1hannel1" onchange="c1hannel1_change(this.value)">
    <option selected value='0'>[频道]</option>
    <%
    newsBean.getSkdb1().getChannel1().executeQuery();
    newsBean.getSkdb1().getChannel1().first();
    for(int i=0;i<newsBean.getSkdb1().getChannel1().getRowCount();i++ )
    {
    %>
    <option value="<%=newsBean.getSkdb1().getChannel1().getInt("id")%>"><%= newsBean.getSkdb1().getChannel1().getString("ChannelName") %></option>
    <%
    newsBean.getSkdb1().getChannel1().next() ;
    }
    newsBean.getSkdb1().getChannel1().close();
    %>
     </SELECT></TD>



              <TD noWrap width=159 height="19">专区
                <SELECT name="c1hannel20" value="0">
                  <OPTION  selected value='0'>[选择专区]</OPTION></select>
     <%
    newsBean.getSkdb1().getChannel1().executeQuery();
    newsBean.getSkdb1().getChannel1().first();
    newsBean.getSkdb1().getChannel2().executeQuery();
    for(int i=0;i<newsBean.getSkdb1().getChannel1().getRowCount();i++ )
    {
    newsBean.getSkdb1().getChannel2().first();
    %>
    <SELECT name="c1hannel2<%=newsBean.getSkdb1().getChannel1().getInt("id")%>"  style="DISPLAY: none" onchange="c1hannel2_change(this.value)" value='<%=i+1%>' >
    <OPTION selected value="0">[选择专区]</OPTION>
    <%
    for(int j=0;j<newsBean.getSkdb1().getChannel2().getRowCount();j++)
    {
    if(newsBean.getSkdb1().getChannel2().getInt("UpperChannel")==newsBean.getSkdb1().getChannel1().getInt("id"))
    {
    %>
    <option value="<%=newsBean.getSkdb1().getChannel2().getInt("id")%>"><%= newsBean.getSkdb1().getChannel2().getString("ChannelName") %></option>
    <%
    }
    newsBean.getSkdb1().getChannel2().next();
    }
    %>
    </select>
    <%
    newsBean.getSkdb1().getChannel1().next() ;
    }
    newsBean.getSkdb1().getChannel1().close();
    newsBean.getSkdb1().getChannel2().close();
    %></TD>



              <TD noWrap width=159 height="19">专版
                <SELECT name="c1hannel30">
                  <OPTION selected
        value=0>[选择专版]</OPTION></SELECT>
        <%
    newsBean.getSkdb1().getChannel2().executeQuery();
    newsBean.getSkdb1().getChannel2().first();
    newsBean.getSkdb1().getChannel3().executeQuery();
    for(int i=0;i<newsBean.getSkdb1().getChannel2().getRowCount();i++ )
    {
    newsBean.getSkdb1().getChannel3().first();
    %>
                <SELECT name="c1hannel3<%= newsBean.getSkdb1().getChannel2().getInt("id")%>"  style="DISPLAY: none" value='<%=i+1%>' >
                  <OPTION selected value="0">[选择专版]</OPTION>
    <%
    for(int j=0;j<newsBean.getSkdb1().getChannel3().getRowCount();j++)
    {
    if(newsBean.getSkdb1().getChannel3().getInt("UpperChannel")==newsBean.getSkdb1().getChannel2().getInt("id"))
    {
    %>
    <option value="<%= newsBean.getSkdb1().getChannel3().getInt("id")%>"><%= newsBean.getSkdb1().getChannel3().getString("ChannelName") %></option>
    <%
    }
    newsBean.getSkdb1().getChannel3().next();
    }
    %>
    </select>
    <%
    newsBean.getSkdb1().getChannel2().next() ;
    }
    newsBean.getSkdb1().getChannel2().close();
    newsBean.getSkdb1().getChannel3().close();
    %>

    </TD></tr>
    </table>

  <p>
    <input type="hidden"  name="S1Level3" value='' >
    <input type="hidden"  name="userid" value="<%=request.getParameter("userid")%>" >
    <input type="hidden"  name="validperiod" value="<%=request.getParameter("validperiod")%>" >
    <input type="hidden"  name="trialtime" value="<%=request.getParameter("trialtime")%>" >
    <input type="submit" name="Submit" value="开通"></form>
  </p>
  <table border="1" width="261">

    <tr>
      <td height="26" width="117" >已开通专版</td>
      <td height="26" width="128" >删除？</td>
    </tr>
    <%

     start.getQuanxianinfo().executeQuery();
     start.getQuanxianinfo().first();
     for( int i=0 ; i< start.getQuanxianinfo().getRowCount() ;i++)
{
    if(start.getQuanxianinfo().getInt("userid")==Integer.parseInt(request.getParameter("userid")))
    {%>
    <tr>
      <td width="117">
      <%
      start.getChannelinfo().executeQuery();
      start.getChannelinfo().first();
      for( int j=0 ; j< start.getChannelinfo().getRowCount() ;j++)
      {

      if (start.getChannelinfo().getInt("id")==start.getQuanxianinfo().getInt("channelid"))
        {
        out.print(start.getChannelinfo().getString("ChannelName"));
          break;}
          else start.getChannelinfo().next();
      }
       start.getChannelinfo().close();
      %> </td>
      <td width="128">

    <form action="quanxian_del.jsp">
    <input type="hidden"  name="userid" value="<%=request.getParameter("userid")%>" >
    <input type="hidden"  name="validperiod" value="<%=request.getParameter("validperiod")%>" >
    <input type="hidden"  name="trialtime" value="<%=request.getParameter("trialtime")%>" >
    <input type="hidden" name="quanxianid" value="<%=start.getQuanxianinfo().getInt("id")%>" >
    <input type="submit" name="确认" value="删除">
    </form></td>
    </tr>
    <%
  }
   start.getQuanxianinfo().next();
}
  start.getQuanxianinfo().close();
    %>



  </table>
  <p>&nbsp;</p>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -