📄 grade_manager_m.jsp

📁 企业员工考勤系统

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312" 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;
   
   String sql="";
  
 %>
<html>
  <head>
     <title>院系管理</title>
	 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	 <link rel="stylesheet" href="../../public/style.css">
  </head>
  <body class="ss">
  <a href="grade_manager.jsp" class="a">建立年级</a>&nbsp;&nbsp;
  <a href="grade_manager_m.jsp" class="a">管理年级</a>&nbsp;&nbsp;
  <a href="javascript:window.location.reload()" class="a">刷新</a>&nbsp;&nbsp;
  <a href="javascript:history.back()" class="a">返回</a>
  <hr></hr>
  <center>
  <h3>年级信息列表</h3>
  <table width="50%" border="1" cellpadding="1" cellspacing="0">
    <tr bgcolor="#3399FF">
       
       <td width="10%">年级名称</td>
      
      
      <td width="10%"><center>删除</center></td>
    </tr>
       <% 
         sql="select * from grade order by grade_name";
         rs=conn.executeQuery(sql);
		 while(rs.next()){
       %>
    <tr>
      
      <td><%=rs.getString("grade_name") %></td>
      
      
      
      <td><center><a href="grade_del.jsp?id=<%=rs.getInt("id")%>" onClick="return confirm('您确信要删除吗？此院系的所有信息将被删除！')">删除</a></center></td>
    </tr>
      <% 
       }
     //  conn.close();
     %>
  </table>
  </center>  
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -