📄 44.jsp

📁 一个自已编写的用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;
}
.STYLE2 {
	font-size: 20px;
	font-family: "方正姚体";
	color: #FF0033;
}
body {
	background-color: #CCCCFF;
}
-->
</style>
<body>
<p align="center"><span class="STYLE1">DSY 人事管理系统</span></p>
<p align="center" class="STYLE2">注意：此删除为永久性删除，请管理员确认后再执行！！</p>
<table width="769" border="1" align="center" bgcolor="lightpink">
  <tr>
    <td>职工编号</td>
    <td>姓名</td>
    <td>部门</td>
    <td>性别</td>
    <td>生日</td>
    <td>民族</td>
    <td>籍贯</td>
    <td>家庭出身</td>
    <td>基本工资</td>
    <td>职务</td>
    <td>职称</td>
    <td>学历</td>
    <td>奖罚情况</td>
    <td>主要经历</td>
    <td>社会兼职</td>
    <td colspan="2" >操作</td>
  </tr>
  <%
 Connection conn=null;
 Statement stmt=null;
 ResultSet rs=null;
 String id="";
 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";
    }
  // out.println(sql);
    rs=stmt.executeQuery(sql);
   session.setAttribute("sql1","");
 }
 catch(SQLException e)
 {
    out.println(e.getMessage());
 }
 session.setAttribute("flag","0");
 session.setAttribute("flag1","0");
 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;
    	    id=rs.getString("id");
			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("sr")+"</td>");
			out.println("<td>"+rs.getString("mz")+"</td>");
			out.println("<td>"+rs.getString("jg")+"</td>");
			out.println("<td>"+rs.getString("jtcs")+"</td>");
			out.println("<td>"+rs.getString("jbgz")+"</td>");
			out.println("<td>"+rs.getString("zw")+"</td>");
			out.println("<td>"+rs.getString("zc")+"</td>");
			out.println("<td>"+rs.getString("xl")+"</td>");
			out.println("<td>"+rs.getString("jfqk")+"</td>");
			out.println("<td>"+rs.getString("zyjl")+"</td>");
			out.println("<td>"+rs.getString("shjz")+"</td>");
			out.println("<td><a href='66.jsp?id="+id+"'>"+"修改"+"</a></td>");
			//out.println("<td><a href='test1.jsp?id="+id+"'>"+"修改"+"</a></td>");
			out.println("<td><a href='shangchu.jsp?id="+id+"'>"+"删除"+"</a></td>");
			out.println("</tr>");
			if(!rs.next())break;
		}
		rs.close();
		stmt.close();
		conn.close();
 
%>
</table>
<p align="center">第<%=intpage %>页
<a href=44.jsp?pages=<%=1 %>>首页</a>
<a href=44.jsp?pages=<%=intpage-1 %>>上一页</a>
<a href=44.jsp?pages=<%=intpage+1 %>>下一页</a>
<a href=44.jsp?pages=<%=TotalPages %>>尾页</a>
共<%=TotalPages %>页</p>
</body>
</html>
⌨️ 快捷键说明

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