Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¡­¡­ ºÜÓÐÓᣠҲºÜ»ù´¡¡£Äã¿´Ò»¹þÏà¹ØµÄ֪ʶºÍ´úÂë¾Í»áÃ÷°×ÁË¡£

Â¥Ö÷Ó¦¸Ã½áÌù¡£
½áÌùÂÊ߯µÍ
{{----}


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

ÇóÒ»SQLÓï¾ä

Ô­Êý¾Ý

ÉÌÆ·    Ô­¼Û    ´òÕÛ·½Ê½1  ÕÛ¿Û1    ´òÕÛ·½Ê½2  ÕÛ¿Û2
±Ê¼Ç±¾  10000  NULL        0      NULL&nb ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ