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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

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 ......

java synchronized - Java / Java SE

Java code:

......
synchronized(user){
int loginNum = Integer.parseInt(Main_Client_Dia.jtf2.getText().trim());
Main_Client_Dia.jtf2.setText("");
loginNum++;
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ