📄 ywyzl_zlxg_2_1.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 & " sex='"&request("sex")&"' " & ","
		sql_up=sql_up & " birthday='"&request("birthday")&"' " & ","
		sql_up=sql_up & " nation='"&request("nation")&"' " & ","
		sql_up=sql_up & " card='"&request("card")&"' " & ","
		sql_up=sql_up & " degree='"&request("degree")&"' " & ","
		sql_up=sql_up & " special='"&request("special")&"' " & ","
		sql_up=sql_up & " school='"&request("school")&"' " & ","
		sql_up=sql_up & " funcion='"&request("funcion")&"' " & ","
		sql_up=sql_up & " gongneng='"&request("gongneng")&"' " & ","
		sql_up=sql_up & " telephone='"&request("telephone")&"' " & ","
        sql_up=sql_up & " post='"&request("post")&"' " & ","
		sql_up=sql_up & " email='"&request("email")&"' " & ","
		
		sql_up=sql_up & " oicq='"&request("oicq")&"' " & ","
		sql_up=sql_up & " http='"&request("http")&"' " & ","
		sql_up=sql_up & " call='"&request("call")&"' " & ","
		sql_up=sql_up & " mobile='"&request("mobile")&"' " & ","
		sql_up=sql_up & " address='"&request("address")&"' " & ","
		
	

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


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

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -