ASP programming introduction (twenty): Insert data record of ADO components

Title:

Author:

Content:

</ textarea> <br></p> <p><Input Type = "Submit" value = "add"></p> <p><Input Type = "RESET" value = "reset"></p> <p></ form></p> <p>[CTRL A All Selection Tips: You can modify some code first, then press Run] This page is actually very simple, that is, submitted the information content of the form to the Addit.asp page by the Submit button. Third, establish a page program addit.asp2 that processes data and inserts a database table, addit.asp</p> <p><! - # incrude file = "conn.asp" -> <% whattitle = request.form ("title" )WHOAUTHOR = Request.form ("Author") WhatContent = Request.form ("Content")%> <% Set = server.createObject ("adoDb.recordset") SQL = "Select * from cnarticle" rs.open SQL, CONN, 3, 2%> <% rs.addNewRS ("cn_title") = whatTitlers ("cn_author ") = WHOAUTHORRS (" cn_content ") = whatcontentrs.Update%> Article Add success, <a href="showit.asp"> Browse </a> <% rs.close set rs = nothingconn.close set conn = nothing% ></p> <p>Well, then it is to analyze it. 1, <! - # include file = "conn.asp" -> Needless, if you have contact with the database, you should use the connection file. 2, whatTITLE = Request.form ("Title") is to assign the value accepted in the last page form to a variable, which is convenient for the call of the program below. 3, RS.Open SQL, CONN, 3, 2 Note Parameters and the parameters used by the display database. 4, RS.Addnew is very simple and very conspicuous: Newly built a database record collection. 5, RS ("CN_TITLE" = WhatTITLE is about to receive the form value in the relevant field. 6, rs.Update is just the value of the value and the database field, and then the corresponding value is submitted to the database table after it is over. 7. You can jump to showit.asp after insertion. 8. Release resources are rules, don't forget. So, now. Insert and display database records, which is completely small dishes for you. The overall frame is completed, and the following is specific refinement. These include: the client's form is detected, preventing the omission of user information input; of course, it is best to add a server-side form detection, due to certain reasons of the client (such as self-design submission of non-detected pages) based on safety considerations, everything is still The information accepted by the server is accurate. Then continue in the application below. 1. The client detection is actually through simple script testing, which is repeated again when I start school ASP mentioned the script. Strengthened Addit.html <script laguage = "javascript"></p> <p><! -</p> <p>Function Form1_onSubmit ()</p> <p>{</p> <p>IF (Document.form1.title.Value == "")</p> <p>{</p> <p>Alert ("Please enter an article title")</p> <p>Document.form1.title.focus ()</p> <p>Return False</p> <p>}</p> <p>Else if (Document.form1.content.Value == "")</p> <p>{</p> <p>Alert ("Please enter your article content")</p> <p>Document.form1.content.focus ()</p> <p>Return False</p> <p>}</p> <p>}</p> <p>-></p> <p></ script></p> <p><form action = "addit.asp" method = "post" name = "οnsubmit =" οns1_onsubmit () "></p> <p>Title: <input type = "text" name = "title"> <br></p> <p>Author: <input type = "text" Name = "author"> <br></p> <p>Content: <br></p> <p><textarea name = "content" rows = "8" cols = "30"> </ textarea> <br></p> <p><Input Type = "Submit" value = "add"></p> <p><Input Type = "RESET" value = "reset"> </ form></p> <p>[CTRL A All Selection Tips: You can modify some code, then press Run] 2, the server side detection may ask, since there is a client's detection, then multiple server-side detection? The reason is very simple, such as simply submitting the Page HTML form, you can design a page that removes the form detection. When you click Submit, and there is no information, you will definitely cause the server to fail to fail. Strengthened Addit.asp</p> <p><! - # clude file = "conn.asp" -> <% whattitle = trim (Request.form ("Title")) ")") WhatContent = TRIM (Request)). Form ("Content"))%> <% if whattitle = "" "> <script language = VBS> ALERT (" Please enter an article title ") History.go (-1) </ script> <% end if% > <% if whatcontent = "" "> <script language = VBS> ALERT (" Please enter an article title ") History.go (-1) </ script> <% end if%> <% set RS = Server. CreateObject ("AdoDb.Recordset") SQL = "Select * from CNArticle" rs .open SQL, CNA, 3, 2%> <% rs.addNewRS ("cn_title") = WhatTITLERS ("cn_AUTHOR") = WHOAUTHORRS ("CN_CONTENT" ") = whatcontentrs.Update%> Article Add success, <a href="showit.asp"> Browse </a> <% = nothingconn.close set conn = Nothing%></p> <p>It can be seen that it is to add similar judgments.</p> <p><% if whattitle = "" THEN> <script language = VBS> ALERT ("Please enter an article title") History.go (-1) </ script> <% end if%></p> <p>It is very simple. If the information received is empty, the warning box will pop up, and after confirmation, return to addit.html. Of course, the CN_AUTHOR does not set the detection because the accepted value of the field is allowed to be empty. OK, summarize, inserting record is mainly</p> <p>Rs.addNewrs ("cn_title") = whatTitle ... rs.Update</p> <p>Very simple, first declare addnew, then correspond to, then submit the inserted database. This is a method of inserting a database. Here you will contact another one. It should be noted that the structured query language is the SQL statement to complete some more demanding database operations. Of course, for the flow of information such as extraction, the flow of information is not left. So the method of inserting the following is done directly with SQL syntax. Modified Addit.asp <! - # clude file = "conn.asp" -> <% whattitle = request.form ("title" )WHOAUTHOR = Request.form ("Author") WhatContent = Request.Form "Content")%> <% sql = "INTO CNARTICLE (CN_TITLE, CN_AUTHOR, CN_CONTENT) VALUES ('" & whattitle & ",'" & whatcontent & ")" CONNECUTE (SQL)%> The article is added successfully, <a href="showit.asp"> Browse </a> <% conn.close set conn = Nothing%></p> <p>In this program, you will find that as long as the SQL statement is required, do not need to build a RESCORD record collection, do not require AddNew, do not perform Update. Directly through conn.execute (SQL). Of course, this method is applied. If you have an accepted value of the field, you can also insert the record. This is the first report</p> <p>Microsoft Jet Database Engine Error '80040E21' field 'xxx.xxx' cannot be zero-length string.</p> <p>It has great fault tolerance. It is the readability of the program or the simple and high efficiency of the method.</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-70337.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="70337" 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.048</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 = 'lg3XuKQB7ZcZ3zFC_2FJK_2Fr_2F6hMBjrtQyiqXDFqG0yKHJrGsgP0NtKQ_2Fbh19PnpMrjVpxO19gs_2BSHPTH_2Bp'; 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>