📄 worker.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312" import="java.sql.*"%>
<%@page import="oabean.database"%>
<jsp:useBean id="pagecount" class="oabean.pageInfo" scope="page" />
<jsp:useBean id="getPages" class="oabean.pages" scope="page" />
<jsp:useBean id="common" class="oabean.common" scope="page" />
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>show worker info</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script language="javascript" type="text/javascript" src="js/Tip.js"></script>
<link href="css/Tip.css" rel="stylesheet" type="text/css" />
<style type="text/css" media="all">
@import "admin/Upimg/thickbox.css";
@import "css/pages.css";
</style>
<script src="admin/Upimg/jquery-1.1.3.1.pack.js" type="text/javascript"></script>
<script src="admin/Upimg/thickbox-compressed.js" type="text/javascript"></script>
<script src="admin/Upimg/global.js" type="text/javascript"></script>
<script type="text/javascript" src="/oa/js/popcalendar.js"></script>
<script language="javascript">
function sty()
{
document.getElementById("add").style.textDecoration="underline";
}
function out()
{
document.getElementById("add").style.textDecoration="blink";
}
</script>
</head>
<body>
<% String un=(String)session.getAttribute("user");
if(un==null) {response.sendRedirect("../index.jsp");}%>
<%!
database db=new database();
ResultSet rs;
int cunt;
String condition;
%>
<%
condition="select depId,depName from oa_department";
rs=db.executeQuery(condition);
%>
<script language="javascript">
var department_subval = new Array();
<%
cunt=-1;
while(rs.next())
{
cunt++;
%>
department_subval[<%=cunt%>]=new Array("<%=rs.getInt("depId")%>","<%=rs.getString("depName")%>")
<%
}
%>
function changeselect11(locationid)
{
var i;
document.form1.choice2.length=0;
document.form1.choice2.options[0]=new Option("==请选择==","");
if(locationid=="depName")
{
for(i=0;i<department_subval.length;i++)
{
document.form1.choice2.options[document.form1.choice2.length] = new Option(department_subval[i][1],department_subval[i][0]);
}
}
else if(locationid=="degree")
{
document.form1.choice2.options[document.form1.choice2.length] = new Option("专科","11");
document.form1.choice2.options[document.form1.choice2.length] = new Option("本科","12");
document.form1.choice2.options[document.form1.choice2.length] = new Option("研究生","13");
document.form1.choice2.options[document.form1.choice2.length] = new Option("博士","14");
}
}
</script>
<form name="form1" action="admin/worker.jsp" >
<%
int pageNow=1;//初始页
int pageSize=4;//一页显示多少条记录
String userId="";
String pagenow=request.getParameter("pageNow");//接收页码
if(pagenow==null)
{
pagenow="";
}
String se1=request.getParameter("choice1");
if(se1==null)
{
se1="";
}
String se2=request.getParameter("choice2");
if(se2==null)
{
se2="";
}
String name=request.getParameter("name");
if(name==null)
{
name="";
}
if(pagenow!=null&&pagenow!="")
{
pageNow=Integer.parseInt(pagenow);
}
oabean.workerBean wb=new oabean.workerBean();
String sql=wb.getSql(pageSize,pageNow,se1,se2,name);
String Countsql=wb.getCountsql(se1,se2,name);
int pageCount=pagecount.getpageCount(Countsql,pageSize); //得到总共有多少页
int rowCount=pagecount.getrowCount(Countsql);//得到总共有多少条记录
ArrayList a1=getPages.getUser(sql);// .getUser(sql);//得到分页信息
%>
<table width="100%" class="topList" cellSpacing=1 align="center" border=0>
<tr>
<td align="center" colspan="10"><div align="center" class="STYLE3">
按条件搜索:
<select name="choice1" onChange="changeselect11(this.value)">
<option>==请选择==</option>
<option value="depName">部门</option>
<option value="degree">学历</option>
</select>
具体可选择:
<select name="choice2" >
<option>==请选择==</option>
</select>
输入姓名查询:
<input type="text" id="ShowText" name="name" onblur="javascript:setTimeout('HideTTip()',300);" onkeyup="javascript:if(this.value!=''){ShowTip();}else{HideTTip();}" size="20" autocomplete="off"/>
<div id="ShowTip" style="display:none"></div> <input type="submit" name="fdfdf" value="站内搜索" >
</td>
<tr>
<td scope="col"><div align="center" class="STYLE1">用户号</div></td>
<td scope="col"><div align="center" class="STYLE1">姓名</div></td>
<td scope="col"><div align="center" class="STYLE1">电话</div></td>
<td scope="col"><div align="center" class="STYLE1">手机</div></td>
<td scope="col"><div align="center" class="STYLE1">地址</div></td>
<td scope="col"><div align="center" class="STYLE1">油箱</div></td>
<td scope="col"><div align="center" class="STYLE1">学历</div></td>
<td scope="col"><div align="center" class="STYLE1">部门</div></td>
<td scope="col"><div align="center" class="STYLE1">权限</div></td>
<td scope="col"><div align="center" class="STYLE1">修改</div></td>
<td scope="col"><div align="center" class="STYLE1">删除</div></td>
</tr>
<%
for(int i=0;i<a1.size();i++){
//从a1中取出StudentBean
oabean.workerBean St=(oabean.workerBean)a1.get(i);
userId=""+St.getUserId() ;
%>
<tr>
<td align="center"><%=userId%></td>
<td align="center"><%=St.getUserName()%></td>
<td align="center"><%=St.getPhone() %></td>
<td align="center"><%=St.getMobile()%></td>
<td align="center"><%=St.getAddress()%></td>
<td align="center"><%=St.getMail()%></td>
<td align="center"><%=St.getDegree() %></td>
<td align="center"><%=St.getDepName()%></td>
<td align="center"><%=St.getPower()%></td>
<td align="center"><img src="images/del.gif"><a href="user/deleteUser.user?userId=<%=userId%>" onclick="return window.confirm('您确认要删除吗？');" style="text-decoration:none">删除</a></td>
<td align="center"><img src="images/mod.gif"><a href="admin/updateUser.jsp?userId=<%=userId%>&modal=true" class="thickbox" style="text-decoration:none">修改</a></td>
<%
}
%>
<tr>
<td colspan="10">
<ul id="nav">
页次: <span class="STYLE2"><% out.println(pageNow+"/"+pageCount);%></span>页
每页显示:<span class="STYLE2"><%=pageSize%></span>条
共有<span class="STYLE2"><%=rowCount%></span>条记录
<br>
<%
out.println("<li><a href=admin/worker.jsp?pageNow=1&choice1="+se1+"&choice2="+se2+"&name="+name+" style='text-decoration:none'>首</a></li>");
if(pageNow>1){
out.println("<li><a href=admin/worker.jsp?pageNow="+(pageNow-1)+"&choice1="+se1+"&choice2="+se2+"&name="+name+" style='text-decoration:none'>«</a></li>");
}
for(int j=1;j<=pageCount;j++){
out.println("<li><a href=admin/worker.jsp?pageNow="+j+"&choice1="+se1+"&choice2="+se2+"&name="+name+" style='text-decoration:none'>["+j+"]</a></li>");
}
if(pageNow<pageCount){
out.println("<li><a href=admin/worker.jsp?pageNow="+(pageNow+1)+"&choice1="+se1+"&choice2="+se2+"&name="+name+" style='text-decoration:none'>»</a></li>");
}
out.println("<li><a href=admin/worker.jsp?pageNow="+pageCount+"&choice1="+se1+"&choice2="+se2+"&name="+name+" style='text-decoration:none'>末</a></li>");
%>
</ul>
</td>
<td align="center"><img src="images/add.gif"><a href="admin/addUser.jsp?modal=true" class="thickbox" onmouseover="sty();" onmouseout="out();" style='text-decoration:blink'>增加</a></td>
</tr>
</table>
</form>
<form name="form2" action="admin/worker.jsp">
转到:<input type="text" name="pageNow" size="8">页
<input type="hidden" name="choice1" value="<%=se1%>">
<input type="hidden" name="choice2" value="<%=se2%>">
<input type="hidden" name="name" value="<%=name%>">
<input type="submit" value="Go">
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -