aspÁ¬½Óoracle9iÎÊÌâ
¸÷λ´ó¸ç´ó½ã¾ÈÃüѽ£¡£¡Êý¾Ý¿â´ó×÷Òµ×öµ½×îºó¹Ø¼üʱ¿ÌÔªµ©±»¿¨ÁË3Ì죬ÏÂÖÜÒª½»ÁË¡£ÎҵĻ·¾³ÊÇwindows2003+oracle9i£¬ODBCµÄDATA SOURCE NAME:DZSW;TNS:MYSW;USER:SCOTT£¨½¨±íµÄÓû§£©;PASSWORD:TIGER;testconntion²âÊÔʱ³É¹¦£»µ«ÓÃÁ¬½Ó´úÂëcommon/conn.asp£º <%
'Á¬½ÓÊý¾Ý¿â
dim conn
dim connstr
Set conn=Server.CreateObject("ADODB.Connection")
connstr="Driver={Oracle in OraHome92};server=MYSW;uid=scott;pwd=tiger;"
startime=timer()
%>
ÇëÇó´úÂëΪ£º <%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../common/conn.asp"-->
<!--#include file="../common/status.html"-->
<!--#include file="../common/md5.asp"--> <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>¹ÜÀíÔ±µÇ¼ </title>
</head>
<%
dim address
address = left(cstr(request.servervariables("REMOTE_ADDR")),10)
if address <>"192.168.0." then
%>
ÄúÊÇÍâÍøÓû§£¬ÎÞȨ²é¿´ÄÚ²¿ÍøÕ¾£¬ÎåÃëÖÓºó×Ô¶¯·µ»Ø£¬Èç¹ûÄúµÄä¯ÀÀÆ÷ûÓÐ×Ô¶¯·µ»Ø£¬Çë <a href="../admin/login.html">µã»÷´Ë´¦ </a>¡£ <BR>Çë²»ÒªÖØ¸´²âÊÔ£¬ÄúµÄËù×÷ËùΪÎÒÃǾùÓмǼ¡£
<meta http-equiv="refresh" content="5;url=login.html"> <
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
ÍòÍøµÄ·þÎñÆ÷Ö§³Öα¾²Ì¬µÄ,Ö±½ÓÓÃrewriteÔÚweb.configÎļþд¹æÔò,Ò²²»Óð²×°×é¼þ¾Í¿ÉÒÔʵÏÖα¾²Ì¬,µ«ÊÇÔÚʱ´ú»¥Áª·þÎñÆ÷¾ÍÓò»ÁËÁË,×ÉѯËüµÄ¿Í·þ,Ëû˵ËûÃÇ·þÎñÆ÷(»ù±¾ÐÍC)²»Ö§³Öα¾²Ì¬µÄ.ÇëÎÊһϸ÷λÎÒ¸ÃÓÃʲô·½·¨ ......