·À·¶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ÖÐÓÃÎʺţ¨£¿£©¼ÓÃû×ÖÀ´×÷Ϊ²ÎÊýռλ·û£¬²»Í¬µÄÊý¾Ý¿âÖвÎÊýµÄ±íʾ·ûºÅ²»Ò»Ñù£¬Õâ¸öÐèҪעÒâ¡£
Ïà¹ØÎĵµ£º
¾ßÌåҪעÒâµÄ£º
1.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º
select id from t where num=0 &n ......
¸Õ×°ÍêÊý¾Ý¿â¾Í±»ÈË·è¿ñɨÃèsa£¬ÎÞ±ÈÓôÃÆ¡£
¸ÄsaÃû³Æ£¬1433¶Ë¿ÚºÅ£¬ÒòΪ¿ª·¢ÐèÒª»¹±ØÐë´ò¿ªÔ¶³ÌÁ¬½Ó£¬½á¹ûÔÚ¿Í»§¶ËÎÞÂÛÈçºÎ¶¼²»ÄÜÁ¬½ÓÉÏ·þÎñÆ÷¡£
¿ñº¹Çë°Ù¶È´óÉñ³öÂí£¬°Ñ¸÷ÖÖÅäÖÃÁ·Á˸öÊ죬½á¹û»¹ÊÇû½â¾ö¡£
¸ãЦµÄÊÇ×îºóÎÞÒâÖÐÔÚMicrosoftÂÛ̳ÉÏ¿´µ½Õâôһ¾ä£¬ÐÞ¸ÄÍê¶Ë¿ÚºÅ£¬ÔÚ¿Í»§¶ËµÇ¼µÄʱºòÒªÔÚIPºóÃ棫¶ººÅ£«¶Ë¿Úº ......
SQL³£ÓÃÃüÁîʹÓ÷½·¨£º
(1) Êý¾Ý¼Ç¼ɸѡ£º
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû=×Ö¶ÎÖµ order by ×Ö¶ÎÃû [desc]"
sq ......
ʹÓÃSQLÓï¾ä
SQLÓïÑÔ°üÀ¨Êý¾Ý²éѯÓïÑÔ(SELECT)¡¢Êý¾Ý²Ù×ÝÓïÑÔ(INSERT¡¢UPDATE¡¢DELETE)¡¢ÊÂÎñ¿ØÖÆÓïÑÔ(COMMIT¡¢ROLLBACK¡¢SAVEPOINT)¡¢Êý¾Ý¶¨ÒåÓïÑÔ(CREATE TABLE¡¢ALTER TABLE¡¢DROP)¡¢Êý¾Ý¿ØÖÆÓïÑÔ(GRANT¡¢REVOKE)µÈÎå¸ö²¿·Ö¡£
µ±±àдPL/SQLÓ¦ÓóÌÐòʱ£¬Ö»ÄÜÖ±½ÓǶÈëSELECT ......