//数据分页技术的bean All_Info.java
package zhaobiao.qiantai.LuoJi;
import zhaobiao.data.*;
import zhaobiao.com.Opendb.*;
import java.util.*;
import java.sql.*;
public class All_Info{
OpendbConn odb=new OpendbConn();//连接数据库的bean
ResultSet rs;
public Vector getProject_list(long page,long pagemax，String sql){//page为待显示的页，pagem记录数ax为每页的最大，sql为相应的sql语句
page1=page1-1;
Vector list1=new Vector();//创建一个向量
try{
rs=odb.executeQuery(sql);
long count1=1;
while(rs.next()){
if(count1>(page1*pagemax1)&&count1<=(page1*pagemax1+pagemax1))
{
Project_Info project=new Project_Info();//项目具体信息的bean
project.setProject_id(rs.getLong("Project_id"));
project.setProject_name(rs.getString("Project_name"));
project.setProject_Bgtime(rs.getString("Project_bgtime"));
project.setProject_time(rs.getString("Project_time"));
project.setProject_charge(rs.getString("Project_company"));
project.setProject_cost(rs.getString("Project_cost"));
project.setProject_content(rs.getString("Project_content"));
list1.add(project);//把项目具体信息的bean加到可移动的向量中
}
count1++;
}
rs.close();
}catch(Exception e){System.out.print(e.getMessage());}
return list1;
}
}
显示相应传来的sql语句的而查询得到的总记录数
package zhaobiao.qiantai.LuoJi;
import zhaobiao.com.Opendb.*;
import java.util.*;
import java.sql.*;
public class getTotal_count{
OpendbConn odb=new OpendbConn();
ResultSet rs;
public long total_count1(String sql)
{
long count1=0;
try{
rs=odb.executeQuery(sql);
while(rs.next()){
count1++;
}
rs.close();
}catch(Exception e){System.out.print(e.getMessage());}
return count1;
}
}
///显示分页项目信息的jsp页面-----(由于这是项目的一个节选。。可能有些地方有问题。。。)
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" import="java.util.*" import="zhaobiao.data.*" import="zhaobiao.qiantai.LuoJi.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www./TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www./1999/xhtml">
<head>
<link rel=‘stylesheet‘ type=‘text/css‘ href=‘/zhaobiaoINfo_manage/css/FORUM.CSS‘>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>招标系统</title>
<style type="text/css">
<!--
.STYLE4 {color: #0000FF}
.STYLE5 {color: #993333}
.STYLE8 {color: #CC6633;}
.STYLE9 {color: #CC9966}
.STYLE11 {
font-size: 16pt;
color: #FF0000;
font-weight: bold;
}
.STYLE12 {font-size: small}
.STYLE13 {font-size: large}
.STYLE14 {font-size: large; color: #FF0000; font-weight: bold; }
-->
</style></head>
<jsp:useBean id="all_list" scope="page" class="zhaobiao.qiantai.LuoJi.All_Info"/>
<jsp:useBean id="idb" scope="page" class="zhaobiao.com.Opendb.OpendbConn"/>
<jsp:useBean id="gt" scope="page" class="zhaobiao.qiantai.LuoJi.getTotal_count"/>
<body>
<%!
long page1=1;
long page2=1;
long page3=1;
long pagemax=3;
String sql="select * from Project";
%>
<%
try{
page1=Integer.parseInt(request.getParameter("showpage1"));
}catch(Exception gxxxxx1){
page1=1;
}
Vector list1=new Vector();
list1=all_list.getProject_list(page1,pagemax,sql);
long total_page1=(gt.total_count1()%pagemax==0)?gt.total_count1()/pagemax:((gt.total_count1()/pagemax)+1);//out.println("gt.total_count1="+gt.total_count1());
%>
<div align="center">
<table width="800" border="0"cellpadding="0" cellspacing="0" bgcolor="#CCFFFF">
<!--DWLayoutTable-->
<tr>
<td height="140" colspan="4" valign="top"><table width="80%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="1159" height="124" valign="top"><img src="/zhaobiaoINfo_manage/image/layout_01.gif" width="600" height="124" /><img src="/zhaobiaoINfo_manage/image/layout_02.jpg" width="559" height="124" /></td>
</tr>
<tr>
<td height="16" bgcolor="#99FF99"> </td>
</tr>
</table></td>
<td width="14"> </td>
<td width="7"> </td>
</tr>
<tr>
<td width="158" rowspan="5" valign="top" bgcolor="#00CC66"><p> </p>
<p> </p>
<p> </p>
<p><a href="/zhaobiaoINfo_manage/JSP/Project_info.jsp"><img src="/zhaobiaoINfo_manage/image/project.jpg" width="155" height="31"/></a></p>
<p><a href="/zhaobiaoINfo_manage/JSP/Maker_info.jsp"><img src="/zhaobiaoINfo_manage/image/maker.jpg" width="155" height="31" /></a></p>
<p><a href="/zhaobiaoINfo_manage/JSP/Product_info.jsp"><img src="/zhaobiaoINfo_manage/image/product.jpg" width="155" height="31" /></a></p>
<p><a href="javascript:window.close()"><img src="/zhaobiaoINfo_manage/image/tuichu.jpg" width="155" height="31" /></a></p></td>
<td height="34" colspan="3" valign="top"><img src="/zhaobiaoINfo_manage/image/layout_10.gif" width="1000" height="34" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="38" rowspan="4" valign="top" bgcolor="#99FF99"><img src="/zhaobiaoINfo_manage/image/layout_15.gif" width="38" height="817" /></td>
<td width="924" height="66" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="926" height="41" align="center" valign="middle" bgcolor="#66FFCC"><form id="form13" name="form13" method="post" action="/zhaobiaoINfo_manage/JSP/search.jsp" >
<p> </p>
<p>
<label> </label>
<label><span class="STYLE4">关键字</span>
<input name="keys" type="text" size="40" />
</label>
<label>
<select name="select">
<option value="all" selected="selected">所有</option>
<option value="project">项目</option>
<option value="maker">厂商</option>
<option value="product">产品</option>
</select>
</label>
<input name="image" type="image" src="/zhaobiaoINfo_manage/image/search.gif" border="0" alt="搜索" height="30" /></p>
</form></td>
</tr>
</table> </td>
<td width="38" rowspan="3" valign="top"><img src="/zhaobiaoINfo_manage/image/layout_15.gif" width="38" height="785" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="698" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="924" height="684" valign="top">
<table width="800" height="565" border="0" align="left">
<tr>
<td height="133" align="left" valign="top"><table width="850" height="115" border="1" align="left" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td height="19" colspan="6"><div align="center" class="STYLE11 STYLE13">项目信息</div></td>
</tr>
<tr>
<td width="107" height="32" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目名称</div></td>
<td width="159" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目开标时间</div></td>
<td width="107" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目工期</div></td>
<td width="133" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目总造价</div></td>
<td width="166" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目负责单位</div></td>
<td width="101" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">项目简介</div></td>
</tr>
<%
try{
for(int a=0;a<list1.size();a++)
{
Project_Info pj=new Project_Info();
pj=(Project_Info)list1.elementAt(a);
%>
<tr>
<td height="22" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center"><span class="STYLE12"><a href="/zhaobiaoINfo_manage/JSP/Project_xiangxi1.jsp?project_id=<%=pj.getProject_id()%>">
<%out.print(pj.getProject_name());%>
</a></span></div></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center" class="STYLE12"><%if(pj.getProject_Bgtime()!=null)out.print(pj.getProject_Bgtime());%>
</div></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center" class="STYLE12"><%if(pj.getProject_time()!=null)out.print(pj.getProject_time());%>
</div></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center" class="STYLE12"><%if(pj.getProject_cost()!=null)out.print(pj.getProject_cost());%>
</div></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center" class="STYLE12"><%if(pj.getProject_charge()!=null)out.print(pj.getProject_charge());%>
</div></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center"><a href="/zhaobiaoINfo_manage/JSP/Project_xiangxi1.jsp?project_id=<%=pj.getProject_id()%>" class="STYLE12">查看详情</a></div></td>
</tr>
<%}}catch(Exception e){out.print(e.getMessage());}%>
<tr>
<td height="40" colspan="6" bordercolor="#CC9966" bgcolor="#CC9966"><form method="post" action="/zhaobiaoINfo_manage/JSP/main.jsp" name="form">
<div align="left">
<%if(page1==1){if(total_page1!=1){%> <a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=page1+1%>"><img src="/zhaobiaoINfo_manage/image/forward.gif" width="35" height="15" border="0" alt="下一页"/></a>|<a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=total_page1%>">最后一页</a>
<%}}else if(page1==total_page1){%><a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=1">第一页</a>| <a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=page1-1%>"><img src="/zhaobiaoINfo_manage/image/bank.gif" width="35" height="15" border="0" alt="上一页"/></a><%}else{%><a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=1">第一页</a>| <a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=page1-1%>"><img src="/zhaobiaoINfo_manage/image/bank.gif" width="35" height="15" border="0" alt="上一页"/></a>
|<a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=page1+1%>"><img src="/zhaobiaoINfo_manage/image/forward.gif" width="35" height="15" border="0" alt="下一页"/></a>|<a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=total_page1%>">最后一页</a><%}%>
共有<font color=red><%=gt.total_count1()%></font>条项目信息 现在是第<font color=red><%=page1%></font>页 转到第
<select size="1" name="showpage1"><%
for (int j=1;j<=total_page1;j++)
{
out.println(" <option value="+j+">"+j+"页</option>");
}
%>
</select>
页
<input type="submit" value="go" name="B1" height="20">
</div>
</form></td>
</tr>
</table></td>
</tr>
<tr>
<td height="192" align="left" valign="top"></td>
</tr>
</table></td>
</tr>
</table> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="34" colspan="3" valign="top"><img src="/zhaobiaoINfo_manage/image/layout_10.gif" width="966" height="34" /></td>
<td> </td>
</tr>
</table>
</div>
<%
</body>
</html>
