Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

tomcat+jdk+mysqlÃâ°²×°µÄÕûºÏÐÎʽ

tomcat+jdk+mysqlÃâ°²×°µÄÕûºÏÐÎʽ
 
Ò»£º tomcat+jdk Ãâ°²×°
ºÜ¾ÃÒÔǰ¾Í¿ªÊ¼Óà tomcat µÄÃâ°²×°°æ(zip ½âѹ°æ)¡£Ö±½ÓÔËÐÐ bin/startup.bat µÄ·½Ê½ÔËÐУ¬ÓÐÒ»¸ö²»ºÃµÄµØ·½¾ÍÊÇ×¢ÏúµÇ¼Óû§³ÌÐò¾ÍÍ˳öÁË¡£±ÈÈç windows 2003 server °æÖÐÔËÐÐ tomcat ÒÔÌṩ¶ÔÍâ·þÎñ£¬ºÜ¿ÉÄܹÜÀíÔ±Æô¶¯ÁË tomcat ºó¾ÍÍ˳ö windows 2003 server¡£ÕâÑù tomcat Ò²ËæÖ®Í˳ö. ÒÔ windows ·þÎñµÄ·½Ê½ÔËÐоͲ»»á£¬Ò²¿É·½±ãµØÉèÖÿª»úÔËÐÐ.
 
Ãâ°²×°µÄjdk + tomcat·¢²¼Ó¦ÓóÌÐò²½Öè
Ò»¡¢¿½±´Ò»¸ö°²×°ºóµÄjdk .È磺jdk1.6.0_10(¿½±´bin, include, lib,jreËĸöÎļþ¼Ð,
       ÍøÉÏÒ²ÓÐÈËûÓмÓjreÎļþ¼Ð,·´Õý¶¼¿ÉÒÔÊÔÒ»ÊÔ)
¶þ¡¢¿½±´Ò»¸öÂÌÉ«Ãâ°²×°µÄtomcat .È磺apache-tomcat-6.0.18
Èý¡¢°Ñjdk·Åµ½tomcatÏÂÃæ£¬È磺apache-tomcat-6.0.18 \ jdk1.6.0_10
ËÄ¡¢ÐÞ¸ÄÏà¹ØµÄbatÎļþ(ÎÒÕâÀïÓÃÁ½ÖÖ·½Ê½À´Æô¶¯: startup.bat·½Ê½ºÍ·þÎñ·½Ê½)
       ·½Ê½¢Ù£ºstartup.bat·½Ê½À´Æô¶¯tomcat
Ö»ÒªÐÞ¸Äapache-tomcat-6.0.18 \bin\startup.bat ¼´¿É£¬ÐÞ¸ÄÄÚÈÝÈçÏÂ:
ÔÚset CURRENT_DIR=%cd%
if not "%CATALINA_HOME%" == "" goto gotHome
Ö®¼ä(Èç¹ûûÓиıä¹ýÎļþ,Ó¦¸ÃÊÇÔÚ25ÐкÍ26ÐÐÖ®¼ä) ¼ÓÈëÏÂÃæÄÚÈÝ:
set JAVA_HOME=%CURRENT_DIR%\jdk1.6.0_10
if exist "%JAVA_HOME%" goto gogoTomcat
cd ..
set JAVA_HOME=%cd%\jdk1.6.0_10
cd %CURRENT_DIR%
:gogoTomcat
 
·½Ê½¢Ú£ºÓ÷þÎñµÄ·½Ê½À´Æô¶¯tomcat
1¡¢  ÐÞ¸ÄÅäÖÃÎļþ,°²×°tomcat·þÎñ
       ÕâÀïʾÀýһϰ²×°£¬cd ÔÚ tomcat_home£¬È磺N:/apache-tomcat-6.0.18
1.        N:\apache-tomcat-6.0.18>bin\service.bat install mytomcat   
2.        Installing the service 'mytomcat' ...   
3.        Using CATALINA_HOME: N:\apache-tomcat-6.0.18   
4.        Using CATALINA_BASE: N:\apache-tomcat-6.0.18   
5.        Using JAVA_HOME:     N:\apache-tomcat-6.0.18\jdk1.6.


Ïà¹ØÎĵµ£º

MySql±Ê¼Ç02

Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
¡¡¡ ......

Mysql´æ´¢¹ý³Ì£¨Î壩——SEQUENCEµÄʵÏÖ

ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......

mysql³£ÓÃÖ¸ÁºÏ


Java´úÂë
mysql> select version(),current_date;   
²éѯmysqlµÄ°æ±¾ºÅ ºÍ  ÈÕÆÚ   
mysql> select version();   
²éѯmysqlµÄ°æ±¾ºÅ   
select now();   
²éѯµ±Ç°ÈÕÆÚºÍ׼ȷµÄʱ¼ä  
Java ......

MysqlÈÎÎñµ÷¶È£¨Event£©

<!-- [if gte mso 10]>
MySQL5.1.x
°æ±¾ÖÐÒýÈëÁËÒ»ÏîÐÂÌØÐÔ
EVENT
£¬¹ËÃû˼Òå¾ÍÊÇʼþ¡¢¶¨Ê±ÈÎÎñ»úÖÆ£¬ÔÚÖ¸¶¨µÄʱ¼äµ¥ÔªÄÚÖ´ÐÐÌØ¶¨µÄÈÎÎñ£¬Òò´Ë½ñºóһЩ¶ÔÊý¾Ý¶¨Ê±ÐÔ²Ù×÷²»ÔÙÒÀÀµÍⲿ³ÌÐò£¬¶øÖ±½ÓʹÓÃÊý¾Ý¿â±¾ÉíÌṩµÄ¹¦ÄÜ¡£´Ë¹¦ÄÜÊǶÔ
Oracle
µÄ
Job/Schedule
µÄÄ£·Â£¬
5.1.X
°æ±¾ÒÔÉϲÅÖ§³Ö¡£
 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ