sql Àà
ÎÒÕýѧϰÓÃc#±àдһ¸öµÇ¼¿ò£¬·¢ÏÖÀïÃæÓкܶàSqlCommand£¬ExecuteNonQuery£¬DisposeµÈµÈµÄ¡£ÎÒ²»¶®¡£ÏëÇëÎÊÄÄÀïÓÐÕâ·½ÃæµÄ½Ì³ÌÄØ£¿Âé·³¸ø³öÏêϸµÄ½âÊͽ̳̣¬Ð»Ð»£¡ »¹ÓÐÄÄλ¿ÉÒÔ½ÌÎÒ×öÒ»¸öµÇ¼¿òµÄ£¬¿ÉÒÔ¼ÓÎÒΪºÃÓÑÂð£¿À§»óÒѾÃÁË¡£
C#Êý¾Ý¿â±à³Ì´ÓÈëÃŵ½¾«Í¨ ADO.NET¼¼ÊõÄÚÄ» °ï¶¥ ϸöADO.NETѧϰѧϰ~!Ó¦¸ÃûʲôÎÊÌâµÄÒýÓà ÎÒÕýѧϰÓÃc#±àдһ¸öµÇ¼¿ò£¬·¢ÏÖÀïÃæÓкܶàSqlCommand£¬ExecuteNonQuery£¬DisposeµÈµÈµÄ¡£ÎÒ²»¶®¡£ÏëÇëÎÊÄÄÀïÓÐÕâ·½ÃæµÄ½Ì³ÌÄØ£¿Âé·³¸ø³öÏêϸµÄ½âÊͽ̳̣¬Ð»Ð»£¡ »¹ÓÐÄÄλ¿ÉÒÔ½ÌÎÒ×öÒ»¸öµÇ¼¿òµÄ£¬¿ÉÒÔ¼ÓÎÒΪºÃÓÑÂð£¿À§»óÒѾÃÁË¡£ Õâ¸ö¶¼ÊÇADO.netÖеĶ«Î÷£¬Ö»ÒªÂ¥Ö÷»áÊý¾Ý¿â£¬Ä㿴һϣ¬ÆäʵºÜ¼òµ¥µÄ¡£ ado.net ADO.NET + ASP.NETÒýÓà ÒýÓÃÂ¥Ö÷ coolio1 µÄ»Ø¸´: ÎÒÕýѧϰÓÃc#±àдһ¸öµÇ¼¿ò£¬·¢ÏÖÀïÃæÓкܶàSqlCommand£¬ExecuteNonQuery£¬DisposeµÈµÈµÄ¡£ÎÒ²»¶®¡£ÏëÇëÎÊÄÄÀïÓÐÕâ·½ÃæµÄ½Ì³ÌÄØ£¿Âé·³¸ø³öÏêϸµÄ½âÊͽ̳̣¬Ð»Ð»£¡ »¹ÓÐÄÄλ¿ÉÒÔ½ÌÎÒ×öÒ»¸öµÇ¼¿òµÄ£¬¿ÉÒÔ¼ÓÎÒΪºÃÓÑÂð£¿À§»óÒѾÃÁË¡£ Õâ¸ö¶¼ÊÇADO.netÖеĶ«Î÷£¬Ö»ÒªÂ¥Ö÷»áÊý¾Ý¿â£¬Ä㿴һϣ¬ÆäʵºÜ¼òµ¥µÄ¡£ No£¬Dispose²»ÊÇ¡£ Õâ¸öÊÇC# ¶ÔÊý¾Ý¿â²Ù×÷µÄһЩº¯Êý¡£ ÔÚÓ¦ÓÃʱ¡£Äã±ØÐë¼ÓÉÏusing System.data.sqlclient ÃüÃû¿Õ¼ä SqlCommand£¬ExecuteNonQuery£¬Dispose¡¡ ºÜÓÐÓᣠҲºÜ»ù´¡¡£Äã¿´Ò»¹þÏà¹ØµÄ֪ʶºÍ´úÂë¾Í»áÃ÷°×ÁË¡£ Â¥Ö÷Ó¦¸Ã½áÌù¡£ ½áÌùÂÊ߯µÍ {{----}
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÔÊý¾Ý ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2 ±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
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 ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......