📄 student.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
ResultSet rs = null;
rs = Operate.executeQuery("select * from dept");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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;
}
</style>
<body>
<table width="600" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><br>
<form name="form1" method="post" action="student_list.jsp">
<table width="370" height="21" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="131"><div align="center">请输入学号查询：</div></td>
<td width="169">
<div align="center">
<input name="stunum" type="text" size="25" maxlength="30">
</div></td>
<td width="70"><div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</form>
<br>
<form name="form2" method="post" action="student_list.jsp">
<table width="370" height="21" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="131"><div align="center">请输入姓名查询：</div></td>
<td width="169">
<div align="center">
<input name="stuname" type="text" size="25" maxlength="30">
</div></td>
<td width="70"><div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</form>
<br>
<form name="form2" method="post" action="student_list.jsp">
<table width="370" height="24" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="147">根据准考证号查询：</td>
<td width="151">
<div align="center">
<input name="stupermit" type="text" size="22" maxlength="30">
</div></td>
<td width="72">
<div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</form>
<br>
<form name="form3" method="post" action="student_list.jsp">
<table width="318" height="49" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="113" height="22"><div align="center">请选择系别</div></td>
<td width="132">
<div align="center">
<select name="studept" size="1">
<option selected>请选择</option>
<%
while(rs.next()){
%>
<option><%=rs.getString("deptname")%></option>
<%
}
rs.close();
%>
</select>
</div></td>
<td width="65" rowspan="2">
<div align="center"><input type="submit" name="Submit" value="提交"></div>
</td>
</tr>
<tr>
<td height="24"><div align="center">请输入班级</div></td>
<td><input name="stuclass" type="text" size="22" maxlength="30"></td>
</tr>
</table>
</form> <br>
<table width="350" height="37" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><a href="student_add.jsp">增加学生信息</a></td>
</tr>
</table> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -