QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨
QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨ÕâÀïÒÔoracle 9iΪÀý×Ó£¬ÆäËûµÄÊý¾Ý¿âÁ¬½Ó·½·¨ÊÇÏàͨµÄ¡£
a.Ê×ÏÈÒªÔÚ±¾»ú½¨ÒéODBCÊý¾ÝÔ´£¬Õâ¸öÊôÓÚ»ù±¾²Ù×÷£¬ÕâÀï²»½²£¬Ìø¹ý£»
b.»ñÈ¡oracleµÄÁ¬½Ó´®µÄ·½·¨£¬ÔÚ±¾µØÐ½¨Ò»¸ö.txtÎļþ£¬ÐÞ¸ÄÀ©Õ¹ÃûÃû*.udl£¬Ë«»÷*.udlÎļþ£¬´ò¿ªÊý¾Ý¿âÁ´½ÓÊôÐÔ£¬¶¨Î»µ½“Ìṩ³ÌÐò”Ñ¡ÏÔ¿¨£¬Ñ¡ÖÐ oracleµÄÁ¬½Ó oracle provider for OLE DB,µã»÷ÏÂÒ»²½£¬ÊäÈëÊý¾ÝÔ´£¬Êý¾Ý¿âÓû§ÃûÒÔ¼°ÃÜÂ룬µã»÷²âÊÔÁ¬½Ó£¬È»ºóÓÃUE»ò¼Çʱ¾´ò¿ª*.udlÎļþ£¬oracleµÄÁ¬½Ó´®ÒѾÉú³ÉÁË£¬ÀýÈç
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Data Source=192.168.13.19
ÒÔÉϾÍÊÇudlÎļþÉú³ÉµÄoracleÁ¬½Ó´®
ÏÖÔÚÎÒÃÇÐèÒªÊÖ¶¯Ìí¼ÓÒ»¸öoracleÁ¬½Ó´®µÄÃÜÂë×Ö¶ÎPassword£¬²åÈëµ½User IDºóÃæ£¬ÖмäÓ÷ֺŸô¿ª£»
¼´ Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;;Password=test;Data Source=192.168.13.19
c.ÔÚqtpÖÐÀ´Á¬½ÓÊý¾Ý¿â
Dim Cnn '¶¨ÒåÒ»¸öÊý¾Ý¿âÁ¬½Ó´®
Set Cnn = CreateObject("ADODB.Connection")
Cnn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Password=test;Data Source=192.168.13.19 "
Cnn.Open '´ò¿ªÊý¾Ý¿âÁ¬½Ó
If Cnn.State = 0 Then 'ÅжÏÊý¾Ý¿âÁ¬½ÓÊÇ·ñ³É¹¦
Reporter.ReportEvent micFail, "testing", "Á¬½ÓÊý¾Ý¿âʧ°Ü"
else
Reporter.ReportEvent micPass, "testing", "Á¬½ÓÊý¾Ý¿â³É¹¦"
End If
if Cnn.State<> 0 then
Set Rs=CreateObject("ADODB.Recordset") 'Éú³É¼Ç¼¼¯¶ÔÏó
strsql ="Select * from t_sys_user" '´ÓÊý¾Ý¿âÖвéѯt_sys_userµÄËùÓмǼ
Rs.Open strsql ,Cnn,1,3 'Ö´ÐÐsqlÓï¾ä£¬¼Ç¼¿ÉÒÔ×ÔÓÉÒÆ¶¯£¬µ¥Êý¼Ç¼´¦ÓÚÖ»¶Áģʽ
ydl=Rs("USER_ID") 'È¡µÃ×Ö¶ÎΪUSER_IDµÄ¼Ç¼£¬Óα궨ÒåÔÚµÚÒ»ÐУ¬ËùÒÔÈ¡µÃµÄÊǸÃ×Ö¶ÎËùÔÚÐеĵÚÒ»ÐÐÊý¾Ý
msgbox ydl
&nbs
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
1.SQL> select * from v$nls_parameters;
PARAMETER VALUE
----------------------------------- ------------------------------------
---------- ......
Êý¾Ýµ¼³ö£º
1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
exp system/manager@TEST file=d:\daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíin ......
28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔÀ´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......
¡öÀÖÖª
“ËÊÇ˵ÄË”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......