index_ajax.jsp

在线音乐系统。使用struts2完成。挺好的

<%@ page language="java"
	import="java.util.*,java.sql.*,Pluto.function,java.util.Date,java.text.SimpleDateFormat;"
	pageEncoding="UTF-8"%>
<jsp:useBean id="conn" class="Pluto.DBConnection" scope="session" />
<link href="css/thickbox.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/thickbox.js"></script>
<script type="text/javascript" src="js/nicejforms.js"></script>

<%
	response.setHeader("Expires", "Sat, 6 May 1995 12:00:00 GMT");
	response.setHeader("Cache-Control",
			"no-store, no-cache, must-revalidate");
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Pragma", "no-cache");
	int nowpage = function.strToInt(request.getParameter("page"));
	int pagesize = 15; //每页容纳的条数
	int limit = 0; //从多少条开始
	int maxPage = 0; //一共多少页
	if (nowpage != 0) {
		limit = (nowpage - 1) * pagesize;
	} else {
		nowpage = 1;
	}
	ResultSet rs = conn
			.executeQuery("select count(id) as count from music");
	rs.next();
	int count = rs.getInt("count");
	maxPage = (count % pagesize == 0) ? (count / pagesize) : (count
			/ pagesize + 1);
	rs.close();
	rs = conn
			.executeQuery("select * from music order by id DESC LIMIT "
					+ limit + "," + pagesize + "");
	if (rs.next()) {
		do {
			String id = rs.getString("id");
			String title = rs.getString("title");
			String singer = rs.getString("singer");
			String special = rs.getString("special");
			String value = rs.getString("value");
			long time = rs.getLong("time");
			Date date = new Date(time);
			SimpleDateFormat sdf = new SimpleDateFormat(
					"yyyy年MM月dd日 HH:mm:ss");
			String music_time = sdf.format(date);
			String click = rs.getString("click");
			ResultSet comments_rs = conn
					.executeQuery("select count(id) as count from comments where music_id = "
							+ id + "");
			comments_rs.next();
			String comments = comments_rs.getString("count");
			String filePath = rs.getString("url");
			Random rd = new Random();
			int rd_id = rd.nextInt(9999);
%>
<div class="post">
	<h2 class="title">
		<a href="show.jsp?id=<%=id%>"><%=title%></a>
	</h2>
	<h3 class="date">
		<%=music_time%>
	</h3>
	<div class="entry">
		<p>
			试听：
			<object type="application/x-shockwave-flash"
				data="player/audioplayer.swf" width="290" height="24"
				id="audioplayer<%=rd_id%>">
				<param name="movie" value="player/audioplayer.swf" />
				<param name="FlashVars"
					value="playerID=<%=rd_id%>&soundFile=<%=filePath%>" />
				<param name="quality" value="high" />
				<param name="menu" value="false" />
				<param name="wmode" value="transparent" />
			</object>
			<br />
			歌手：
			<%=singer%><br />
			所在专辑：
			<%=special%><br />
			<%=value%>
		</p>
	</div>
	<p class="meta">
		<a href="show.jsp?id=<%=id%>" class="more">阅读全文</a>
		<b>|</b>
		<span class="comments"><%=comments%>条评论</span>
		<b>|</b>
		<span class="comments"><%=click%>次点击</span>
		<%
			if (session.getAttribute("PlutoUser") != null) {
		%>
		<b>|</b>
		<a href="JavaScript:addbox('<%=id%>');" class="comments">添加到我的音乐盒</a>
		<b>|</b>
		<img src="images/img14.gif">
		&nbsp;
		<a href="sendmusic.jsp?height=230&width=350&modal=true&id=<%=id%>"
			class="thickbox" title="我要注册">点歌</a>
		<%
			}
		%>
	</p>
</div>
<%
	} while (rs.next());
		out.println("<div class=\"yahoo2\">"
				+ function.page(maxPage, nowpage, pagesize,
						"index_ajax.jsp") + "</div><br />");
	} else {
%>
<div class="post">
	暂无任何歌曲，快来分享给大家喔~！
</div>
<%
	}
%>