jsp关于分页和隔行变颜色的代码

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>

<style type="text/css">
<!--
body,td {
 font-size: 14px;
 color: #000000;
}
th {
 font-size: 14px;
 color: #ffffff;
}
a:link {
 color: #000000;
 text-decoration: none;
}
a:visited {
 text-decoration: none;
 color: #000000;
}
a:hover {
 text-decoration: underline;
 color: #0033FF;
}
a:active {
 text-decoration: none;
 color: #0033FF;
}
-->
</style>

<script language="javascript">
function newwin(url) {
var

newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}

function subb() {
 document.form1.action="search.jsp";
 form1.submit();
}
</script>
<script LANGUAGE="javascript">
function submit10()
{
self.location.replace("searchfiles.jsp")
}
</script>
<%//变量声明
java.sql.Connection sqlCon; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.sql.ResultSet sqlRst; //结果集对象
java.lang.String strCon; //数据库连接字符串
java.lang.String strSQL; //SQL语句
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
java.lang.String strPage;
int i;
//设置一页显示的记录数
intPageSize = 10;
//取得待显示页码
strPage = request.getParameter("page");
String keyword=request.getParameter("keyword");
String keyparagh=request.getParameter("keyparagh");
String firDir=request.getParameter("anclassid");
String secDir=request.getParameter("nclassid");
if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据
 intPage = 1;
 session.setAttribute("keywordtemp",keyword);
 session.setAttribute("keyparaghtemp",keyparagh);
 session.setAttribute("firdirtemp",firDir);
 session.setAttribute("secdirtemp",secDir);
}
else{//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
//装载JDBC驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//设置数据库连接字符串
strCon = "jdbc:odbc:filesmag";
//连接数据库
sqlCon = java.sql.DriverManager.getConnection(strCon,"sa","");
//创建一个可以滚动的只读的SQL语句对象
sqlStmt =
sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//准备SQL语句
keyword=(String)session.getAttribute("keywordtemp");
keyparagh=(String)session.getAttribute("keyparaghtemp");
firDir=(String)session.getAttribute("firdirtemp");
secDir=(String)session.getAttribute("secdirtemp");
System.out.println("firdir:(new#####################)"+firDir);
System.out.println("firdir:(new#####################)"+secDir);
if(keyparagh.equals("all")){
  if(firDir.equals("")){
   strSQL = "select * from filelist where FileName like '%"+keyword+"%'  or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%'";
   System.out.println("error corporation"+strSQL);
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  else if(secDir.equals("")){
   strSQL = "select * from filelist where FirDirect='"+firDir+"' and (FileName like '%"+keyword+"%'  or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%') " ;
   System.out.println("correct corporation"+strSQL);
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  else{
   strSQL = "select * from filelist where FirDirect='"+firDir+"' and SecDirect='"+secDir+"' and (FileName like '%"+keyword+"%'  or Writer like '%"+keyword+"%' or Keyword like '%"+keyword+"%' or Upcourse like '%"+keyword+"%' or FileSource like '%"+keyword+"%' or Department like '%"+keyword+"%' or Remark like '%"+keyword+"%')";
   //执行SQL语句并获取结果集
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  
}
else{
 if(keyword.equals("")){
  if(secDir.equals("")){
   strSQL = "select * from filelist where FirDirect='"+firDir+"'";
   //执行SQL语句并获取结果集
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  else{
   strSQL = "select * from filelist where FirDirect='"+firDir+"' and SecDirect='"+secDir+"'";
   //执行SQL语句并获取结果集
   sqlRst = sqlStmt.executeQuery(strSQL);
  }

 }
 else{
  if(firDir.equals("")){
   strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%'";
   System.out.println("strSQL:"+strSQL);
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  else if(secDir.equals("")){
   strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%' and FirDirect='"+firDir+"'" ;
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
  else{
   strSQL = "select * from filelist where "+keyparagh+" like '%"+keyword+"%' and FirDirect='"+firDir+"' and SecDirect='"+secDir+"'";
   sqlRst = sqlStmt.executeQuery(strSQL);
  }
 }
}
//获取记录总数
sqlRst.last();//??光标在最后一行
intRowCount = sqlRst.getRow();//获得当前行号
System.out.println("查询结果集:"+intRowCount);
//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询列表</title>
</head>
<body bgcolor="#FFFFFF" >
<table align=center bgcolor=#ffffff border=0 cellpadding=0 cellspacing=0
height=57 width=760>
  <tbody>
  <tr>
    <td width="506" height="57" background="newpage/images/in_01.jpg">
      <table width="100%" border="0" cellspacing="0" cellpadding="1" height="57">
        <tr>
          <td width="20">&nbsp;</td>
          <td><font color="#FFFFFF" size="5"><b>查询列表</b></font></td>
          <td width="20">&nbsp;</td>
        </tr>
      </table>
      <font size=6> </font></td>
    <td width="254" background="newpage/images/in_02.jpg">&nbsp;</td>
  </tr>
  </tbody>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="1" align="center" bgcolor="#0066B3">
  <tr>
    <td valign="top">
      <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
        <tr>
          <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="20">
              <tr>
                <td valign="top">
    <table width="715">
     <form method="POST" action="searchfiles.jsp" name="form1">
     <td >第<%=intPage%>页  共<%=intPageCount%>页

       <%if(intPage<intPageCount){%><a href="searchfiles.jsp?page=<%=intPage+1%>">下一页

     </a><%}%>  <%if(intPage>1){%><a href="searchfiles.jsp?page=<%=intPage-1%>">

     上一页</a><%}%>
     转到第:<input type="text" name="page" size="8"> 页
     <span><input class=buttonface type="submit" value="GO" name="cndok"></span></td>
     <td  align="right"><input type="button" name="Submit" value="返回" onClick="subb()"></td>
     </form>
     </table>
     <table width="715" border="0" cellspacing="1" cellpadding="0" align="center">
     <tr>
     
     <th width="44%" height="30" align="center" bgcolor="#1681c8">文件名称</th>
     <th width="13%" height="30" align="center" bgcolor="#1681c8">文件作者</th>
     <th width="13%" height="30" align="center" bgcolor="#1681c8">建立日期</th>
     <th colspan="2" height="30" align="center" bgcolor="#1681c8">操作</th>
     </tr>
     <%
     if(intPageCount>0){
     //将记录指针定位到待显示页的第一条记录上
      sqlRst.absolute((intPage-1) * intPageSize + 1);
      //显示数据
      i = 0;
      int id;
      String fileName,writerName,firDirect,secDirect,Keyword,Year,Term,createDate,UpCourse,FileSource,Department,Remark;
      boolean found=sqlRst.isAfterLast();
      while(i<intPageSize && !found){
       id=sqlRst.getInt(1);
       fileName=sqlRst.getString(2);
       writerName=sqlRst.getString(3);
       firDirect=sqlRst.getString(4);
       secDirect=sqlRst.getString(5);
       Keyword=sqlRst.getString(6);
       Year=sqlRst.getString(7);
       Term=sqlRst.getString(8);
       createDate=sqlRst.getString(9);
       UpCourse=sqlRst.getString(10);
       FileSource=sqlRst.getString(11);
       Department=sqlRst.getString(12);
       Remark=sqlRst.getString(13);
       if(i%2!=0){
       %>

       <tr>
       
       <td width="44%" height="25" align="left" bgcolor="#DDE3EC"><a href="do_download.jsp?filename=<%=id%>"><%=fileName%></td>
       <td width="13%" height="25" align="left" bgcolor="#DDE3EC"><%=writerName%></td>
       <td width="13%" height="25" align="left" bgcolor="#DDE3EC"><%=createDate%></td>

       <td width="15%" height="25" align="center" bgcolor="#DDE3EC"><a href="detailinfo.jsp?id=<%=id%>&page=<%=intPage%>">详细信息</a></td>
       <td width="15%" height="25" align="center" bgcolor="#DDE3EC"> <a href="CreateDeletefile.jsp?id=<%=id%>&page=<%=intPage%>&attributeName=<%=id%>&doid=1" onClick="return confirm('您确定删除吗？')">删除</a></td>
       </tr>
       <%
       }
       else{
       %>
       <tr>
      
       <td width="44%" height="25" align="left"><a href="do_download.jsp?filename=<%=id%>"><%=fileName%></td>
       <td width="13%" height="25" align="left"><%=writerName%></td>
       <td width="13%" height="25" align="left"><%=createDate%></td>

       <td width="15%" height="25" align="center"><a href="detailinfo.jsp?id=<%=id%>&page=<%=intPage%>">详细信息</a></td>
       <td width="15%" height="25" align="center"><a href="CreateDeletefile.jsp?id=<%=id%>&page=<%=intPage%>&attributeName=<%=id%>&doid=1" onClick="return confirm('您确定删除吗？')">删除</a></td>
       </tr>
       <%
       }
       sqlRst.next();
       found=sqlRst.isAfterLast();
       System.out.println("@@@@@@@@@@@show whether is the last record:"+found);
       
       i++;
       
      }
     }
     %>
     </table>
      </td>
       </tr>
        </table>
      </td>
    </tr>
  </table>
   </td>
 </tr>
</table>

<table width="760" border="0" cellspacing="0" cellpadding="3" align="center" bgcolor="#FFFFFF">
    <tr>
     <td align="center">
    <table border="0" cellspacing="0" cellpadding="2">
   <tr>
     <td class="p9" nowrap align="center"><font color="#0066B3">版权所有&copy;
    中国传媒大学 </font></td>
   </tr>
   <tr>
     <td class="p9" align="center">&nbsp;</td>
   </tr>
    </table>
  </td>
 </tr>
</table>

</body>
</html>
<%
//关闭结果集
sqlRst.close();
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
%>