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
Ïà¹ØÎĵµ£º
1.SQL> select * from v$nls_parameters;
PARAMETER VALUE
----------------------------------- ------------------------------------
---------- ......
28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
OracleÊý¾Ý¿â·þÎñÓÉÁ½²¿·Ö×é³É£ºÊý¾Ý¿â½ø³ÌºÍÍøÂç¼àÌýÆ÷½ø³Ì£¬ËüÃÇ·Ö±ð¿Éͨ¹ýsqlplusºÍlsnrctlÃüÁî¿ØÖÆÆô¶¯¹Ø±Õ¡£
1£®Êý¾Ý¿â½ø³Ì
ʹÓÃDBCA¹¤¾ß´´½¨Êý¾Ý¿âºó£¬Æä½ø³ÌÒѾ×Ô¶¯Æô¶¯£¬ÕâЩ½ø³Ì¶¼ÊÇÒÔÊý¾Ý¿âÃû³Æ£¨ÔÚ±¾ÀýÖÐΪorcl£©ÃüÃû£¬ÈçÏÂËùʾ¡£
$ ps -ef|grep orcl
orac ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒ ......
Tomcat4.0ÓëOracleÔõô½¨Á¢Á¬½Ó³Ø£¿½¨ºÃºóÔõô²âÊÔ£¿
×÷Õߣºdorawo 2003Äê11ÔÂ07ÈÕ 10:01 ½øÈëÂÛ̳
Ïà¹ØÌÖÂÛ:oracle Á¬½Ó³Øweblogic½¨Á¢Á¬½Ó³ØÁ¬½Ó³Øtomcat Á¬½Ó³Øjava Á¬½Ó³Øhibernate Á¬½Ó³Ømys ......
¡öÀÖÖª
“ËÊÇ˵ÄË”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......