oracle¿Í»§¶ËÅäÖÃÓëʹÓã¨vb£©
ʹÓÃoracleÊý¾Ý¿âÓÐÁ½ÖÖ·½·¨£º
1¡¢ÔÚ¿Í»§¶Ë»úÆ÷Éϰ²×°oracleµÄ¿Í»§¶ËÈí¼þ¡£Î¨Ò»µÄÀýÍâ¾ÍÊÇjavaÁ¬½ÓÊý¾Ý¿âµÄʱºò£¬¿ÉÒÔÓÃjdbc thinģʽ£¬²»ÓÃ×°oracleµÄ¿Í»§¶ËÈí¼þ¡£
2¡¢Èç¹ûÄãÔÚ»úÆ÷ÉÏ×°ÁËoracleÊý¾Ý¿â·þÎñÆ÷£¬¾Í²»ÐèÒªÔÚµ¥¶ÀÔڸûúÆ÷Éϰ²×°oracle¿Í»§¶ËÁË£¬ÒòΪװoracleÊý¾Ý¿âµÄʱºò»á×Ô¶¯°²×°oracle¿Í»§¶Ë
Èç¹ûÏëÓñ¾µØµÄ¼ÆËã»ú·ÃÎÊ»òÁ¬½ÓÔ¶³ÌµÄoracleÊý¾Ý¿â£¬ÄÇô¾Í±ØÐëÔÚ±¾µØµÄ¼ÆËã»úÉϰ²×°oracle¿Í»§¶ËÈí¼þ¡£
ÔÚ°²×°¿Í»§¶Ëǰ£¬È·±£ÔÚ·þÎñÆ÷¶Ë£º
1£®±£Ö¤listener·þÎñÒѾÆô¶¯¡£
2£®±£Ö¤Êý¾Ý¿âÒѾÆô¶¯¡£
°²×°Íê¿Í»§¶ËÈí¼þºó£¬Òª¶Ô¿Í»§¶ËÈí¼þϵÄÅäÖúÍÒÆÖ²¹¤¾ß----¡·net configuration assianstant½øÐÐÅäÖ㬰´ÕÕÌáʾ£º
1¡¢Í¼ÐνçÃæÐ޸ģ¨×îºÃÓÃÕâÖÖ·½·¨Ð޸ģ©
¿ÉÒÔÔÚ¿Í»§¶Ë»úÆ÷ÉÏʹÓÃoracle Net Configuration Assistant»òoracle Net ManagerͼÐÎÅäÖù¤¾ß¶Ô¿Í»§¶Ë½øÐÐÅäÖ㬸ÃÅäÖù¤¾ßʵ¼ÊÉÏÐÞ¸Ätnsnames.oraÎļþ¡£
ÏÂÃæÊÇʹÓà oracle Net Configuration Assistant¹¤¾ß¶Ô¿Í»§¶Ë½øÐÐÅäÖõģ¬ÉèÖÃÍê³ÉÖ®ºónet manageÖÐÒ²×÷ÁËÏàÓ¦µÄÐ޸ġ£²½ÖèÈçÏ£º
1¡¢´ò¿ªcmdÊäÈënetca»òÓò˵¥Ñ¡Ôñ Net Configuration Assistant¡£
2¡¢Ñ¡Ôñ¡¾±¾µØnet·þÎñÃûÅäÖá¿→ÏÂÒ»²½¡£
3¡¢Ñ¡Ôñ¡¾Ìí¼Ó¡¿→ÏÂÒ»²½¡£
4¡¢ÔÚ¡¾·þÎñÃû¡¿ÖÐÊäÈëÄãÏëÒªÁ¬½ÓµÄ·þÎñÆ÷ÉϵÄoracle·þÎñµÄÃû×Ö£¨Ô¶³Ì·þÎñÆ÷ÉÏÊý¾Ý¿âµÄÃû×Ö£©→ÏÂÒ»²½¡£
5¡¢Ñ¡Ôñ¡¾tcp¡¿→ÏÂÒ»²½¡£
6¡¢ÔÚ¡¾Ö÷»úÃû¡¿ÖÐÊäÈëÄãÏëÒªÁ¬½ÓµÄ·þÎñÆ÷ip£¬¶Ë¿ÚºÅ²»±ä→ÏÂÒ»²½¡£
7¡¢Ñ¡Ôñ¡¾½øÐвâÊÔ¡¿→ÏÂÒ»²½¡££¨µ±È»ÄãÒ²¿ÉÒÔÑ¡Ôñ²»²âÊÔ£©
¡ù1²âÊÔÈç¹û²»Í¨¹ý£¬µã»÷¡¾¸ü¸ÄµÇ¼¡¿ÊäÈëÒ»¸ö¿Ï¶¨ÄܵÇÈëµÄ¡¾Óû§Ãû¡¿ºÍ¡¾¿ÚÁî¡¿→È·¶¨£¬³öÏÖ¡¾ÕýÔÚÁ¬½Ó...²âÊԳɹ¦¡£¡¿±íÃ÷²âÊԳɹ¦¡£
¡ù2²âÊÔ²»Í¨¹ýµÄ»°£¬µã¡¾ÉÏÒ»²½¡¿È·ÈÏÄãдµÄ¡¾·þÎñÃû¡¿ºÍ¡¾Ö÷»úÃû¡¿£¬È·ÈÏÎÞÎóµÄÇé¿öÏ£¬È·ÈÏÄãÒªÁ¬½ÓµÄ·þÎñÆ÷oracle¼àÌý·þÎñÒѾ´ò¿ª¡£
8¡¢ÔÚ¡¾net·þÎñÃûÖС¿ÊäÈëÄãÏëҪʹÓõı¾µØµÄ·þÎñÃû£¨±¾µØÊ¹ÓõķþÎñÃû³Æ¼´µ±³ÌÐòÁ´½ÓÊý¾Ý¿âËùʹÓõÄÊý¾Ý¿âÃû³Æ»òÊý¾Ý¿â±ðÃû¡¢ÍøÂç·þÎñÃû£©→ÏÂÒ»²½¡£
¡ù¾ÍÊÇ¡¾sqlplus user/passwd @±¾µØ·þÎñÃû¡¿¡£
9¡¢Ñ¡Ôñ¡¾·ñ¡¿→ÏÂÒ
Ïà¹ØÎĵµ£º
VBÖÐ Replace º¯Êý
ÃèÊö
·µ»Ø×Ö·û´®£¬ÆäÖÐÖ¸¶¨ÊýÄ¿µÄij×Ó×Ö·û´®±»Ì滻ΪÁíÒ»¸ö×Ó×Ö·û´®¡£
Óï·¨
Replace(expression, find, replacewith[, compare[, count[, start]]])
Replace º¯ÊýµÄÓï·¨ÓÐÒÔϲÎÊý£º
²ÎÊý ÃèÊö
expression ±ØÑ¡¡£×Ö·û´®±í´ïʽ£¬°üº¬ÒªÌæ»»µÄ×Ó×Ö·û´®¡£
find ±ØÑ¡¡£±»ËÑË÷µÄ×Ó×Ö·û´®¡£
......
VBÏÔʾ͸Ã÷FLASHЧ¹û
ÑÝʾЧ¹û£º
´úÂëÈçÏ£º
¹«¹²ÉùÃ÷ÇøÓò
Option Explicit
Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "user32" Alias "SetW ......
Ö÷´°Ìå´úÂ룺
'´ò¿ªÍøÒ³
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
'¸´ÖÆÎļþ
Private Declare Fu ......
¾ÍÕâôһ¸öº¯Êý¾Í½â¾öÁËÄÇλÈÊÐÖ3Ìì¶àµÄ¹¤×÷
°¦~£¡Õæ±»Ò»¸öº¯ÊýÍæËÀÁË
ÕâÀï˳±ãÌû³öÀ´°É
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Microsoft.VisualBasic.Shell( ......
Private Declare Function InternetSetCookie Lib "wininet.dll" Alias "InternetSetCookieA" (ByVal lpszUrlName As String, ByVal lpszCookieName As String, ByVal lpszCookieData As String) As Boolean
Private Declare Function InternetGetCookie Lib "wininet.dll" Alias "InternetGetCookieA" (ByVal lpszUrlName ......