down_main.jsp

JSP+MYSQL能飞网络办公OA系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>




<%@ include file="down_mainmenu.jsp"%>


             </TD></TR>
             </TBODY></TABLE>




</TD><TD id=right_pane>


<TABLE class=maintd id=Columns height=100% cellSpacing=0  cellPadding=12 width="100%" border=0  background=../images/adminbodybg7.gif>
 <TBODY>
<TR><td valign=top width=100%>


<img src=../images/mymsg.jpg>


<%if(request.getParameter("lei")==null || (request.getParameter("lei").compareTo("null")==0) ){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">资源下载中心</span><%}else{%>

<%if((request.getParameter("lei")).compareTo("1")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">内部使用软件</span>
<%}%>
<%if((request.getParameter("lei")).compareTo("2")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">系统安装相关</span>
<%}%>
<%if((request.getParameter("lei")).compareTo("3")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">驱动程序相关</span>
<%}%>
<%if((request.getParameter("lei")).compareTo("4")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">其它相关软件</span>
<%}%>
<%}%>





<!------------------------------------>
<%if(request.getParameter("lei")==null || (request.getParameter("lei").compareTo("null")==0) ){
rs=stmt.executeQuery("SELECT * from down  order by id desc");
}else{
rs=stmt.executeQuery("SELECT * from down where lei='"+request.getParameter("lei")+"' order by id desc");
}
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0 ;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>

                <TABLE width=100% height="50" border=0 cellPadding=0 cellSpacing=0 align=center>
                  <TBODY>
              <TR>
                      <TD height="50" valign="middle"> 
                        <TABLE border=0 cellPadding=0 cellSpacing=0 width=100%>
                    <TBODY>
                    <TR>
                      <TD width="100%">
                        <TABLE bgColor=#000000 border=0 cellPadding=0 
                        cellSpacing=1 width=100%>
                          <TBODY>
                          <TR>
                            <TD bgColor=#d9eaeb  height=30 width=150 background=images/gongcheng.gif><font color=003399 size=2><b><div align=center><br><%=rs.getString("softname")%></font></div><br><br></b></font></TD>
                            <TD bgColor=#f3f3e3 width=549>软件简介:<%=rs.getString("softtext")%></TD>

                          </TR>
                          <TR>
                            <TD bgColor=#d9eaeb height=20 width=146>
                              <TABLE align=center border=0 cellPadding=0 
                              cellSpacing=0 width="90%">
                                <TBODY>
                                <TR>
                                  <TD height=10 vAlign=top>
                                    <table align=center border=0 cellpadding=0 
                                cellspacing=0 width="87%">
                                      <tbody> 
                                      <tr> 
                                       <td>下载次数:<%=rs.getString("softhit")%>

</td>
                                      </tr>
                                      </tbody> 
                                    </table>
                                  </TD>
                                </TR>
                            </TBODY></TABLE></TD>
                            <TD bgColor=#f3f3e3 width=80%>
                              <TABLE align=center border=0 cellPadding=0 
                              cellSpacing=0 width="100%">
                                <TBODY>
                                
                                <TR>
                                  <TD height=10 vAlign=top>
                                    <table align=center border=0 cellpadding=0 
                                cellspacing=0 width="100%">
                                      <tbody> 

                                      <tr> 
                                        <td>更新日期:<%=rs.getString("softtime")%>
<div align=right><img src=../images/soft.gif><a onClick="javascript:window.open('download.jsp?id=<%=rs.getString("id")%>','','toolbar=0,scrollbars=1,width=300,height=250')"  style="CURSOR: hand"><font color=red>点击下载</a></font></div></td>
                                      </tr>
                                      </tbody>
                                    </table>
                                  </TD>
                                </TR>
                              </TBODY></TABLE></TD>
                          </TR>
           </TBODY></TABLE></TD></TR></TBODY></TABLE>
</TD></TR></TBODY></TABLE>
<br><br>
<%}%>
<%if(request.getParameter("lei")==null || (request.getParameter("lei").compareTo("null")==0) ){
rs=stmt.executeQuery("SELECT count(*) from down order by id desc");
}else{
rs=stmt.executeQuery("SELECT count(*) from down where  lei='"+request.getParameter("lei")+"' order by id desc");
}
while(rs.next()) i = rs.getInt(1) ;
%>

<div align=right>

记录数:<%=i%>, 第<%=pageInt%>页/总<%=(i+20)/20%>页&nbsp;&nbsp;

<a href=?page=1&space=<%=request.getParameter("space")%>&lei=<%=request.getParameter("lei")%>><font face=webdings size=2>9</font>首页</a>&nbsp;&nbsp;

<%if (pageInt>1){%><a href=?page=<%=pageInt-1%>&space=<%=request.getParameter("space")%>&lei=<%=request.getParameter("lei")%>><%}%><font face=webdings size=2>7</font>前页</a>&nbsp;&nbsp;
<%int bb=(i+20)/20;%>
<%if (pageInt<bb){%><a href=?page=<%=pageInt+1%>&space=<%=request.getParameter("space")%>&lei=<%=request.getParameter("lei")%>><%}%>后页<font face=webdings size=2>8</font></a>&nbsp;&nbsp;

<a href=?page=<%=(i+20)/20%>&space=<%=request.getParameter("space")%>&lei=<%=request.getParameter("lei")%>>末页<font face=webdings face=webdings size=2>:</font></a>
</div>

</TD></TR></TBODY></TABLE>
</TD></TR></TBODY></TABLE>
<!----------------------------------------->








</TD></TR></TBODY></TABLE>
</TD></TR>
</TBODY>
</table>






<%@ include file="end.jsp"%>
</BODY>
</HTML>