pic_list.jsp

*JSP WAP 图铃下载系统* 铃声那里建表文件丢失

<%@ 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">


<% 
//request.setCharacterEncoding("GBK");
//String sname =  (String) session.getAttribute("sname"); 
//String par_type = request.getParameter("TYPE");
//String url_par_type = java.net.URLEncoder.encode(request.getParameter("TYPE"),"GBK");


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


pst = conn.prepareStatement(sql_piclist,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 = 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");

//String rs_Content          =  rs.getString("Content");
/*
String rs_imgid      =  rs.getString("Img_id");
String rs_imgname    =  rs.getString("Img_name");
String rs_imgsize    =  rs.getString("Img_size");
String rs_imghw      =  rs.getString("Img_hw");
String rs_imgtype    =  rs.getString("Img_type");
String rs_imgpath    =  rs.getString("Img_path");
*/







  //float rs_imgsizeFloat=Float.parse(rs_imgsize);

 /*
 int    rs_imgsizeint =     Integer.parseInt(rs_imgsize);
int kb;
kb=rs_imgsizeint/1024;
*/ 

//kb=rs_imgsizeFloat/1024;
%>

<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 />
<%
//////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 />


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

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