<%@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'> ");
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>
<%@ 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'> ");
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>
解决方案 »
- hibernate注解 一对一问题 请教
- mysql 修改语句的问题在线等。。。。
- 我在Mysql中直接操作插入中文数据没问题,编码我都设为GBK,网页也用的gbk,可从网页提交插入中文数据总是乱码(显示????),英文、数字没
- Apache装Tomcat后,会不会影响原来的CGI
- 请教一下lucene怎样按照时间范围检索
- 遇到一个奇怪的问题,求大神进下?
- 请问大家都是用什么来写jsp程序的呢?(急!)
- 在Struts标签里,如下问题该怎么解决?
- apache和tomcat整合之后的问题----帮忙看一下!
- 救急:url为product_list.jsp?dpt_code=01+product_type=0101,怎么样能让product_list.jsp接收到的是dpt_code=01&product_type=0101呢?
- 基于LINUX下的网络播放系统JSP开发。怎么弄?恳请大哥们教下,有没有源代码可以参考的?
- 一个JSP表单下拉选项的问题
还有个问题 取数据的时候 数据库表中的列名 如果neirong 在name前面的话 不就能先取name列