📄 6-3.asp

📁 ASP+SQL Server动态网站开发从基础到实践教程

💻 ASP

字号:

<html>

<head>

<title>OLE DB连接ACCESS数据库</title>
</head>

<body>

<%
Dim ConnStr,myConn,mySQL
ConnStr="Provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("../chap5/register.mdb") '参照表6-2的连接字符串
Set myConn=Server.CreateObject ("ADODB.Connection")
Myconn. ConnectionString=ConnStr
myConn.open  '直接打开数据库连接

'定义一个Insert的SQL语句，向register.mdb的member数据库表插入一条记录
mySQL="insert into member (id,name,sex,birth,diploma,phone,email,pwd) values ('107','Marry','girl',#1978-1-1#,'硕士','88888888','hello@163.com','324561')"
myConn.Execute mySQL
mySQL="insert into member (id,name,sex,birth,diploma,phone,email,pwd) values ('108','Bill','boy',#1968-1-1#,'硕士','77777777','welcome@163.com','123456')"


myConn.Execute mySQL
response.write "记录添加成功！"

%>


</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -