📄 复件 444.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>
  <%
  int countpage=0;
  int currpage=1;
  int pagesize=5;
  int countrow=0;
  String strpage=(String)request.getParameter("page");
  if(strpage==null){
 	  currpage=1;
 	 }
  else{
 	 
 	 currpage=Integer.parseInt(strpage);
  }
 Connection conn=null;
 Statement stmt=null;
 ResultSet rs=null;
 String id="";
 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);
 /* stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_UPDATABLE);*/
    String sql="select * from people order by id";
  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());
 }
 session.setAttribute("flag","0");
 session.setAttribute("flag1","0");
 
rs.last();
int i=0;
countrow=rs.getRow();
countpage=(countrow/pagesize);
if(countrow%pagesize>0)
	countpage++;
rs.first();
if(countrow>0)
{
rs.absolute(currpage*pagesize-pagesize+1);

 %>
</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>
  <%
    // while(rs.next())
    	while(i<pagesize&&!rs.isAfterLast()){
		{
    	    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>");
			rs.next();
			i++;
		}
    	}
		rs.close();
		stmt.close();
		conn.close();
		
%>
</table>
<% if(currpage>1){%>
<a href="44.jsp?page=<%=currpage-1%>">上一页</a>
<%} %>
<% if(currpage<countpage){%>
<a href="44.jsp?page=<%=currpage+1%>">下一页</a>
<%} %>
<a href="44.jsp?page=<%=countpage%>">最后一页</a>
</body>
</html>
⌨️ 快捷键说明

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