jspÈçºÎ·À·¶sql×¢Èë¹¥»÷
ÉÏÖܸø±ðÈË×öÁ˸öÍøÕ¾£¬ÎÞÒâ¼ä·¢ÏÖ×Ô¼ºµÄ×÷Æ·Óкܶà©¶´£¬Ôڶ̶̵Ä20Ãë¾Í±»×Ô¼ºÓÃsql×¢Èë·¨¸ø¸ÉÁË¡£ËùÒÔ²éÁËÒ»µã¹ØÓÚsql×¢ÈëµÄ×ÊÁÏ£¬²¢ÇÒÓеã¸ÐÎò£¬Ï£ÍûÄÜÓëÐÂÊÖÃÇ·ÖÏíһϡ£¸ßÊÖÃǼûЦÁË£¡
sql×¢Èë¹¥»÷µÄ×ÜÌå˼·£º
·¢ÏÖsql×¢ÈëλÖã»
ÅжϷþÎñÆ÷ÀàÐͺͺǫ́Êý¾Ý¿âÀàÐÍ£»
È·¶¨¿ÉÖ´ÐÐÇé¿ö
¶ÔÓÚÓÐЩ¹¥»÷Õß¶øÑÔ£¬Ò»°ã»á²ÉÈ¡sql×¢Èë·¨¡£ÏÂÃæÎÒҲ̸һÏÂ×Ô¼º¹ØÓÚsql×¢Èë·¨µÄ¸ÐÎò¡£
×¢Èë·¨£º
´ÓÀíÂÛÉÏ˵£¬ÈÏÖ¤ÍøÒ³ÖлáÓÐÐÍÈ磺
select from admin where username=' xxx' and password=' yyy' µÄÓï¾ä£¬ÈôÔÚÕýʽÔËÐд˾ä֮ǰ£¬Èç¹ûûÓнøÐбØÒªµÄ×Ö·û¹ýÂË£¬ÔòºÜÈÝÒ×ʵʩsql×¢Èë¡£
ÈçÔÚÓû§ÃûÎı¾¿òÄÚÊäÈ룺abc’ or 1=1-- ÔÚÃÜÂë¿òÄÚÊäÈ룺123 ÔòsqlÓï¾ä±ä³É£º
select from admin where username=' abc’ or 1=1 and password=' 123’ ²»¹ÜÓû§ÊäÈëÈκÎÓû§ÃûÓëÃÜÂ룬´ËÓï¾äÓÀÔ¶¶¼ÄÜÕýÈ·Ö´ÐУ¬Óû§ÇáÒׯ¹ýϵͳ£¬»ñÈ¡ºÏ·¨Éí·Ý¡£
²Â½â·¨£º
»ù±¾Ë¼Â·ÊÇ£º²Â½âËùÓÐÊý¾Ý¿âÃû³Æ£¬²Â³ö¿âÖеÄÿÕűíÃû£¬·ÖÎö¿ÉÄÜÊÇ´æ·ÅÓû§ÃûÓëÃÜÂëµÄ±íÃû£¬²Â³ö±íÖеÄÿ¸ö×Ö¶ÎÃû£¬²Â³ö±íÖеÄÿÌõ¼Ç¼ÄÚÈÝ¡£
»¹ÓÐÒ»ÖÖ·½Ê½¿ÉÒÔ»ñµÃÄãµÄÊý¾Ý¿âÃûºÍÿÕűíµÄÃû¡£
¾ÍÊÇͨ¹ýÔÚÐÎÈ磺http://www. .cn/news?id=10' µÄ·½Ê½À´Í¨¹ý±¨´í»ñµÃÄãµÄÊý¾Ý¿âÃûºÍ±íÃû£¡
¶ÔÓÚjsp¶øÑÔÎÒÃÇÒ»°ã²ÉȡһϲßÂÔÀ´Ó¦¶Ô£º
1¡¢preparedstatement
Èç¹ûÄãÒѾÊÇÉÔÓÐˮƽ¿ª·¢Õß Äã¾ÍÓ¦¸ÃʼÖÕÒÔpreparedstatement´úÌæstatement.
ÒÔÏÂÊǼ¸µãÔÒò
1¡¢´úÂëµÄ¿É¶ÁÐԺͿÉά»¤ÐÔ.
2¡¢preparedstatement¾¡×î´ó¿ÉÄÜÌá¸ßÐÔÄÜ.
3¡¢×îÖØÒªµÄÒ»µãÊǼ«´óµØÌá¸ßÁ˰²È«ÐÔ.
µ½Ä¿Ç°ÎªÖ¹£¬ÓÐһЩÈË£¨°üÀ¨±¾ÈË£©Á¬»ù±¾µÄ¶ñÒåsqlÓï·¨¶¼²»ÖªµÀ.
string sql = " select from tb_name where name= ' " +varname+" ' and passwd=' " +varpasswd+" ' "
Èç¹ûÎÒÃǰÑ[' or ' 1' = ' 1]×÷Ϊname´«È
Ïà¹ØÎĵµ£º
ÓÃÁËcommons-fileupload-1.2.jarºÍcommons-io-1.3.2.jarÕâÁ½¸ö°ü¡£
save.jsp
<%@ page language="java" contentType="text/html;charset=utf-8"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.regex.*"%>
<%@ page import="org.apache.co ......
ǰ¼¸Ì죬ºþÄÏSEOÔÚÓÃjspдһ¸öÆóÒµÕ¾³ÌÐòµÄʱºò£¬ÒòΪҪ²Î¼ÓÏîÄ¿´ð±ç¾ºÑ¡£¬ËùÒÔ¾ÍÏëΪ×Ô¼ºÐ´µÄ³ÌÐò¸ã¼¸¸öÁÁµã£¬ÒòΪ¸ãSEO¾ÃÁË£¬²»×Ô¾õ¾Í»áÏ뵽α¾²Ì¬£¬µ«ÊÇÔڰٶȲéÁËÒ»¸öÏÂÎ磬ֻ²éµ½ÁËurlrewrite¼Ü°üµÄÏÂÔØµØ·½£¬ºÍ¼ÜÉè·½ÃæµÄÎÄÕ£¬²¢Ã»ÓÐjsp(JAVA)α¾²Ì¬µÄ¾ßÌå²Ù×÷ʾ·¶£¬ÓеÄÒ²Ö»ÊÇ£¬µ¥Ò³ÃæµÄα¾²Ì¬µÄд·¨£¬ÕâÀïÎÒ¾ÍÖØÍ· ......
Ò²ÐíºÜ¶à¸ßÊÖ¶¼²»Ï÷½â¾öÕâ¸öÎÊÌ⣬µ«ÊÇÎÒ¾õµÃ¶Ô³õѧÕßÀ´ËµÕâ¸öÎÊÌ⻹ÊÇÒªÑо¿Ò»»áµÄ£¬ËùÒԾͼǼÏÂÀ´ÁË¡£
ÎÊÌâÃèÊö£º
µ±ÄãÔÚEclipseµÄ³ÌÐòÖмÓÈëÒ»¸öJSPÎļþºó£¬Õû¸öProject »á±¨Ò»¸öÕâÑùµÄError.
ÎÊÌâÔÒò£º
ĬÈÏEclipseµÄ±àÒë»·¾³ÊÇJRE£¬¶øJREÊDz»´ø±àÒëÆ÷µÄ£¬Ö»ÓÐJDK²Å´ø±àÒëÆ÷¡£ËùÒÔ±ØÐë°ÑJDK×÷ΪÄãÏîÄ¿µÄInstalle ......
»ù±¾ÄÚÈÝ
Ê×ÏÈÊÇÓÃJ2SE+TOMCAT´î½¨¿ª·¢Æ½Ì¨£¬È»ºó»áÓÃʵÀý·Ö±ð¶ÔjavabeanºÍservlet½øÐвâÊÔ£¬
ͬʱҲ»á̸µ½Ò»Ð©ÖÐÎÄ´¦ÀíÉϵÄÎÊÌâ¡£ÎÄÕÂÄÚÈÝ¿ÉÄÜ»áÓеãÔÓÂÒºÍÁãÉ¢£¬µ«ÕâÒ²ÊÇѧϰ
jsp×î»ù´¡µÄ֪ʶ£¬ÒªÏëѧºÃjsp»¹µÃ¿¿×Ô¼º¶àŬÁ¦Ñ§Ï°¡£
ΪʲôҪдÕâÑùһƪÎÄÕ£¿
ÈÏʶÎÒµÄÅóÓÑ¿ÉÄÜ»áÖªµÀ£¬ÎÒÆ½Ê±Ö»ÊÇдºÍ·ÒëһЩJ2ME· ......
JSP¹²ÓÐÒÔÏÂ9ÖÖ»ù±¾ÄÚÖÃ×é¼þ£¨¿ÉÓëASPµÄ6ÖÖÄÚ²¿×é¼þÏà¶ÔÓ¦£©£º
¡¡1.request Óû§¶ËÇëÇ󣬴ËÇëÇó»á°üº¬À´×ÔGET/POSTÇëÇóµÄ²ÎÊý¡£
2. response ÍøÒ³´«»ØÓû§¶ËµÄ»ØÓ¦ ¡£
3.pageContext ÍøÒ³µÄÊôÐÔÊÇÔÚÕâÀï¹ÜÀí ¡£
4.session ÓëÇëÇóÓйصĻỰÆÚ¡£
5.ap ......