sql²éѯÎÊÌâ
select id from dcr_hao where haono='1000000000547001 198953273313'
ÕâÑùµÄ Ôõô²éѯ²»µ½£¿
Êý¾Ý¿âÀïÓÐÕâÌõ¼Ç¼°¡ ÊDz»ÊÇÓпոñµÄÔÒò ?
Äã¿´¿´haono×Ö¶ÎÀïÊDz»ÊÇǰºóÓпոñ°¡£¬ÔÚÊý¾Ý¿âÀïÒ²¼ì²éһϡ£
ûÓпոñ..
SQL code:
select id from dcr_hao where haono='1000000000547001 198953273313'
--²é²»µ½Êý¾ÝÊÇÒòΪÄãµÄhaono×Ö¶ÎûÓеÈÓÚ1000000000547001 198953273313µÄÖµºÍ¿Õ¸ñû¹ØÏµµÄ
×Ö¶ÎÓпոñÊÇ¿ÉÒÔ²éѯ³öÀ´µÄ¡£
desc dcr_hao ;
¿´Ò»ÏÂÄãµÄ±í½á¹¹¡£
Èç¹ûÈ·¶¨ÄãµÄ haono ÊÇ×Ö·ûÐÍ£¬Ôò
select id , haono from dcr_hao where haono like '1000000000547001%';
Ìù³öÀ´¿´Ò»Ï¡£¹À¼ÆÊǸù±¾Ã»ÓзûºÏÌõ¼þµÄ¼Ç¼¡£
¹À¼ÆÊÇûÓÐÕâ¸öÖµ»òÕßÀàÐͳö´í
PHP code:
select id from dcr_hao where haono='1000000000547001 198953273313'
where Ìõ¼þºóÃæµÄ`haono`Õâ¸ö×Ö¶ÎÄãûÓÐselect ³öÀ´
Õâôд£º
PHP code:
select id, [color=#FF0000]haono[/color] from dcr_hao where [color=#FF0000]haono[/color]='1000000000547001 198953273313'
PHP code
Code highlighting produced by Actipro CodeHighli
Ïà¹ØÎÊ´ð£º
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......