⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 update.asp

📁 很不错的站件包含的内容和具体功能先删除编译后的debug/release目录以减少压缩包大小
💻 ASP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<!--#include file="conn.asp" -->
<!--#include file="check.asp" -->
<%if request("CL") = "News" then%>
<script language="javaScript">
function checkdel(test)
{
return confirm("系统提示:\n此操作不可逆，是否确定批量"+test+"!!");
}
</script>
<%if request("Submit") = "确定更新" and request("b_id") <> "" and request("e_id") <> ""  then
sql="update Ce_News set N_Class = '"&request("N_Class")&"' where N_ID >="&request("b_id")&" and N_ID <="&request("e_id")
conn.execute sql
%>
<script language="JavaScript">
<!--
<!--
alert("系统提示：\n数据更新成功！")
self.navigate("News_Admin.asp")
-->
//-->
</script>
<%end if%>
<%if request("Submit2") = "确定更新" or request("Submit32") = "确定更新" then
sql="update Ce_News set N_Class = '"&request("e_Class")&"' where N_Class = '"&request("b_Class")&"'"
conn.execute sql
%>
<script language="JavaScript">
<!--
alert("系统提示：\n数据更新成功！")
self.navigate("News_Admin.asp")
-->
</script>
<%end if%>
<!--#include file="move.asp" --><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>中国保险资讯网后台管理页</title>
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="35" background="img/admin_top_bg.gif"><img src="img/copy.gif" height="35"></td>
  </tr>
</table>
<table width="820" height="100" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr height="10"> 
          <td height="5"></td>
        </tr>
      </table>
         
        
      <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" class="table">
        <form name="form1" method="post" action="" onSubmit="return checkdel('更新数据');">
          <tr > 
            <td  bgcolor="00CC00"height="26" colspan="4" align="center" class="font"> 
              <div align="right"> 
                <table width="99%" border="0" align="right" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td class="font"><strong><font color="#FFFFFF">批量操作 — 按编号范围更新数据</font></strong></td>
                  </tr>
                </table>
              </div></td>
          </tr>
          <tr> 
            <td width="12%" height="25" align="center" bgcolor="#FFFFFF" class="td">开始编号</td>
            <td width="92%" height="25" colspan="3" valign="bottom" bgcolor="#FFFFFF" class="td"> 
              <input name="b_id" type="text" id="b_id" size="20"> </td>
          </tr>
          <tr> 
            <td height="23" align="center" bgcolor="#FFFFFF" class="td">结束编号</td>
            <td height="23" colspan="3" valign="middle" bgcolor="#FFFFFF" class="td"><input name="e_id" type="text" id="e_id" size="20"></td>
          </tr>
          <tr> 
            <td width="12%" height="23" align="center" bgcolor="#FFFFFF" class="td">更 
              新 为</td>
            <td height="23" colspan="3" valign="middle" bgcolor="#FFFFFF" class="td"> 
              <select name="N_Class" class="input" id="N_Class">
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="Select * from Ce_News_Class order by C_ID asc"
rs.open sql,conn,1,1
do while not rs.eof
%>
                <option  value="<%=rs("C_Name")%>"><%=rs("C_Name")%></option>
                <%     
rs.movenext 
loop
rs.close 
set rs=nothing
%>
              </select> </td>
          </tr>
          <tr> 
            <td height="25" align="center" bgcolor="#FFFFFF" class="td"><div align="right"></div></td>
            <td height="25" colspan="3" valign="middle" bgcolor="#FFFFFF" class="td"> 
              <input type="submit" name="Submit" value="确定更新""> <input type="button" name="Submit" value="返回上页" onClick="history.go(-1)"> 
            </td>
          </tr>
        </form>
      </table>
      <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr height="10"> 
          <td height="5"></td>
        </tr>
      </table></td>
  </tr>
</table>
  
<table width="820" border="0" align="center" cellpadding="0" cellspacing="0">
  <form name="form2" method="post" action="" onSubmit="return checkdel('更新数据');">
 <tr> 
      <td valign="top"> 
        <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" class="table">
          <tr > 
            <td  bgcolor="00CC00"height="26" colspan="4" align="center" class="font"> 
              <div align="right"> 
                <table width="99%" border="0" align="right" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td class="font"><strong><font color="#FFFFFF">批量操作 — 按分类更新数据</font></strong></td>
                  </tr>
                </table>
              </div></td>
          </tr>
          <tr> 
            <td width="12%" height="25" align="center" bgcolor="#FFFFFF" class="td">原始数据</td>
            <td width="92%" height="25" colspan="3" valign="bottom" bgcolor="#FFFFFF" class="td"> 
              <select name="b_Class" class="input" id="select">
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="Select * from Ce_News_Class order by C_ID asc"
rs.open sql,conn,1,1
do while not rs.eof
%>
                <option  value="<%=rs("C_Name")%>"><%=rs("C_Name")%></option>
                <%     
rs.movenext 
loop
rs.close 
set rs=nothing
%>
              </select>
            </td>
          </tr>
          <tr>
            <td height="25" align="center" bgcolor="#FFFFFF" class="td">更 新 为</td>
            <td height="25" colspan="3" valign="bottom" bgcolor="#FFFFFF" class="td"><select name="e_Class" class="input" id="select5">
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="Select * from Ce_News_Class order by C_ID asc"
rs.open sql,conn,1,1
do while not rs.eof
%>
                <option  value="<%=rs("C_Name")%>"><%=rs("C_Name")%></option>
                <%     
rs.movenext 
loop
rs.close 
set rs=nothing
%>
              </select></td>
          </tr>
          <tr> 
            <td height="25" align="center" bgcolor="#FFFFFF" class="td"><div align="right"></div></td>
            <td height="25" colspan="3" valign="middle" bgcolor="#FFFFFF" class="td"> 
              <input type="submit" name="Submit2" value="确定更新"> <input type="button" name="Submit2" value="返回上页" onClick="history.go(-1)"> 
            </td>
          </tr>
        </table>
        <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr height="10"> 
            <td height="5"></td>
          </tr>
        </table></td>
    </tr></form>
  </table>
  
<table width="820" border="0" align="center" cellpadding="0" cellspacing="0">
  <form name="form3" method="post" action="" onSubmit="return checkdel('更新数据');">
    <tr> 
      <td valign="top"> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" class="table">
          <tr > 
            <td  bgcolor="00CC00"height="26" colspan="4" align="center" class="font"> 
              <div align="right"> 
                <table width="99%" border="0" align="right" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td class="font"><strong><font color="#FFFFFF">批量操作 — 自定义分类更新数据</font></strong></td>
                  </tr>
                </table>
              </div></td>
          </tr>
          <tr> 
            <td width="12%" height="25" align="center" bgcolor="#FFFFFF" class="td">原始数据</td>
            <td width="92%" height="25" colspan="3" valign="bottom" bgcolor="#FFFFFF" class="td"><input name="b_Class" type="text" id="b_Class" value="原始分类名称" size="20"></td>
          </tr>
          <tr> 
            <td height="25" align="center" bgcolor="#FFFFFF" class="td">更 新 为</td>
            <td height="25" colspan="3" valign="bottom" bgcolor="#FFFFFF" class="td"><select name="select" class="input" id="select2">
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="Select * from Ce_News_Class order by C_ID asc"
rs.open sql,conn,1,1
do while not rs.eof
%>
                <option  value="<%=rs("C_Name")%>"><%=rs("C_Name")%></option>
                <%     
rs.movenext 
loop
rs.close 
set rs=nothing
%>
              </select></td>
          </tr>
          <tr> 
            <td height="25" align="center" bgcolor="#FFFFFF" class="td"><div align="right"></div></td>
            <td height="25" colspan="3" valign="middle" bgcolor="#FFFFFF" class="td"> 
              <input name="Submit32" type="submit" id="Submit32" value="确定更新""> 
              <input type="button" name="Submit222" value="返回上页" onClick="history.go(-1)"> 
            </td>
          </tr>
        </table>
        <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr height="10"> 
            <td height="5"></td>
          </tr>
        </table></td>
    </tr>
  </form>
</table>
<%end if%>
12

⌨️ 快捷键说明

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