asp /asp.net c#Á´½ÓOrcale Êý¾Ý¿âµÄ·½°¸
1£¬ÔÚweb·þÎñÆ÷Éϰ²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***;User ID=***;Data Source=ipcheck;"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
%>
4£¬ASP.net(C#) Á´½ÓÊý¾Ý¿â ¿ÉÒÔʹÓÃÕâÆªÎÄÕ½éÉܵķ½Ê½
Ìí¼Ó
<appSettings>
<add key="SysDSN" value="Data Source=ServerName;User ID=userid;Password=password;Unicode=True"/>
</appSettings>
ÔÙÕߣ¬¾Í¿ÉÒÔÌí¼ÓÒ»¸ömyclassÎļþ¼Ð£¬Ö®ºóÔÚÆäÖн¨¸öÀàÎļþ£¬Ä¬ÈÏÃüÃû¿Õ¼äÊÇmyClass
ÀàÎļþÃûΪconn.cs
ÓÉÓÚVS.NET2005²»Ä¬ÈÏÖ§³ÖoracleÊý¾Ý¿â£¬ËùÒÔÒªÌí¼ÓÆäÒýÓãºÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÀïÌí¼ÓÒýÓãºSystem.Data.OracleClient£¨×ÐϸÕÒÕÒàÞ~ÔÚ.NETÑ¡ÏÖУ©
ÄÚÈÝ£¨²»¶Ï¸üУ©£º
1using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.OracleClient;
11
12namespace User.Data
13{
14 public class conn
15 {
16
17 ¹¹Ô캯Êý#region ¹¹Ô캯Êý
18 /**//// <summary>
19 /// ¹¹Ô캯Êý(ĬÈÏ)
20 /// </summary>
21 public conn() { }
 
Ïà¹ØÎĵµ£º
Ê×ÏÈÌù´úÂ룺
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim objDic
Dim arr(2)
arr(0) = 0
arr(1) = 1
arr(2) = 2
Set objDic = Server.CreateObject("Scripting.Dictionary")
objDic.Add "key",arr
Response.Write("ÕâÊÇÐÞ¸Ä֮ǰµÄÖµ£º" & objDic.Item("key")(0))
objDic.Item("key")(1) = ob ......
×öÏîĿҲÓÐÒ»¶Îʱ¼äÁË£¬ÔÚ³ÌÐòÖÐÒ²Óöµ½ºÜ¶à°²È«·½ÃæµÄÎÊÌâ¡£Ò²¸Ã×ܽáÒ»ÏÂÁË¡£Õâ¸öÏîÄ¿ÊÇÒ»¸ö CMS ϵͳ¡£ÏµÍ³ÊÇÓà ASP.NET ×öµÄ¡£¿ª·¢µÄʱºò·¢ÏÖ΢Èí×öÁ˺ܶలȫ´ëÊ©£¬Ö»ÊÇÓÐЩÐÂÊÖ³ÌÐòÔ±²»ÖªµÀÔõô¿ªÆô¡£ÏÂÃæÎÒͨ¹ý¼¸¸ö·½Ãæ¼òµ¥½éÉÜ£º
¡¡¡¡1£ºSQL ×¢Èë
¡¡¡¡2£ºXSS
¡¡¡¡3£ºCSRF
¡¡¡¡4£ºÎļþÉÏ´«
SQL ×¢Èë
¡¡¡¡ÒýÆðÔÒ ......
<%@Language="VBScript" CodePage="65001"%>
<% option explicit%>
<% on error resume next %>
<% Session.CodePage="65001" %>
<% response.charset="utf-8" %>
<%
dim conn,connstr,sql,rs,rs2,rs3
connstr="dbq=" & server.MapPath("../data091003/data09 ......
<div id="storyScroller" style="width:100%;height:140px;line-height:28px;overflow:hidden;">
<div id="storyScrollMid">
<ul id="storyScrollUl" style=" list-style-type:circle; list-style-position: outside; margin-left:18px; margin-right:0px">
<li>item01</l ......
ÔÚAsp.netÖУ¬´ÓAÒ³ÃæÖе¯³öBÒ³Ãæ£¬ÔÚBÒ³ÃæÖÐÑ¡ÔñÊý¾Ýºó£¬¹Ø±Õ²¢½«Êý¾Ý¸üе½AÒ³Ãæ£¬ÊÇÒ»ÖÖ³£Óà µÄ·½Ê½¡£Ö»ÊÇÎÒ¶ÔJavascript²»ÊìϤ£¬ËùÒÔµ·¹ÄÁËÒ»ÏÂÎ磬ÖÕÓÚÓÐÁËÒ»µã³É¼¨£º
²âÊÔÏîÄ¿ÓÐÁ½¸öÒ³Ãæ£ºDefault.aspx¼°Default2.aspx£¬ÔÚDefault.aspxÒ³ÃæÉÏÓÐÒ»¸öTextBox1¼°Ò»¸öButton1£¬Button1ÓÃÓÚ´¥·¢Default2.aspx£¬TextBox1Óà ......