<%@page contentType="text/html;charset=gb2312" pageEncoding="gb2312"%>
  <%@   page   import="java.sql.*"%>   
<jsp:useBean id="divdao"
class="com.centrain.bjecom.dao.Divdao" scope="session"></jsp:useBean>
<html>
<body  bgcolor="#000000" onload="banner()" style="text-align: right">
 <div align="center">
<table border="1" width="80%" id="table1" style="border-width: 0px" cellspacing="0" cellpadding="0" height="427">
<tr>
<td colspan="2" style="border-style: none; border-width: medium" height="6"><%@include file="top.jsp"%></td>
</tr>
<tr>
<td align="center" style="border-style: none; border-width: medium" bgcolor="#404040" valign="top"><div align="center">
<td height="305" bgcolor="#848484" width="79%">
<font size="2">
<%   
      int   pagesize=10;//每页显示记录数   
      int   recordcount=0;//记录总数   
      int   pagecount=0;//总页数   
      int   pageid=1;//待显页码   
    Connection   conn=null;   
      try{   
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");   
       conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=quake","sa","13294110"); 
      Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);   
      String   sql="select   *   from   ziliao where lei =1 order by time1";   
      ResultSet   rs=stmt.executeQuery(sql);   
      rs.last();   
      recordcount=rs.getRow();//取得总记录数   
      pagecount=(recordcount%pagesize==0?(recordcount/pagesize):(recordcount/pagesize)+1);//取得总页数  
      int   count=1;   
      String   strpage=request.getParameter("pageid");   
      if(strpage==null)   pageid=1;   
      else   pageid=Integer.parseInt(strpage);   
      if(pageid>recordcount)   pageid=recordcount;   
      if(recordcount>0){   
      rs.absolute((pageid-1)*pagesize+1);}   
      int   i=0;   
      //rs.previous();   
     // rs.beforeFirst(); 
      while(rs.next()&&count<=pagesize){   
      count++;   
      i++;   
out.print("<div align='center'>");
out.print("<table border='1' width='100%' style='border-width: 0px' bgcolor='#665D58'>");
out.print("<tr>");
out.print("<td width='26%' style='border-style:none; border-width:medium; '>");
out.print("<table width='85' height='105' cellspacing='0' cellpadding='0' bgcolor='#D5D4D4'>");
out.print("<tr>");
out.print("<td style='border-style: none; border-width: medium' align='center'>");
out.print("<td><div align='center'><img src='photo/"+rs.getString("photo")+"' width='80' height='100'></div></td>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("</td>");
out.print("<td width='69%' style='border-style:none; border-width:medium; ' valign='top'>");
out.print("<div align='left'>");
out.print("<table border='1' width='59%' style='border-width: 0px' cellspacing='1'>");
out.print("<tr>");
out.print("<td style='border-style: none; border-width: medium'>");
out.print("<a href='yingpianxinxi.jsp'>");
out.print("<span style='text-decoration: none; font-weight: 700'>");
out.print("<font color='#C0C0C0' size='2'>");
out.print(rs.getString("name1"));
out.print("</font>");
out.print("</span>");
out.print("</a>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("<table border='1' width='100%' style='border-width: 0px'>");
out.print("<tr>");
out.print("<td style='border-style: none; border-width: medium'>");
out.print("<p>");
out.print("<font size='2' color='#D5D4D4'>主演:"+rs.getString("daoyan"));
out.print("</font>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("<table border='1' style='border-width: 0px' width='100%'>");
out.print("<tr>");
out.print("<td style='border-style: none; border-width: medium'>");
out.print("<font color='#D5D4D4' size='2'>");
out.print(rs.getString("neirong"));
out.print("</font>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("</div>");
out.print("</td>");
out.print("</tr>");
out.print("<tr>");
out.print("<td colspan='2' style='border-style: none; border-width: medium' bgcolor='#ABAAAA'>");
out.print("<b>");
out.print("<font size='2' color='#00FFFF'>&nbsp;&nbsp;&nbsp;");
out.print("</font>");
out.print("<font size='2' color='#554F4C'>");
out.print("</font>");
out.print("</b>");
out.print("<font size='2' color='#554F4C'>");
out.print("推荐:"+rs.getString("tuijian"));
out.print("</font>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("</div>");  
    }
        %>  
</font>  
</td>
</tr>
<tr>
<td height="26" bgcolor="#848484" style="border-style: none; border-width: medium" width="21%">
 </td>
<td height="26" bgcolor="#848484" style="border-style: none; border-width: medium" width="79%" nowrap align="center">
   <font size="2">
   <font color="#800080">
  <%out.print("共");   
        out.print(pagecount);   
        out.print("页");   
          
        out.print("共");   
        out.print(recordcount);   
        out.print("条");   
          
        out.print("第");   
        out.print(pageid);   
        out.print("页");   
     
        out.print("             ");   
        if(pageid<pagecount){   
        out.print("<a   href=daluxinpian1.jsp?pageid=");   
        out.print(pageid+1);   
        out.print(">下一页</a>");}   
        if(pageid>1){   
        out.print("<a   href=daluxinpian1.jsp?pageid=");   
        out.print(pageid-1);   
        out.print(">上一页</a>");}   
        out.print("                ");   
        for(int   j=1;j<=pagecount;j++){   
        out.print("<a   href=daluxinpian1.jsp?pageid=");   
        out.print(j);   
        out.print(">");   
        out.print(j);   
        out.print("</a>");}   
        stmt.close();   
      conn.close();   
      }   
      catch(ClassNotFoundException   e){   
          out.println(e.getMessage());   
  }   
  catch(SQLException   e)   {   
  out.println(e.getMessage());   
  }   
  finally{   
    try{   
      if(conn   !=   null)   
        conn.close();   
        }   
        catch(Exception   e){}   
      }   
      %></font> </font></td>
</tr>
</table>
</div>
</body>
<p>
<%@include file="footer.jsp"%> 
</p>
</html>