📄 spmanager.jsp
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>
<%!
ResultSet rs=null;
ResultSet rs_c=null;
String sql="";
String sql_c="";
int c_number=0;
%>
<%
request.setCharacterEncoding("GBK");
%>
<script language="javascript">
function formCheck(theForm)
{
if(theForm.college_id.value=="")
{
alert("请选择院系！");
theForm.college_id.focus();
return false;
}
if(theForm.sp_id.value=="")
{
alert("专业代号不能为空！");
theForm.sp_id.focus();
return false;
}
if(theForm.sp_name.value=="")
{
alert("专业名称不能为空！");
theForm.sp_name.focus();
return false;
}
}
</script>
<html>
<head>
<title>专业管理</title>
<link rel="stylesheet" href="../../public/style.css">
</head>
<body class="ss">
<a href="spmanager.jsp" class="a">建立专业</a>
<a href="spmanager_m.jsp" class="a">管理专业</a>
<a href="javascript:window.location.reload()" class="a">刷新</a>
<a href="javascript:history.back()" class="a">返回</a>
<hr></hr>
<center>
<h3>建立新的专业</h3>
<form action="sp_add_2.jsp" method="post" onSubmit="return formCheck(this)">
<table width="43%" border="0" cellspacing="0">
<tr>
<td width="40%">请选择院系：</td>
<td width="60%"><select name="college_id">
<option value="" selected>===请选择===</option>
<%
ResultSet rs_c=null;
rs_c=conn.executeQuery("select college_id,college_name from college");//获得结果集
while(rs_c.next())//输出结果集
out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
conn.close();
%>
</select></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="40%">专业代号:</td>
<td width="60%"><input name="sp_id" type="text" size="30" maxlength="20"></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="40%">专业名称:</td>
<td width="60%"><input name="sp_name" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="40%"><center><input type="submit" name="Submit" value="添加"></center></td>
<td width="60%"><center><input type="reset" name="Submit" value="重置"></center></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<%
String msg=(String)request.getParameter("errmsg");
if(msg!=null&&!msg.equals("")){
%>
<tr>
<td colspan="8"><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 + -