ubuntu8.04.2ÏÂApache+Resin+Mysql°²×°+ÐéÄâÖ÷»úÅäÖÃ
Ò» Apache°²×°
# tar zxvf httpd-2.2.14.tar.gz(½âѹ)
# cd httpd-2.2.14(½øÈë½âѹºóµÄĿ¼)
# ./configure --prefix=/usr/local/apache2 --enable-so --enable-mods-shared=all
(ÃüÁî#./configure --help¿ÉÒԲ鿴configureµÄÅäÖòÎÊý
--prefix=°²×°Â·¾¶
--enable-so //´ò¿ª DSO Ö§³ÖµÄ apache ºËÐÄÄ£¿é
--enable-mods-shared=all //½«È«²¿µÄÄ£°å±àÒë³ÉDSO£¬¶ÔÓÚ²»ÐèÒªÎÒÃÇ¿ÉÒÔÔÚhttpd.confÈ¥µô
)
# make
# make install
configureʱ³öÏÖ±àÒë´íÎóÌáʾΪûC±àÒ빤¾ß£¬½â¾ö·½·¨£º
°²×°GCC
#sudo apt-get install build-essential
³öÏÖ¹ØÓÚzlibµÄ´íÎó£¬ÔÒòÊÇȱÉÙzlib
linuxϱàÒë°²×°zlib
zlib¹Ù·½ÍøÕ¾£º
http://www.zlib.net
ÉÏÏÂÔØÔ´ÂëÀ´°²×°zlibÈí¼þ°ü¡£
Ŀǰ×îа汾zlibÊÇzlib1.2.3£¬°²×°¿ªÊ¼£»
# wget http://www.zlib.net/zlib-1.2.3.tar.gz
# tar -xvzf zlib-1.2.3.tar.gz
# cd zlib-1.2.3.tar.gz
# ./configure
# make
# sudo make install
Æô¶¯Apache(rootÓû§²ÅÄÜ)
# /usr/local/apache2/bin/apachectl start
²é¿´±àÒë½øapacheµÄÄ£¿é
# /usr/local/apache2/bin/httpd -l
¿ª»úÆô¶¯Apache
# cp /usr/local/apache2/bin/apachectl /etc/init.d/apachectl
# sysvconfig(ÊÇͼÐνçÃæ£¬½«apachectlÑ¡ÖÐ)
=======================================================================================================================
¶þ Mysql°²×°
# tar zvxf mysql-5.1.39.tar.gz
# cd mysql-5.1.39
# ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_bin --with-extra-charsets=big5,ascii,gb2312,gbk,utf8,latin1
//ĬÈϵÄ×Ö·û¼¯È±Ê¡Îªlatin1¡£
//ÆäÖУ¬utf8¶ÔÓ¦¿ÉÓõÄcollationֵΪ£ºutf8_bin¡¢utf8_general_ci¡¢utf8_unicode_ci
//extraÖ§³ÖÒ²¿ÉÒÔʹÓà "--with-extra-charsets=all"¡£
//ĬÈÏconfigure²ÎÊýϲ»»á°²×°gbk±àÂë
ÅäÖóɹ¦»áÌáʾ£º
MySQL has a Web site at [URL="http://www.mysql.com/"][COLOR=#000000]http://www.mysql.com/[/COLOR][/URL] whic
Ïà¹ØÎĵµ£º
×î½üµÄÒ»¸öÏîÄ¿ÔÚʹÓÃC3P0µÄÁ¬½Ó³Ø£¬Êý¾Ý¿âΪMysql¡£¿ª·¢²âÊÔûÓÐÎÊÌ⣬ÔÚÔËÐÐÖÐÿ¸öÒ»¶Î³¤µÄ¿ÕÏÐʱ¼ä¾Í³öÏÖÒì³£Communications link failure due to underlying exception:
java ´úÂë
²é¿´ÁËMysqlµÄÎĵµ£¬ÒÔ¼°Connector/JµÄÎĵµÒÔ¼°ÔÚÏß˵Ã÷·¢ÏÖ£¬³öÏÖÕâÖÖÒì³£µÄÔÒòÊÇ£º
Mysql·þÎñÆ÷ĬÈϵēwait_timeout&rdquo ......
ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØÒ»Ð©ÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£±¾ÈËÒÔÇ°Ò²ÔøÓöµ½¹ýÀàËÆÎÊÌ⣬¾ÏêϸÔĶÁMySQLµÄManual£¬·¢ÏÖ¿ÉÒÔÓÐÒ»ÖÖ·½·¨ºÜ·½±ãµÄ½â¾ö²¢µÃµ½ÂúÒâµÄ½á¹û¡£
¡¡¡¡Àý×Ó£º
¡¡¡¡Ï£Íûͨ¹ý“±êÌâ”¶ÔÐÂÎÅ¿â½øÐмìË÷£¬¹Ø¼ü×Ö¿ÉÄܰüº¬Ê ......
֮ǰ£¬ÓÉÓÚ¿Í»§ÒªÇóÔÚcentOSϰ²×°ÏµÍ³Ó¦Óã¬Òò´ËÓлú»á½Ó´¥ÁËÒ»ÏÂCentOS£¬Ë³±ãÒ²Á˽âÁËÏÂCentOSµÄ³£¹æ²Ù×÷£¬»¹ÓÐÔÚCentOSϵÄMySQLÏà¹Ø²Ù×÷¡£
Ŀǰ¼¼Êõ¿ò¼ÜʹÓÃJSF£¨richfaces¡¢facelets£©+Spring+JPA£¨OpenJPA£©£¬²»Ê¹ÓÃÊý¾Ý¿âÒÀÀµµÄ´¥·¢Æ÷»ò´æ´¢¹ý³Ì£¬ËùÓÐÒµÎñÂß¼ÔÚweb·þÎñÆ÷ÉÏÖ´ÐУ¬Òò´ËÊý¾Ý¿â»ù±¾²»Óÿ¼ÂÇÒÆ ......
inner joins 內Á¬½Ó½öÑ¡³öÁ½ÕűíÖл¥ÏàÆ¥ÅäµÄ¼Ç¼£®Òò´Ë£¬Õâ»áµ¼ÖÂÓÐʱÎÒÃÇÐèÒªµÄ¼Ç¼ûÓаüº¬½øÀ´¡£
Ϊ¸üºÃµÄÀí½âÕâ¸ö¸ÅÄÎÒÃǽéÉÜÁ½¸ö±í×÷ÑÝʾ¡£ËÕ¸ñÀ¼Òé»áÖеÄÕþµ³±í(party)ºÍÒéÔ±±í(msp)¡£
party(Co
de,Name,Leader)
Code: Õþµ³´úÂë
Name: Õþµ³Ãû³Æ
Leader: Õþµ³ÁìÐä
msp(Name,Party,Constituency ......