实现效果:
实现目的:
1.展现出MySQL中所对应的相关数据表中的信息并且可以进行增删改的操作
2.左上角的新增班级功能,左下角的返回功能
3.在进行完删除和增加功能后会自动返回到此页面已告知操作成功,若无法返回则会自动报错
4.实现数据的分页效果,我这里是选择每一页展示六个数据
5.调用javabean较为简单的实现些功能并在删除按钮传递表名参数
实现代码:
<%@ page language="java" import="java.util.*,java.sql.*,wang.mysqlcon" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<jsp:useBean id="rain" class="wang.mysqlcon" scope="session"></jsp:useBean>
<%
Connection con = rain.getcon();
ResultSet rs = null;
%>
<body bgcolor="#FFFFF0">
<p><center><font size="5" style="color:#6495ED">所有班级</font></center></p>
<p><font size="3" style="color: #BDB76B;"><a href="addstu.jsp">新加班级</a></font></p>
<table width="80%" border="1" align="center">
<tr>
<td>班级编号</td> <td>教室编号</td> <td>课程编号</td> <td>教室编号</td> <td>上课时间</td> <td>删除</td> <td>更新</td>
</tr>
<% String tea_id="",id="",cour_id="",room_id="",cour_time="";
int mark=0;
int pagesize=6;
int totalrecord;
int totalpage=0;
int pagenow=1;
String n=request.getParameter("n");
if(n!=null)
{
pagenow=Integer.parseInt(n);
}
try{String sql="select count(*) from classes";
rs=rain.search(sql);
if(rs.next())
{
totalrecord=rs.getInt(1);
totalpage=totalrecord%pagesize==0?totalrecord/pagesize:totalrecord/pagesize+1;}
}
catch(Exception e){
System.out.println("统计数据失败!");
System.out.println(e.getMessage());}
try{String sql="select * from classes limit "+pagesize*(pagenow-1)+","+pagesize;
rs=rain.search(sql);}
catch(Exception e){
System.out.println("统计数据失败!");
System.out.println(e.getMessage());}
while(rs.next())
{ id=rs.getString("id");
tea_id=rs.getString("tea_id");
cour_id=rs.getString("cour_id");
room_id=rs.getString("room_id");
cour_time=rs.getString("cour_time");
out.print("<tr><td>"+id+"</td>");
out.print("<td>"+tea_id+"</td>");
out.print("<td>"+cour_id+"</td>");
out.print("<td>"+room_id+"</td>");
out.print("<td>"+cour_time+"</td>");
out.print("<td><a href=admdel.jsp?id="+id+"&table=classes>"+"删除"+"</a></td>");
out.print("<td><a href="+"#"+">"+"更新"+"</a></td><tr>");
}out.print("</tr></table>");
rs.close();
con.close();
%>
<center>
<%for(int i=1;i<=totalpage;i++)
{out.print("<a href='admclass.jsp'?n="+i+"'>"+i+"<a/> ");} %>
</center>
<p><font size="3" style="color: #BDB76B;"><a href="control.jsp"> < < back </a></font></p>
<p><center><b><font color="#99FF33" size="2" >版权所有©:<a href="names.jsp">(个人信息)</a></font></b></center></p>
</body>
</html>