📄 downloadcenter.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="zh-CN" />
<meta content="all" name="robots" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {
font-family: "黑体";
font-size: 36px;
}
.STYLE3 {font-family: "黑体"}
--></style>
</head>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/interface.js"></script>
<link rel="stylesheet" type="text/css" href="css3.css" media="all" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="css/css2.css" />
<body>
<div align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="100%" height="80">
<param name="movie" value="logo.swf" />
<param name="quality" value="high" />
<embed src="logo.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="100%" height="80"></embed>
</object>
</div>
<div id="pointermenu">
<ul>
<li><a href="index2.jsp">主 页</a></li>
<%
String LoggedUserName = (String)session.getAttribute("logged");
if(LoggedUserName==null)
{
out.print("<li>"+"<a href=login.jsp"+">"+"用户登陆"+"</a>"+"</li>");
}
else
{
out.print("<li>"+"<a href=userinfo.jsp"+">"+"我的个人资料"+"</a>"+"</li>");
}
%>
<li><a href="register.jsp">用户注册</a></li>
<li><a href="downloadcenter.jsp">下载中心</a></li>
<li><a href="http://www.zcool.com.cn/">友情链接</a></li>
<li><a href="mailto:liudun05@163.com">联系我们</a></li>
<%
if(LoggedUserName==null)
{}
else
{
out.print("<li>"+"<a href=upload.jsp"+">"+"上传我的作品"+"</a>"+"</li>");
}
%>
<li><a id="rightcorner"> </a></li>
</ul>
</div>
<p> </p>
<p> </p>
<p><br style="clear: left" /></p>
<div align="center">
<p>
<%
Connection con;
Statement sql;
ResultSet rs;
int i=0,j=0;
int perPage=6;
int PageNums=0;
int currentPage=0;
int total=0;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.println("forname err");
}
try{
con=DriverManager.getConnection("jdbc:odbc:game","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String condition="SELECT 游戏名称,游戏图片,下载连接 FROM game";
rs=sql.executeQuery(condition);
rs.last();//将游标移动到最后一行。
if(rs.getRow() % perPage ==0)
PageNums= rs.getRow() / perPage ;//rs.getRow获取最后一行的行号。
else{
PageNums= rs.getRow() / perPage+1;
}
out.println("<div class=badoo align=center>");
for(i=1;i<=PageNums;i++){
out.println("<span>"+"<a href=downloadcenter.jsp?PageNo=" + Integer.toString(i) + ">" + Integer.toString(i) +"</a>"+"</span>");}
out.println("</span></div>");
String PageNo=request.getParameter("PageNo");
if (PageNo==null)
{ currentPage=1; }
else { currentPage=Integer.parseInt(PageNo); }
rs.absolute((currentPage-1)*perPage+1); //移动游标。
out.println("<Table Border=1>");
for(i=0;i<2;++i)
{
out.println("<tr>");
for(j=0;j<3;++j) {
out.println("<td height=227 width=160>");
String str1=rs.getString(1);
String str2=rs.getString(2);
String str3=rs.getString(3);
rs.next();
out.println("<img src=images/"+str2+" width=160 height=227 /><p>"+"<a href=download.jsp?filename="+str3+">"+str1+"</a>"+ "</p>");
out.println("</td>");
}
out.println("</tr>");
}
out.println("</table>");
}
catch (Exception e){e.printStackTrace();}
/* String PageNo=request.getParameter("PageNo");
if (PageNo==null)
{
}
else {
out.print(PageNo);
out.print("now in page3");
}
*/
%>
</p>
</div>
<!--bottom dock -->
<div class="dock" id="dock2">
<div class="dock-container2">
<a class="dock-item2" href="#"><span>Home</span><img src="images/home.png" alt="home" /></a>
<a class="dock-item2" href="#"><span>Contact</span><img src="images/email.png" alt="contact" /></a>
<a class="dock-item2" href="#"><span>Portfolio</span><img src="images/portfolio.png" alt="portfolio" /></a>
<a class="dock-item2" href="#"><span>Music</span><img src="images/music.png" alt="music" /></a>
<a class="dock-item2" href="#"><span>Video</span><img src="images/video.png" alt="video" /></a>
<a class="dock-item2" href="#"><span>History</span><img src="images/history.png" alt="history" /></a>
<a class="dock-item2" href="#"><span>Calendar</span><img src="images/calendar.png" alt="calendar" /></a>
<a class="dock-item2" href="#"><span>Links</span><img src="images/link.png" alt="links" /></a>
<a class="dock-item2" href="#"><span>RSS</span><img src="images/rss.png" alt="rss" /></a>
<a class="dock-item2" href="#"><span>RSS2</span><img src="images/rss2.png" alt="rss" /></a>
</div>
</div>
<!--dock menu JS options -->
<script type="text/javascript">
$(document).ready(
function()
{
$('#dock2').Fisheye(
{
maxWidth: 60,
items: 'a',
itemsText: 'span',
container: '.dock-container2',
itemWidth: 40,
proximity: 80,
alignment : 'left',
valign: 'bottom',
halign : 'center'
}
)
}
);
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -