Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ :

LinuxÏÂpclintÎÊÌâ

²âÊÔ³ÌÐò:
C/C++ code:
#include <iostream>
#include <openssl/rsa.h>
using std::cout;
using std::endl;
int main()
{
int i = 0;;
cout << "hello world,test pclint" << i << endl;
return 0;
}

------------------------------------------- ......

Çó¸ösqlСÓï¾ä


¼Ç¼

  id c1  c2  c4
  1  2  3  4
  2  3  3  20
  3  4  a  40

select ³öÀ´µÄ¼Ç¼ µÚ4Áиù¾ÝÖµµÄ·ÃÎÊÏÔʾһ¸öÖÐÎÄ  10һϵÄÏÔʾ µÍ  30һϵÄÏÔʾÖÐ 40ÒÔÉϵÄÏÔʾ¸ß
SQL code:
select
......

¹ØÓÚSQL²éѯÓï¾ä



ÈçÉÏ£¬ÎÒÏ뽫±í¸ñÖС°´úÂ롱ÁÐÖÐǰÈýλΪ¡°000¡±µÄËùÓÐÐÐÈ«²¿ÕÒ³öÀ´£¬ÓÃSQLÔõôд°¡
Êý¾ÝÊÇ´æÔÚACCESSÖеÄ

select * from table where [´úÂë] like '000%'

VB code:

Private Sub Cmd1_Click()
Dim i As Integer
Dim s As String

recset.Close '¹Ø±Õ¼Ç¼¼¯
s = &q ......

hql¡¡sqlÎÊÌâ

select b.* from Blog b inner join Friend f on b.uid=f.fuid where f.fuid=?
ÓÃsqlÔõôд
ÄãдµÄ²»¾ÍÊÇsqlÂð£¿

HQL ½¨Òéµ½javaµÄ°æ¿éÈ¥ÎÊһϡ£



ÊÔÏÂÊDz»ÊÇÕâÑù£º
select b from Blog b inner join b.Friend f where f.fuid='Öµ'


¶àл Â¥ÉϵÄÀÏʦ 
¶àл¶àл
......

Õâ¸ösqlÓï¾äÔõôд°¡

Ħ¸ù֪ʶÌö¨Ê±ÈÎÎñ ¸Ä³É ×¢Èëservice


±ít
ÓÐ×ֶΣºÃû³Æ,ʱ¼äºÍÆäËû×Ö¶Î
name----time
a-------2006
a-------2007
a-------2008
a-------2009
b-------2007
b-------2008
c-------2007
c-------2008
c-------2009
ÒªÇó²é³öµÄ½á¹û£º
°´Ãû³Æ£¬Ò²¾ÍÊÇa,b,cÈ¡³öÈÕÆÚÏàͬ×î´ ......

Çë½Ì¸ösqlÓï¾äÎÊÌâ

Èç¹û´ÓÊý¾Ý¿â²é³öÏÂÒ»Ìõ¼Ç¼ÔõÑù²é  ÓÃID×ֶβé
Èç¹ûÕâ¸öIDµÄÏÂÒ»Ìõ¼Ç¼ûÓРΪ¿Õ  ¾Í·µ»Ø0

Ìõ¼þ£ºID
±íÃû£ºnews

¾ÍÊÇʵÏÖÐÂÎÅÒ³ÎÄÕ½áβµÄ ÉÏһƪ£ºTitle  ÏÂһƪ£ºTitle(Èç¹ûΪ0µÄ»°¾ÍÏÔʾ¡°Ã»ÓÐÁË¡±)

¼òµ¥ÎÊÌâ  ·ÖÖ»ÓÐÕâµãÁË ²ÑÀ¢¡£¡£¡£  Ï£ÍûÄܽâ¾ö    ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3615] [3616] [3617] [3618] 3619 [3620] [3621] [3622] [3623] [3624]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ