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

Linux + Apache2.0 + Mysql + PHP + phpBB3.0

 Linux + Apache2.0 + Mysql + PHP + phpBB3.0
 1.°²°ü£º
   Apache2.0
         #tar -zxf httpd-***.tar.gz -C /usr/local/src/
         #cd /usr/local/src/httpd-***
         #./configure --prefix=/usr/local/apache2 --enable-so --enable-rewrite
         #make
         #make install
   Mysql
        #groupadd -g 200 mysql
        #useradd -u 200 -g mysql -d /usr/local/mysql/data -M mysql
        #tar -zxf mysql-***.tar.gz -C /usr/local/
        #cd /usr/local
        #ln -s mysql-***/ mysql
        #mkdir /var/lib/mysql
        #chown -R mysql:mysql /var/lib/mysql
        #chown -R root:mysql /usr/local/mysql-***
        #chown -R mysql:mysql /usr/local/mysql/data
        #cd /usr/local/mysql
        #cp support-files/my-medium.cnf /etc/my.cnf
        #./scripts/mysql_install_db
        #chown -R mysql:mysql /var/lib/mysql
        #chown -R mysql:mysql /usr/local/mysql/data
        #/usr/local/mysql/bin/safe_mysqld --user=mysql &
        #/usr/local/mysql/bin/mysqladmin -u root password 'myrootpw'
        #/usr/local/mysql/bin/mysql -u root -p
        Enter password: myrootpw
   &nb


Ïà¹ØÎĵµ£º

MYSQL ¶à¹Ø¼ü×ÖÏà¹ØÎÄÕ²éѯ·½·¨

È¡µÃÎÄÕ¹ؼü×ÖΪkeywords
±ínewsµÄ¹Ø¼ü×Ö×Ö¶ÎΪkeyword
keywords=keywords.replace(',','|');
  String sql="SELECT * from news WHERE keyword REGEXP '"+keywords+"' ORDER BY id ";
ÓÉÓÚijЩԭÒò£¬ÓÐʱºòÎÒÃÇûÓа´ÕÕ·¶Ê½µÄÉè¼Æ×¼Ôò¶ø°ÑһЩÊôÐԷŵ½Í¬Ò»¸ö×Ö·û´®×Ö¶ÎÖС£±ÈÈç¸öÈËÐËȤ£¬ÓÐʱºòÎÒÃÇÉè¼Æ±íΪ
cr ......

Mysql whileÑ­»·Óï¾äÉú³É²âÊÔÊý¾Ý

ʹÓÃwhileÑ­»·Óï¾äÉú³É²âÊÔÊý¾Ý£º
ÏÂÃæµÄ·½·¨ÊÇͨ¹ý´´½¨Ò»¸ö´æ´¢¹ý³Ì£¬È»ºóÔÙµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÀ´ÊµÏֵ쬴ÓÍøÉÏÕÒÁ˺ܶ෽·¨£¬µ«¶¼Ã»Óгɹ¦¡£
delimiter // /*¶¨ÒåÃüÁî½áÊø·ûĬÈÏΪ ; */
create procedure genUsers()
begin
declare i int default 0;
while i < 40 do
insert into users(userID,userName, ......

mysql jdbcÇý¶¯ÎÊÌâ

1¡¢½¨Á¢ÁËÒ»¸öj2eeÏîÄ¿¡£
2¡¢½«mysqlµÄjdbcÇý¶¯¿½±´µ½WebContent / WEB-INF/ lib Ŀ¼Ï¡£
3¡¢ÔÚÇý¶¯jar°üÉϵãÓÒ¼ü½«jar°üÌí¼Óµ½¹¹½¨Â·¾¶ÖС£
4¡¢È»ºó±àдÓëÊý¾Ý¿âÏà¹ØµÄ´úÂë¡£
5¡¢ÔÚʵÏÖÀàÖÐÌí¼Ómain·½·¨½øÐе¥Ôª²âÊÔ£¬¸÷¸ö·½·¨¶¼ÄÜÕý³£ÔËÐС£
6¡¢´´½¨jspÒ³ÃæÔÚÆäÖд´½¨¶ÔÏóµ÷Óòéѯ·½·¨¡£²úÉú´íÎó¡£
cn.guopeng.bbs ......

linux ÄÚºË2.4.26 Éý¼¶ºó Æô¶¯Ê§°Ü

ÎÒÏëÔÚredhatÏÂʹÓÃÉãÏñÍ·  µ«ÊÇÏÖÓа汾²»Ö§³Ö ËùÒÔÎÒÏëÉý¼¶ÄÚºË ÕâÑù¿ÉÄÜ»áÖ§³ÖÉãÏñÍ·
ÓÚÊÇÎÒ´ÓÍøÉÏÏÂÔØÁË 2.4.26°æ±¾µÄÄÚºË Í¨¹ýÍøÉϽéÉܵÄÄÇЩ·½·¨ Éý¼¶ÄÚºË Éý¼¶ºóÖØÆôµçÄÔ ½øÈëÐÂÄÚºËʱ Óöµ½ÏÂÃæµÄÎÊÌâ
VFS:Cannot open root device "sda2" or 08:01
Please append a correct "root=" boot option
kernel pa ......

ʹÓÃBusyBoxÖÆ×÷linux¸ùÎļþϵͳ


ʹÓÃBusyBoxÖÆ×÷linux¸ùÎļþϵͳ£¨CramFS+mdev£©
²Ù×÷ϵͳ£ºUbuntu9.04
Äں˰汾£ºlinux-2.6.24.7  
¿ª·¢°å£º²©´´arm2410s    
½»²æ±àÒ빤¾ß£ºarm-linux-gcc-4.1.1 
BusyBox£ºbusybox-1.11.1      
CramFS£ºCramFS-1.1
 
×¢Ò⣺ÓÉÓÚÒªÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ