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() { }
 
Ïà¹ØÎĵµ£º
dz̸ASP.NETÖеÄÈýÖֻỰ״̬
³£ÓõÄASP.NETµÄ»á»°×´Ì¬ÖÐÓÐÈýÖÖ.·ÖΪ½ø³ÌÄڻỰ״̬¡¢×´Ì¬·þÎñÆ÷»á»°×´Ì¬¡¢SQL Server »á»°×´Ì¬
ÏÈ̸̸½ø³ÌÄڻỰ״̬£¨Inprocess£©ÕâÊÇÒ»ÖÖĬÈϵÄģʽ£¬µ«ÊÇÖ»ÒªÔÚWeb.configÖнøÐмòµ¥µÄÅäÖþͿɽøÐиü¸Ä£¬¾ßÌå ......
SingletonģʽµÄʵÏÖ
SingletonģʽµÄʵÏÖ»ùÓÚÁ½¸öÒªµã£º
1£©²»Ö±½ÓÓÃÀàµÄ¹¹Ô캯Êý£¬¶øÁíÍâÌṩһ¸öPublicµÄ¾²Ì¬·½·¨À´¹¹ÔìÀàµÄʵÀý¡£Í¨³£Õâ¸ö·½·¨È¡ÃûΪInstance¡£Public±£Ö¤ÁËËüµÄÈ«¾Ö¿É¼ûÐÔ£¬¾²Ì¬·½·¨±£Ö¤Á˲»»á´´½¨³ö¶àÓàµÄʵÀý¡£
2£©½«ÀàµÄ¹¹Ô캯ÊýÉèΪPrivate£¬¼´½«¹¹Ô캯Êý"Òþ²Ø"ÆðÀ´£¬ÈÎºÎÆóͼʹÓù¹Ô캯Êý´´½¨Ê ......
1£ºÉÏ´«Ò³Ãæ
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="te ......
<%@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 ......
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql ......