| |
 |
|
<%
if request("accounts")<>"" then
dim gconn,rs,str
set gconn=Server.CreateObject("ADODB.Connection")
gconn.Open "Dbq="&Server.Mappath("database/goalwoo.mdb")&";DRIVER={Microsoft Access Driver (*.mdb)};"
str="Select * from manage where accounts='"&request("accounts")&"' and password='"&request("password")&"'"
set rs=gconn.Execute(str)
if not rs.Eof then
response.redirect"techologyservicemanage.asp"
else
response.write""
end if
end if
%>
| |
| |
|
|
| |
|
<%
if trim(request("companyname"))<>"" then
'下面将数据填入数据库中
'On Error Resume Next
'建立Connection对象
Dim db
Set db=Server.CreateObject("ADODB.Connection")
db.Open "Dbq="&Server.Mappath("database/goalwoo.mdb")&";DRIVER={Microsoft Access Driver (*.mdb)};"
'这里利用新数据源
'下面添加数据
Dim strSql
strSql = "Insert into service(companyname,address,phone,name,date1,remark)values('"&trim(request("companyname"))&"','"&trim(request("address"))&"','"&trim(request("phone"))&"','"&trim(request("name"))&"','"&trim(request("date"))&"','"&trim(request("remark"))&"')"
db.execute(strSql)
db.close
'执行添加操作
'下面判断插入过程有无错误,并给出相应信息
response.write""
End If
%>
| |
| |
|
|
|
|
Copyright 2005 GuangZhou Goalwoo Electric Technologies Co.,Ltd.All rights reserved |
地址:广州市天河区中山大道东圃大马路2号2栋三楼 E-Mail:master@goalwoo.com |
设计制作:广州高伍电子科技有限公司 |
|
|