实现效果:
实现目的:
1.展现出MySQL中所对应的相关数据表中的信息并且可以进行增删改的操作
2.左上角的新增学生功能,左下角的返回功能
3.在进行完删除和增加功能后会自动返回到此页面已告知操作成功,若无法返回则会自动报错
4.实现数据的分页效果,我这里是选择每一页展示六个数据
5.调用javabean较为简单的实现些功能并在删除按钮传递表名参数
实现代码:admstu.jsp
<%@ 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> <td>电话</td> <td>E_mail</td> <td>删除</td> <td>更新</td>
</tr>
<% String name="",id="",password="",jiguan="",dep="",sex="",tel="",mail="";
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 student";
rs=rain.search(sql);
/* st=con.prepareStatement("select count(*) from student");
rs=st.executeQuery(); */
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 student limit "+pagesize*(pagenow-1)+","+pagesize;
rs=rain.search(sql);
/* st=con.prepareStatement("select * from student limit "+pagesize*(pagenow-1)+","+pagesize);
rs=st.executeQuery(); */}
catch(Exception e){
System.out.println("统计数据失败!");
System.out.println(e.getMessage());}
while(rs.next())
{ id=rs.getString("id");
name=rs.getString("name");
password=rs.getString("password");
jiguan=rs.getString("jiguan");
dep=rs.getString("department");
sex=rs.getString("sex");
mark=rs.getInt("mark");
tel=rs.getString("tel");
if(tel==null || tel.equals(""))
tel="没有";
mail=rs.getString("E_mail");
if(mail==null || mail.equals(""))
mail="没有";
out.print("<tr><td>"+id+"</td>");
out.print("<td>"+name+"</td>");
out.print("<td>"+password+"</td>");
out.print("<td>"+jiguan+"</td>");
out.print("<td>"+dep+"</td>");
out.print("<td>"+sex+"</td>");
out.print("<td>"+mark+"</td>");
out.print("<td>"+tel+"</td>");
out.print("<td>"+mail+"</td>");
out.print("<td><a href=admdel.jsp?id="+id+"&table=student>"+"删除"+"</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='admstu.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>