study_main.jsp

一个Java网络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="study_mainmenu.jsp"%>





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

</TD><TD id=right_pane   background=../images/adminbodybg5.gif>



<!-- ### Right Pane Position ### -->

<div 
      style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 6px; WIDTH: 100%; PADDING-TOP: 6px; HEIGHT: 100%" 
      >
      <TABLE id="Table2" cellSpacing="0" cellPadding="0" width="100%" border="0" >
        <TBODY>
        <TR>
          <TD>
          
</td></TR></TABLE><div id="ContentPanel">
	
<div id="ColumnTitlePanel">
<%if((request.getParameter("key")).compareTo("1")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">通知公告</span>
<%}%>
<%if((request.getParameter("key")).compareTo("2")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">公司新闻</span>
<%}%>
<%if((request.getParameter("key")).compareTo("3")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">活动盛事</span>
<%}%>
<%if((request.getParameter("key")).compareTo("4")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">业务知识</span>
<%}%>
<%if((request.getParameter("key")).compareTo("5")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">规章制度</span>
<%}%>
<%if((request.getParameter("key")).compareTo("6")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">企业文化</span>
<%}%>
<%if((request.getParameter("key")).compareTo("7")==0){%>
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">产品相关</span>
<%}%>


<BR>
<span id="ItemDescription1_Label1" class="description"></span>
<FONT 
      face="宋体"><BR></FONT>
	</div>



<TABLE cellSpacing="0" cellPadding="0" width="98%" align="center" border="0" class="article-page" bordercolor=red>

	<tr>
		<td class="article-page-body" height="100%" colspan="2" width="100%">
			<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0" height="100%" bordercolor=blue>

				<TR>
					<TD valign="top">
						
<TABLE width="100%" border="0">
  <TR>
    <TD><FONT color="red">
</FONT><FONT color="blue">
</FONT></TD></TR></TABLE>
<table class="Grid" cellspacing="1" cellpadding="1" rules="cols" ItemCount="13" border="0" Style="border-width:0px;width:100%;">
			<tr class="Grid_Header">
				<td>
名称

</td><td style="width:16%;">
					<U>创建时间</U>
				
</td>
			</tr>








<%if(request.getParameter("key")==null){
rs=stmt.executeQuery("select * from news where lei=4  order by id desc");
}else{
rs=stmt.executeQuery("select * from news where lei='"+request.getParameter("key")+"'  order by id desc");
}
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0,mm=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++ ;%>



<tr class="datalist<%if(mm==0){%>1<%mm++;}else{%>2<%mm=0;}%>">

<td>
<a href="newslist.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("title")%></a></td>

<td><%=rs.getString("fbtime")%></td>
</tr>





<%}%>


<%if(request.getParameter("key")==null){
rs=stmt.executeQuery("SELECT count(*) from news where lei=4 ");
}else{
rs=stmt.executeQuery("SELECT count(*) from news where lei='"+request.getParameter("key")+"'  ");
}
while(rs.next()) i = rs.getInt(1) ;
%>

<tr class="pagemark" align="right">
<td colspan="4">记录数:<%=i%>, 第<%=pageInt%>页/总<%=(i+20)/20%>页&nbsp;&nbsp;

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

<%if (pageInt>1){%><a href=?page=<%=pageInt-1%>&space=<%=request.getParameter("space")%>&key=<%=request.getParameter("key")%>><%}%><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")%>&key=<%=request.getParameter("key")%>><%}%>后页<font face=webdings size=2>8</font></a>&nbsp;&nbsp;

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

	</div>
</TD>
				</TR>
			</TABLE>
		</td>
	</tr>
</TABLE>




</div></DIV>

<!-- ### Right Pane Position ### -->





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






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