all.jsp

一个自已编写的用JSP编写的简单的人事管理系统

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<style type="text/css">
<!--
.STYLE1 {	font-family: "方正舒体", "方正姚体";
	font-size: 50px;
	color: #0066FF;
}
body {
	background-color: #CCCCFF;
}
-->
</style>
	
<p align="center"><span class="STYLE1">DSY 人事管理系统</span></p>
<p align="center">&nbsp;</p>
<table width="520" border="1" align="center">
    <tr>
      <td width="80" height="18">职工编号</td>
      <td width="80">姓名</td>
      <td width="80">部门</td>
      <td width="80">性别</td>
      <td width="80">职务</td>
      <td width="80">学历</td>
    </tr>

 <%
 request.setCharacterEncoding("GBK");
 Connection conn=null;
 Statement stmt=null;
 ResultSet rs=null;
 int TotalRecords=0;
 try
 {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
 catch(ClassNotFoundException ce)
 {
    out.println(ce.getMessage());
 }
 try
 { 
    conn=DriverManager.getConnection("jdbc:odbc:dong");                                                               
    stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_READ_ONLY);
   String sql="select * from people order by id";
   String sql3="select count(*) as recordcount from people";
   rs=stmt.executeQuery(sql3);
   if(rs.next()) TotalRecords=rs.getInt("recordcount");
   String sql2=(String)session.getAttribute("sql1");
   if(sql2!="")
    {
    	sql=sql2;
    	sql+=" order by id";
    }
    rs=stmt.executeQuery(sql);
    session.setAttribute("sql1","");
 }
 catch(SQLException e)
 {
    out.println(e.getMessage());
 }
 int PageSize=5;
 int TotalPages=(TotalRecords+PageSize-1)/PageSize;
 int intpage;
 String pages1=request.getParameter("pages");
 if(pages1==null)
	 intpage=1;
 else
	 intpage=Integer.parseInt(pages1);
 if(intpage<1)intpage=1;
 if(intpage>TotalPages)intpage=TotalPages;
 rs.absolute((intpage-1)*PageSize+1);
 int i=0;
 while(i<PageSize)
 {
	        i=i+1;
		    out.println("<tr>");
			out.println("<td>"+rs.getString("id")+"</td>");
			out.println("<td>"+rs.getString("name")+"</td>");
			out.println("<td>"+rs.getString("bm")+"</td>");
			out.println("<td>"+rs.getString("sex")+"</td>");
			out.println("<td>"+rs.getString("zw")+"</td>");
			out.println("<td>"+rs.getString("xl")+"</td>");
			out.println("</tr>");
			if(!rs.next())break;
	}
		rs.close();
		stmt.close();
		conn.close();

%>
</table>
<p align="center">第<%=intpage %>页
<a href=all.jsp?pages=<%=1 %>>首页</a>
<a href=all.jsp?pages=<%=intpage-1 %>>上一页</a>
<a href=all.jsp?pages=<%=intpage+1 %>>下一页</a>
<a href=all.jsp?pages=<%=TotalPages %>>尾页</a>
共<%=TotalPages %>页</p>