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µÄmysqldump¹¤¾ßµ¼Èëµ¼³öÊý¾Ý¿â£¡
1.µ¼³öÕû¸öÊý¾Ý¿â(DosÏÂ)
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc > chai.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc users>c ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
»ù±¾²éѯ
SELECTÓï¾äÓÃÓÚ²éѯÊý¾Ý¿âºÍSQLÖеÄËùÓÐÊä³ö²Ù×÷¡£
SELECTc_u_name, emailfromcooya_users;
Êä³öcooya_users±íÖÐËùÓÐÐУ¨»ò¼Ç¼£©µÄÊôÐÔc_u_nameºÍemailµÄÖµ¡£
Èç¹ûÐèÒªËùÓÐÊôÐÔ£¬¿ÉÒÔʹÓÃÐǺţ¨*£©µÄ¿ì½Ý·½Ê½¡£
SELECT* from cooya_users;
SELECTÓï¾ä»¹¿ÉÒÔÊä³ö²»ÊÇÊý¾Ý¿âÖеÄÊý¾Ý¼°¿ÉÒÔÓÃ×÷¼òµ¥µÄ¼ÆËã·û ......
Ê×ÏÈÉèÖÃmysqlµÄ±àÂëΪutf8
ÔÚlinuxÏÂÐ޸ģ³¸ömy.cnfµÄ£±¸ö/etc/mysql
/my.cnfÎļþ
ÕÒµ½¿Í»§¶ËÅäÖÃ[client] ÔÚÏÂÃæÌí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
ÔÚÕÒµ½[mysqld] Ìí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
init_connect='SET NAMES utf8' £¨É趨Á¬½Ómysql
Êý¾Ý¿âʱʹÓÃutf8±àÂ룬ÒÔÈà ......
ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true" debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name=" ......