WebRoot/student/kecheng1.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="proj112.*" %>
<jsp:useBean id="a" scope="page" class="proj112.dbconn"/>
<html>
<head>
  <style type="TEXT/CSS">
  A:LINK{COLOR:blue;FONT-SIZE:11PT;TEXT-DECORATION:NONE}
  A:VISITED{COLOR:blue;FONT-SIZE:11PT;TEXT-DECORATION:NONE}
   A:HOVER{COLOR:red;FONT-SIZE:11PT;TEXT-DECORATION:UNDERLINE}</STYLE>
<title>
kecheng1
</title>
</head>
<body bgcolor="#ffffff"><br>
&nbsp; &nbsp; &nbsp;姓名:&nbsp;<font color="#0033FF"><%=session.getAttribute("stu_name") %> </font>  &nbsp; &nbsp; &nbsp;学号:&nbsp;<font color="#0033FF"><%=session.getAttribute("id") %></font><br>
 <hr><br>
<%
int PageSize = 6;
int Page = 1;
int totalPage = 1;
int totalrecord = 0;
String id = "";

String sql = null;
ResultSet rs = null;


    //算出总行数
	sql = "SELECT count(*) as recordcount FROM kecheng";
	rs = a.executeQuery(sql);
	if (rs.next()) totalrecord = rs.getInt("recordcount");
	//输出记录
	sql = "SELECT * FROM kecheng";
    rs = a.executeQuery(sql);
%>
<form action="kecheng2.jsp" method="POST" name="form3">

<p align="center">
<table  width="100%" cellspacing="0" cellpadding="4" rules="all" bordercolor="#CC9966" border="1" id="dg_rxkb" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:100%;border-collapse:collapse;">
<tr align=middle>
    <td colspan="7" bgcolor="#9dcaf4"><font color="red">所有课程信息</font></td>
  </tr>
   <tr>
        <td align="center"><font color="#6633CC">选课</font></td>
	<td align="center"><font color="#6633CC">课程名</font></td>
	<td align="center"><font color="#6633CC">任课教师</font></td>
	<td align="center"><font color="#6633CC">星期几</font></td>
	<td align="center"><font color="#6633CC">时间</font></td>
	<td align="center"><font color="#6633CC">上课教室</font></td>

    </tr>

<%
if(totalrecord % PageSize ==0)// 如果是当前页码的整数倍
		totalPage = totalrecord / PageSize;
	else  // 如果最后还空余一页
		totalPage = (int) Math.floor( totalrecord / PageSize ) + 1;