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

TomCat6.0Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃʵÀý(mysqlÊý¾Ý¿â)

TomCat6.0Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃʵÀý(mysqlÊý¾Ý¿â)
TomCat6.0Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃÓм¸ÖÖ·½Ê½£¬ÔÚÕâÀïÎÒÖ»½éÉÜÆäÖеÄÒ»ÖÖ¹©´ó¼Ò²Î¿¼£º
ÏÂÃæÎÒ°ÑÅäÖùý³Ì·Ö³ÉÈý¸ö²½ÖèÀ´Íê³É£º
µÚÒ»²½£ºÔÚÄã°²×°TomCatµÄĿ¼ÏÂÕÒµ½context.xmlÅäÖÃÎļþ¡££¨ÀýÈ磺D:\Tomcat 6.0\conf\context.xml£©È»ºó´ò¿ªcontext.xml£¬ÔÚ±êÇ©<context></<context>Ö®¼ä¼ÓÈëÒÔÏÂÄÚÈÝ£º(ΪÁË´ó¼ÒÈÝÒ×Àí½â£¬ÎÒ¼ÓÁ˽ÏÏêϸµÄ×¢ÊÍ)
<Resource
name="jdbc/course" //Êý¾ÝÔ´Ãû³Æ£¨×Ô¶¨Ò壩µ½Ê±ºòÒªÓõ½µÄ£¬ËùÒÔ×îºÃÆð
//¸öÓк¬ÒåµÄÃû×Ö£¬ÀýÈçÎÒÕâ¸öÊý¾ÝÔ´Ãû×Ö£¬jdbc±íʾÓë//Êý¾Ý¿âÁ¬½ÓÓйص쬶øcourseÊÇÎÒÕâ¸öÏîÄ¿µÄÃû×Ö¡£
auth="Container" //Õâ¸öĬÈϾͺÃÁË
type="javax.sql.DataSource" //Õâ¸öҲĬÈϾͺÃÁË
              driverClassName="com.mysql.jdbc.Driver"//ÕâÀïÓõ½µÄÊÇmysqlÊý¾Ý¿âµÄÇý¶¯°ü¡£
              url="jdbc:mysql://localhost/course" //ÕâÀïÊÇÁ¬½Óµ½mysqlÊý¾Ý¿âµÄurl£¬ÆäÖÐurl="jdbc:mysql://localhost/"Êǹ̶¨µÄ£¬¶øcourseÊÇÎÒÕâ¸ö //ÏîÄ¿µÄÊý¾Ý¿âÃû³Æ£¬ËùÒÔÕâÀï¸ÄΪÄãÃǵÄÊý¾Ý¿âÃû³Æ¾ÍºÃÁË¡£
              username="root"//µÇ½Êý¾Ý¿âµÄÓû§Ãû 
     password="admin" //µÇ½Êý¾Ý¿âµÄÃÜÂë
     maxIdle="5"//Õâ¸öҲĬÈϾͺÃÁË
              maxWait="5000"//Õâ¸öҲĬÈϾͺÃÁË
              maxActive="10"/>//Õâ¸öҲĬÈϾͺÃÁË
µÚ¶þ²½£ºÔÚÄãµÄÏîÄ¿WEB-INFĿ¼ÏÂÕÒµ½web.xmlÅäÖÃÎļþ£¬È»ºó´ò¿ª£¬ÔÚ±êÇ©<web-app></web-app>Ö®¼ä¼ÓÈëÒÔÏÂÄÚÈÝ£º
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/course</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
ÆäÖУºDB Connection ÊÇ×Ô¶¨ÒåµÄ£¬¶øjdbc/courseÊǶÔÓ¦ÉÏÃæ<Resource></Re


Ïà¹ØÎĵµ£º

linuxÏÂÆô¶¯mysqlµÄÃüÁî

 
Ò»¡¢×ܽáһϣº
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
   mysqladmin start
/ect/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
   mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
   mysqladmin shut ......

mysqlÃüÁî´óÈ«

Æô¶¯£ºnet start mySql;
¡¡¡¡½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
¡¡¡¡ÁгöÊý¾Ý¿â£ºshow databases;
¡¡¡¡Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
¡¡¡¡Áгö±í¸ñ£ºshow tables£»
¡¡¡¡ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
¡¡¡¡½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
¡¡¡¡Æ¥Åä× ......

Mysql Âý²éѯÆôÓÃ

 MySQLÂý²éѯ¼Ç¼ÈÕÖ¾¶ÔÓÚ¸ú×ÙMySQL¸ºÔص÷ÓÅÎÊÌâºÜÓÐÓô¦£¬ÆäʵÆôÓÃMySQLµÄÂý²éѯÈÕÖ¾ºÜ¼òµ¥,Ö»ÐèÒªÔÚMySQLµÄÅäÖÃÎļþÀïÌí¼Ólog-slow-queriesºÍlong_query_timeÁ½¸ö²ÎÊý¼´¿É¡£
WindowsÏ¿ªÆôMySQLÂý²éѯ
MySQLÔÚWindowsϵͳÖеÄÅäÖÃÎļþÒ»°ãÊÇÊÇmy.iniÕÒµ½[mysqld]ÏÂÃæ¼ÓÉÏ
log-slow-queries = F:\MySQL\log\mysqls ......

MySQLµÄMyISAMºÍInnoDB¶Ô±È¼°ÓÅ»¯

±¾ÎÄ×ªÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html 
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......

ÁªÏëR520 °²×° AS4.4 +apache+mysql+php

 Õ⼸Ìì°²×°ÁËһ̨linux·þÎñÆ÷¡£±¾À´Ò»Î»Í¦¼òµ¥¸öÊ£¬Ã»Ïëµ½ÕÛÌÚÁ˺ü¸Ìì¡£
Ê×ÏÈÊÇ °²×° AS4.4
·þÎñÆ÷ÊÇÁªÏë R520 G6£¬±¾ÒÔΪŪ¸öаæµÄunbuntu¾ÍÄÜÇý¶¯ÆðÀ´£¬Ã»Ïëµ½ÉÏÀ´¾ÍÓöµ½ÁËÂé·³¡£Ð°æµÄlinux»¹ÊÇû°ì·¨Çý¶¯ÆðÀ´£¬ÁªÏëËæ»ú¸øµÄÇý¶¯×î¸ß¾Íµ½AS4.4£¬Ã»°ì·¨Ö»ºÃÕÒÕÒAS4.4 °²×°ÁË¡£
Ê×ÏȹâÅÌÆô¶¯ ÊäÈë linux dd&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ