work_serach.jsp

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

<%@ page import="swing.Cutstring"%>
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.zh.conpool.Condata"%>
<%@ page import="com.bwm.string.Str"%>
<%
	Cutstring cutstring=new Cutstring(); 
	Str str=new Str();
 %>
	<table border=0 cellpadding=0 cellspacing=0 width="100%">
	<tr>
		<td>◆<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><div align="center">◆<a href="../stat/stat.jsp" target="mainName" ><font color="#050415">统计</font></a></div></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;
							String jobpl="s";
							con1=conn1.getConnection();
							java.sql.ResultSet rs11=conn1.executeQuery("select * from jobwork where Name in(select Name from tb_person where Popdeom=1) ORDER BY DateTime 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("Name");
								String jobback=rs11.getString("BackPath");
								String jo=jobback.substring(14,jobback.length());
								String jobcontent=rs11.getString("Content");
								String jobcontenttext=rs11.getString("Contenttext");
								int jobplcontent=rs11.getInt("Plcontent");
								if(jobplcontent==0){
									jobpl="按计划完成";
								}else if(jobplcontent==1){
									jobpl="提前完成";
								}else if(jobplcontent==2){
									jobpl="落后完成";
								}
						%>
							<tr align="center">
							    <td height="24"><%=jobname%></td>
							    <td height="24"><%=cutstring.toCut(jobcontent)%></td>
							    <td height="24"><%=cutstring.toCutlong(jobcontenttext)%></td>
							    <td height="24"><%=jobpl%></td>
							    <td height="24"><%=jo%></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>