📄 classinfo0.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>班级信息</title>
<style type="text/css">
<!--
body {
background-color: #B9DAF9;
}
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String userid = (String) session.getAttribute("userid");
if (userid == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
Integer level = (Integer) session.getAttribute("level");
int l = level.intValue();
if (level == null)
response.sendRedirect("../index.jsp?error=2");
if (!(l == 2))
response.sendRedirect("../error.jsp");
%>
<%
String sql = null;
java.sql.Connection con = null;
java.sql.ResultSet rs = null;
%>
<%
sql = "select * from class";
con = myRs.getConnection();
rs = myRs.executeQuery(sql);
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" border="0" background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" height="160" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassInfo.jsp">班级信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassQuery.jsp">班级号查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassQuery.jsp">班级名查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassAdd.jsp">增加班级</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassDel.jsp">删除班级</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ClassMod.jsp">修改班级</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<%
out.println("<table align=\"center\" border=\"1\" width=\"800\">");
out.println("<tr><td>编号<td>名称<td>人数<td>入学日期</tr>");
while (rs.next()) {
out.println("<tr><td><a href=\"Class.jsp?classid="
+ rs.getString("classid") + "\">"
+ rs.getString("classid") + "</a><td>"
+ rs.getString("classname") + "<td>"
+ rs.getInt("menbers") + "<td>" + rs.getDate("Cdate")
+ "</tr>");
}
out.println("</table>");
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -