📄 ywyzl_zlxg_2_2.asp

📁 asp+Access开发的客户资源管理系统,用户名:admin,密码:

💻 ASP

字号:

<%
		'与数据库*.mdb建立连接
		Set conn = Server.CreateObject("ADODB.Connection")
	conn.open "driver={Microsoft Access Driver (*.mdb)};pwd=webcool_2000;dbq=" & Server.MapPath("../database/customer.mdb")
		'发送一条修改指令
	   
		sql_up="UPDATE worker SET "
		sql_up=sql_up & " name='"&request("name")&"' " & ","
		sql_up=sql_up & " search='"&request("search")&"' " & ","
		
		sql_up=sql_up & " sex='"&request("sex")&"' " & ","
		sql_up=sql_up & " birthday='"&birthday&"' " & ","
		sql_up=sql_up & " nation='"&request("minzu")&"' " & ","
		sql_up=sql_up & " card='"&request("cardok")&"' " & ","
		sql_up=sql_up & " degree='"&request("wenhua")&"' " & ","
		sql_up=sql_up & " special='"&request("degree")&"' " & ","
		sql_up=sql_up & " school='"&request("schoolok")&"' " & ","
		sql_up=sql_up & " funcion='"&request("now")&"' " & ","
		sql_up=sql_up & " gongneng='"&request("xingzhi")&"' " & ","
		sql_up=sql_up & " telephone='"&request("telephoneok")&"' " & ","
	        sql_up=sql_up & " post='"&request("youbian")&"' " & ","
		sql_up=sql_up & " email='"&request("emailok")&"' " & ","
		
		sql_up=sql_up & " oicq='"&request("oicqok")&"' " & ","
		sql_up=sql_up & " http='"&request("httpok")&"' " & ","
		sql_up=sql_up & " call='"&request("callok")&"' " & ","
		sql_up=sql_up & " mobile='"&request("mobileok")&"' " & ","
		sql_up=sql_up & " address='"&request("addressok")&"' " & ","
		
	

		sql_up=sql_up & " introduce='"&request("jieshao")&"' "
		sql_up=sql_up & " where name='"&session("name")&"' "
		
		'发送sql指令，加入信息
		conn.Execute sql_up
			set conn=nothing
%>
<%response.redirect("ywyzl_zltj_no.asp")%>


<html><script language="JavaScript">                                                                  </script></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -