📄 student_list.jsp

📁 网上考试系统文件版
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
ResultSet rs = null;
String sql="";

if(request.getParameter("stunum")!=null)
	{
	String studentnum=new String(request.getParameter("stunum").getBytes("ISO8859_1"));
	sql="select * from student where student_num='"+studentnum+"'ORDER by student_num";
	}
	
if(request.getParameter("stuname")!=null)
	{
	String studentname=new String(request.getParameter("stuname").getBytes("ISO8859_1"));
	sql="select * from student where student_name ='"+studentname+"'ORDER by student_num";
	}

if(request.getParameter("stupermit")!=null)
	{
	String studentpermit=new String(request.getParameter("stupermit").getBytes("ISO8859_1"));
	sql="select * from student where student_permit ='"+studentpermit+"'ORDER by student_num";
	}

if((request.getParameter("studept")!=null)&&(request.getParameter("stuclass")!=null))
	{
	String studentdept=new String(request.getParameter("studept").getBytes("ISO8859_1"));
	String studentclass=new String(request.getParameter("stuclass").getBytes("ISO8859_1"));
	sql="select * from student where student_dept='"+studentdept+"' and student_class='"+studentclass+"'ORDER by student_num";
	}


	rs = Operate.executeQuery(sql);
%>

<html>
<head>
<title>无标题文档</title>
</head>
<style type=text/css>
BODY
{CURSOR: url(images/mouse.ani);
FONT-SIZE: 12px;
	COLOR: #000000;
	FONT-FAMILY: 宋体;
        SCROLLBAR-FACE-COLOR: #f6f6f6;
        SCROLLBAR-HIGHLIGHT-COLOR: #cccccc;
        SCROLLBAR-SHADOW-COLOR: #cccccc;
        SCROLLBAR-3DLIGHT-COLOR: #cccccc;
        SCROLLBAR-ARROW-COLOR: #330000;
        SCROLLBAR-TRACK-COLOR: #f6f6f6;
        SCROLLBAR-DARKSHADOW-COLOR: #cccccc;}
TD { 
FONT-SIZE: 12px; FONT-FAMILY: 宋体; line-height: 16px;table-layout:fixed;word-break:break-all}
input,select,Textarea{
        font-family:Verdana, Arial, Helvetica, sans-serif,宋体; 
        font-size: 12px; line-height: 16px;}
.table
{ border-collapse: collapse }
A {
        COLOR: #183468; 
        TEXT-DECORATION: none
}
A:hover {
        COLOR: #FF8C40; 
        TEXT-DECORATION: underline
}
A.ToolBarLink{
	font-size: 12px;
	text-decoration: none;
	color: #555555;
}
A.ToolBarLink:hover{
	font-size: 12px;
	text-decoration: underline;
	color: #666666;
}
A.TableLink{
	font-size: 12px;
	text-decoration: none;
	color: #555555;
}
A.TableLink:hover{
	font-size: 12px;
	text-decoration: underline;
	color: #FF9900;
}
th

.TableBorder 
{background-color: #000000;
border: 1px solid #000000;
font-size: 12px;
}
.Tablebody 
{background-color: #CCCCCC;
WORD-BREAK: break-all
font-size: 12px;
width:98%;}
.Shadow 
{FONT-SIZE: 9pt; FILTER: dropshadow(color=#FFFFFF,offx=-1,offy=1,positive=1); COLOR: #666666}
.ArticleSize
{font-size: 11pt; 
        font-family:"Verdana", "Arial", "宋体";
        line-height:150%;}
.Border1 
{background-color: #F5F5F5;}
.Border2 
{background-color: #FFFFFF; }
div.quote{margin:5px 20px;border:1px solid #CCCCCC;padding:5px;background:#F3F3F3 ;line-height : normal ;
}
div.HtmlCode{margin:5px 20px;border:1px solid #CCCCCC;padding:5px; background:#FDFDDF ;
font-size:14px;font-family:Tahoma;font-style : oblique;line-height : normal ;font-weight:bold;
}
<!--
.style3 {color: #880000}
-->
</style>
<body>
<table width="645" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="708" align="left" valign="top"><p>&nbsp;</p>
      <table class=center_tdbgall width="630" height="45" border="1" cellSpacing=0 cellPadding=0>
        <tr>
          <td width="100" height="23"><div align="center">学号</div></td>
          <td width="100"><div align="center">姓名
          </div></td>
          <td width="100"><div align="center">准考证号码</div></td>
          <td width="150"><div align="center">系别</div></td>
          <td width="70"><div align="center">班级</div></td>
          <td width="60"><div align="center">成绩</div></td>
          <td width="45"><div align="center">操作</div></td>
          <td width="45"><div align="center">操作</div></td>
        </tr>
<%
 if( rs == null )
{  	
	out.println("<table width=\"500\" height=\"200\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
	out.println("<tr>");
	out.println("<td><span class=\"style3\">&nbsp;&nbsp;&nbsp;&nbsp;结果集中无数据或者输入查询条件有错误！！</span></td>");
	out.println("</tr>");
	out.println("</table>");
}else{
		  while(rs.next()){
		  %>
        <tr>
          <td height="22"><div align="center"><%=rs.getString("student_num")%></div></td>
          <td><div align="center"><%=rs.getString("student_name")%></div></td>
          <td><div align="center"><%=rs.getString("student_permit")%></div></td>
          <td><div align="center"><%=rs.getString("student_dept")%></div></td>
          <td><div align="center"><%=rs.getString("student_class")%></div></td>
          <td><div align="center"><%=rs.getString("student_score")%></div></td>
          <td><div align="center"><a href="student_modify.jsp?stuid=<%=rs.getString("ID")%>">修改</a></div></td>
          <td><div align="center"><a href="student_delete.jsp?stunum=<%=rs.getString("student_num")%>">删除</a></div></td>
        </tr>
		  <%
		  }
		rs.close();
}
		  %>
      </table> 

      <p>&nbsp;</p>
    <p>&nbsp;</p>      <p>&nbsp;</p></td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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