婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

主頁 > 知識庫 > javascript asp教程添加和修改

javascript asp教程添加和修改

熱門標簽:寧夏怎么申請400電話 外呼回撥系統圖片 咸陽銷售外呼系統 企數外呼系統能用多久 常用地圖標注范圍點 蘭州智能語音電銷機器人功能 離線電子地圖標注軟件注冊 為什么外呼系統需要預存話費呢 辦理400電話一年多少錢

The Connection Execute():

If you want to retrieve data from a database then you have no choice but to use a Recordset. However, for the purposes of adding, updating, and deleting data you don't necessarily have to have a Recordset. It's up to you.

For the purposes of adding, updating and deleting you can avoid the Recordset by using the Execute() method.

Get Started:

Below is the script for Lesson 19.

%@LANGUAGE="JavaScript"%>
var strConnect="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" 
strConnect += Server.MapPath("\\GOP") + "\\datastores\\gop.mdb;"
!-- METADATA TYPE="typelib" 
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
HTML>
HEAD>
TITLE>Administrator Page - Changing the Mailing List/TITLE>
/HEAD>
BODY LINK="red" VLINK="red" ALINK="crimson">
H2>Administrator Page/H2>
H3>Changing a the Mailing List/H3>
%
if (Request.Form("Delete") > "")
	{
	var sql="DELETE FROM Address WHERE ID = " + Request.Form("ID") + ";"
	}
else
	{
	var firstName = new String(Request.Form("firstName"))
	var lastName = new String(Request.Form("lastName"))
	var Address = new String(Request.Form("Address"))
	var City = new String(Request.Form("City"))

	var myRegExp = /[']/g;
	firstName = firstName.replace(myRegExp, '#39;');
	lastName = lastName.replace(myRegExp, '#39;');
	Address = Address.replace(myRegExp, '#39;');
	City = City.replace(myRegExp, '#39;');
	
	var sql="UPDATE Address SET firstName= '" + firstName + "' , lastName='" 
	sql += lastName + "' , Address='" + Address + "' , City='" 
	sql += City + "' , State='" + Request.Form("State") + "' , Zip='" 
	sql += Request.Form("Zip") + "' WHERE ID = " + Request.Form("ID") + ";"
	}
var objConn=Server.CreateObject("ADODB.Connection");
objConn.Open(strConnect)
objConn.Execute(sql)
objConn.Close()
objConn = null;
Response.Write("The member has been updated in the database.")
Response.Write("A HREF=\"../files/committee.asp\">")
Response.Write("Click here to see it./A>")
%>

There's no link to see this one in action. I did that for security reasons. I just want to point out a few highlights.

Danger in The Single Quote:

You'll notice that I replace single quote marks with the HTML encoded equivalent. I did that using the following code.

var myRegExp = /[']/g;
firstName = firstName.replace(myRegExp, '#39;');

The single quote is the only character you cannot input into a database using an ASP application. Everything else is fair game. DO NOT accept any text from users into your database without replacing all single quotes. To use an analogy, the single quote is like a key that opens up your entire database. Hackers will tear your application to shreds if you let someone input single quotes.

Execute( ):

The only other thing I want to spend any time with is objConn.Execute(sql). The variable sql takes on one of two definitions depending on the result of an "if" statement. In this case sql does all the work, and we never need a recordset.

標簽:麗江 家電維修 昆明 溫州 泰州 咸陽 鐵嶺 昌都

巨人網絡通訊聲明:本文標題《javascript asp教程添加和修改》,本文關鍵詞  javascript,asp,教程,添加,和,;如發現本文內容存在版權問題,煩請提供相關信息告之我們,我們將及時溝通與處理。本站內容系統采集于網絡,涉及言論、版權與本站無關。
  • 相關文章
  • 下面列出與本文章《javascript asp教程添加和修改》相關的同類信息!
  • 本頁收集關于javascript asp教程添加和修改的相關信息資訊供網民參考!
  • 企业400电话

    智能AI客服机器人
    15000

    在线订购

    合计11份范本:公司章程+合伙协议+出资协议+合作协议+股权转让协议+增资扩股协议+股权激励+股东会决议+董事会决议

    推薦文章
    主站蜘蛛池模板: 红原县| 二连浩特市| 鸡东县| 武川县| 托克逊县| 巩留县| 郴州市| 鄂托克旗| 六枝特区| 鹿泉市| 霍林郭勒市| 景谷| 龙胜| 秦皇岛市| 望奎县| 富民县| 丹棱县| 融水| 长宁区| 丹凤县| 五台县| 札达县| 通州市| 沅陵县| 灵丘县| 克拉玛依市| 昌图县| 油尖旺区| 始兴县| 海阳市| 长子县| 牡丹江市| 宕昌县| 漠河县| 广饶县| 青阳县| 樟树市| 曲周县| 米泉市| 凯里市| 定州市|