📄 showmusic.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0050)http://bjcgi.163.net/cgi-bin/tom_reg.cgi?rf=060704 -->
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.util.*,java.sql.*,music.*" %>
<%
String songname="";
String size="";
String word="";
String songpattern="";
String createtime="";
String kind="";
String description="";
String frequency="";
String songset="";
String download="";
String name=LoadDriver.convert(request.getParameter("word"));
String pattern=LoadDriver.convert(request.getParameter("lm"));
DBManager db=DBManager.getInstance("localhost","music","root","589060");
String sql=null;
ResultSet rs=null;
if(pattern.equals("0"))
sql="select * from song where name='"+name+"' and pattern='mp3' ";
else if(pattern.equals("1"))
sql="select * from song where name='"+name+"' and pattern='rm' ";
else if(pattern.equals("2"))
sql="select * from song where name='"+name+"' and pattern='wma' ";
else
sql="select * from song where name='"+name+"'";
rs=db.executeQuery(sql);
if(rs!=null)
if(!rs.next())
out.print("<br/><br/><br/>没有相关记录!");
else
do
{
songname=rs.getString(2);
word=rs.getString(3);
size=rs.getString(4);
songpattern=rs.getString(5);
createtime=rs.getString(6);
kind=rs.getString(7);
description=rs.getString(8);
frequency=rs.getString(10);
songset="<a href='showsongset.jsp?songid="+rs.getInt(1)+"'>所属专辑介绍 进入...</a>";
download="<a href='do_download.jsp?location="+rs.getString(9)+"'>点击下载</a>";
}while(rs.next());
%>
<HTML><HEAD><TITLE>歌曲管理</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="../TOM用户注册.files/register.css" type=text/css rel=stylesheet>
<STYLE type=text/css>
BODY {
FONT-SIZE: 12px; COLOR: #000000
}
TD {
FONT-SIZE: 12px; COLOR: #000000
}
A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #000000; TEXT-DECORATION: none
}
A:active {
COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
COLOR: #ff0000; TEXT-DECORATION: underline
}
.glow {
PADDING-RIGHT: 0px; PADDING-LEFT: 12px; FILTER: Glow(Color=#ffffff, Strength=4); PADDING-BOTTOM: 1px; PADDING-TOP: 0px
}
P {
LINE-HEIGHT: 130%
}
.px14 {
FONT-SIZE: 14px
}
.px16 {
FONT-SIZE: 16px
}
.px5 {
FONT-SIZE: 5px
}
.hx {
BORDER-BOTTOM: #ade0ff 1px solid; BACKGROUND-COLOR: #f7fbff
}
.input {
BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BACKGROUND: #ffffff; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid
}
.a5 {
COLOR: #0059a5
}
A.a5:link {
COLOR: #0059a5; TEXT-DECORATION: underline
}
A.a5:visited {
COLOR: #0059a5; TEXT-DECORATION: underline
}
A.a5:hover {
COLOR: #ff0000; TEXT-DECORATION: none
}
.bm {
COLOR: #0000ff
}
A.bm:link {
COLOR: #0000ff; TEXT-DECORATION: underline
}
A.bm:visited {
COLOR: #0000ff; TEXT-DECORATION: underline
}
A.bm:hover {
COLOR: #ff0000; TEXT-DECORATION: none
}
.00 {
COLOR: #0000ff
}
A.00:link {
COLOR: #0000ff; TEXT-DECORATION: underline
}
A.00:visited {
COLOR: #0000ff; TEXT-DECORATION: underline
}
A.00:active {
COLOR: #0000ff; TEXT-DECORATION: underline
}
A.00:hover {
COLOR: #ff0000; TEXT-DECORATION: underline
}
.bl {
COLOR: #0000ff
}
A.bl:link {
COLOR: #0000ff; TEXT-DECORATION: none
}
A.bl:visited {
COLOR: #0000ff; TEXT-DECORATION: none
}
A.bl:hover {
COLOR: #ff0000; TEXT-DECORATION: none
}
.ff {
COLOR: #ffffff
}
A.ff:link {
COLOR: #ffffff; TEXT-DECORATION: none
}
A.ff:visited {
COLOR: #ffffff; TEXT-DECORATION: none
}
A.ff:hover {
COLOR: #ff0000; TEXT-DECORATION: none
}
.STYLE6 {
font-size: large;
color: #009933;
}
.STYLE8 {font-size: 10}
</STYLE>
<SCRIPT language=javascript>
function checkuser()
{
window.open("about:blank","zhutong", 'menubar=0,width=350,height=240,left=230,top=200,resizable=0,scrollbars=auto');
window.myform1.target = "zhutong";
window.myform1.action = "./getorgid.cgi";
window.myform1.submit();
}
function register()
{
window.myform1.target = "";
window.myform1.action = "";
window.myform1.submit();
}
function CloseMe()
{
window.close();
}
</SCRIPT>
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<FORM name=myform1 action="" method=post><INPUT type=hidden value=reguser
name=funcid> <INPUT type=hidden value=060704 name=rf> <INPUT type=hidden
value="system error" name=refer>
<!--input type="hidden" name="sid" value=""--><INPUT id=year type=hidden
value=1980 name=year> <INPUT id=month type=hidden value=1 name=month> <INPUT
id=day type=hidden value=1 name=day>
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 width=773 border=0>
<TBODY>
<TR>
<TD width=165> </TD>
<TD class=00 align=right> </TD>
</TR></TBODY></TABLE>
<TABLE style="MARGIN-BOTTOM: 3px" height=1 cellSpacing=0 cellPadding=0 width=773
bgColor=#c9e4ad border=0>
<TBODY>
<TR>
<TD><NOBR></NOBR></TD></TR></TBODY></TABLE>
<TABLE height=77 cellSpacing=0 cellPadding=0 width=773
border=0>
<TBODY>
<TR>
<TD height=32>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=128> </TD>
<TD width=105> </TD>
<TD align=right> </TD>
<TD width=3 bgColor=#ffffff></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=100></TD>
<TD align="left" valign="middle" style="LINE-HEIGHT: 160%"><span class="divmsg1 STYLE6">歌曲信息</span>
<CENTER>
</CENTER></TD>
<TD width=8> </TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE
style="BORDER-RIGHT: #5a9900 1px solid; BORDER-TOP: #5a9900 0px solid; BORDER-LEFT: #5a9900 1px solid; BORDER-BOTTOM: #5a9900 1px solid"
height=430 cellSpacing=0 cellPadding=0 width=773 border=0>
<TBODY>
<TR>
<TD> </TD>
<TD align=middle></TD>
</TR>
<TR>
<TD width=100 valign="top"> </TD>
<TD><TABLE
style="BORDER-RIGHT: #eafce6 4px solid; BORDER-TOP: #eafce6 4px solid; BORDER-LEFT: #eafce6 4px solid; BORDER-BOTTOM: #eafce6 4px solid"
cellSpacing=0 cellPadding=4 width=580 border=0>
<TBODY>
<TR>
<TD height=37> </TD>
</TR>
<TR bgColor=#eafce6>
<TD bgColor=#eafce6 height=36><FONT color=#cc0000>*</FONT> 歌曲名：<%=songname%> </TD>
</TR>
<TR>
<TD height=38>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=180><p><FONT color=#cc0000>*</FONT>歌词<br/><%=word%></p>
<p> </p>
<p> </p></TD>
<TD> </TD>
</TR></TBODY></TABLE></TD></TR>
<TR bgColor=#eafce6>
<TD height=36><table cellspacing=0 cellpadding=0 width="100%" border=0>
<tbody>
<tr>
<td width=1><div align="left"></div></td>
<td width="563"><div align="left"><FONT color=#cc0000>*</FONT>下载次数：<%=frequency%></div></td>
</tr>
</tbody>
</table></TD>
</TR></TBODY></TABLE>
<TABLE height=10 width=580 border=0>
<TBODY>
<TR>
<TD width=180> <p><FONT color=#cc0000>*</FONT>文件格式： <%=songpattern%>
<span class="STYLE8">
<label class="px16"></label>
</span> </p>
<p> <FONT color=#cc0000>*</FONT>歌曲类型：<%=kind%>
<label></label>
<!--script language="JavaScript"
src="http://bjcgi.163.net/js/image.js"></script-->
</p>
<p><FONT color=#cc0000>*</FONT>描述:<%=description%>
<label></label>
</p>
</TD>
</TR></TBODY></TABLE>
<TABLE height=10 width=579 border=0>
<TBODY>
<TR>
<TD width=174><p><FONT color=#cc0000>*</FONT>文件大小：<%=size%>
<TD width=395><p><FONT color=#cc0000>*</FONT>创建时间：<%=createtime%>
</TR></TBODY></TABLE>
</TD>
</TR>
</TBODY></TABLE>
<TABLE height=10 width=579 border=0>
<TBODY>
<TR>
<TD width=174><p><FONT color=#cc0000>*</FONT><%=songset%>
<TD width=395><p><FONT color=#cc0000>*</FONT><%=download%>
</TR></TBODY></TABLE>
</TD>
</TR>
</TBODY></TABLE>
<SCRIPT language=JavaScript src="js1.js"></SCRIPT>
<HR style="COLOR: #818181" width=773 SIZE=1>
<BR>
<TABLE cellSpacing=0 cellPadding=4 align=center border=0>
<TBODY>
<TR>
<TD style="LINE-HEIGHT: 22px" align=middle><FONT face=Arial>Copyright ©
2006</FONT></TD>
</TR></TBODY></TABLE></CENTER></FORM></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -