📄 showsinger.jsp

📁 音乐信息管理系统
💻 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 singername="";
    String sex="";
    String address="";
    String intro="";
    String hotdegree="";
    String interest="";
    String disccorp="";
    String songsetid=LoadDriver.convert(request.getParameter("songsetid"));
    DBManager db=DBManager.getInstance("localhost","music","root","589060");
    String sql="select * from singer where id in (select singerid from publish where songsetid="+songsetid+")";  
    ResultSet rs1=db.executeQuery(sql);
  
    if(rs1==null)
    out.print("没有相关记录！");
     else 
     {
     rs1.next();
    singername=rs1.getString(2);
    sex=rs1.getString(3);
    address=rs1.getString(4);
    intro=rs1.getString(5);
    hotdegree=rs1.getString(6);
    interest=rs1.getString(7);
   
    disccorp="<a href='showdisccorp.jsp?singerid="+rs1.getString(1)+"'>点击查看与该歌手签约的公司</a>";
  }
   %>
<HTML><HEAD><TITLE>歌手</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK 
href="file:///D|/数据库作业/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;
}
</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>&nbsp;</TD>
    <TD class=00 align=right>&nbsp;</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>&nbsp;</TD>
          <TD width=105>&nbsp;</TD>
          <TD align=right>&nbsp;</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><BR>
            <CENTER>
            </CENTER></TD>
          <TD width=8>&nbsp;</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>&nbsp;</TD>
    <TD align=middle></TD></TR>
  <TR>
    <TD width=100 valign="top">&nbsp;</TD>
    <TD>
      <TABLE width=580 border=0>
        <TBODY>
        <TR>
          <TD width="434">&nbsp;</TD>
          <TD width="136" align=right>&nbsp;</TD>
        </TR></TBODY></TABLE>
      <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=24><FONT color=#cc0000>*</FONT> 歌手姓名：<%=singername%></TD>
        </TR>
        <TR bgColor=#eafce6>
          <TD bgColor=#eafce6 height=21>&nbsp;</TD>
        </TR>
        <TR>
          <TD height=21>
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
              <TR>
                <TD width=180><FONT color=#cc0000>*</FONT>爱好： <%=interest%>                 </TD>
                <TD>&nbsp; </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=270><FONT color=#cc0000>*</FONT>籍贯： <%=address%>                 </td>
                <td width="294"><label><FONT color=#cc0000>*</FONT>性别：<%=sex%>
                    
                     </label></td>
              </tr>
            </tbody>
          </table></TD>
        </TR></TBODY></TABLE>
      <TABLE height=94 width=580 border=0>
        <TBODY>
        <TR>
          <TD width=180 height="90"> <p><FONT color=#cc0000>个人介绍<br/><%=intro%></FONT>
              <label></label>
          </p>
            <p>
              <label></label>
              
              <!--script language="JavaScript" 
src="http://bjcgi.163.net/js/image.js"></script-->
              </p>
            <p>&nbsp;</p>
            </TD>
		  
        </TR></TBODY></TABLE>
      <TABLE height=10 width=579 border=0>
        <TBODY>
        <TR>
          <TD width=174><p><FONT color=#cc0000>*</FONT> 人气星级：<%=hotdegree%>
          
              <label></label>
          <TD width=395><p>
         </TR></TBODY></TABLE>
      </TD>
  </TR></TBODY></TABLE>
  <TABLE height=10 width=579 border=0>
        <TBODY>
        <TR>
          <TD width=174><p><FONT color=#cc0000>*</FONT><%=disccorp%>
          
              <label></label>
          <TD width=395><p>
         </TR></TBODY></TABLE>
      </TD>
  </TR></TBODY></TABLE>
<SCRIPT language=JavaScript src="file:///D|/数据库作业/页面/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 &copy; 
      2006</FONT></TD>
  </TR></TBODY></TABLE></CENTER></FORM></BODY></HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -