Java 切换按钮

最新推荐文章于 2023-12-13 21:43:21 发布

原创最新推荐文章于 2023-12-13 21:43:21 发布 · 389 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Java #Mobile #SQL #JSP

JAVA 专栏收录该内容

332 篇文章

订阅专栏

本系统通过数据库查询并展示街拍照片，包括标题、图片及描述等内容，并提供支持功能。系统采用分页显示机制，能够根据用户请求加载不同批次的照片。同时，系统还实现了简单的条件筛选功能。



 <%
	String sign=request.getParameter("signid");
	if(request.getParameter("signid")!=null){
		sign=request.getParameter("signid");
	}
	if(sign==null){%>
		最新照片|<a href="index.jsp?signid=1">热门照片</a>
	 <%
	}
	if(sign!=null){
		out.println("<a href='index.jsp'>"+"最新照片"+"</a>"+"|热门照片");
	}

 %>

<br/>

<%	
	String imgPath= Common.getPropertiesValue("LOCAL_HOST")+"/"+ Common.getPropertiesValue("LOCAL_MANAGEROOT")+"/"+Common.getPropertiesValue("LOCAL_NEWS");
	String mobile = Common.getMobile(request);
	Object myNickName=request.getSession().getAttribute("myNickName");
	Connection conn = null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	int count=0;
	int pagesize=5;
	int pagenum=1;
	if(request.getParameter("pn")!=null){
		pagenum=Integer.parseInt(request.getParameter("pn"));
	}
	if(mobile==null&&"".equals(mobile)){
		out.println("请您正确使用手机操作！");
		out.println("<br/>");
	}else{
		try {		
				conn = DBClassLocal.getConnection();
				String sql="select count(*) from local_streetshoot where pass=0 order by createtime desc";
				ps = conn.prepareStatement(sql);
				rs=ps.executeQuery();
				while(rs.next()){
					count=rs.getInt(1);
				}

				sql = "select * from (select t.*,rownum rn from (select * from local_streetshoot where pass=0 order by createtime desc)t where rownum<=?)where rn>?";
				ps = conn.prepareStatement(sql);
				ps.setInt(1,pagesize*pagenum);
				ps.setInt(2,pagesize*(pagenum-1));
				rs=ps.executeQuery();
				while(rs.next()){
					out.println("标题："+rs.getString("titlename"));
					out.println("<br/>");
					String path=rs.getString("imgurl");
				//	String path2=imgPath+path;
					out.println("<img src='"+path+"'/>");
					out.println("<br/>");
					out.println("描述："+rs.getString("discription"));
					out.println("<br/>");
					out.println("<a href='support.jsp?id="+rs.getInt("id")+"'>"+"支持一下"+"</a>"+"("+rs.getInt("hot")+")");
					out.println("昵称："+"<a href='http://wap.139hz.com/wap/weibo/kongjian/'>"+rs.getString("nickname")+"</a>");
					out.println("<br/>");

				}
			} catch (Exception e) {
				request.setAttribute("message","服务器错误");
				request.getRequestDispatcher("message.jsp").forward(request,response);
				return;
			} finally {
				if (rs != null) {
					rs.close();
				}
				if (ps != null) {
					ps.close();
				}
				if (conn != null) {
					conn.close();
				}
			}
			out.println(Pager.getPagerSimple(count, pagesize, pagenum, "index.jsp"));

	}



 %>