📄 student_modify.jsp
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<jsp:useBean id="DbUtil" scope="page" class="todb.DbUtil"/>
<%
ResultSet rs = null;
String studentid=request.getParameter("stuid");
rs = Operate.executeQuery("select * from student where ID="+studentid+"");
%>
<script language="javascript">
function checkform() {
if (document.form1.stunum.value=="" || document.form1.stuname.value==""|| document.form1.stupermit.value==""|| document.form1.studept.value==""|| document.form1.stuclass.value==""){
alert("请确保输入信息完整！");
return false;
}
return true;
}
</script>
<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;
}
</style>
<body>
<table width="600" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><p> </p>
<form name="form1" method="post" action="student_update.jsp">
<%
while(rs.next()){
%>
<input name="stuid" type="hidden" size="20" maxlength="30" value="<%=rs.getString("ID")%>">
<table class=center_tdbgall width="314" height="151" border="1" align="center" cellSpacing=0 cellPadding=0>
<tr>
<td width="104" height="21"><div align="center">学号</div></td>
<td width="210">
<div align="center">
<input name="stunum" type="text" size="20" maxlength="30" value="<%=rs.getString("student_num")%>">
</div></td>
</tr>
<tr>
<td height="21"><div align="center">姓名</div></td>
<td>
<div align="center">
<input name="stuname" type="text" size="20" maxlength="30" value="<%=rs.getString("student_name")%>">
</div></td>
</tr>
<tr>
<td height="22"><div align="center">准考证号码</div></td>
<td><div align="center">
<input name="stupermit" type="text" size="20" maxlength="30" value="<%=rs.getString("student_permit")%>">
</div></td>
</tr>
<tr>
<td height="22"><div align="center">系别</div></td>
<td>
<div align="center">
<%
Connection conn1=DbUtil.connectToDb();
Statement stmtx = conn1.createStatement(); //语句接口
ResultSet rsx = null;
rsx = stmtx.executeQuery("select * from dept");
%>
<select name="studept" size="1">
<%
while(rsx.next()){
%>
<option><%=rsx.getString("deptname")%></option>
<%
}
rsx.close();
conn1.close();
%>
</select>
</div></td>
</tr>
<tr>
<td height="23"><div align="center">班级</div></td>
<td>
<div align="center">
<input name="stuclass" type="text" size="20" maxlength="30" value="<%=rs.getString("student_class")%>">
</div></td>
</tr>
<tr>
<td height="20"><div align="center">成绩
</div> <div align="center">
</div></td>
<td height="20"><div align="center">
<input name="stuscore" type="text" size="20" maxlength="30" value="<%=rs.getString("student_score")%>">
</div></td>
</tr>
<tr>
<td height="22" colspan="2"><div align="center">
<input type="submit" name="Submit" value="提交" onclick="javascript:return(checkform());">
</div></td>
</tr>
</table>
<%
}
rs.close();
%>
</form>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -