<%@ page language="java" %>
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<SCRIPT LANGUAGE="javascript">
function openwindow()
{
self.location="banjitianjia.jsp";
}
</SCRIPT>
<title>班级浏览</title>
<META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">
</head>
<body bgcolor="#FFFFFF">
<% 
if (session.getAttribute("username")==null)
{%>
<script language="javascript">
alert("非法登陆!");
document.location.href="../login.html";
</script>
<%}
String readonly="";
String tmp=(String)session.getAttribute("readonly");
//out.println(tmp);
if (!tmp.equals("n"))
readonly="y";
else
readonly="n";
%>
<form method="post" action="deletebanji.jsp">
<table width="600" border="0" cellspacing="2" cellpadding="1">
<tr bgcolor="#00FF00">
<td>
选择
</td>
<td>
班级
</td>
<td>
年级
</td>
<td>
教室
</td>
<td>
年制
</td>
<td>
专业
</td>
<td>
班主任
</td>
<td>
备注
</td>
<td>
修改
</td>
</tr>
<%!int PageSize=10;
int ShowPage=1;
int RowCount=0;
int PageCount=0;%>
<%
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String SConnStr="jdbc:odbc:albumSource";Class.forName(sDBDriver);
Connection conn=DriverManager.getConnection(SConnStr);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from 班级 ORDER BY grade DESC";
ResultSet rs=stmt.executeQuery(sql);%>
<% 
if(!rs.next())
out.println("没有数据!");
else{
rs.last();RowCount=rs.getRow();
PageCount=((RowCount%PageSize)==0?(RowCount/PageSize):(RowCount/PageSize)+1); %>
<% String ToPage=request.getParameter("ToPage");
if(ToPage!=null){
ShowPage=Integer.parseInt(ToPage);
if(ShowPage>PageCount){
ShowPage=PageCount;
}else if(ShowPage<=0){
ShowPage=1;
}
}
rs.absolute((ShowPage-1)*PageSize+1);%>
<%
for (int i=1;i<=PageSize;i++)
{
int id=rs.getInt("id");
String banji=rs.getString("grade");
String nianji=rs.getString("class");
String room=rs.getString("classroom");
String nianzhi=rs.getString("nianzhi");
String zhuanye=rs.getString("major");
String banzhuren=rs.getString("cmaster");
String beizu=rs.getString("meno");
%>
<tr bgcolor="#00FF00">
<td>
<INPUT type="checkbox" id=xuanze name=xuanze value=<%=id%>>
</td>
<td>
<%=banji%>
</td>
<td>
<%=nianji%>
</td>
<td>
<%=room%>
</td>
<td>
<%=nianzhi%>
</td>
<td>
<%=zhuanye%>
</td>
<td>
<%=banzhuren%>
</td>
<td>
<%=beizu%>
</td>
<%if (readonly.equals("n"))
{%>
<td>
<a href=banjixiugai.jsp?id=<%=id%>>修改</a>
</td>
<%}%>
</tr>
<%if(!rs.next())
break;
}
%>
<%
rs.close();
stmt.close();
%>
<tr>
<%if (readonly.equals("n"))
{%>
<td>
<INPUT type="submit" value="删除" id=submit1 name=submit1>
</td>
<td>
<INPUT type="button" value="添加" id=button1 name=button1 onclick="openwindow()">
</td>
<%}%>
</tr>
</table></form>
<table width="600" border="0" cellspacing="2" cellpadding="1">
<tr bgcolor="#ffffff">
<td width="400" height="70"><div align="right">共<%=PageCount%>/<font color="#FF0000"><%=ShowPage%></font>页</div></td>
<td width="56"><div align="center"> 
<%if(ShowPage!=1){%>
<a href=classview.jsp?ToPage=<%=1%>>首页</a> 
<%}else{%>
<font color="#CCCCCC">首页</font> 
<%}%>
</div></td>
<td width="49"><div align="center"> 
<%if(ShowPage!=1){%>
<a href=classview.jsp?ToPage=<%=ShowPage-1%>>上页</a> 
<%}else{%>
<font color="#CCCCCC">上页</font> 
<%}%>
</div></td>
<td width="54"><div align="center"> 
<%if(ShowPage!=PageCount){%>
<a href=classview.jsp?ToPage=<%=ShowPage+1%>>下页</a> 
<%}else{%>
<font color="#CCCCCC">下页</font> 
<%}%>
</div></td>
<td width="46"><div align="center"> 
<%if(ShowPage!=PageCount){%>
<a href=classview.jsp?ToPage=<%=PageCount%>>尾页</a> 
<%}else{%>
<font color="#CCCCCC">尾页</font> 
<%}%>
</div></td>
<td width="100" valign="bottom"><div align="center"> 
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr> 
<td> <form action=classview.jsp method=post>
<input name=ToPage type="text" value=<%=ShowPage%> size="4">
页</form></td>
</tr>
</table>
</div></td>
</tr>
</table>
<%}%></body>
</html>--------------------------------------------------------------------------------<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%!
int pagesize=8; //每页显示数目
int pagecount; //总页数
int showpage; //当前页数
%>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
out.print(e);
}
try{
String key=request.getParameter("id");
if(key==null){
key="";
}
byte d[] =key.getBytes("ISO-8859-1");
key=new String(d);
con=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};dbq=g:\\database\\sun.mdb");
sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("select * from sa");
rs.last();
int rowcount=rs.getRow();
pagecount=(rowcount%pagesize==0)?(rowcount/pagesize):(rowcount/pagesize+1);
%>
<p>总共有<%=rowcount%>条记录</p>
<table border=1>
<tr>
<td width=100>编号</td>
<td width=100>学号</td>
<td width=100>姓名</td>
<td width=100>数学成绩</td>
<td width=100>语文成绩</td>
<td width=100>物理成绩</td>
<td width=100>化学成绩</td>
<td width=100>英语成绩</td>
</tr>
<%
rs.beforeFirst();
String s=request.getParameter("page");
if(s==null){
s="0";
}
try{
showpage=Integer.parseInt(s);
}catch(NumberFormatException e){
out.print(e);
}
if(showpage>=pagecount){
showpage=pagecount;
}
if(showpage<=1){
showpage=1;
}
int posion=(showpage-1)*pagesize+1;
rs.absolute(posion);
for(int i=1;i<=pagesize && !rs.isAfterLast();i++){
out.print("<tr>");
for(int k=1;k<9;k++){
out.print("<td>"+rs.getString(k)+"</td>");
}
out.print("</tr>");
rs.next();
}
con.close();
out.print("</table>");
}catch(SQLException e){
out.print(e);
}
for(int i=1;i<=pagecount;i++){
out.print("<a href=king.jsp?page="+i+">"+i+"</a>");
out.print("&nbsp");
}
%>
</body>
</html>