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

·À·¶sql×¢Èë¹¥»÷£¨Ï£© ²ÎÊý»¯sql

ÉÏһƪдµÄsql×¢ÈëµÄ»ù±¾Ô­Àí£¬±¾À´Òª½Ó×ÅдÕâÆªµÄ£¬µ«ÊÇÓÉÓÚʱ¼äµÄÔ­ÒòһֱûÓÐд³É£¬½ñÌìÊÇÎåÒ»¼ÙÆÚ£¬×ÜËãÊÇÄܳé¿ÕддÁË¡£
×÷Ϊһ¸ö³ÌÐòÔ±£¬·À·¶sql×¢ÈëµÄµÚÒ»ÏßÊÇÓÉÎÒÃÇÀ´ÊØ»¤µÄ£¬Ö»ÒªÎÒÃÇÔÚ³ÌÐòÖÐÁôÉÙÐíµÄ©¶´£¬¾Í»á¸ø³ÌÐòÔöÇ¿°²È«ÌØÐÔ¡£ËùÒÔÎÒÃÇÒª×öµÄÊÇҪд°²È«µÄ³ÌÐò£¬·ÀÖ¹sql×¢ÈëÔÚ³ÌÐòÌåÏÖÔÚ²»ÒªÆ´½Ósql×Ö·û´®£¬Ò»¶¨Òª²ÎÊý»¯sql»òÕßд´æ´¢¹ý³Ì£¬ÕâÀï¾Í˵˵¼òµ¥µÄ²ÎÊý»¯sql°É¡£
Àý×ÓÖÐÓÃc#ºÍoracleʵÏÖ£¬javaÖлòÕ߯äËûÊý¾Ý¿âÖеÄʵÏÖÒ²ÊÇÀàËÆµÄ¡£
using System.Data.OracleClient;//ÒýÈëoracle²Ù×÷°ü
 
//¶¨ÒåDMLÓï¾ä
string strSQL = @"select user.name from user where user.name = :userName";
//ÉϾäÖеģºuserName¾ÍÊÇsqlÓï¾äÖвÎÊýµÄռλ·û£¬Ò²¾ÍÊÇ˵ÔÚÊý¾Ý¿â·þÎñÆ÷ÖÐÖ´ÐÐÕâÌõsqlÓï¾äµÄʱºòÕâ¸öռλ·ûÒª±»ÆäËû¶«Î÷Ìæ»»µô£¬µ½µ×ÓÃʲô¶«Î÷Ìæ»»ÄØ£¬½Ó×ÅÍùÏ¿´
OracleParameter[] param = {
new OracleParameter(":userName",txtName);
}//ÕâÀﶨÒåÒ»¸ö²ÎÊýµÄÊý×飬ÀïÃæ¿ÉÒÔдÈë¶à¸ösql²ÎÊý£¬ÔÛÃǵÄÕâÀïÖ»ÓÐÒ»¸ö£¬ËùÒÔ¾ÍдÈëÒ»¸ö²ÎÊý£¬ÕâÀイռλ·ûºÍËûµÄÌæ»»Ò²¾ÍÊDzÎÊýÖµ¶ÔÓ¦ÆðÀ´ÁË£¬txtName¾ÍÊÇռλ·ûµÄÌæ»»Öµ£¬ËûÊÇÓû§½çÃæÖÐÓû§ÊäÈëµÄÖµ£¬¾ÍÊÇËû¿ÉÄܺ¬ÓÐ×¢Èë¹¥»÷µÄ×Ö·û£¬ÕâÏÂÊý¾Ý¿â·þÎñÆ÷ÖªµÀÓÃʲô¶«Î÷Ìæ»»Õ¼Î»·ûÁË¡£
¶¨ÒåºÃsqlÓï¾äºÍ²ÎÊýºó¾ÍÊÇÖ´ÐÐÁË£¬Ö´ÐеÄʱºòÐèҪͬʱ½«sqlÓï¾äºÍ²ÎÊý´«È룬ÕâÑùÓû§ÊäÈëµÄ´øÓзǷ¨×Ö·ûµÄ×Ö·û´®ÔÚÊý¾Ý¿â»áµ±×÷²ÎÊý´¦Àí£¬¶ø²»»áµ±×÷sqlÓï¾äºÍÊý¾Ý¿â×Ô¼ºµÄ×Ö·û»ìÂÒ£¬·ÀÖ¹ÁË×¢Èë¹¥»÷¡£
    OracleCommand cmd = new OracleCommand();
     cmd.CommandText = strSQL;//¶¨ÒåoracleÃüÁîµÄÎı¾ÄÚÈÝ
      for(oracleParameter p in param)//½«²ÎÊý´«Èë
{
cmd.Parameters.Add(p);
}
     cmd.ExecuteNonQuery(); //Ö´ÐÐÃüÁî
 
ÉÏÃæ»ù±¾ÉÏÊÇÒ»¸öÍêÕûµÄ²ÎÊý»¯sql£¬²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷sqlÓï¾äÖвÎÊýµÄռλ·û²»Í¬£¬ÉÏÃæÓõÄÊÇoracle£¬²ÎÊýռλ·ûÊÇðºÅ£¨£º£©¼ÓÃû×Ö£¬ÔÚsqlserverÖÐÊÇÓÃ@·ûºÅ¼ÓÃû×Ö×÷Ϊռλ·û£¬¶øÔÚmysqlÖÐÓÃÎʺţ¨£¿£©¼ÓÃû×ÖÀ´×÷Ϊ²ÎÊýռλ·û£¬²»Í¬µÄÊý¾Ý¿âÖвÎÊýµÄ±íʾ·ûºÅ²»Ò»Ñù£¬Õâ¸öÐèҪעÒâ¡£


Ïà¹ØÎĵµ£º

sqlµÝ¹é²éѯ

ÔÚ¹¤×÷ÖÐÓöµ½Ò»¸öÎÊÌâ,ÊÇÐèÒªsqlµÝ¹é²éѯµÄ.²»¶®,ÓÚÊǵ½csdnÉÏÈ¥ÎÊ,ÄÇÀïµÄЧÂÊÕæÊǷdz£¸ß,ÎÒÒÔǰҲûÔÚÉÏÃæÎʹýÎÊÌâ.
ÎÊÌâÃèÊö:
ÎÒÓÐÒ»¸ö±í½á¹¹ÈçÏÂ:
id upperid
1     2
3     2
4     1
5     3
¾ßÌå²ã´Î²»ÖªµÀ,ÎÒÏëÓõݹésqlÓ ......

SQL´¥·¢Æ÷µÄʹÓÃ

Ò»¡¢´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨ ......

SQL ³£ÓÃÓï¾ä

Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
 
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
  select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
& ......

SQLiteÖв»Ö§³ÖµÄsqlÓï·¨

½ñÌìºÜ×ÔÈ»µÄÔÚдSqlÓï¾äµÄʱºòÓÃÁËTop£¬Ò»¿ªÊ¼Ã»·¢ÏÖÎÊÌ⣬ÒòΪÎÒ´ÓÊý¾Ý¿â¶Á³öµÄÖµÕýºÃÊÇ0£¬¶øÎÒϰ¹ß±äÁ¿¶¨ÒåµÄʱºòÒ²¶¼¸³Öµ0£¬¿ÉÊǵ½ÎÒ²»Òª0µÄʱºòÎҾͷ¢ÏÖÎÊÌâÁË¡£ºóÀ´²ÅÖªµÀ£¬¿É°®µÄСsqlite¾¹È»Óв»Ö§³ÖµÄsqlÓï·¨¡£
¡¡¡¡¿´µ½Ä³¸öÂÛ̳ÓиöÐÂÊÖÒ²·¢ÏÖÁËÕâ¸öÎÊÌâ²¢·¢ÌûÁË£¬ÏÂÃæÒ»Å£È˵Ļظ´ÊÇ“topÊÇÄļҵĹؼü´Ê?s ......

SQL 2000ºÍSQL 2005·þÎñ¶Ë¿Ú²é¿´»òÐÞ¸Ä

1¡¢ SQL Server£ºÈëÕ¾¶Ë¿ÚΪTCP 1433£¬³öÕ¾¶Ë¿ÚΪTCPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
2¡¢ SQL Browser £ºÈëÕ¾¶Ë¿ÚΪUDP 1434£¬³öÕ¾¶Ë¿ÚΪUDPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
3¡¢²é¿´»òÐÞ¸ÄSQL2005ʵÀýµÄ¶Ë¿ÚºÅ£¬Èç¹ûϵͳÖÐͬʱ°²×°SQL 2000ºÍSQL 2005£¬SQL 2005µÄÁ¬½Ó¶Ë¿Ú¿ÉÄܲ»ÊÇ1433£¬ÎÒÃÇÐèÒª¸ü¸ÄSQL 2005 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ