jboss+mysqlÅäÖÃÊÖ²á
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíƽ̨ϵͳ£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âʹÓÃMySQL
2.ÔËÐл·¾³¼°°²×°ËµÃ÷
2.1Ó²¼þ˵Ã÷ËùÐèÓ²¼þÉ豸Áбí
Ó²Å̿ռ䣺80GB
CPU£ºË«ÖÁÇ¿2GHZ
RAM£º2GB
2.2 Èí¼þϵͳ˵Ã÷
²Ù×÷ϵͳ£º °æ±¾
redhat AS4
JAVA£¨J2SDK£© °æ±¾
SUN J2SDK For Linux 1.4.2_06
Ó¦Ó÷þÎñÆ÷ °æ±¾
jboss Application Server 4.0.1
Êý¾Ý¿â·þÎñÆ÷ °æ±¾
MySQL 5.0.21
¿Í»§¶Ëä¯ÀÀÆ÷ °æ±¾
Internet Explorer 5.0(°æ±¾£º5.00.3700.1000)»òÒÔÉÏ
2.3 Linux»·¾³°²×°²½Öè˵Ã÷
·ÖÇø &nb
Ïà¹ØÎĵµ£º
ÓÅ»¯mysqlÊ×ÏÈÓ¦¸Ã¶àÓÃexplain select ,show variables, show status ,show processlistÕâЩ¹¤¾ß¡£
ÔÚдsqlµÄʱºò£¬ÔÚ´ó±íÉϲ»×ögroup by ²Ù×÷¡£
¶ÔÓÚË÷Òý£º
1.²»ÒªË÷ÒýÄã²»ÏëÒªµÄ¶«Î÷¡£
2.mysqlÄÜʹÓÃË÷ÒýµÄÇé¿ö£º> ,>=, =, <,<= ,if null ÒÔ¼°between
3.mysql²»Ê¹ÓÃË÷ÒýµÄÇé¿ö£ºÈç¹ûmysqlÄܹÀ¼Æ³ö ......
Èç¹ûÖ»ÊÇÒ»¸öÊý¾Ý¿âµÄ»°£¬ÎÒÃÇÒ»°ãÏ°¹ßÕâÑùд£ºmysql_select_db("guestbook")£»
mysql_query('select * from users');
µ«ÊÇÈç¹ûÊÇÁ¬½Ó¶à¸ömysql£¬ÓпÉÄܳöÏÖͬÃûµÄÊý¾Ý¿â£¬»òÕßÊý¾Ý¿âÖгöÏÖͬÃûµÄ±í£¬ËùÒԾͱØÐëÓÃÍêÕûµÄÐÎʽÁË£¬ÈçÏ´úÂ룺
<?php
$link1 = mysql_connect('localhost1','root','root');
mysql ......
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£ ......
ÔÚwindowsÏ£º
´ò¿ªÃüÁîÐд°¿Ú£¬Í£Ö¹mysql·þÎñ£º Net stop mysql
Æô¶¯mysql£¬Ò»°ãµ½mysqlµÄ°²×°Â·¾¶£¬ÕÒµ½ mysqld-nt.exe
Ö´ÐУºmysqld-nt --skip-grant-tables µ±Ç°´°¿Ú½«»áÍ£Ö¹¡£
ÁíÍâ´ò¿ªÒ»¸öÃüÁîÐд°¿Ú£¬Ö´ÐÐmysql Èç¹ûÌáʾûÓÐÕâ¸öÃüÁÏȽøÈëMYSQL ......