📄 new.jsp

📁 实现了一个OA系统基本的功能
💻 JSP
字号:
<%--这个页面是用来显示除了内容之外的所有新闻的--%>
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="oanoticecrud.newsBean"%>

<jsp:useBean id="pagecount" class="oabean.pageInfo" scope="page" />
<jsp:useBean id="getPages" class="oabean.pages" scope="page" />
<jsp:useBean id="date" class="oabean.date" scope="page" />

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>show news info</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	
<style type="text/css" media="all">
@import "admin/Upimg/thickbox.css";
@import "css/pages.css";
</style>

<script src="admin/Upimg/jquery-1.1.3.1.pack.js" type="text/javascript"></script>
<script src="admin/Upimg/thickbox-compressed.js" type="text/javascript"></script>
<script src="admin/Upimg/global.js" type="text/javascript"></script>
<script type="text/javascript" src="/oa/js/popcalendar.js"></script>

<script language="javascript">
    function sty()
	{
	document.getElementById("add").style.textDecoration="underline";
	}
	function out()
	{
	document.getElementById("add").style.textDecoration="blink";
	}
</script>

</head>
  
<body>
    <%
       String un=(String)session.getAttribute("user"); 
       System.out.println(un);
       if(un==null) {response.sendRedirect("../index.jsp");}
       int pageNow=1;//初始页
       int pageSize=4;//一页显示多少条记录
       String s="";
       String pagenow=request.getParameter("pageNow");//接收页码
       //下面是获取当前要显示的是重要还是普通的新闻
       String sel1=request.getParameter("select1");
       String dat=request.getParameter("ndate");
       
       if(pagenow!=null&&pagenow!="")
       {
         pageNow=Integer.parseInt(pagenow);
       }
       String sql= "select top "+pageSize+" * from oa_news where newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news )";
	   String Countsql="select count(*) from oa_news";
	  
	   //这里是只查询普通还是重要的新闻
	  if((sel1!=null&&sel1!="")&&dat=="")
	   {
	    if(sel1.equals("1"))
	    {
	    sql="select top "+pageSize+" * from oa_news where type='普通' and newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news where type='普通')";
	    Countsql="select count(*)from oa_news where type='普通'";
	    }
	    else if(sel1.equals("2"))
	    {
	    sql="select top "+pageSize+" * from oa_news where type='重要' and newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news where type='重要')";
	    Countsql="select count(*)from oa_news where type='重要'";
	    }
	   }
	   
	   //查询具体时间的公告
	   else if(sel1==""&&dat!="")
	   {
	    sql="select top "+pageSize+" * from oa_news where dateTime='"+dat+"' and newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news where dateTime='"+dat+"')";
	    Countsql="select count(*) from oa_news where dateTime='"+dat+"'";
	   }
	   
	   //这里是查询选了type和datetime的新闻
	   else if((sel1!=null&&sel1!="")&&dat!="" )
	   {
	     if(sel1.equals("1"))
	    {
	    sql="select top "+pageSize+" * from oa_news where type='普通' and dateTime='"+dat+"' and newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news where type='普通' and dateTime='"+dat+"')";
	    Countsql="select count(*) from oa_news where type='普通' and dateTime='"+dat+"'";
	    }
	    else if(sel1.equals("2"))
	    {
	    sql="select top "+pageSize+" * from oa_news where type='重要' and dateTime='"+dat+"' and newId not in(select top "+pageSize*(pageNow-1)+" newId from oa_news where type='重要' and dateTime='"+dat+"')";
	    Countsql="select count(*) from oa_news where type='重要' and dateTime='"+dat+"'";
	    }
	   }
	  
       int pageCount=pagecount.getpageCount(Countsql,pageSize);//得到总共有多少页     
	   int rowCount=pagecount.getrowCount(Countsql);//得到总共有多少条记录
	   ArrayList a1=getPages.getNews(sql);//得到分页信息
     //显示
   %>
     <form action="admin/new.jsp" method="post" name="student">
		<table width="100%" class="topList"  cellSpacing=1 align="center" border=0>
		 <tr>
		  <td align="center" colspan="10"><div align="center" class="STYLE3">
		   <select name="select1"  size="1">
		    <option value="">请选择重要程度</option>
		  	<option value="1">普通</option>
		  	<option value="2">重要</option>		 
		   </select>
		   <label>日期：</label>
		    <input id="sdv" name="ndate" onclick="showCalendar(this, this, 'yyyy-mm-dd','cn',1);" maxlength="20" size="10" value=""/>日
           <script>
            var osdv = document.getElementById('sdv');
            if(osdv != null) osdv.readOnly='true';
           </script>	
		    <input type="submit" name="ns" value="搜索"></div>
		  </td>
		</tr>
	    <tr>
	     <td scope="col"><div align="center" class="STYLE1">新闻号</div></td>
	     <td scope="col"><div align="center" class="STYLE1">标题</div></td>
	     <td scope="col"><div align="center" class="STYLE1">新闻类别</div></td>
	     <td scope="col"><div align="center" class="STYLE1">新闻时间</div></td>
	     <td scope="col" colspan="3"><div align="center" class="STYLE1">操作</div></td>
	   </tr>
	   <%
	   	for(int i=0;i<a1.size();i++)
	   	{
	   	  //从a1中取出noticeBean
	   	  oanoticecrud.newsBean St=(oanoticecrud.newsBean)a1.get(i);
	   %>
        <tr>
         <% int newid=St.getNewId();%>
         <td align="center"><%=St.getNewId()%></td>
         <td align="center"><a href="admin/newscontent.jsp?id=<%=newid%>&modal=true" class="thickbox" style="text-decoration:none"><%=St.getTitle()%></a></td>
         <td align="center"><%=St.getType()%></td>
         <td align="center"><%=St.getDateTime().substring(0,10)%></td>
         <td align="center"><img src="images/del.gif"><a href="new/delnews.new?id=<%=newid%>" onclick="return window.confirm('您确认要删除吗？');" style="text-decoration:none">删除</a></td>
         <td align="center"><img src="images/mod.gif"><a href="admin/modnews.jsp?id=<%=newid%>&modal=true" class="thickbox" style="text-decoration:none">修改</a></td>
       <%
         }
       %>
      <tr>
	    <td colspan="10">
	    <ul id="nav">
	    共有<span class="STYLE2"><%=rowCount%></span>条记录
		   <%
		     out.println("<li><a href=admin/new.jsp?pageNow=1&&select1="+sel1+"&&ndate="+dat+" style='text-decoration:none'>首</a></li>");
		     if(pageNow!=1)
		     {
		      out.println("<li><a href=admin/new.jsp?pageNow="+(pageNow-1)+"&&select1="+sel1+"&&ndate="+dat+" style='text-decoration:none'>&laquo;</a></li>");
		     }
		     for(int j=1;j<=pageCount;j++)
		     {
		     out.println("<li><a href=admin/new.jsp?pageNow="+j+"&&select1="+sel1+"&&ndate="+dat+" style='text-decoration:none'>["+j+"]</a></li>");
		     }
		     if(pageNow!=pageCount)
		     {
		      out.println("<li><a href=admin/new.jsp?pageNow="+(pageNow+1)+"&&select1="+sel1+"&&ndate="+dat+" style='text-decoration:none'>&raquo;</a></li>");
		     }
		     out.println("<li><a href=admin/new.jsp?pageNow="+pageCount+"&&select1="+sel1+"&&ndate="+dat+" style='text-decoration:none'>末</a></li>");
		   %>
		  <span class="STYLE2"><% out.println(pageNow+"/"+pageCount);%></span>
		   </ul>
	    </td>
	    <td align="left"><img src="images/add.gif"><a id="add" href="admin/addnews.jsp?modal=true"  onmouseover="sty();" onmouseout="out();" style='text-decoration:blink'>增加</a></td>
	    </tr> 
     </table>
     </form>
    <form action="admin/new.jsp"> 
      跳转到第
     <input type="text" name="pageNow" size="8">页 &nbsp;
     <input type="hidden" name="select1" value="<%=sel1%>">
     <input type="hidden" name="ndate" value="<%=dat%>">
     <input type="submit" value="Go">

    </form>
  </body>
</html>
💿 文件大小 5326 K
👤 上传用户 xufengping716
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#OA系统
⌨️ 快捷键说明

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