Use in keyword to implement data from the bulk deletion
Use the in keyword to implement data from the bulk to delete the original: Xiao Wang Zai often encounters the volume deletion of the data in Web programming. Our usual practice is to achieve the batch deletion of data by looping. But a program module is used to use too many of this program module to decline. Therefore, this article describes the batch deletion of data by using in keywords.
Let's take an example to explain the data bulk deletion of the in keyword, if we want to delete the data of this page: The relevant code is as follows: Managenews.asp <% 'database I will not say%>
management news <TITLE> Management News </ TITLE> <meta http-equiv = "content-type" content = "text / html; charSet = GB2312"> < Link rel = "stylesheet" href = "./ index / style.css" type = "text / css"> <script> Function del () // Used to determine whether the record has no selected function {var flag = true; VAR TEMP = ""; var tmp; if ((Document.form1.answer.Length ") ==" undefined ") {TMP = 1} else {tmp = Document.form1.answer.Length} if (TMP == 1) {if (document.form1.answer.checked) {flag = false; temp = document.form1.answer.Value}} else {for (i = 0; i <document.form1.answer.length; i ) { IF (Document.form1.answer [i] .checked) {if (Temp == ") {flag = false; temp = document.form1.answer [i] .value} else {flag = false; temp = TEMP "," Document.form1.answer [i] .value}}}}}}}}}}}}}} {Alert ("Sorry, you have not selected!")} else {name = document.form1.name.value // alert (Name) IF ("Do you want to delete?")) {WINDOW.LOCATION = "DELNEWS.ASP? ID =" TEMP;}} Return! Flag;} </ script> </ head> <body> < Script lang UAGE = JavaScript> Function checkall (all) // Used to determine the function {var A = document.getlementsByname ("Answer"); for (var i = 0; i <a.length; i ) a [i ] .checked = all.checked;} </ script> <% set = server.createObject ("adoDb.recordset") SQL = "SELECT * from news order by addtime desc" rs.open SQL, CONN, 1, 3 %> <% if xi.eof death%></p>
<p><table width = "50%" border = "0" align = "center" id = "table2"> <tr> <td align = "center"> No news! </ tr> </ table> <% else%> <form method = "post" id = form1 name = form1> <Table width = "90%" border = "0" align = "center" class = "tabdocborder" ID = "table3"> <tr> <TD> <table width = "80%" align = "center" id = tabdocmain border = '1' cellspacing = '0' cellpadding = '0' bordercolorlight = '# 82b4dd' bordercolor = '# b6d3eb' class = "tabdocmain"> <Tabdocmain> <TabDocMain> <TD colspan = "7" align = "center"> News Management </ td> </ tr> </ thead> <TBODY> <TR > <TD align = center> Delete box </ td> <td align = center> News Title </ td> <TD align = center> Publishing time </ td> <td align = center> Manage </ td> </ Tr> <% do while not rs.eof%></p>
<p><TR> <TD Align = Center> <input type = "Checkbox" Name = "Answer" Value = "<% = rs (" ID ")%>" ID = "CheckBox1"> </ td> <TD align = LEFT> <% IF LEN (RS ("Title") <= 30 THEN%> <% = RS ("Title")%> <% ELSE%> <% = (rs (rs ("title"), 30 )))%> ... <% end IF%> </ td> <td align = left> <% = rs ("addtime")%> </ td> <TD align = center> <a href = "editnews .asp? id = <% = rs ("ID")%>> Edit </a> </ td> </ tr> </ tbody> <% rs.movenext loop%></p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-100389.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="100389" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.042</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'e_2BPX3_2FiK2HuSStA2vIG0Ok_2F294wZ5btNDZKnAUL7VFZr3htQU6MVr_2F09pUgtDbOcJUIg8ME_2FP2hnyoOJYDo1_2Fg_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
