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


Ïà¹ØÎÊ´ð£º

JSP/Servlet½»»¥ - Java / Web ¿ª·¢

JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
  JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
  
  ÒªÇóÈçÏÂ;
  1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......

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

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

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......

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ºÅ