📄 teq2.jsp
字号:
<html>
<head>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="adminBean" scope="page" class="exam.exam"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询学生</title>
<script language="JavaScript">
function detail(a,b)
{
c="qscore.jsp?pnum="+a+"&sbnum="+b;
window.open(c,"body31f","toolbar=no,status=no,scrollbars=yes,menubar=no,location=no,top=190,resizable=no,left=250,width=430,height=400")
}
function submit01()
{
self.location.replace("teq2.jsp")
}
</script>
<link href="_notes/ccc" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:visited {
text-decoration: none;
}
A:active {color: #000000}
A:link,A:visited {color:#000000; text-decoration: none}
A:hover {color:#003399;text-decoration:underline}
-->
</style>
</head>
<body background="images/bg.gif">
<table width="730" border=1 align="center" bordercolor="#008000" background="images/bj.gif">
<tr bgcolor="#99FFFF">
<td>
<div align="center"><strong>学 号</strong></div></td>
<td>
<div align="center"><strong>姓 名</strong></div></td>
<td>
<div align="center"><strong>性 别</strong></div></td>
<td>
<div align="center"><strong>系 别</strong></div></td>
<td>
<div align="center"><strong>年 级</strong></div></td>
<td>
<div align="center"><strong>班 级</strong></div></td>
<td>
<div align="center"><strong>成绩单</strong></div></td>
</tr>
<%
String sid=request.getParameter("id");
if(sid==null)
{
sid=(String)session.getValue("sid");
}
String name2 = null;
if (request.getParameter("sname") != null) {
name2=new String ((request.getParameter("sname")).getBytes("ISO8859-1"),"gb2312");
}
if(name2==null)
{
name2=(String)session.getValue("name2");
}
String depints=request.getParameter("dep");
if(depints==null)
{
depints=(String)session.getValue("depints");
}
session.putValue("depints",depints);
session.putValue("sid",sid);
session.putValue("name2",name2);
int pageLine=4;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
ResultSet countrs=null;
countrs=adminBean.executeQuery("select count(*)as cnt from student where snum like '"+"%"+sid+"%"+"' and sname like '"+"%"+name2+"%"+"' and dep like '"+"%"+depints+"%"+"'");
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
adminBean.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
ResultSet rs2=adminBean.executeQuery("select * from student where snum like '"+"%"+sid+"%"+"' and sname like '"+"%"+name2+"%"+"' and dep like '"+"%"+depints+"%"+"'");
ResultSet rs0=adminBean.executeQuery("select * from student where snum like '"+"%"+sid+"%"+"' and sname like '"+"%"+name2+"%"+"' and dep like '"+"%"+depints+"%"+"'");
int sbnum;
String id;
String name;
int sexint;
String sex;
int gradeint;
String gradestr;
int sclassint;
int depint;
if (rs0.next())
{ }
else
{
out.println(" <td> </td><td><center><font color=red>查无此记录!!!</font></center></td><td> </td><td> </td><td> </td><td> </td><td> </td>");
}
if (intPageCount>0)
{
for(i=1;i<=(intPage-1)*pageLine;i++)
rs2.next();
for(i=1;i<=pageLine;i++)
{
if(rs2.next())
{
id=rs2.getString("snum");
name=rs2.getString("sname");
sexint=rs2.getInt("ssex");
if (sexint==1)
sex="男";
else
sex="女";
gradeint=rs2.getInt("grade");
if (gradeint<=9)
gradestr="0"+gradeint;
else gradestr=""+gradeint;
sclassint=rs2.getInt("sclass");
depint=rs2.getInt("dep");
String sdep;
String sql2="select * from departmen where dep='"+depint+"'";
ResultSet rs22=adminBean.executeQuery(sql2);
rs22.next();
sdep=rs22.getString("depname");
rs22.close();
%>
<font size="3">
<tr>
<td><center>
<%=id%></center></td>
<td><center>
<%=name%></center></td>
<td><center>
<%=sex%></center></td>
<td><center>
<%=sdep%></center></td>
<td><center>
<%=gradestr%></center></td>
<td><center>
<%=sclassint%></center></td>
<td align="center" width="10%"><font size="2" color="000000"><a href="javascript:detail(<%=id%>,<%=id%>);" class="ccc">查看</a></font></td>
</tr>
</font>
<%}
}
%></tr>
</table>
<%
rs2.close();
}
%>
<%
out.print("<center><table "+"width=600 "+" valign=bottom>");
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='post' name=fPageNum action='teq2.jsp'>");
if(intPage<2)
out.print("首页 上一页 ");
else{
out.print("<a href='teq2.jsp?page=1' ><font color='#2DFFFF' size='2'>首页 </font></a>");
out.print("<a href='teq2.jsp?page="+(intPage-1)+"' ><font color='#2DFFFF' size='2'>上一页 </font></a>");
}
if(intPage-intPageCount>=0)
out.print("下一页 尾页");
else{
out.print("<a href='teq2.jsp?page="+(intPage+1)+"'><font color='#2DFFFF' size='2'>下一页 </font></a><a href='teq2.jsp?page="+intPageCount+"'><font color='#2DFFFF' size='2'>尾页</font></a>");
}
out.print(" 页次:<b><font color=red>"+intPage+"</font>/<font color=red>"+intPageCount+"</font></b>页 ");
out.print("共<b><font color=red>"+totalRec+"</font></b>条记录 <b><font color=red>"+pageLine+"</font></b>条/页");
out.print(" 转到第<input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("页<input class=buttonface type='submit' value='GO' name='cndok'></span></p></form>");
out.print("</tr>");
out.print("</table></center>");
%></font>
<div align="center"></div>
<center>
<form action="teindex.jsp" method="post" name="form1" target="_parent">
<p>
<input name="Submit" type="submit" value="结束查询">
</p>
</form>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -