worknote_serach.jsp

JSP简单的OA系统_非常不错的一个系统

<%@ page import="swing.Cutstring"%>
<%@ page import="com.bwm.string.Str"%>
<%@ page import="com.zh.conpool.Condata"%>
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>

	<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	<link href="../../css/style1.css" rel="stylesheet">

<% 
	Str str1=new Str();
	Cutstring cutstring=new Cutstring(); 
 %>	
 
 <table border=0 cellpadding=0 cellspacing=0 width="100%">
	<tr>
		<td width="91%">◆<a href="../serach/psserach.jsp" target="mainName"><font color="#050415">工作记录查询</font></a> <img src="../../images/16edit.gif" width="16" height="16"><a href="worknote.jsp" target="mainName"><font color="#050415">新工作记录</font></a>◆<a href="../serach/worknote.jsp" target="mainName"><font color="#050415">工作进度查询</font></a>◆<a href="worked.jsp" target="mainName"><font color="#050415">工作进度安排</font></a></td>
		<td width="9%" align="center">◆<a href="../stat/stat.jsp" target="mainName" ><font color="#050415" >统计</font></a></td>
   </tr>
</table>
	<hr size=1>
	<table bgcolor="#FFFFFF" border=1 cellpadding=0 cellspacing=0 width="100%" bordercolor="#FFFFFF" bordercolordark="#EEF2F9" bordercolorlight="#FFFFFF">
			      <tr align="center" bgcolor="#Eff2fb">
				    <td height="24">员工名称</td>
				    <td height="24">工作内容</td>
				    <td height="24">起止时间</td>
				    <td height="24">截止时间</td>
				    <td height="24">内容详情</td>
				  </tr>
				  <%	
				  			Condata conn1=new Condata();
							java.sql.Connection con1=null;
							con1=conn1.getConnection();
							java.sql.ResultSet rs11=conn1.executeQuery("select * from jdwork where Name in(select Name from tb_person where Popdeom=1) ORDER BY BeginTime,Works desc ");  	
							int pagesize=6;
							int showpage=1;
							int rowcount=0;
							int pagecount=0;
							int ii=0;	
							String topage="";	
							String baa="";
							
							if(!rs11.next()){
								out.println("没有添加记录");
							}else{
								rs11.last();
								rowcount=rs11.getRow();
								pagecount=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1));
								topage=request.getParameter("topage");
								if(topage!=null){
									showpage=Integer.parseInt(topage);
									if(showpage>pagecount){
										showpage=pagecount;
									}else if(showpage<=0){
										showpage=1;
									}
								}
								rs11.absolute((showpage-1)*pagesize+1);
						
							for(int i=1;i<=pagesize;i++){
								String jobid=rs11.getString("ID");
								String jobname=rs11.getString(2);
								String jobback=rs11.getString(3);
								java.sql.Date jobcontent=rs11.getDate(4);
								java.sql.Date jobcontenttext=rs11.getDate(5);
								String jobplcontent=rs11.getString(6);
						%>
							<tr align="center">
							    <td height="24"><%=jobname%></td>
							    <td height="24"><%=cutstring.toCut(jobback)%></td>
							    <td height="24"><%=jobcontent%></td>
							    <td height="24"><%=jobcontenttext%></td>
							    <td height="24"><%=cutstring.toCutlong(jobplcontent)%>...</td>
				 		 </tr>
				 		<%
								if(!rs11.next()){
									break;
								}
							}
						}
							if(con1!=null){
		con1.close();
	}
	if(conn1!=null){
		conn1.close();
	}

				  %>
				  							<tr align="center">
							  <td height="25" colspan="8" bgcolor="#ECECF2" ><a href="worknote_serach.jsp?topage=<%=showpage-1%>&a=b"><img src="../../images/1-prev.gif" width="36" height="11" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="worknote_serach.jsp?topage=<%=showpage+1%>&a=b"><img src="../../images/1-next.gif" width="36" height="11" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;共<%=rowcount%>条记录每页6条记录</td>
						    </td>
						  </tr>

	</table>