<%@ page language="java" contentType="text/vnd.wap.wml;charset=gb2312" %>
<%@ page import="java.sql.*" errorPage=""%>
<%@ page import="java.net.*" %>
<%@ 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>
<%
String url_par_type = request.getParameter("TYPE");

/////////////////////////////if(session.getAttribute("sname")==null)
///////////////////////////////{ response.sendRedirect("sorry.jsp");}
///////////////////////////String par_mid = request.getParameter("MISC_MID");

%>
<card id="list" title="<%=url_par_type%>" >
<p align="left">


<% 


String sqlmidlist="select  sid,type,singername,midname,mid1,hits from mid where type=? order by Sid DESC";

pst = conn.prepareStatement(sqlmidlist,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
pst.setString(1,url_par_type);
rs  = pst.executeQuery(); 


int intPageSize; 
int intRowCount; 
int intPageCount; 
int intPage; 
String strPage;
int i;
intPageSize = 9;
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_type           =  rs.getString("type");
String rs_singername     =  rs.getString("singername");
String rs_midname        =  rs.getString("midname");
String rs_mid1           =  rs.getString("mid1");//硬盤上名稱,路徑
String rs_hits           =  rs.getString("hits");


%>

<br />

<a href="http://wap.你的URL.com:800/wapmedia/ring/mid/<%=rs_mid1%>"><%=rs_midname%></a><br />

<small>類型:<%=rs_type%><br />次數:<%=rs_hits%></small><br />
<%
//////session.setAttribute ("TitleID",bid);
//////session.setAttribute ("Title_Name",tname);
%>
<% 
rs.next(); 
   i++; 
  } 
  }
rs.close();
pst.close();
stmt.close(); 
conn.close();

%>
<%
//for (int i=1;i<=intPageCount ;i++ ) {
    
//}
%>
<br />
<a href="mid_search.jsp">MID查找</a><br/><br/>


<%if(intPage>1){%>
<a href="mid_list.jsp?TYPE=<%=url_par_type%>&amp;page=<%=intPage-1%>" >上頁</a> 
<%}else{%>
上頁 
<% } %>
<%if(intPage<intPageCount){%>
<a href="mid_list.jsp?TYPE=<%=url_par_type%>&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="mid_list.jsp" method="get">
<postfield name="TYPE" value="<%=url_par_type%>"/>
<postfield name="page" value="$(page)"/>
</go>轉到該頁</anchor><br/>
<%@ include file="noclassfoot.jsp"%>
<%@ include file="foot.jsp"%>
<%@ include file="bottommost.jsp"%>

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