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

sqlÃüÁî - Web ¿ª·¢ / ASP

ÏòÊý¾Ý¿â±íaÖвåÈëÊý¾Ý£¬Êý¾ÝÓÐÁ½¸öÀ´Ô´£ºÒ»¸öÊÇ´ÓÒ³ÃæÎı¾¿ò»ñÈ¡²åÈëµ½±íaÖУ¬ÁíÒ»¸öÊÇ´ÓÆäËû±íÖлñÈ¡Êý¾Ý²åÈëa£¬
Ïòjz_glc²åÈëÊý¾Ý,ÁíÒ»¸ö±íÊÇexpressinfo£º
string cmdstr = "insert into jz_glc(¿ìµ¥ºÅ,·ÑÓÃ) values('"+this.expressnum_TextBox.Text.Trim()+"',"+this.expressfee_TextBox.Text+")"//´ÓÒ³Ãæ»ñÈ¡
+"insert into jz_glc(¿ìµÝ¹«Ë¾,·¢¼þÈË,¹ÜÀí´¦,ÊÕ¼þÈË) select expressinfo.¿ìµÝ¹«Ë¾,expressinfo.·¢¼þÈË,expressinfo.¹ÜÀí´¦,expressinfo.ÊÕ¼þÈË from expressinfo where expressinfo.¿ìµ¥ºÅ='"+this.expressnum_TextBox.Text.Trim()+"'";//´ÓÆäËû±í»ñÈ¡

Ëù²åÈëµÄÁв»ÄÜΪ¿Õ£¬´íÎóÌáʾ£º²»Äܽ«null²åÈëµ½·ÑÓúÍÊÕ¼þÈË£¬²»Ã÷°×

Ö´ÐÐǰresponse.write(cmdstr)¿´¿´SQLÓï¾äÓÐÎÞɶ´íÎó£¬Äĸö×ֶεÄֵûÊÕµ½¡£

Ëù²åÈëµÄÁв»ÄÜΪ¿Õ£¬Õâôֱ°×µÄÖÐÎÄ£¡

²åÈëÊý¾ÝǰÏÈ×öÅжϺʹ¦Àí

ÔõôÅжϺʹ¦Àí£¿Çë´Í½Ì£¬²åÈëµÄÊý¾Ý¶¼²»Îª¿Õ°¡




this.expressfee_TextBox.Text
expressinfo.ÊÕ¼þÈË

ÕâÁ½¸öÀïÃæÓÐÖµÂð?

string cmdstr = "insert into jz_glc(¿ìµ¥ºÅ,·ÑÓÃ) values('"+this.expressnum_TextBox.Text.Trim()+"',"+this.expressfee_TextBox.Text+")"// ´ÓÒ³Ãæ»ñÈ¡
+"insert into jz_glc(¿ìµÝ¹«Ë¾,·¢¼þÈË,¹ÜÀí´¦,ÊÕ¼þÈË) select expressinfo.¿ìµÝ¹«Ë¾,expressinfo.·¢¼þÈË,expressinfo.¹ÜÀí´¦,expressinfo.ÊÕ¼þÈË from expressinfo where expressinfo.¿ìµ¥ºÅ='"+this.expressnum_TextBox.Text.Trim()+"'";//´ÓÆäËû±í»ñÈ¡

ÄãÕâÊDzåÈëÁ½Ìõ¼Ç¼µÄSQL,¶øÇÒÓï·¨ÓÖ²»¶Ô


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

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



type Exception report


message

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

exception

org.apache.jas ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

SQLÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Çë½Ì¸ßÊÖ£º
 ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ  
  id planname TaskBeginTime Status
329 2010Äê03 ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ