<%@ 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_hw = request.getParameter("HW");



String qrypn="select Sid,Name,Picname,Content,Pictype,Size1,Type from pic  where Size1= ? order by Sid DESC";






pst = conn.prepareStatement(qrypn,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
pst.setString(1,par_hw);
rs  = pst.executeQuery(); 
/**/






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");//硬盤上名稱,路徑
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();
pst.close();
stmt.close(); 
conn.close();

%>

<br />


<%if(intPage>1){%>
<a href="search_hw.jsp?HW=<%=par_hw%>&amp;page=<%=intPage-1%>" >上頁</a> 
<%}else{%>
上頁 
<% } %>
<%if(intPage<intPageCount){%>
<a href="search_hw.jsp?HW=<%=par_hw%>&amp;page=<%=intPage+1%>" >下頁</a> 
<%}else{%>
下頁 
<%  }  %><%=intPage%>/<%=intPageCount%> 頁<br />


<input title="請輸入頁數" name="page" type="text" size ="6" maxlength="6" format="*N" value="1" />
<anchor><go href="search_hw.jsp" method="get">
<postfield name="HW" value="<%=par_hw%>"/>
<postfield name="page" value="$(page)"/>
</go>轉到該頁</anchor><br/>
<%@ include file="foot.jsp"%>
<%@ include file="bottommost.jsp"%>

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