📄 adddepartment.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="myBeans.SQLBean" %>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>增加院系</title>
</head>
<body>
<p>
<% String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String dep = (String)session.getAttribute("dep");
if(dep==null){response.sendRedirect("login.jsp");
}else if(!dep.equals("0000")){response.sendRedirect("getDepartment.jsp");
}
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">新增院系</font></p>
<form name="form1" method="post" action="DepartmentSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center">
<table width="420" border="0" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="33%" bgcolor="#FFFFFF"><div align="right">院系名称</div></td>
<td width="67%" bgcolor="#FFFFFF"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">院长</div></td>
<td bgcolor="#FFFFFF"><input name="cname" type="text" id="cname"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">院系代号</div></td>
<%boolean f = true;
String count = "",format = "0000";
String sql="select count(*)+1 from department";
String query="";
SQLBean db = new SQLBean();
ResultSet rs = db.executeQuery(sql);
if(rs.next()){
count = rs.getString(1);
}
if(count.length()<format.length()){
count=format.substring(count.length())+count;
}
while( f ){
SQLBean db1 = new SQLBean();
query="select ID from department where ID='"+count+"'";
rs = db1.executeQuery(query);
if(rs.next()){
count = String.valueOf((Integer.parseInt(count)+1));
if(count.length()<format.length()){
count=format.substring(count.length())+count;
}
}else{f=false;}
}
%>
<td bgcolor="#FFFFFF"><input name="id" type="text" id="id" value="<%=count%>"></td>
</tr>
</table>
<p>
<input name="确定" type="submit" id="确定" value="提交">
</p>
</div>
</form>
<p> </p>
<p align="center"><a href="getDepartment.jsp">返回</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -