TA的每日心情 | 衰 2019-8-18 09:37 |
---|
签到天数: 2 天 [LV.1]初来乍到
|
数据库连接:
$ N1 J/ k }* }( i! `; n<%
~% a W& q$ o4 X! w0 r+ Aset conn=server.createobject("adodb.connection")
% l. o/ I2 {8 o5 @& R& M1 Kconn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")
# p) @8 @. a" t# Z' d( p4 O, B1 `%>0 W6 f$ t6 g) v1 D1 V9 o+ l9 V. j9 g
/ D, d9 A2 K9 [. Z
% ]/ g; i! L9 U2 u0 S' G& l
打开数据库:! k' [; p2 e5 O9 g
exec="select * from 数据库表"( w( m: n4 D- D2 m \( B3 a1 G! V1 ^
set rs=server.createobject("adodb.recordset")1 t4 p( m' ]$ K* P
rs.open exec,conn,1,1
! a# R( @/ ?1 Q, H+ h* a# r% D$ X参数1,1为读取/ C' ]# \" a: D" ?5 ^, E
" n4 m2 ^5 j5 ~+ k
读取内容格式:<%=rs("字段")%>
1 N( l% ?; l; t' {0 U y! S6 d9 Z! A ?
添加记录处理程序:# ~2 R- Z" M$ L. Q7 j
<%
8 S2 Q- e5 c3 N* B4 sset conn=server.createobject("adodb.connection")
: k- z1 e, y4 q/ O6 r! {# xconn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")
# J7 ?4 U$ J( G: k, O# h5 z* ?name=request.form("字段") name,tel,message为提交表单所设置的字段值
- u6 D( \ P2 M# Y1 t/ ^tel=request.form("字段"), j; S$ U. }' f, G2 Q8 Y$ _ i, ? H
message=request.form("字段")
0 p& |3 W$ w" v4 }1 d9 G* A/ Jexec="insert into 表名(字段)values('"+字段+"')" 多个用逗号隔开
+ y n' k9 ~' Z4 h3 Q' `3 F4 Dconn.execute exec 使用execute提交
. N3 z0 n# O( b2 L! c+ Gconn.close8 c; q' ^5 s z5 ?
set conn=nothing5 [: o7 d3 t4 w% k
%> P7 \5 Y5 L5 P; F
, ^& O7 y6 M: z$ l! D搜索处理程序:$ n3 x" H- n* x5 a6 d; h
<%: w8 H8 Q+ i9 A a7 w
name=request.form("字段") name,tel为提交表单所设置的字段值
% O' C, J, l6 c7 {- E5 ]3 T% {tel=request.form("字段"); M. K/ J$ b7 ^% g' U. m0 U
set conn=server.createobject("adodb.connection")& b" l7 n" ]1 ^4 t
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")
' f2 S4 k4 W" m- f5 m% D& Nexec="select * from 表 where name='"+字段+"' and tel="+字段
+ Y* G. c" O) P. q* d0 A, F( ?$ @set rs=server.createobject("adodb.recordset"). `9 F/ ~7 J+ ?1 x; v# H, X4 m9 I8 o
rs.open exec,conn,1,1
4 w% G5 O' a. T5 e! ~%>5 w6 ~7 s% ?+ r8 U% \( j5 c7 D
'页面搜索到的内容导出来
" N, G( {" W/ k<%# X) V6 E' ^9 a3 ?- ~$ `
do while not rs.eof6 Q5 V. `% t. ]4 v6 }; C' a
%><tr>
' @. B( g/ D9 U& W9 S<td><%=rs("name")%></td>) ^3 _( _. p2 W+ D' y2 c
<td><%=rs("tel")%></td>+ T) c1 v9 t7 s( j$ g6 ~; b" N$ g
<td><%=rs("time")%></td>
- }* a. |4 P5 u8 W2 j2 t+ m</tr>
c! P @$ ~9 ~" ?- D6 C<%; Y3 k9 s! N2 w' k- m" d# l
rs.movenext
! q9 N7 P+ `7 ?' h& M1 k3 s; ]loop' w, {% n2 X3 j9 h
%>9 v! D/ i' W! `, @7 \
2 e7 k) ? b" k$ i/ Q
删除记录处理程序:" g2 P4 n* y8 l
<%
0 l4 X1 k* u# hset conn=server.createobject("adodb.connection")
) j4 |8 w0 p3 Q! ~7 S& dconn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")
; }( b) _: z! R2 }/ }/ kexec="delete * from 表名 where 编号="&request.form("id")! X; p" f |+ c) X, w) T4 F% ] t
conn.execute exec
# o7 q" f/ t% D3 N7 B2 i%>
, }9 G* m5 Q2 A1 Y4 ^5 P. K" o
3 g. Y4 G9 T+ n. Y
5 y: b" c. p l8 ~# }修改记录处理程序:' e; s; p, s/ R7 @& k7 E
<%
6 ^3 u5 R3 d4 W7 Kset conn=server.createobject("adodb.connection")9 B" l4 s8 m' U" {" H
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")! J, ~/ }8 z; r- k: ?1 v* O* l6 P
exec="select * from 表名 where 编号="&request.form("id")4 [) t! ], y U" p
set rs=server.createobject("adodb.recordset")
9 A& L) b" g4 q# M/ D5 s6 Nrs.open exec,conn,1,3 '1,3为修改意思
& l9 ^) U" t& U/ g/ vrs("name")=request.form("字段") 'name,tel,message为提交表单所设置的字段值7 s6 F5 ~- ^3 ~( j
rs("tel")=request.form("字段")2 F2 j2 t3 ]' H/ x3 i& n E& ~. q
rs("message")=request.form("字段")6 M& G; H0 @2 Z4 B; h: S" U
rs.update
0 g% A' |" ?' i G( T, wrs.close7 i9 ^% A# X& b& k' D* ~
set rs=nothing% r. x) B# N& G. ^+ `
conn.close
1 |& K& i, T% g0 g7 aset conn=nothing
1 a6 w% e# V0 M! T) L& g0 _, w+ R%>4 {/ q2 J9 K/ Z; Y5 j, A! o' d# z
修改记录执行程序:输入ID号页面>>>导出相对应ID数据>>>>>>直接修改的处理程序
( P5 T$ s9 e7 Z: T$ \1 ]4 k. a
j- v* ^% C& Y, V# A& C [后台登陆处理程序例子:0 c, E9 _$ `$ D! i6 S- `+ P
<%+ V6 g9 V: ^% u' y. h
dim name,password- S# D! b3 T, T8 ]- H/ ^. s
name=request.form("name")
" x. Q$ F" D% Y, @password=request.form("password")
% j7 T- x( i! |7 \& Qdim exec,conn,rs
# m" U! ^5 n2 N' cexec="select *from 表名 where(name='"&字段&"' and password='"&字段&"')"
: U3 X- e& U% Z" l. H3 z1 aset conn=server.createobject("adodb.connection")) L) a1 g" K) Y- w7 h8 `
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库名")
* L+ d5 ~# o: m4 H0 Aset rs=server.createobject("adodb.recordset")3 V- X) V i ?" u
rs.open exec,conn
5 m1 k' ]5 `; O3 j; J: z$ Bif not rs.eof then8 R# z% M$ W( V2 j: }
rs.Close
* S3 Z+ V1 e# l: c0 X% e \conn.Close* w' i' F3 q' k3 B' h) m
session("checked")="yes" r0 ^; B, z$ A. W& v* w9 [
session("check")="right": e/ x9 t; q6 l. i v
response.Redirect "index.asp", A# q% P0 _2 z7 Y- b4 z% [
else) m+ A, x6 I% g; S% k6 A( s( K: n* _
session("checked")="no"
# h3 Z; d. z. R( n P& Asession("check")="wrong"
" l0 R- [4 t$ p3 dresponse.Redirect "login.asp"
1 D0 @: t. b' }8 I( E$ A" cend if
2 a2 `$ I7 d5 {+ g%>
: Y u9 _( _. \' K0 q* o+ X% h: J
每个后台页面加上:$ a$ x4 {9 v5 a6 Q. X l: X
<%if not session("checked")="yes" then 'session里面定义一个checked字符串变量
; g) g. f8 i# P5 g8 J' P& ^response.Redirect "login.asp" 2 B& y4 L) `5 a
else- l. f9 M0 E" P5 W
%> |
|