[ÉêÃ÷:ÐÂÊÖ]sqlÊý¾Ý¿â¸½¼ÓºÍÁ¬½ÓµÄÎÊÌâ!
´ó¼ÒºÃ,ÕæÕæ¶ùµÄÊÇÐÂѧ,ʵÔÚÊDz»¶®,ƽʱÀÏʦ½²µÄ¶¼Òª¸½¼ÓSQLÊý¾Ý¿â,ºÍÉèÖÃweb.configÎļþÀïµÄsaÕ˺źÍÃÜÂë,¿É´«µ½¿Õ¼äÀïÀϳö´í. ÐéÄâ¿Õ¼äÀ︽¼ÓÊý¾Ý¿âºÍweb.configÎļþÀïµÄÕ˺ÅÃÜÂëÎÊÌâÔõô½â¾ö?¿Õ¼äûÓÐÎÊÌâ,ÊÇÈ«ÄܵÄ,´«Á˼òµ¥µÄaspxÎļþ²âÊÔûÓÐÎÊÌâ,¿ÉÒ»µ½Á¬Êý¾Ý¿âÕâ¶ù¾Í²»Ì±ÁË,Ôõô¶¼²»ÐÐ,ÊDZ¾µØºÍÉÏ´«µÄʱºòÊý¾Ý¿âÁ¬½ÓÓÐÇø±ð?ÓÐûÓÐʲôͨÓõİ취Âð? ´ó¼Ò»ïƽʱ´«¿Õ¼äÀï¶¼ÊÇÔõôÅäÖõÄ,ÎÒÕâÎÊÌâµ½µ×ÊdzöÄĶùÁË?
֮ǰ´«¹ýÒ»¸ö¿Õ¼ä,µ«ÊÇûÓÐÂòÊý¾Ý¿â,ËùÒÔ°Ñms sql ¸Ä³ÉÁËsqlite,ÓеãÏñaccess
°ï¶¥ÁË
¹§Ï²
¸ú¿Õ¼äÌṩÉÌѯÎÊÊý¾Ý¿âµÄÅäÖ÷½·¨
ͨ³££¬×î¼òµ¥µÄ·½Ê½
1.ÏÖÔÚ±¾µØ²âÊÔ³ÌÐòÊÇ·ñÔËÐÐÕý³££¬°üÀ¨Êý¾Ý¿â·ÃÎʲ¿·Ö
2.ÕÒÊý¾Ý¿â¿Õ¼äÌṩÉÌ£¬ÎÊÒ»ÎÊÈçºÎÅäÖÃÄãµÄÊý¾Ý¿âµ½·þÎñÆ÷£¬²¢Ìṩ¸øÄã·þÎñÆ÷ÉÏÊý¾Ý¿âµÄÓû§Ãû¡¢ÃÜÂë¡¢IP
3.ÐÞ¸Äweb.configÎļþÀïµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®µÄIPµØÖ·£¬Óû§Ãû£¬ÃÜÂëΪ·þÎñÆ÷ÉϵÄÃÜÂë
4.Èç¹û±¾µØÕý³££¬ÉÏ´«ºó³ö´í£¬ÐÞ¸Äweb.configµÄcustomErrors ±êÇ©ÖеÄmodeÊôÐÔΪOFF£¬¿ÉÒÔÏÔʾÏêϸµÄ´íÎóÐÅÏ¢£¬ÔÚ¸ù¾ÝÏêϸµÄ´íÎóÐÅϢȥÕÒGoogle»òÕßÉÏcsdnÀ´ÎÊ
5.×îºó±ðÍüÁ˰ÉcustomErrors ±êÇ©ÖеÄmodeÊôÐԸĻØÔÀ´µÄÑù×Ó
¿Õ¼äÊý¾Ý¿âµÄÅäÖ÷½·¨ÓÐÊ²Ã´ÌØÊâÒªÇóÂð£¿
лл´ó¼Ò,ÎÒÈ¥ºÍ¿Õ¼ä·þÎñÉÌÒ»ÏÂÔõôÅäÖÃ,ºÜ¸Ðл´ó¼ÒµÄÖ¸½Ì!
·ÖÊý²»¶à,ƽ¾ù·ÖÒ»ÏÂ,ËãÊǸöÐÄÒâ!
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд
£º ......
SQL±íÒ»
ÐòÁкÅ, ²úÆ· bz
0001 mc 0
0002 mc 0
0003& ......
sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ ......