ASP Programming Introduction (20): Modified Data Records of ADO Components

xiaoxiao2021-03-06 39

Come and summarize: The operation of the database is nothing more than displaying records, inserts record, modifying records, delete records, query records. And in the display record, the displayed output format, the paging program, then combined with the insert record, a simple news system, the article system, the message system, and registered landing systems are not any problem. The following is to manage this, you need to modify the database record. First, which modification is to be modified, not a cage, but to modify the corresponding pair of specific pairs. It can be said that specific modifications are made to the specific rows of the database table. So, this time the record set has its specific one, of course, this is mainly determined by the SQL statement. For example, SQL = "Select * from table where id = 1" means that the extracted ID number is all records of the line of 1, and then simply assigns a new value that needs to be modified in this line and then upload the database is OK. The same statement SQL = "Select * from table where id = 2" believes that you can understand. But as we are in the page, it is not to be fixed, there is a choice of a connection, or enter a form value ... Jump to a dedicated modification page, so all the tasks are all on the page, it has The SQL statement should be a strong adaptive such as SQL = "select * from table where id =" & required.Queyrstring ("id") Next, the corresponding assignment to be modified is simple. As inserted into the record, the fields and values correspond to the value. RS ("CN_NAME") = "CNBRUCE" = "" cn_sex ") =" MALE "corresponds to a certain variable or function final, upload update the database and insert RS.UPDATA, actually observed, inserted The new records and update records are just a statement of RS.AddNew. 1. Showit.asp This file is the referenced by the previous example. It is primarily displayed, then now, add a skip to a hyperlink to a modified page for a specific record.

<% For i = 1 to rs.pageSize 'Use the for next loop to read the current page record IF ife.eof kilite ("") Response.write ("Article title is:" & RS ("cn_title") Response.write ("
article author is:" & RS ("cn_author ")) Response.write ("
) Response.write ("
article content is:" & rs ("cn_content") response.write) response.write ("cn_content")) response.write "

") rs.MovenextNext%>

Note that response.write (" Modify ") is dynamic, then look at CHANG .asp can be resistant. 2, change.asp

<% id = request.queryString ("ID")%> <% if request.form ("submit") = "change" thenwhattitle = request.form ("Title") WHOAUTHOR = Request.form ("Author") WhatContent = Request.form ("Content") id = request.form ("id") set = server.createObject ("adoDb.recordset") SQL = "Select * from cnarticle where cn_id =" & idrs.Open sql, conn, 3,2rs ( "cn_title") = whattitlers ( "cn_author") = whoauthorrs ( "cn_content") = whatcontentrs.updaters.close Set rs = Nothingconn.close SET CONN = NothingResponse.Redirect ("Showit.asp") response.end%> <% end if%> <% if id <> "" "" "" "" "adoDb.recordset") SQL = "SELECT * From cnarticle where cn_id = "& id ropen sql, conn, 1, 1 whattitle = rs (" cn_title ") WHOAUTHOR = RS (" cn_author ") WhatContent = RS (" cn_content ") end if%>

title: = whatTITLE% >>
Author: >
Content:

<% = WHA TCONTENT%> </ textarea> <br> <input type = "submit" value = "change" name = "submit"> <input type = "reset" value = "reset"> <input name = "id" type = "Hidden" Value = "<</p>
<p>% = ID%>> </ form> Of course, all procurators, security protection has not been done, BUG a lot, you will slowly solve it. Another type of modification update</p>
<p><% if Request.form ("Submit") = "change" "" "" "") @form ("author") Whatcontent = Request.form ("Content") ID = Request.Form ( "id") sql = "update cnarticle set cn_title = '" & whattitle & "', cn_author = '" & whoauthor & "', cn_content = '" & whatcontent & "' where cn_id =" & idconn.Execute (sql) conn.close set conn = NothingResponse.Redirect ("Showit.asp") Response.end%></p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-70333.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="70333" 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.036</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 = 'WBGgmMN7XbiZwMtWu_2BLIIxwoa8tLuQaJI19HxLZRaCywEO_2FhrUqZbIgnz94hoM4p9QFTZPrDSdSbDiG_2F2W8i4w_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);
});

$('#nav li[data-active="fid-1"]').addClass('active');
</script>