admin_dj.asp

主要功能是为大家提供一个免费的校园平台网站,有新闻发布、会员及管理、论坛

          <tr class=lanyuds> 
            <td width="17%">舞曲选项</td>
            <td width="83%"> 
              <select name="djcatid">
<%
sql="select * from djcat"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof%><option value="<%=rs("djcat_id")%>"><%=rs("djcat_name")%></option>
<%rs.movenext
loop
if rs.eof and rs.bof then%><option value="0">当前没有舞曲分类</option>
<%end if%>
</select>
<select name="pic">
<option value="rm">播放类型</option>
<option value="asf">ASF音乐</option>
<option value="asfmtv">ASF影视</option>
<option value="rm">RAM音乐</option>
<option value="rmmtv">RAM影视</option>
<option value="flash">FLASH动画</option>
              </select>
<select name="desc">
<option value="☆☆★★★">推荐等级</option>
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★">☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">视听地址</td>
            <td width="83%"> 
              <input type="text" name="url" size="60">
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>       
          <tr class=lanyuqs align="center"> 
            <td colspan="2"> 
              <input type="checkbox" name="isbest" value="1">
              推荐&nbsp;&nbsp;&nbsp; 
              <input type="submit" name="Submit" value="确定新增" class="button">
             <input type="button" value="返回"  onClick="location.href='admin_dj.asp?action=dj'" class="button"></td>
          </tr>
		  <input type="hidden" name="action" value="newdj">
		<input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
      <%end if
	  if request.QueryString("action")="editdj" then
	  if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的舞曲ID参数！');history.back(1);</script>")
	response.end
  end if
end if
sql="select * from dj where dj_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            修改舞曲</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> 
              <input name="name" type="text" class="textarea" id="name" size="40" value="<%=rs("dj_name")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲作者</td>
            <td width="83%"> 
              <input name="user" type="text" class="textarea" id="user" size="40" value="<%=rs("dj_user")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲分类</td>
            <td width="83%"> 
              <select name="djcatid" id="djcatid">
                <%
sql="select * from djcat"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof%>
                <option value="<%=rs2("djcat_id")%>" <%if rs2("djcat_id")=rs("djcat_id") then response.write "selected" end if%>><%=rs2("djcat_name")%></option>
                <%rs2.movenext
loop
if rs2.eof and rs2.bof then%>
                <option value="0">当前没有舞曲分类</option>
                <%end if%>
              </select>
<select name="pic">
<option value="asf" <%if rs("dj_pic")="asf" then response.write "selected" end if%>>ASF音乐</option>
<option value="asfmtv" <%if rs("dj_pic")="asfmtv" then response.write "selected" end if%>>ASF影视</option>
<option value="rm" <%if rs("dj_pic")="rm" then response.write "selected" end if%>>RAM音乐</option>
<option value="rmmtv" <%if rs("dj_pic")="rmmtv" then response.write "selected" end if%>>RAM影视</option>
<option value="flash" <%if rs("dj_pic")="flash" then response.write "selected" end if%>>FLASH动画</option>
</select>
<select name="desc">
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★" selected>☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
          <tr class=lanyuds> 
            <td  width="17%">视听地址</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>
          <tr  class=lanyuqs align="center"> 
            <td colspan="2"> <input name="isbest" type="checkbox"  id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐
              <input name="Submit" type="submit" id="Submit" value="确定修改"> 
 <input type="button" value="返回"  onClick="location.href='admin_dj.asp?action=dj'" class="button"></td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("dj_id")%>">
          <input type="hidden" name="action" value="editdj">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
	  <%end if
if request.QueryString("action")="editerror" then
	  if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的舞曲ID参数！');history.back(1);</script>")
	response.end
  end if
end if
sql="select * from dj where dj_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            修改舞曲</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> 
              <input name="name" type="text" class="textarea" id="name" size="40" value="<%=rs("dj_name")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲作者</td>
            <td width="83%"> 
              <input name="usere" type="text" class="textarea" id="user" size="40" value="<%=rs("dj_user")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲分类</td>
            <td width="83%"> 
              <select name="djcatid" id="djcatid">
                <%
sql="select * from djcat"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof%>
                <option value="<%=rs2("djcat_id")%>" <%if rs2("djcat_id")=rs("djcat_id") then response.write "selected" end if%>><%=rs2("djcat_name")%></option>
                <%rs2.movenext
loop
if rs2.eof and rs2.bof then%>
                <option value="0">当前没有舞曲分类</option>
                <%end if%>
              </select>
<select name="pic">
<option value="asf" <%if rs("dj_pic")="asf" then response.write "selected" end if%>>ASF音乐</option>
<option value="asfmtv" <%if rs("dj_pic")="asfmtv" then response.write "selected" end if%>>ASF影视</option>
<option value="rm" <%if rs("dj_pic")="rm" then response.write "selected" end if%>>RAM音乐</option>
<option value="rmmtv" <%if rs("dj_pic")="rmmtv" then response.write "selected" end if%>>RAM影视</option>
<option value="flash" <%if rs("dj_pic")="flash" then response.write "selected" end if%>>FLASH动画</option>
</select>
<select name="desc">
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★" selected>☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
          <tr class=lanyuds> 
            <td  width="17%">视听地址</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>
          <tr  class=lanyuqs align="center"> 
            <td colspan="2"> <input name="isbest" type="checkbox"  id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐
              <input name="Submit" type="submit" id="Submit" value="确定修改"> 
 <input type="button" value="返回"  onClick="location.href='admin_dj.asp?action=djerror'" class="button"></td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("dj_id")%>">
          <input type="hidden" name="action" value="editerror">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
	  <%end if
	  if request.QueryString("action")="deldj" then
	  if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的舞曲ID参数！');history.back(1);</script>")
	response.end
  end if
end if
sql="select * from dj where dj_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            删除舞曲</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> <%=rs("dj_name")%> 　</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲作者</td>
            <td width="83%"> <%=rs("dj_user")%> 　</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">舞曲分类</td>
            <td width="83%"> 
                <%
sql="select * from djcat where djcat_id="&rs("djcat_id")
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
%><%=rs2("djcat_name")%> 　</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">视听地址</td>
            <td width="83%"><%=rs("dj_url")%> 　</td>
          </tr>
          <tr  class=lanyuqs align="center"> 
            <td colspan="2"> 
              <input name="isbest" type="checkbox" id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐 
              <input name="Submit" type="submit" id="Submit" value="确定删除">
 <input type="button" value="返回"  onClick="location.href='admin_dj.asp?action=dj'" class="button"></td>
          </tr>
          <input type="hidden" name="id" value="<%=rs("dj_id")%>">
          <input type="hidden" name="action" value="deldj">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if
end if
%>