📄 chart_toppers.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>Chart Toppers Page</title>
</head>
<body bgcolor="#C0C0C0" topmargin="0" background="http:\\localhost:8000\music\Background.bmp" >
<table border="0" width="100%">
<tr>
<td width="100%">
<table border="0" width="97%" height="19">
<tr>
<td width="18%" height="13" valign="middle" align="right">
<font face="Arial" size="5" color="#800000"><b><i>eMusicWorld-----> The World of Music</i></b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<form method="POST" action="http://localhost:8000/music/home_page.htm">
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%@ page language = "java" %>
<%! String time;%>
<%Calendar cal = Calendar.getInstance(TimeZone.getDefault());
String DATE_FORMAT = "MMMMM dd, yyyyy";
java.text.SimpleDateFormat sdf=new java.text.SimpleDateFormat(DATE_FORMAT);
sdf.setTimeZone(TimeZone.getDefault());
time=sdf.format(cal.getTime());
%>
<table border="1" width="100%" height="363">
<tr>
<td width="18%" height="357">
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/user_home_page.jsp">Home</a></b></font></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/chart_toppers.jsp">Chart Toppers</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/SearchContext/SearchAlias">Search</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/vote_page.jsp">Vote</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/new_release_page.jsp">New Releases</a></font></b>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/Register/RegisterPage.htm">Register</a></b></font>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/login_page.htm">Login</a></b></font>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/help_page.htm">Help</a></b></font></p>
<p> </td>
<td width="82%" valign="top" >
<table border="1" width="100%" >
<tr>
<td width="100%" valign="top" colspan="2" height="19" align="center"><b><font face="Arial" color="#800000" size="3">Chart
Topper Songs as on <%=time%></font></b></td>
</tr>
<tr>
<td valign="top" colspan="1" align="center"><b><font face="Arial" color="#800000" size="2">Number</font></b></td>
<td valign="top" colspan="1" align="center"><b><font face="Arial" color="#800000" size="2">Song</font></b></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
Statement state;
state = connect.createStatement();
String strQuery1 = "SELECT top 10 Vote_info.Item_code, Item_Master.Item_Desc FROM Vote_info, Item_Master where Vote_info.Item_code=Item_Master.Item_code ORDER BY Number_votes desc;";
String str;
int ctr=1;
ResultSet result1 = state.executeQuery(strQuery1);
while(result1.next())
{
%><tr>
<td width="10%" valign="top" height="19" align="top"><font face="Arial" color="#800000" size="2">
<%out.println(ctr+".");%>
</font></td>
<td valign="top" height="19" align="top"><font face="Arial" color="#800000" size="2">
<%out.println(result1.getString("Item_Desc"));%>
</font></td>
</tr>
<%
ctr=ctr+1;
}
connect.close();
}
catch(Exception e){
out.println("done exception" +e);
}
%>
</table>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -