www.gusucode.com > 盘锦DJ舞曲网 商业版源码程序 > admin/data_all.asp
<!--#include file="../conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据合并</title>
<style type="text/css">
<!--
.toptext {color: #FFFFFF}
body,td,th {
font-size: 12px;
}
a:link {
text-decoration: none;
color: #282828;
}
a:visited {
text-decoration: none;
color: #282828;
}
a:hover {
text-decoration: underline;
color: #FF0000;
}
a:active {
text-decoration: none;
color: #282828;
}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="upclass.asp?action=editclass">
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#42CFF9">
<tr>
<td height="30" align="center" bgcolor="#1E6997"><font color="#FFFFFF"><b>数 据 合 并</b></font></td>
</tr>
<tr>
<td height="50" align="center" bgcolor="#FFFFFF">把
<select name="classone" size="1">
<%
set rs=server.createobject("adodb.recordset")
sql="select * from class"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option " & sel & " value='"&rs("classid")&"'>"+rs("class")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
<option selected value="0">音乐类别</option>
</select>
合并到
<select name="classtwo" size="1">
<%
set rs=server.createobject("adodb.recordset")
sql="select * from class"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option " & sel & " value='"&rs("classid")&"'>"+rs("class")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
<option selected value="0">音乐类别</option>
</select></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#FFFFFF"><input type="submit" name="Submit" value=" 立即执行 " /></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="upclass.asp?action=deleall">
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#42CFF9">
<tr>
<td height="30" align="center" bgcolor="#1E6997"><font color="#FFFFFF"><b>清空数据库</b></font></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#FFFFFF"><input type="submit" name="Submit" onClick="{if(confirm('确定清空数据库吗?删除后将不可恢复！')){this.document.cybd.submit();return true;}return false;}" value=" 立即执行，请谨慎操作！" /></td>
</tr>
</table>
</form>
</body>
</html>