´ó¼ÒºÃ£¡ÎÒÊÇJAVAµÄ³õѧÕߣ¬Ïëѧϰ¹ØÓÚÊÖ»ú¿ª·¢·½ÃæµÄ֪ʶ£¬ÎÒÓ¦¸ÃÔõÑùÈëÊÖ°¡£¬Ê×ÏÈÊǰÑJAVA»ù´¡Ñ§ºÃÁË£¬Æä´ÎÄØ£¿´ó¼Ò°ï°ïæ°¡£¡Ð»Ð»ÁË
ÎÒÒ²ÊdzõѧÕß,ÃÔãÖÐ
Èç¹ûJAVA»ù´¡Ñ§ºÃÁËѧj2me¾ÍºÜ¼òµ¥ÁË£¬£¬£¬Ö»Òª¶à¿´¿´API¶àдд´úÂë¾ÍÐÐÁË
2Â¥Ã²ËÆÓÐÎÊÌâ
3¥ͬÒâ
J2ME±È½Ï¼òµ¥Âð£¿
ÒýÓÃ
J2ME±È½Ï¼òµ¥Âð ......
class A {
A() {
System.out.println("A.A called");
}
}
class B extends A {
int i =f();
int j;
{
j = 37;
System.out.println("initialization block executed");
}
B() {
......
±í½á¹¹
id ×Ô¶¯Ôö¼ÓÀàÐÍ
click int ÀàÐÍ
show inti ÀàÐÍ
Ïë°´ÕÕclickºÍshow֮ǰµÄ±È½µÐòÅÅÁС£ÏÖÔÚÊÇÓÃÏÂÃæµÄ·½·¨Íê³ÉµÄ£¬²»ÖªµÀÕâÑùÐÐÂ𣿣¬»¹ÓиüºÃµÄ·½·¨Ã»ÓУ¿
select (click/show) as percent from talbe order by percnt desc;
ÒýÓÃÏÖÔÚÊÇÓÃÏÂÃæµÄ·½·¨Íê³ÉµÄ£¬²»ÖªµÀÕâÑùÐÐÂð£¿
¿ÉÒÔ£ ......
ÔÚÒ»¸ö±íÉÏÓÐ2¸öÁªºÏË÷Òýy(a,b,c),x(a,c)
ÎÒ²éѯµÄʱºò select * from table where a=1201 order by c desc limit 20 µÄʱºòÓÃexplain²é¿´£¬·¢ÏÖmysqlÓõÄÊÇyË÷Òý
ÕâÑùÎÒÔÚextraÀï¿´µ½ÓÐfilesort,¶ø²»ÊÇÎÒÏëÒªµÄxË÷Òý£¬Õâ¸öÔõô°ì£¿Ôõô²ÅÄÜÓõ½ÎÒµÄxË÷Òý
select * from table FORCE INDEX (x)
where a ......
SQL Server Óм¯³É Windows Éí·ÝÑéÖ¤¡£MySQL PostgreSQL ÊÇ·ñÓм¯³É Linux Éí·ÝÑéÖ¤µÄ·½Ê½£¬Windows Çé¿öÓÖÈçºÎÄØ£¿
mysql ûÓС£³ý·ÇÄã×Ô¼º¸ÄËüµÄÔ´´úÂë¡£
PostgreSQL ±¾Éí¾ÍÊǼ¯³ÉµÄ¡£
postgresqlҲûÓÐ
......
±¾À´ÓÐÊý¾Ý¿âA ¡¢ºÍÊý¾Ý¿âB
Êý¾Ý¿âAÀï±íxuexiao ºÍÊý¾Ý¿âB±íxuexiaoÊÇÒ»ÑùµÄ£¨°üÀ¨×ֶΣ©
ID(×Ô¶¯µÝÔö£¬´Ó1¿ªÊ¼£© aid£¨Õ˺ÅIDµÝÔö£¬´Ó101001¿ªÊ¼£© name£¨Õ˺ſÉÄÜÓÐÖØ¸´£© pw£¨ÃÜÂ룩 std£¨Ñ§Éú£© nl£¨ÄêÁ䣩
ÎÒ°ÑB±íÀïµÄxuexiao¿½±´µ½A±íÀïÁË£¬²¢ÖØÐÂÃüÃûΪ xuexiao_copy¡£
ÏÖÔÚ±íAÀï Óбíxuexiao ºÍ±íx ......