📄 yhgl.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page pageEncoding="GB2312"%>
<%
java.sql.Connection sqlCon ; //数据库连接对象
java.sql.Statement sqlStmt ; //SQL语句对象
java.sql.ResultSet sqlRst ; //结果集对象
java.lang.String strCon ; //数据库连接字符
java.lang.String strSQL ; //SQL语句
int intPageSize ; //一页最多显示的记录数
int intRowCount ; //记录总数
int intPageCount ; //总页数
int intPage ; //待显示页码
java.lang.String strPage ;
int i;
//设置一页最多显示的记录数
intPageSize = 10 ;
//取得待显示页码
strPage = request.getParameter("page") ;
if(strPage == null){
//表名在QueryString中没有page这个参数，此时显示第一页数据
intPage = 1 ;
} else{
//将字符串转换成整形
intPage = java.lang.Integer.parseInt(strPage) ;
if(intPage<1) intPage = 1 ;
}
//转载JDBC驱动程序
Class.forName("com.mysql.jdbc.Driver").newInstance() ;
//连接数据库
//localhost/shop为数据库，user为root，password为密码。
sqlCon = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/jzg?user=root&password=root&useUnicode=true&characterEncoding=gbk") ;
//创建语句对象
sqlStmt=sqlCon.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY) ;
//创建查询语句
strSQL = "select * from user order by id desc" ;
//执行SQL语句并获得结果集
sqlRst = sqlStmt.executeQuery(strSQL) ;
//获取记录总数
sqlRst.last() ;
intRowCount = sqlRst.getRow() ;
//计算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize ;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount ;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<!-- DW6 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>教职工管理系统</title>
<link rel="stylesheet" href="emx_nav_right.css" type="text/css">
<script type="text/javascript">
<!--
var time = 3000;
var numofitems = 7;
//menu constructor
function menu(allitems,thisitem,startstate){
callname= "gl"+thisitem;
divname="subglobal"+thisitem;
this.numberofmenuitems = 7;
this.caller = document.getElementById(callname);
this.thediv = document.getElementById(divname);
this.thediv.style.visibility = startstate;
}
//menu methods
function ehandler(event,theobj){
for (var i=1; i<= theobj.numberofmenuitems; i++){
var shutdiv =eval( "menuitem"+i+".thediv");
shutdiv.style.visibility="hidden";
}
theobj.thediv.style.visibility="visible";
}
function closesubnav(event){
if ((event.clientY <48)||(event.clientY > 107)){
for (var i=1; i<= numofitems; i++){
var shutdiv =eval('menuitem'+i+'.thediv');
shutdiv.style.visibility='hidden';
}
}
}
// -->
</script>
<style type="text/css">
<!--
.style10 {font-size: 16px; color: #0066FF; }
#Layer1 {
position:absolute;
left:814px;
top:112px;
width:149px;
height:27px;
z-index:1;
}
-->
</style>
</head>
<body onmousemove="closesubnav(event);">
<div id="Layer1">
<table width="120">
<tr>
<td><a href="zc.jsp">新员工录入</a></td>
</tr>
</table>
</div>
<table width="96%" height="100%" border="0" align="center" cellspacing="0">
<tr>
<td height="52" colspan="6" background="image/top_bg.gif"><table width="466" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="269"><img src="image/logo.jpg" width="269px" height="52"></td>
<td width="167"><img src="image/top_2.gif" width="167px" height="52"> </td>
<td width="30"></td>
</tr>
</table></td>
</tr>
</table>
<div class="skipLinks">skip to: <a href="#content">page content</a> | <a href="pageNav">links on this page</a> | <a href="#globalNav">site navigation</a> | <a href="#siteInfo">footer (site information)</a> </div>
<div id="masthead">
<br>
<br>
<br>
<div id="globalNav">
<img alt="" src="image/gblnav_left.gif" height="32" width="4" id="gnl"> <img alt="" src="image/glbnav_right.gif" height="32" width="4" id="gnr">
<div id="globalLink">
<a href="#" id="gl1" class="glink" onmouseover="ehandler(event,menuitem1);">教职工基本信息管理</a>
<a href="#" id="gl2" class="glink" onmouseover="ehandler(event,menuitem2);">其他信息管理</a>
<a href="#" id="gl3" class="glink" onmouseover="ehandler(event,menuitem3);">信息查询</a>
<a href="index.jsp" id="gl4" class="glink" onmouseover="ehandler(event,menuitem4);">安全退出</a>
</div>
<!--end globalLinks-->
</div>
<!-- end globalNav -->
<div id="subglobal1" class="subglobalNav">
<a href="jbxx.jsp">基本信息</a> |
<a href="cjxx.jsp">惩奖信息</a> |
<a href="ndkh.jsp">年度考核</a> </div>
<div id="subglobal2" class="subglobalNav">
<a> </a>
<a> </a>
<a> </a>
<a href="zc.jsp">注册新用户</a> |
<a href="khxx.jsp">年度考核</a> |
<a href="yhgl.jsp">用户管理</a> </div>
<div id="subglobal3" class="subglobalNav">
<a> </a>
<a> </a>
<a> </a>
<a href="grxxcx.jsp">个人信息查询</a> |
<a href="khxxcx.jsp">考核信息查询</a> |
<a href="hzxxcx.jsp">惩奖信息查询</a> </div>
<div id="subglobal4" class="subglobalNav"> </div>
<div id="subglobal5" class="subglobalNav"> </div>
<div id="subglobal6" class="subglobalNav"> </div>
<div id="subglobal7" class="subglobalNav"> </div>
<div id="subglobal8" class="subglobalNav"> </div>
</div>
<div id="pagecell1">
<table width="98%" border="1" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td height="30"><p align="center"><font size="5" face="华文新魏">用户资料</font> </p></td>
</tr>
<tr>
<td height="90"><table width="98%" border="1" align="center" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0">
<tr align="center" valign="middle">
<td height="20"><font size="4" face="华文新魏">用户名</font></td>
<td width="93" height="20"><font size="4" face="华文新魏">用户密码</font></td>
<td width="105" height="20"><font size="4" face="华文新魏">真实姓名</font></td>
<td width="147" height="20"><font size="4" face="华文新魏">所属学院</font></td>
<td width="112" height="20"><font size="4" face="华文新魏">入职时间</font></td>
<td width="65" height="20"><font size="4" face="华文新魏">工号</font></td>
<td width="50" height="20"><font size="4" face="华文新魏">性别</font></td>
<td width="74" height="20"><font size="4" face="华文新魏">更改</font></td>
<td width="64" height="20"><font size="4" face="华文新魏">删除</font></td>
</tr>
<% if(intPageCount>0) {
//将记录指针定位到待显示页的第一条记录上
sqlRst.absolute((intPage-1) * intPageSize + 1 ) ;
i = 0 ;
while(i<intPageSize && ! sqlRst.isAfterLast()){
%>
<tr align="center" valign="middle">
<td width="100" height="25"><span class="style10"><%=sqlRst.getString("user")%></span></td>
<td width="93" height="25"><span class="style10"><%=sqlRst.getString("password")%></span></td>
<td width="105" height="25"><span class="style10"><%=sqlRst.getString("name")%></span></td>
<td width="147" height="25"><span class="style10"><%=sqlRst.getString("college")%></span></td>
<td width="112" height="25"><span class="style10"><%=sqlRst.getString("rzsj")%></span></td>
<td width="65" height="25"><span class="style10"><%=sqlRst.getString("gh")%></span></td>
<td width="50" height="25"><span class="style10"><%=sqlRst.getString("sex")%></span></td>
<td width="74" height="25"><a href="servlet/Modify?user=<%=sqlRst.getString("user")%>">修改</a></td>
<td width="64" height="25"><a href="servlet/Delete?user=<%=sqlRst.getString("user")%>">删除</a></td>
</tr>
<% sqlRst.next() ;
i ++ ;
}
}
%>
</table></td>
</tr>
<tr>
<td height="30" align="center"><font size="4" face="华文新魏">第<%=intPage%>页 共<%=intPageCount%>页
<% if(intPage>1){ %>
<a href="dzxx.jsp?page=<%=intPage-1%>">上一页</a>
<% }else{ %>
上一页
<% } %>
<% if(intPage<intPageCount){ %>
<a href="dzxx.jsp?page=<%=intPage+1%>">下一页</a>
<% }else{ %>
下一页
<% } %>
</font> </td>
</tr>
</table>
<%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
</div>
<!-- end masthead -->
<!--end pagecell1-->
<br>
<script type="text/javascript">
<!--
var menuitem1 = new menu(7,1,"hidden");
var menuitem2 = new menu(7,2,"hidden");
var menuitem3 = new menu(7,3,"hidden");
var menuitem4 = new menu(7,4,"hidden");
var menuitem5 = new menu(7,5,"hidden");
var menuitem6 = new menu(7,6,"hidden");
var menuitem7 = new menu(7,7,"hidden");
// -->
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -