adddepartment.jsp

来自「采用基于B/S结构进行开发学生管理信息系统,本系统采用Servlet+Jsp+J」· JSP 代码 · 共 74 行

JSP
74
字号
<%@ 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>&nbsp;</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>&nbsp;</p>
<p align="center"><a href="getDepartment.jsp">返回</a></p>


</body>
</html>

⌨️ 快捷键说明

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