Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

javaºÍSQLÁ¬½ÓÎÊÌâ

ÎÒÏëÓÃÒ»¸öjavaдһ¸ö¹ÜÀíÈí¼þ  Ïë°ÉjavaºÍSQLÁ¬½ÓÆðÀ´ 
ÎÒÒѾ­ÓÐJDBCÁË ¾ÍÊDz»ÖªµÀÔõôÓà ÔõôÁ¬½Ó 
Ï£Íû¸ßÊÖÃǰï°ïÎÒ
¸üÏ£ÍûÓиöÊÓÆµ½ÌÎÒÓÃ
лл
Íû¸ßÊÖÃÇÖ¸µã 
ÔÚÏ¸м¤²»¾¡
http://www.itcast.net/course/detail/945

ÕâÊÇÎÒ×Ô¼ºÔÚ±à³ÌʱһֱÓõÄÁ¬½Ó³Ø£¬Äã¾ÍÖ±½Óµ¼Èë½ø ......

×îÓÐЧÂʵÄsqlÓï¾ä£¬ÕÒµ½×îºóÒ»Ìõ¼Ç¼(MySql)

idµÝÔö£¬ÈçºÎ×îÓÐЧÂÊÕÒµ½×îºóÒ»Ìõ¼Ç¼£¿£¿
select * from tt order by id desc limit 1
or
select a.* from tt a
inner join
(select max(id) as ma from tt) b
on a.id=b.ma

select * from ±íÃû order by id desc limit 1


ʹÓÃhibernate3ÓÃHQLÓï¾äÈçºÎд£¿£¿

ÄãµÄHQLÖÐÓÐûÓÐÅÅÐò£¿

......

ÐÂÊÖÎÊÒ»ÏÂÓÃVBÁ¬½ÓSQL ServerµÄÎÊÌâ

ÐÂÊÖѧ×öÊý¾Ý¿â£¬×öÁ˸öС³ÌÐò£¬ÊÇÓÃVBÁ¬µÄAccessÊý¾Ý¿â£¬ÎÒÏÖÔÚÏë¸Ä³ÉÁ¬½ÓSQLÊý¾Ý¿â£¬²»´úÂëÐÞ¸ÄÉÏÓ¦¸Ã×¢ÒâÄÄЩÖ÷񻂿±ð¡£±ÈÈç Á¬½ÓSQLÁ¬½Ó×Ö·û´®ÈçºÎд£¿
1, "Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
2, Èç¹ ......

ÇëÎÊÏÂVBÖÖ¶ÔÓÚʱ¼äµÄSQL²éѯÈçºÎʵÏÖ

ÇëÎÊ´óÉñÃÇ£¬ÔÚÎҵijÌÐòÖÐÓÃDTPICKER½«ÈÕÆÚ¼Èëµ½ÁËÊý¾Ý¿âÖУ¬µ«ÊÇÔÚMSHFLEXGRIDÀïÃæÓɼÈëʱµÄ2009-11-12È´ÏÔʾ³É11/12/2009£¬ÔÚÖ´Ðвéѯʱ¼äºÍʱ¼ä¶ÎµÄʱºòÈ´²é²»³öÈκμǼ£¬¸ÃÔõô°ì°¡£¿ÇëÖ¸µãϱÈÈçÎҵĴúÂëÊÇ£ºselect * from storage where ³ö¿âʱ¼ä='dtpicker.value' È´²é²»³öÈκμǼ£¬Ð»Ð»ÁË£¡¸ßÊÖ˵һÏ ......

Delphi 7 ÖУ¬ÈçºÎ¿ìËÙÅжÏSQLÊÇ·ñÄÜÁ¬½ÓÉÏ£¿£¿

Delphi 7 ÖУ¬ÈçºÎ¿ìËÙÅжÏSQLÊÇ·ñÄÜÁ¬½ÓÉÏ£¿£¿
лл¸÷λ£¡£¡
Õâ¸ö°ï¶¥¡£

Ó¦¸ÃÓÐÅжÏÁ¬½ÓµÄº¯Êý°É

ÓÃBDEÁ¬½ÓÏ¡£

ѧϰ

Delphi(Pascal) code:

Õâ¸öÄÜ¿´Ã÷°×Âð?TRYÒ»ÏÂ
with DM do
begin
Conn.Connected := False;
Conn.ConnectionString := Connstring;
try
Conn.Conne ......

oracle sql%rowcount µÄÎÊÌâ




ͼ1ÖбäÁ¿"v_count"ÊÇ0;

ͼ2ÖбäÁ¿"v_count"ÊÇ1;

ΪʲôÎÒûÓиüÐÂÊý¾Ý±íµÄÈκÎÊý¾Ý,sql%rowcount ×ÜÊÇ·µ»Ø1ÄØ,ͼƬ´ó¼Ò¶¼¿´µ½ÁË?

ÓÐÈËÄܽâÊÍÒ»ÏÂÂð?
sql%rowcountµ½µ×ÔõôÓð¡

²¹³äÒ»ÏÂ:±äÁ¿"Group_name_in",µÄÖµ:"xxxx"ÔÚÊý¾Ý±íÖÐÊDz»´æÔÚ ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [383] [384] [385] [386] 387 [388] [389] [390] [391] [392]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ