📄 getclass.jsp

📁 学生/教师信息管理系统,用JSP+ACCESS开发

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>班级</title>
<style type="text/css">
<!--
.STYLE1 {
	font-family: "华文行楷";
	font-weight: bold;
}
.STYLE2 {font-family: "华文行楷"}
-->
</style>
</head>
<jsp:useBean id="classp" scope="page" class="stu.classp"/>
<jsp:useBean id="sqlB" scope="page" class="stu.sqlBean"/>
<body bgcolor="#4692B3" text="#FFFFFF" link="#00FF00">
<div align="center">
  <p>
    <%
String id="",cour_id="",cour_name="",tea_id="",tea_name="",room_id="",cour_time="";
int mark=0;
%>
    <span class="STYLE2"><font color="#00FF00" size="+3">所有班级</font></span> </p>
  <p>&nbsp;</p>
  <p align="left" class="STYLE1"><a href="AddClass.jsp"><font size="+1">新增班级</font></a></p>
</div>
<form action="getclass_confirm.jsp" method="post">
<div align="center">
  <table width="75%"  border="1">
    <tr> 
      <td>班级号</td>
      <td>课程编号</td>
      <td>教师编号</td>
      <td>教室编号</td>
      <td>上课时间</td>
      <td>删除</td>
      <td>更新</td>
    </tr>
<%
ResultSet rs=classp.getClassp();
while(rs.next()) {
id=rs.getString("id");
cour_id=rs.getString("cour_id");
tea_id=rs.getString("tea_id");
room_id=rs.getString("room_id");
cour_time=rs.getString("cour_time");
String sql1="select name from course  where id ='"+cour_id+"' ";
ResultSet rs1= sqlB.executeQuery(sql1);
while(rs1.next()) 
	{ cour_name=rs1.getString("name");}
String sql2="select name from teacher  where id ='"+tea_id+"' ";
ResultSet rs2= sqlB.executeQuery(sql2);
while(rs2.next()) 
	{ tea_name=rs2.getString("name");}
%>	
	<tr><td><%=id%></td><td><%=cour_name%></td><td><%=tea_name%></td><td><%=room_id%></td>
	<td><%=cour_time%></td><td><input type="checkbox" name="chkbx" value="<%=id%>")></td>
	<td><a href="updateclass.jsp?id=<%=id%> ">更新</a></td></tr>
<%
}
%>	
	
  </table>
    <p>
      <input type="submit" name="Submit" value="提交">
    </p>
  </div>
</form>
<p align="left"><a href="admin.jsp">&lt;&lt;返　回</a></p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -