<%@ page language="java" contentType="text/vnd.wap.wml;charset=gb2312" %>
<%@ page import="java.sql.*" errorPage=""%>

<%@ include file="inc/conn.jsp"%>

<?xml version="1.0" encoding="gb2312" ?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="list" title="圖片列表" >
<p align="left">

<% 
String par_pic_name = request.getParameter("PAR_PIC_NAME");


String qrypn="select Sid,Name,Picname,Content,Pictype,Size1,Type from pic  where Name like '%"+par_pic_name+"%' order by Sid DESC";
rs=stmt.executeQuery(qrypn);

int intPageSize; 
int intRowCount; 
int intPageCount; 
int intPage; 
String strPage;
int i;
intPageSize = 3;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}
else
{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last(); 
intRowCount = rs.getRow(); 
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
rs.absolute((intPage-1) * intPageSize+1); 
i = 0; 
while(i< intPageSize && !rs.isAfterLast())

{

String rs_sid      =  rs.getString("Sid");
String rs_name     =  rs.getString("Name");
String rs_picname  =  rs.getString("Picname");//硬盤(pán)上名稱,路徑
String rs_content  =  rs.getString("Content");
String rs_pictype  =  rs.getString("Pictype");
String rs_size1    =  rs.getString("Size1");
String rs_type     =  rs.getString("Type");

%>

<br />

<a href="pic_detail.jsp?PICSID=<%=rs_sid%>"><%=rs_name%></a><br />
 <img src="http://wap.你的URL.com:800/wapmedia/pic/<%=rs_picname%>" alt="Loading.."/><br />
<small><%=rs_pictype%>,<%=rs_size1%></small><br />

<% 
rs.next(); 
   i++; 
  } 
  }	
rs.close();
stmt.close(); 
conn.close();
%>

<br />


<%if(intPage>1){%>
<a href="do_search_name.jsp?PAR_PIC_NAME=<%=par_pic_name%>&amp;page=<%=intPage-1%>" >上頁(yè)</a> 
<%}else{%>
上頁(yè) 
<% } %>
<%if(intPage<intPageCount){%>
<a href="do_search_name.jsp?PAR_PIC_NAME=<%=par_pic_name%>&amp;page=<%=intPage+1%>" >下頁(yè)</a> 
<%}else{%>
下頁(yè) 
<%  }  %><%=intPage%>/<%=intPageCount%> 頁(yè)<br />


<input title="請(qǐng)輸入頁(yè)數(shù)" name="page" type="text" size ="6" maxlength="6" format="*N" value="1" />
<anchor><go href="do_search_name.jsp" method="get">
<postfield name="PAR_PIC_NAME" value="<%=par_pic_name%>"/>
<postfield name="page" value="$(page)"/>
</go>轉(zhuǎn)到該頁(yè)</anchor><br/>
<%@ include file="foot.jsp"%>
<%@ include file="bottommost.jsp"%>

</p>
</card>
</wml>