📄 jiangchenggerenzongti.jsp
字号:
<%@ page import="java.util.*, java.sql.*"
contentType="text/html;charset=gb2312" %>
<HTML>
<head>
<script LANGUAGE="javascript">
function isNum(passedVal){
for(i=0;i<passedVal.length;i++)
{if(passedVal.charAt(i)<"0")
return false
else if(passedVal.charAt(i)>"9")
return false}}
function form1_onsubmit() {
if (document.form1.showPage.value=="")
{
alert("请输入一个正确的数")
document.form1.showPage.focus()
return false
}
else if(isNum(document.form1.showPage.value)==false)
{
alert("请输入一个正确的整数")
document.form1.showPage.focus()
return false
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
<style>
.DoubleColorTable tr{
background-color:expression("#FFFFFF,#EEEEEE".split(",")[rowIndex%2])
}
</style>
<title>奖惩总体查询</title></head>
<body onload='self.status="辽宁工程技术大学"'>
<p>
<%! public String getString(String s)
{if(s==null) s="";
try {byte a[]=s.getBytes("ISO-8859-1");
s=new String(a);
}
catch(Exception e)
{}
return s;
} %>
<%int PageSize=5; //????????
int RowCount; //????
int PageCount; //???
int Page; //?????
int showPage;
int i,j,k;
String strPage = request.getParameter("showPage");
if (strPage==null){
//???QueryString???page?????,?????????
Page = 1;
} else{
//?????????
Page = Integer.parseInt(strPage);
if(Page<1) Page = 1;
}%>
<%
String name= (String)session.getAttribute("name");
name=getString(name);
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","hehong");
sql=con.createStatement();
String condition="select count(*) from jiangcheng,teacher where jiangcheng.jxingming=teacher.tcode and jxingming="+"'"+name+"'";
rs =sql.executeQuery(condition);
rs.next();
RowCount =rs.getInt(1);
rs.close();
PageCount = (RowCount+PageSize-1) / PageSize; //?????
if(Page>PageCount) Page = PageCount; //????????
String swe = "select * from jiangcheng,teacher where jiangcheng.jxingming=teacher.tcode and jxingming="+"'"+name+"'";
rs = sql.executeQuery(swe); //??SQL????????
i = (Page-1) * PageSize; //???????????????????
for(j=0;j<i;j++) rs.next(); %>
<center>
</p>
<form action="" name="form1" method="get" onsubmit="return form1_onsubmit()" LANGUAGE="javascript">
你想要去第
<input name="showPage" Type="text" size="4">
<input Type="submit" name="fen" value="页">
</form>
<p>
<%
String integer=request.getParameter("showPage");
if(integer==null)
{
integer="1";
}
try{showPage=Integer.parseInt(integer);
}
catch(NumberFormatException e1)
{
showPage=1;
}
if(showPage<=1)
{
showPage=1;
}
if(showPage>=PageCount)
{
showPage=PageCount;
}
%>目前显示第<%=showPage %>页</p>
<table width="101%" border="0" cellspacing="1" >
<tr>
<td width="54%">共有<%=RowCount%>条记录,共<%=PageCount%>页</td>
<td width="9%"> <%if(showPage<2){%>首页<%}%><%else{%><a href="jiangchengzongti.jsp?showPage=1">首页</a></td><%}%>
<td width="13%"><%if(showPage<2){%>上一页<%}%><%if(showPage>1){%>
<a href="jiangchengzongti.jsp?showPage=<%=showPage-1%>">上一页</a>
<%
}%></td>
<td width="13%"><%if(showPage-PageCount>=0){%>下一页<%}%><%if(showPage<PageCount){%>
<a href="jiangchengzongti.jsp?showPage=<%=showPage+1%>">下一页</a>
<%
}
%></td>
<td width="11%"> <%if(showPage-PageCount>=0){%>尾页<%}%><%else{%><a href="jiangchengzongti.jsp?showPage=<%=PageCount%>">尾页</a></td><%}%>
</tr>
</table>
<table width=98% border="1" align=left cellpadding="0" cellspacing="1" bordercolor="#009900" class="DoubleColorTable">
<tr bordercolor="#CCCCCC">
<td width="14%" scope="row">员工代码</td>
<td width="15%" scope="row">员工姓名</td>
<td width="18%">奖惩名称</td>
<td width="21%">奖惩日期</td>
<td width="17%">奖惩文号</td>
<td width="15%">浏览详细信息</td>
</tr>
<%
i = 0;
while(i<PageSize && rs.next()){
String jxingming=rs.getString("jxingming");
String jmingdan=rs.getString("jmingdan");
String jriqi=rs.getString("jriqi");
String jwenhao=rs.getString("jwenhao");
String tname=rs.getString("tname");
%>
<tr bordercolor="#CCCCCC">
<td ><%=jxingming%></td>
<td ><%=tname%></td>
<td ><%=jmingdan%></td>
<td ><%=jriqi%></td>
<td><%=jwenhao%></td>
<td ><div align="center" class="style4"><A Href="jiangchengxiangxi.jsp?jxingming=<%=jxingming%>&&jwenhao=<%=jwenhao%>">详细信息</a></div></td>
</tr><% i++; }
%>
</table>
<p> </p>
<p>
<% con.close();}
catch(SQLException e) { }
%>
</p>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -