📄 year_manager_m.jsp

📁 企业员工考勤系统

💻 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;
   String sql="";
   String weekday="";
   Date start_time;
   Date end_time;
 %>

<% 
  request.setCharacterEncoding("GBK");
%>

<html>
  <head>
     <title>学年安排</title>
	 <link rel="stylesheet" href="../../public/style.css">
	 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  </head>
  <body class="ss">
  <a href="javascript:window.location.reload()" class="a">刷新</a>&nbsp;
  <a href="javascript:history.back()" class="a">返回</a>
  <hr></hr>
  <center>
  <h3>学年安排列表</h3>
   <table width="80%" border="1" cellspacing="0">
     <tr bgcolor="#0099FF">
        <td>学年代号</td>
        <td>学年名称</td>
        <td>开始时间</td>
        <td>结束时间</td>
    
        <td><div align="center">修改</div></td>
        <td><div align="center">删除</div></td>
     </tr>
     <% 
        sql="select * from year order by year_id DESC ";
        rs=conn.executeQuery(sql);
        while(rs.next()){
      %>
      <tr>
         <td><%= rs.getString("year_id") %></td>
         <td><%= rs.getString("year_name") %></td>
         <td><%= rs.getDate("year_start") %></td>
         <td><%= rs.getDate("year_end") %></td>
        
         <td><div align="center"><a href="year_detial.jsp?id=<%=rs.getInt("id")%>">修改</a></div></td>
         <td><div align="center"><a href="year_del.jsp?id=<%=rs.getInt("id")%>" target="admin_right" onclick="return confirm('您确信要删除吗？有关此学年的信息将全部删除！')">删除</a></div></td>
      </tr>
      <% 
         }
       conn.close();
      %>
   </table>
  </center>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -