小男孩‘自慰网亚洲一区二区,亚洲一级在线播放毛片,亚洲中文字幕av每天更新,黄aⅴ永久免费无码,91成人午夜在线精品,色网站免费在线观看,亚洲欧洲wwwww在线观看

搜索
分享

利用javabean進(jìn)行分頁(yè)技術(shù)----（與同學(xué)開(kāi)發(fā)的小招標(biāo)系統(tǒng)項(xiàng)目節(jié)選）_Java風(fēng)影園地

 昵稱6X4fT 2007-06-26
 

//數(shù)據(jù)分頁(yè)技術(shù)的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();//連接數(shù)據(jù)庫(kù)的bean
     ResultSet rs;
     
    public Vector getProject_list(long page,long pagemax，String sql){//page為待顯示的頁(yè)，pagem記錄數(shù)ax為每頁(yè)的最大，sql為相應(yīng)的sql語(yǔ)句
                page1=page1-1;
       Vector list1=new Vector();//創(chuàng)建一個(gè)向量
       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();//項(xiàng)目具體信息的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);//把項(xiàng)目具體信息的bean加到可移動(dòng)的向量中
           }
        count1++;
       }
     
        rs.close();
       }catch(Exception e){System.out.print(e.getMessage());}
   
   
         
       return list1;
   
                         }

               }

 

 

 

 


顯示相應(yīng)傳來(lái)的sql語(yǔ)句的而查詢得到的總記錄數(shù)


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;
    }

}


///顯示分頁(yè)項(xiàng)目信息的jsp頁(yè)面-----(由于這是項(xiàng)目的一個(gè)節(jié)選。?？赡苡行┑胤接袉?wèn)題。。。)


<%@ 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>招標(biāo)系統(tǒng)</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">關(guān)鍵字</span>
                <input name="keys" type="text" size="40" />
                </label>
                <label>
                <select name="select">
                  <option value="all" selected="selected">所有</option>
                  <option value="project">項(xiàng)目</option>
                  <option value="maker">廠商</option>
                  <option value="product">產(chǎn)品</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">項(xiàng)目信息</div></td>
              </tr>
                  <tr>
                    <td width="107" height="32" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目名稱</div></td>
                <td width="159" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目開(kāi)標(biāo)時(shí)間</div></td>
                <td width="107" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目工期</div></td>
                <td width="133" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目總造價(jià)</div></td>
                <td width="166" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目負(fù)責(zé)單位</div></td>
                <td width="101" bordercolor="#9999FF" bgcolor="#FFFFCC"><div align="center" class="STYLE5">項(xiàng)目簡(jiǎn)介</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="下一頁(yè)"/></a>|<a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=total_page1%>">最后一頁(yè)</a>
                        <%}}else if(page1==total_page1){%><a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=1">第一頁(yè)</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="上一頁(yè)"/></a><%}else{%><a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=1">第一頁(yè)</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="上一頁(yè)"/></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="下一頁(yè)"/></a>|<a href="/zhaobiaoINfo_manage/JSP/main.jsp?showpage1=<%=total_page1%>">最后一頁(yè)</a><%}%>
                      
                        共有<font color=red><%=gt.total_count1()%></font>條項(xiàng)目信息 現(xiàn)在是第<font color=red><%=page1%></font>頁(yè) 轉(zhuǎn)到第
    <select size="1" name="showpage1"><%
for (int j=1;j<=total_page1;j++)
{
      out.println(" <option value="+j+">"+j+"頁(yè)</option>");
}
%>
    </select>
                        頁(yè)
    <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>

    本站是提供個(gè)人知識(shí)管理的網(wǎng)絡(luò)存儲(chǔ)空間，所有內(nèi)容均由用戶發(fā)布，不代表本站觀點(diǎn)。請(qǐng)注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購(gòu)買(mǎi)等信息，謹(jǐn)防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊一鍵舉報(bào)。
    轉(zhuǎn)藏 分享 獻(xiàn)花（0）

    0條評(píng)論

    發(fā)表

    請(qǐng)遵守用戶 評(píng)論公約

    類(lèi)似文章 更多