pic_detail.jsp

make the picture down from web

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


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

%>
<card id="index" title="下载" >
<p align="left">
<% 
request.setCharacterEncoding("utf-8");

//String par_classid  = request.getParameter("CLASSID");
String par_picsid= request.getParameter("PICSID");
String sqlid="select * from pic  where Sid=? ";

pst = conn.prepareStatement(sqlid,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
pst.setString(1,par_picsid);
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_Content          =  rs.getString("Content");
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");

%>
<%=rs_name%><br />
 <img src="http://wap.你的URL.com:800/wapmedia/pic/<%=rs_picname%>" alt="Loading.."/><br />
<%=rs_content%><br /><%=rs_pictype%> <%=rs_size1%> <br />
 <a href="http://wap.你的URL.com:800/wapmedia/pic/<%=rs_picname%>">直接下载</a><br />
<%
//////session.setAttribute ("TitleID",bid);
//////session.setAttribute ("Title_Name",tname);
%>
<% 
rs.next(); 
   i++; 
  } 
  }
rs.close();
pst.close();
stmt.close(); 
conn.close();
%>
<%

%>
<%@ include file="foot.jsp"%>
<%@ include file="bottommost.jsp"%>

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