📄 edit.jsp

📁 这是一个在线教育系统
💻 JSP
字号:
<%@ include file="conn.jsp"%>
<%String adminvalue="admin",teacher="",fenlei1="",fenlei2="";%>
<%@ include file="isteacher.jsp"%>
<%@ include file="fenlei.jsp"%>
<%
String id=request.getParameter("id");
sql="select * from scott.main,scott.teacher where main.idofteacher=teacher.teacherid and main.mainid="+id; 
 rs=stmt.executeQuery(sql); 
  if(!rs.next()){
out.print("<SCRIPT language=JavaScript>alert('没有找到符合条件的资料！');");
   out.print("history.go(-1);</SCRIPT>"); 
  }else{

%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
	FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
	FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
	COLOR: #0033cc; TEXT-DECORATION: none
}
A:visited {
	COLOR: #0033cc; TEXT-DECORATION: none
}
A:active {
	COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
	COLOR: #000000; TEXT-DECORATION: underline
}
.header	{
font-family: Tahoma, Verdana; font-size: 9pt; color: #FFFFFF; background-color: #69C37C
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: #EFEFEF
}
</STYLE>
<title>编辑资料</title>
<script language="javascript">
function submitonce(theform)
{
//if IE 4+ or NS 6+
if (document.all||document.getElementById){
//screen thru every element in the form, and hunt down "submit" and "reset"
for (i=0;i<theform.length;i++){
var tempobj=theform.elements[i]
if(tempobj.type.toLowerCase()=="submit"||tempobj.type.toLowerCase()=="reset")
//disable em
tempobj.disabled=true
}
}
}
</script>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 onload="document.forms[0].fenlei1.disabled=true,document.forms[0].fenlei2.disabled=true,document.forms[0].teacher.disabled=true;">
<br>
<form action="editok.jsp" method="post" onSubmit=submitonce(this)>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 width="480" border="1" align="center" cellpadding=1>
<tr><td align="center" class="header" colspan=2>编辑资料</td></tr>
  
  <input type=hidden name="fenlei1" size=15 value="<%=fenlei1%>">
  <input type=hidden name="fenlei2" size=15 value="<%=fenlei2%>">
  <input type=hidden name="teacher" size=15 value="<%=teacher%>">
  <tr>
    <td align="center">课程名称</td>
    <td>&nbsp;<input type=text name="course" size=15 value="<%=rs.getString("course")%>">（为方便查找，请各教师注意尽量统一名称）</td>
  </tr>
  <tr>
    <td align="center">资料标题</td>
    <td>&nbsp;<input type=text name="title" size=52 value="<%=rs.getString("title")%>"></td>
  </tr>
  
  <tr>
    <td align="center">资料地址</td>
    <td>&nbsp;<input type=text name="fileurl" size=50 value="<%=rs.getString("fileurl")%>">
        <br>&nbsp;（如资料链接自其他网站，请自行填写链接地址）
    </td>
  </tr>
  <tr>
    <td align="center">资料大小</td>
    <td>&nbsp;<input type=text name="filesize" size=15 value=<%=rs.getString("filesize")%>>K</td>
  </tr>
  <tr>
    <td align="center">资料类型</td>
    <td>&nbsp;<select name="type">
<%
String sql1="select * from scott.type"; 
  Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
 ResultSet rs1=stmt1.executeQuery(sql1); 
%>

<%
while(rs1.next()){
%>
 <option value="<%=rs1.getString("typeid")%>"><%=rs1.getString("type")%></option>
<%
}

%>
	</select>
    </td>
  </tr>
  <tr>
    <td align="center">资料简介</td>
    <td>
        &nbsp;<textarea name="content" cols="40" rows="6"><%=rs.getString("content")%></textarea>
        <input type=hidden name="id" value="<%=id%>">
    </td>
  </tr>
</table>
<center><br><input type=submit name="submit" value="修改">&nbsp;&nbsp;<input type=reset name="reset" value="恢复"></center>
</form>
</body>
</html>
<%
  }
%>
⌨️ 快捷键说明

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