Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 Ç°ÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server 2003 ¾Í±ØÐë°²×° JDK£¬ÒòΪ Windows server 2003 ÊDz»´ø JVM µÄ-Windows server 2003 ·¢ÐÐʱ MS ºÍ SUN ¸ÕºÃÄÖ±ðŤÄØ)¡£°²×°Íêºó£¬ÒªÉèÖü¸¸ö»·¾³±äÁ¿£º
JAVA_HOME = E:\j2sdk1.4.2_04
CLASSPATH = E:\j2sdk1.4.2_04\lib;E:\j2sdk1.4.2_04\lib\tools.jar
Path ÖÐ¼Ó .;E:\j2sdk1.4.2_04\bin;
CATALINA_HOME = E:\Tomcat 5.0
TOMCAT_HOME = E:\Tomcat 5.0
½âÊÍÈçÏ£ºÎÒµÄ JDK°æ±¾ÊÇ 1.4.2£¬°²×°ÔÚ E:\j2sdk1.4.2_04 Îļþ¼ÐÏ¡£
»·¾³±äÁ¿ JAVA_HOME ºÍ CATALINA_HOME ÊÇÒ»¶¨Òª¼ÓµÄ(ÖÁÉٲο¼×ÊÁ϶¼ÊÇÕâô˵µÄ)¡£CLASSPATH Ҳ˵Ҫ¼Ó£¬µ«ÊÇÎÒû¼ÓËƺõҲûʲôӰÏì¡£Path ÖÐ¼Ó “.;E:\j2sdk1.4.2_04\bin;”Ò²Ò»Ñù£¬ÎÒ²»¼Ó jsp Ò²ÄÜÔËÐÐÆðÀ´£¬µ«ÊÇÔÚ DOS ´°¿ÚÏÂÊÖ¹¤±àÒë .java Àൽ .class ÎļþÓÐÓ°Ï죬ÒòΪÕÒ²»µ½ javac.exe ±àÒëÃüÁîÎļþ¡£ÖÁÓÚ path ÖмӵÄÄǸöµã“.”£¬ÎÒÔÀ´ÔÚ resin ÏÂÊÇÐèÒªµÄ£¬ÔÚ Tomcat Ï»¹Ã»È·¶¨ËüÊDz»ÊDZØÐëµÄ¡£
´ó¼Ò»¹·¢ÏÖ CATALINA_HOME ºÍ TOMCAT_HOME µÄÖµÊÇÒ»ÑùµÄ£¬ÎÒ¹À¼Æ TOMCAT_HOME ÊÇ Tomcat µÄ¾É°æ±¾Ê¹Óõģ¬ÏÖÔÚÓõĶ¼ÊÇ CATALINA_HOME¡£²»¹ýÕâ2¸öºÃÏó²¢²»ÊDz»ÏàÈݵģ¬¶¼¼ÓÉÏ£¬»òÕß¼ÓÆäÖÐÈÎÒâÒ»¸ö£¬Jsp ¶¼²»ÊÖÓ°Ïì¡£²»¹ýÎÒ½¨ÒéÓÃÒ»¸ö CATALINA_HOME ¾ÍËãÁË¡£
Tomcat5.0 ÉèÖÃÐéÄâ·¾¶±È½Ï·½±ãÁË£¬ÒòΪ¿ÉÒÔÔÚ Web »·¾³Ï¹ÜÀí¡£http://[url]:8080/admin ¿ÉÒÔ½øÈë¹ÜÀí½çÃæ(¹ÜÀíÔ±adminÃÜÂëÔÚ Tomcat °²×°¹ý³ÌÖпÉÒÔÉèÖÃ)£¬ÔÚ Tomcat Server-Service (Catalina)-Host (localhost)Ï¿ÉÒÔÌí¼Ó Context£¬ÀàËÆÓÚ IIS
ÀïµÄÐéÄâ·¾¶£ºDocument Base Ö¸µÄÊÇ´Óʵ¼Ê E:\Tomcat 5.0\webapps\ROOT ΪÆðµãµÄÎļþ·¾¶£¬Path Ö¸µÄÊÇ´ÓÐéÄâ“/”¿ªÊ¼µÄÐéÄâ·¾¶Ãû£¬Èç“/mytest”¡£ÕâÀï Tomcat ºÃÏóÉè¼ÆµÄÓе㲻ÍêÉÆ£¬Ö»Òª¼ÓÁËÐ嵀 Context£¬±£´æ£¬ÔÙµã“Commit Changes”
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
×÷ÕߣºChris Schalk
ÇáËɹ¹½¨Ò»¸ö»ì´îÓ¦ÓóÌÐò£¬ÒÔʹÓà Oracle XML DB ½« Oracle Êý¾ÝÓë Google Maps API ¼¯³É¡£
2007 Äê 8 Ô·¢²¼
ÕýÈçÄúÖªµÀµÄÄÇÑù£¬Ðí¶àÄêÒÔÇ°£¬Oracle ¾ÍÄܹ»´ÓÊý¾Ý¿â¼´Ê±Éú³É XML¡£³ýÁË´Ó Oracle Êý¾Ý¿âÉú³É XML£¬»¹¿ÉÒÔʹÓöàÖÖÓïÑÔ£¨Èç Java Servlets ºÍ JDBC£©½«Éú³ÉµÄÊý¾Ý XML ·¢²¼µ½ Web¡£ ......
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......
·½·¨Ò»
µÚÒ»²½£ºµÇÈësql/plus Ö´ÐÐÃüÁÎÞÏȺó˳Ðò£©
set time on; (˵Ã÷£º´ò¿ªÊ±¼äÏÔʾ£©
set autotrace on; (˵Ã÷£º´ò¿ª×Ô¶¯·ÖÎöͳ¼Æ£¬²¢ÏÔʾSQLÓï¾äµÄÔËÐнá¹û£©
set autotrace traceonly; (˵à ......