📄 kecheng_update.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>
<script language="javascript">
function formCheck(theForm)
{
if(theForm.kecheng_name.value=="")
{
alert("课程名称不能为空!");
theForm.kecheng_name.focus();
return false;
}
}
</script>
<%!
String sql="";
ResultSet rs=null;
String id="";
String kecheng_id="";
String kecheng_name="";
String college_id="";
%>
<%
request.setCharacterEncoding("GBK");
id=request.getParameter("id");
sql="select * from kecheng where id='"+id+"'";
rs=conn.executeQuery(sql);
if(rs.next()){
kecheng_id=rs.getString("kecheng_id");
kecheng_name=rs.getString("kecheng_name");
college_id=rs.getString("college_id");
}
%>
<html>
<head>
<title>修改课程</title>
<link rel="stylesheet" href="../../public/style.css">
</head>
<body class="ss">
<a href="javascript:window.location.reload()" class="a">刷新</a>
<a href="javascript:history.back()" class="a">返回</a>
<hr></hr>
<center>
<h3>修改课程</h3>
<form action="kecheng_update_m.jsp" method="post" onSubmit="return formCheck(this)">
<input type="hidden" name="kecheng_id" value="<%=kecheng_id%>">
<table width="39%" height="179" border="0" cellspacing="0">
<tr>
<td width="35%">课程代号：</td>
<td width="65%"><%= kecheng_id %></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>课程名称：</td>
<td><input name="kecheng_name" type="text" size="20" maxlength="20" value="<%=kecheng_name%>"></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>课程所属院系：</td>
<td><select name="college_id">
<%
if(college_id==null){
%>
<option value="" selected>=====公共课程=====</option>
<%
ResultSet rs_c=null;
rs_c=conn.executeQuery("select * from college");
while(rs_c.next())
out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
conn.close();
%>
<%
}else{
out.println("<option value=''>=====公共课程=====</option>");
ResultSet rs_c=null;
String college_id_s="";
rs_c=conn.executeQuery("select * from college");
if(rs_c.next()){
do{
college_id_s=rs_c.getString("college_id");
if(college_id.equals(college_id_s))
out.println("<option value="+rs_c.getString("college_id")+" selected>"+rs_c.getString("college_name")+"</option>");
else
out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
}while(rs_c.next());
}
conn.close();
}
%>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td><center><a href="javascript:history.back()">返回</a></center></td>
<td><center><input type="submit" value="修改"></center></td>
</tr>
<%
String msg=(String)request.getParameter("errmsg");
if(msg!=null&&!msg.equals("")){
%>
<tr>
<td colspan="5"><div align="center"><font color="red" size="2"><%=msg%></font></div></td>
</tr>
<%
}
%>
</table>
</form>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -