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

Çó½âSQLÓï¾ä - Java / Web ¿ª·¢

ѧÉúÐÅÏ¢±í£¬ÈçÏ£º
  ID SEX SCORE YEAR
  1 ÄÐ 88 2007
2 Å® 87 2008
3 ÄÐ 89 2006
4 Å® 99 2009
5 ÄÐ 54 2007
6 Å® 56 2008

ÒªÇóͳ¼Æ³öѧÉú×ÜÈËÊý£¬ÄÐÉú×ÜÈËÊý£¬Å®Éú×ÜÈËÊý
  СµÜÊÇÔڸ㲻¶¨£¬Çó´ð°¸£¡Ð»Ð»
select count(*) from student;
select count(*) from student where sex='ÄÐ';
select count(*) from student where sex='Å®';


SQL code:

select sex,count(*) from student group by sex
select count(*) as ×ÜÈËÊý from student


ºÜÄÑÂ𣿣¿£¿

ÒýÓÃ
select count(*) from student;
select count(*) from student where sex='ÄÐ';
select count(*) from student where sex='Å®';


ÊDzÉÓÃÒ»ÌõÓï¾äÕ¹ÏÖ³öÉÏÃæµÄͳ¼Æ½á¹û ¼´£º count£¨*£©£¬count(ÄÐ)£¬count£¨Å®£© ÕâÑùµÄЧ¹û

ÒýÓÃ
SQL code

select sex,count(*) from student group by sex
select count(*) as ×ÜÈËÊý from student


ºÜÄÑÂ𣿣¿£¿


²»ÊÇÓÃÁ½ÌõÓï¾ä

select (select count(*) from student) as total,(select count(*) from student where sex='ÄÐ') as mens,(select count(*) from student where sex='Å®') as womens from student;


ÒýÓÃ
SQL code

select count(*) ×ÜÈËÊý,
sum(case when sex=


Ïà¹ØÎÊ´ð£º

C/SÏîÄ¿¼Ü¹¹Éè¼Æ----ÇóÖú - Java / Java SE

±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ 
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ 
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......

JAVAµç×Ӵʵ䣿 - Java / Java SE

¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£


´Ê¿âÔõôÉú³ÉÄØ£¿

²»»á¡£

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ

ÓÃmap ¼üÖµ¶ÔÓ¦

Èç¹ûÓÃÊý¾Ý¿ ......

java socket email ÎÊÌâ - Java / Java SE

ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:

package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......

SQLÓï¾ä OR ´æ´¢¹ý³Ì£¿ - .NET¼¼Êõ / C#

Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã

Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ