1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCollations¹æ¶¨ÁËaСÓÚb£¬aµÈÓÚa£¬ÒÔ¼°aÊÇ·ñµÈÓÚAÖ®ÀàµÄ¡£Í¨³££¬´ó¼Ò»ù±¾¿ÉÒÔºöÂÔCollationsµÄ´æÔÚ£¬ÒòΪÿ¸ö×Ö·û¼¯¶¼ÓÐÒ»¸öĬÈϵÄCollations£¬Í¨³££¬Ê¹ÓÃĬÈϵÄCollations¾Í¿ÉÒÔÁË¡£
1.2 Character set
ÓëÕâ¶Ô±ÈµÄÊÇ£¬×Ö·û¼¯ÊǸö¸ü¹ãµÄ¸ÅÄ¼´Ê¹ÊÇWindowsÏÂÆÕͨµÄÎı¾Îļþ£¬Ò²Éø¼°µ½×Ö·û¼¯µÄÎÊÌâ¡£²»Í¬µÄ×Ö·û¼¯£¬¹æ¶¨Á˲»Í¬µÄ×Ö·ûµÄ±àÂ뷽ʽ¡£Ò»¸ö character set (×Ö·û¼¯)ÊÇÒ»×é·ûºÅºÍ±àÂ룬±ÈÈ磬ASCII×Ö·û¼¯£¬°üÀ¨µÄ×Ö·ûÓУºÊý×Ö£¬´óСд×Öĸ£¬·ÖºÅ¡¢»»ÐÐÖ®ÀàµÄ·ûºÅ£¬±àÂ뷽ʽÊÇÓÃÒ»¸ö7bit±íʾһ¸ö×Ö·û£¨AµÄ±àÂëÊÇ65£¬bµÄ±àÂëÊÇ98£©¡£ASCIIÖ»¹æ¶¨ÁËÓ¢ÎÄ×ÖĸµÄ±àÂ룬·ÇÓ¢ÎÄÓïÑÔ²»ÄÜÓÃASCII±àÂë±íʾ£¬Îª´Ë£¬²»Í¬µÄ¹ú¼Ò£¬¶¼Îª×Ô¼ºµÄÓïÑÔ×öÁ˱àÂ룬±ÈÈ磬ÎÒÃǹú¼Ò£¬¾ÍÓÐGB2312±àÂë¡£µ«Ã¿¸ö¹ú¼ÒÖ®¼äµÄ±àÂ벻ͬ£¬Ò²´æÔÚ×ÅһЩ¿çƽ̨µÄÎÊÌ⣬Ϊ´Ë£¬Ò» ......
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCollations¹æ¶¨ÁËaСÓÚb£¬aµÈÓÚa£¬ÒÔ¼°aÊÇ·ñµÈÓÚAÖ®ÀàµÄ¡£Í¨³££¬´ó¼Ò»ù±¾¿ÉÒÔºöÂÔCollationsµÄ´æÔÚ£¬ÒòΪÿ¸ö×Ö·û¼¯¶¼ÓÐÒ»¸öĬÈϵÄCollations£¬Í¨³££¬Ê¹ÓÃĬÈϵÄCollations¾Í¿ÉÒÔÁË¡£
1.2 Character set
ÓëÕâ¶Ô±ÈµÄÊÇ£¬×Ö·û¼¯ÊǸö¸ü¹ãµÄ¸ÅÄ¼´Ê¹ÊÇWindowsÏÂÆÕͨµÄÎı¾Îļþ£¬Ò²Éø¼°µ½×Ö·û¼¯µÄÎÊÌâ¡£²»Í¬µÄ×Ö·û¼¯£¬¹æ¶¨Á˲»Í¬µÄ×Ö·ûµÄ±àÂ뷽ʽ¡£Ò»¸ö character set (×Ö·û¼¯)ÊÇÒ»×é·ûºÅºÍ±àÂ룬±ÈÈ磬ASCII×Ö·û¼¯£¬°üÀ¨µÄ×Ö·ûÓУºÊý×Ö£¬´óСд×Öĸ£¬·ÖºÅ¡¢»»ÐÐÖ®ÀàµÄ·ûºÅ£¬±àÂ뷽ʽÊÇÓÃÒ»¸ö7bit±íʾһ¸ö×Ö·û£¨AµÄ±àÂëÊÇ65£¬bµÄ±àÂëÊÇ98£©¡£ASCIIÖ»¹æ¶¨ÁËÓ¢ÎÄ×ÖĸµÄ±àÂ룬·ÇÓ¢ÎÄÓïÑÔ²»ÄÜÓÃASCII±àÂë±íʾ£¬Îª´Ë£¬²»Í¬µÄ¹ú¼Ò£¬¶¼Îª×Ô¼ºµÄÓïÑÔ×öÁ˱àÂ룬±ÈÈ磬ÎÒÃǹú¼Ò£¬¾ÍÓÐGB2312±àÂë¡£µ«Ã¿¸ö¹ú¼ÒÖ®¼äµÄ±àÂ벻ͬ£¬Ò²´æÔÚ×ÅһЩ¿çƽ̨µÄÎÊÌ⣬Ϊ´Ë£¬Ò» ......
1. ÓÃPHP´òÓ¡³öǰһÌìµÄʱ¼ä£¬´òÓ¡¸ñʽÊÇ2007Äê5ÔÂ10ÈÕ 22:21:21
2. PHP´úÂëÈçÏ£º
$a="hello";
$b=&$a;
unset($b);
$b="world";
echo $a;
Æä½á¹ûÊÇ£¿
3. PHP´úÂëÈçÏ£º
$str="cd";
$$str="landog";
$$str.="ok";
echo $cd;
Æä½á¹ûÊÇ£¿
4. ÓÃPHPдһ¶Î´úÂ룬ʵÏÖ²»Ê¹ÓõÚ3¸ö±äÁ¿£¬½»»»$a¡¢$bµÄÖµ£¬$a¡¢$bµÄ³õʼֵ×Ô¼º¶¨¡£
5. ¸ù¾ÝÌâĿҪÇó£¬ÓÃPHPд³ö´úÂë¡£
±íÃûUser
ID Name Tel Content Date
1 ÕÅÈý 13333663366 ´óר±ÏÒµ 2006-10-11
3 ÕÅÈý 13612312331 ±¾¿Æ±ÏÒµ 2006-10-15
5 ÕÅËÄ 020-5566556 ÖÐר±ÏÒµ 2006-10-15
4 ÍõÎå 13521212125 ´óר±ÏÒµ 2006-12-25
2 …………
6 &nbs ......
PHPÖÐÒýÓÃÖ¸µÄÊDz»Í¬µÄÃû×Ö·ÃÎÊͬһ¸ö±äÁ¿ÄÚÈÝ. µ«ÕâÓë£ÃÓïÑÔÖеÄÖ¸ÕëÊÇÓвî±ðµÄ£®£ÃÓïÑÔÖеÄÖ¸ÕëÀïÃæ´æ´¢µÄÊDZäÁ¿µÄÄÚÈÝÔÚÄÚ´æÖдæ·ÅµÄµØÖ·¡£
¹ØÓÚ¶Ô±äÁ¿£¬º¯Êý»òÕßÀàµÄÒýÓò»¶à˵£¬µ«ÒªËµÒ»ÏÂunsetÒ»¸öÒýÓã¬Ê¾Àý£º
<?php
$a = "hello";
$b =&$a;
unset($b);
echo '$a:'.$a;
//output:$a:hello
?>
//²»»á unset $a£¬Ö»ÊÇ $b¡£
global ÒýÓÃ:
µ±Óà global $var ÉùÃ÷Ò»¸ö±äÁ¿Ê±Êµ¼ÊÉϽ¨Á¢ÁËÒ»¸öµ½È«¾Ö±äÁ¿µÄÒýÓá£Ò²¾ÍÊÇ˵ºÍÕâÑù×öÊÇÏàͬµÄ¡£
$this
ÔÚÒ»¸ö¶ÔÏóµÄ·½·¨ÖУ¬$this ÓÀÔ¶Êǵ÷ÓÃËüµÄ¶ÔÏóµÄÒýÓᣠ......
package cn.com.view.read;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class ReadExcel {
public static void main(String[] args){
read("d://air.xls");
}
public static Cell[][] read(String fileName){
Workbook rwb = null;
InputStream is;
try {
is = new FileInputStream(fileName);
rwb = Workbook.getWorkbook(is);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
&nb ......
Ò»¡¢Java ClassLoader
1£¬Ê²Ã´ÊÇClassLoader
Óë C »ò C++ ±àдµÄ³ÌÐò²»Í¬£¬Java ³ÌÐò²¢²»ÊÇÒ»¸ö¿ÉÖ´ÐÐÎļþ£¬¶øÊÇÓÉÐí¶à¶ÀÁ¢µÄÀàÎļþ×é³É£¬Ã¿Ò»¸öÎļþ¶ÔÓ¦ÓÚÒ»¸ö Java Àà¡£
´ËÍ⣬ÕâЩÀàÎļþ²¢·ÇÁ¢¼´È«²¿¶¼×°ÈëÄڴ棬¶øÊǸù¾Ý³ÌÐòÐèҪװÈëÄÚ´æ¡£ClassLoader ÊÇ JVM Öн«Àà×°ÈëÄÚ´æµÄÄDz¿·Ö¡£
¶øÇÒ£¬Java ClassLoader ¾ÍÊÇÓà Java ÓïÑÔ±àдµÄ¡£ÕâÒâζ×Å´´½¨Äú×Ô¼ºµÄ ClassLoader ·Ç³£ÈÝÒ×£¬²»±ØÁ˽â JVM µÄ΢Сϸ½Ú¡£
2£¬Ò»Ð©ÖØÒªµÄ·½·¨
A)loadClass
ClassLoader.loadClass() ÊÇClassLoaderµÄÈë¿Úµã¡£¸Ã·½·¨µÄ¶¨ÒåΪ£ºClass loadClass( String name, boolean resolve );
name£ºJVM ÐèÒªµÄÀàµÄÃû³Æ£¬Èç Foo »ò java.lang.Object¡£
resolve£º²ÎÊý¸æËß·½·¨ÊÇ·ñÐèÒª½âÎöÀà¡£
B)defineClass
defineClass·½·¨ÊÇClassLoaderµÄÖ÷Òª¾÷ÇÏ¡£¸Ã·½·¨½ÓÊÜÓÉÔʼ×Ö½Ú×é³ÉµÄÊý×é²¢°ÑËüת»»³ÉClass¶ÔÏó¡£
C)findSystemClass
findSystemClass·½·¨´Ó±¾µØÎļþϵͳÖÐѰÕÒÀàÎļþ£¬Èç¹û´æÔÚ£¬¾ÍʹÓÃdefineClass½«Ôʼ×Ö½Úת»»³ÉClass¶ÔÏó£¬ÒÔ½«¸ÃÎļþת»»³ÉÀà¡£
D)resolveClass
¿ÉÒÔ²»ÍêÈ«µØ(²»´ø½âÎö)×°ÈëÀ࣬Ҳ¿ÉÒÔÍêÈ«µØ(´ø½âÎö)×°ÈëÀà¡£µ±±àдÎÒÃÇ×Ô¼ºµÄloadClassʱ¿ ......
1.final¹Ø¼ü×ÖÐÞÊÎÀàʱ£¬ËµÃ÷ÆäÀ಻ÄÜÓÐ×ÓÀ࣬Ҳ¾ÍÊÇ˵¸ÃÀ಻Äܱ»¼Ì³Ð£¬¸ÃÀàµÄ³ÉÔ±±äÁ¿ÔÚÕâÀォ²»Æð×÷Óá£
2.final¹Ø¼ü×ÖÐÞÊη½·¨Ê±£¬ËµÃ÷¸Ã·½·¨²»Äܱ»ÖØÐ´£¬ÒòΪÀà¶¼²»Äܱ»¼Ì³ÐÁË£¬·½·¨¾Í¸ü²»ÄÜÖØÐ´ÁË¡£
3.ÀàÀï¿ÉÒÔº¬ÓÐfinal¹Ø¼ü×ÖÐÞÊεķ½·¨¡£
4.ÔÚjavaÀ³éÏóÀà×îÉÙÒªº¬ÓÐÒ»¸ö³éÏó·½·¨£¬ÈÃËüµÄ×ÓÀàȥʵÏÖÕâ¸ö³éÏó·½·¨£¬³éÏóÀàÀïÒ²¿ÉÒÔ¶¨ÒåһЩ·½·¨¡£
5.³éÏóÀàÊDz»ÄÜʵÀý»¯£¬Ö»ÄÜȥʵÏÖËùÓеijéÏó·½·¨£¬·ñÔò¾ÍÖ»ÄÜ»¹ÊÇÒ»¸ö³éÏóÀà¡£
6.¼Ì³ÐÁ˳éÏóÀà¾Í±ØÐëȥʵÏָóéÏóÀàµÄ³éÏó·½·¨¡£
Èç¹û³éÏóÀàµÄ×ÓÀàûÓÐʵÏÖ¸¸ÀàµÄ³éÏó·½·¨£¬¾Í±ØÐëΪ³éÏóÀà¡£
³éÏóÀàºÍÆÕͨ¼Ì³ÐÀàÒ»Ñù£¬¶¼±ØÐëÊǵ¥¼Ì³Ð£¬»òÕßÊǶà²ã¼Ì³Ð¡£
7.½Ó¿ÚÀïµÄ³ÉÔ±±äÁ¿Ä¬ÈÏΪpublic static finalÀàÐ͵ġ£
8.½Ó¿Ú²»ÄÜÉùÃ÷ΪfinalµÄ£¬ÒòΪfinalÀàÐ͵ıØÐëҪʵÏÖ¡£½Ó¿ÚºÃ±ÈÒ»¸ö¹æ¶¨£¬½Ó¿ÚÖ»¶¨ÒåÁËÐÎʽ£¬Ã»ÓоßÌ嶨Òå²Ù×÷¡£
9.½Ó¿Ú×ñÑÀàµÄ¶¨ÒåÔÔò£¬½Ó¿ÚҲͬÑù¿ÉÒԼ̳С£µ«£¨À಻Äܶà¼Ì³Ð£¬¿ÉÒÔ¶à²ã¼Ì³Ð£©½Ó¿Ú¼È¿ÉÒÔ¶à²ã¼Ì³Ð£¬Ò²¿ÉÒÔ¶à¼Ì³Ð¡£
10.ÔÚ¶¨Òå½Ó¿ÚµÄʱºò£¬½Ó¿ÚÀïµÄ·½·¨ÊÇûÓз½·¨ÌåµÄ¡£½Ó¿ÚÀﶨÒåµÄ·½·¨ÐèÒªÔÚÆä×ÓÀàȥʵÏÖ¡£½Ó¿ÚµÄ±äÁ¿Ä¬Èϱ»ÐÞÊÎΪpublic static finalÀàÐÍ
11.½Ó¿ÚÀ ......