首页>>服务专区>>服务政策
-
<%
String dtype="doc";
sql="select * from download where type1=? and type2=? and available=1 order by sort_num asc";
stmt=conn.getPreparedStat(sql);
stmt.setInt(1,pid);
stmt.setString(2,dtype);
try{
rs=stmt.executeQuery();//.doQuery(sql);
while(rs.next())
{
if(dtype=="doc"||dtype=="txt"){
out.print("
- "); out.print(rs.getString("filetext")); out.print(" "); out.print(""); }else{ out.print("
- ");
out.print(""+rs.getString("name")+" 版本："+rs.getString("version")+" 大小:"+rs.getString("size")+"M"+" 上传时间:"+rs.getString("time").substring(0,10)+""); out.print(""+rs.getString("filetext")+""); if(dtype=="video"){ out.print(""); } out.print(" ");
//out.print("
下载 已下载 "+rs.getString("count")+" 次
");
}
}
log.info("excute sql = "+sql);
}catch(Exception e){
log.error("------->error: "+e.toString());
response.sendRedirect("error.jsp?msg="+e.toString());
}
rs.close();
conn.closeConn();
%>