MySQL·À×¢Èë
·ÀÖ¹×¢ÈëµÄ¼¸ÖÖ°ì·¨
ÆäʵÔÀ´¾ÍÊÇÎÒÃÇÐèÒª¹ýÂËһЩÎÒÃdz£¼ûµÄ¹Ø¼ü×ֺͷûºÏÈ磺
Select£¬insert£¬update£¬delete£¬and£¬*£¬µÈµÈ
function inject_check($sql_str) {
return eregi('select|insert|update|delete|\'|\/\*|\*|\.\.\/|\.\/|union|into|load_file
|outfile', $sql_str);
}
»òÕßÊÇͨ¹ýϵͳº¯Êý¼äµÄ¹ýÂËÌØÊâ·ûºÅ
Addslashes£¨ÐèÒª±»¹ýÂ˵ÄÄÚÈÝ£©
Ïà¹ØÎĵµ£º
ʹÓÃÁÙʱ±íµÄºÃ´¦£º
ʹÓÃÁÙʱ±í´æ·ÅÖмä½á¹û,¼ÓËÙ²éѯ£¬»ò´æ·ÅÁÙʱ½á¹û.
(1)
´´½¨ÁÙʱ±íºÜÈÝÒ×£¬¸øÕý³£µÄCREATE TABLEÓï¾ä¼ÓÉÏTEMPORARY¹Ø¼ü×Ö£º
CREATE TEMPORARY TABLE tmp_table (
name VARCHAR(10) NOT NULL,
value INTEGER NOT NULL
)
(2)
ÁÙʱ±í½«ÔÚÄãÁ¬½ÓMySQLÆÚ¼ä´æÔÚ¡£µ±Äã¶Ï¿ªÊ±£¬MySQL ......
¶¨ÆÚά»¤ÄãµÄÊý¾Ý±í¡£
¹¤¾ß£ºmysqlcheck myisamchk
mysqlcheck¿Í»§¶Ë¿ÉÒÔ¼ì²éºÍÐÞ¸´MyISAM±í¡£Ëü»¹¿ÉÒÔÓÅ»¯ºÍ·ÖÎö±í¡£
mysqlcheckµÄ¹¦ÄÜÀàËÆmyisamchk£¬µ«Æ乤×÷²»Í¬¡£
Ö÷Òª²î±ðÊǵ±mysqld·þÎñÆ÷ÔÚÔËÐÐʱ±ØÐëʹÓÃmysqlcheck£¬¶ømyisamch ......
ÔÚÏò´ó¼ÒÏêϸ½éÉÜLinux mysql֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂLinux mysql£¬È»ºóÈ«Ãæ½éÉÜLinux mysql£¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£
1. Linux mysql°²×°£º
$ yum install mysql-server
2. Linux mysqlÐÞ¸ÄrootÃÜÂ룺
$ mysqladmin -u root password
your_new_passwd
3. Æô¶¯Linux mysql·þÎñ
$ /etc/init.d/mysqld start
4. Ìí¼ÓΪϵͳ· ......
1¡¢½¨Á¢ÁËÒ»¸öj2eeÏîÄ¿¡£
2¡¢½«mysqlµÄjdbcÇý¶¯¿½±´µ½WebContent / WEB-INF/ lib Ŀ¼Ï¡£
3¡¢ÔÚÇý¶¯jar°üÉϵãÓÒ¼ü½«jar°üÌí¼Óµ½¹¹½¨Â·¾¶ÖС£
4¡¢È»ºó±àдÓëÊý¾Ý¿âÏà¹ØµÄ´úÂë¡£
5¡¢ÔÚʵÏÖÀàÖÐÌí¼Ómain·½·¨½øÐе¥Ôª²âÊÔ£¬¸÷¸ö·½·¨¶¼ÄÜÕý³£ÔËÐС£
6¡¢´´½¨jspÒ³ÃæÔÚÆäÖд´½¨¶ÔÏóµ÷Óòéѯ·½·¨¡£²úÉú´íÎó¡£
cn.guopeng.bbs ......
×î½üµÄÏîÄ¿ÖÐʹÓÃÁËMySQLÊý¾Ý¿â£¬Ò»Ð©MySQLµÄÐÂÓû§ÔÚÅäÖÃʹÓÃʱ»¹ÓÐЩ²»¹»ÊìÁ·£¬ÌØÔڴ˼Ǽ£¬·½±ã¿ª·¢ÍŶÓʹÓ㬸ÃÎÄÕÂËùÉæ¼°ÄÚÈݾù¿ÉÒÔÔÚMySQL²Î¿¼ÊÖ²áµÚ¶þÕ“°²×°MySQL”ÖÐÕÒµ½¡£MySQL°²×°ºó×Ô´øÁËÓ¢ÎIJο¼ÊֲᣬҲ¿ÉÒÔÔÚhttp://dev.mysql.com/doc/refman/5.1/zh/index.html²é¿´ÖÐÎÄ°æ±¾£ ......