ÎÒÏëÓÃÒ»¸öjavaдһ¸ö¹ÜÀíÈí¼þ Ïë°ÉjavaºÍSQLÁ¬½ÓÆðÀ´
ÎÒÒѾÓÐJDBCÁË ¾ÍÊDz»ÖªµÀÔõôÓà ÔõôÁ¬½Ó
Ï£Íû¸ßÊÖÃǰï°ïÎÒ
¸üÏ£ÍûÓиöÊÓÆµ½ÌÎÒÓÃ
лл
Íû¸ßÊÖÃÇÖ¸µã
ÔÚÏ¸м¤²»¾¡
http://www.itcast.net/course/detail/945
ÕâÊÇÎÒ×Ô¼ºÔÚ±à³ÌʱһֱÓõÄÁ¬½Ó³Ø£¬Äã¾ÍÖ±½Óµ¼Èë½ø ......
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Á¬µÄAccessÊý¾Ý¿â£¬ÎÒÏÖÔÚÏë¸Ä³ÉÁ¬½ÓSQLÊý¾Ý¿â£¬²»´úÂëÐÞ¸ÄÉÏÓ¦¸Ã×¢ÒâÄÄЩÖ÷񻂿±ð¡£±ÈÈç Á¬½ÓSQLÁ¬½Ó×Ö·û´®ÈçºÎд£¿
1, "Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
2, Èç¹ ......
ÇëÎÊ´óÉñÃÇ£¬ÔÚÎҵijÌÐòÖÐÓÃDTPICKER½«ÈÕÆÚ¼Èëµ½ÁËÊý¾Ý¿âÖУ¬µ«ÊÇÔÚMSHFLEXGRIDÀïÃæÓɼÈëʱµÄ2009-11-12È´ÏÔʾ³É11/12/2009£¬ÔÚÖ´Ðвéѯʱ¼äºÍʱ¼ä¶ÎµÄʱºòÈ´²é²»³öÈκμǼ£¬¸ÃÔõô°ì°¡£¿ÇëÖ¸µãϱÈÈçÎҵĴúÂëÊÇ£ºselect * from storage where ³ö¿âʱ¼ä='dtpicker.value' È´²é²»³öÈκμǼ£¬Ð»Ð»ÁË£¡¸ßÊÖ˵һÏÂ
......
Delphi 7 ÖУ¬ÈçºÎ¿ìËÙÅжÏSQLÊÇ·ñÄÜÁ¬½ÓÉÏ£¿£¿
лл¸÷λ£¡£¡
Õâ¸ö°ï¶¥¡£
Ó¦¸ÃÓÐÅжÏÁ¬½ÓµÄº¯Êý°É
ÓÃBDEÁ¬½ÓÏ¡£
ѧϰ
Delphi(Pascal) code:
Õâ¸öÄÜ¿´Ã÷°×Âð?TRYÒ»ÏÂ
with DM do
begin
Conn.Connected := False;
Conn.ConnectionString := Connstring;
try
Conn.Conne ......
ͼ1ÖбäÁ¿"v_count"ÊÇ0;
ͼ2ÖбäÁ¿"v_count"ÊÇ1;
ΪʲôÎÒûÓиüÐÂÊý¾Ý±íµÄÈκÎÊý¾Ý,sql%rowcount ×ÜÊÇ·µ»Ø1ÄØ,ͼƬ´ó¼Ò¶¼¿´µ½ÁË?
ÓÐÈËÄܽâÊÍÒ»ÏÂÂð?
sql%rowcountµ½µ×ÔõôÓð¡
²¹³äÒ»ÏÂ:±äÁ¿"Group_name_in",µÄÖµ:"xxxx"ÔÚÊý¾Ý±íÖÐÊDz»´æÔÚ ......