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
Ïà¹ØÎĵµ£º
MySQL´´½¨¹ØÁª±í¿ÉÒÔÀí½âΪÊÇÁ½¸ö±íÖ®¼äÓиöÍâ¼ü¹Øϵ£¬µ«ÕâÁ½¸ö±í±ØÐëÂú×ãÈý¸öÌõ¼þ
1.Á½¸ö±í±ØÐëÊÇInnoDBÊý¾ÝÒý ......
MySQLÂý²éѯ¼Ç¼ÈÕÖ¾¶ÔÓÚ¸ú×ÙMySQL¸ºÔص÷ÓÅÎÊÌâºÜÓÐÓô¦£¬ÆäʵÆôÓÃMySQLµÄÂý²éѯÈÕÖ¾ºÜ¼òµ¥,Ö»ÐèÒªÔÚMySQLµÄÅäÖÃÎļþÀïÌí¼Ólog-slow-queriesºÍlong_query_timeÁ½¸ö²ÎÊý¼´¿É¡£
WindowsÏ¿ªÆôMySQLÂý²éѯ
MySQLÔÚWindowsϵͳÖеÄÅäÖÃÎļþÒ»°ãÊÇÊÇmy.iniÕÒµ½[mysqld]ÏÂÃæ¼ÓÉÏ
log-slow-queries = F:\MySQL\log\mysqls ......
Weblogic 9.1µÄdomainÅäÖÃmysqlÁ¬½Ó³Ø
¡¡¡¡±¾ÎĽéÉÜÔÚweblogic 9.1ϵÄdomainÅäÖÃmysqlÁ¬½Ó³Ø²½Ö裺
¡¡¡¡1.ÔÚweblogicĿ¼ÏµÄserverlibÏÂÌí¼ÓmysqlÇý¶¯
¡¡¡¡mysql-connector-java-3.1.11-bin.jar
¡¡¡¡2.ÔÚweblogicĿ¼ÏµÄcommoninÏÂÕÒµ½commEnv.cmd´ò¿ª
¡¡¡¡ÕÒµ½set weblogic_classpath= ºó±ß¼ÓÉÏmysqlÇý¶¯ ......
1¡¢mysql_connect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó {3RY4HVT?
¸ñʽ£º Fv n:V\eb
resource mysql_connect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]]) _I;+p eq
Àý£º 1(V>8}zn
$conn = @mysql_connect("localhost", "username", "password") or dir(" ......
µÚÒ»¡¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þ¡¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µÚÈý¡ ......