×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB
CLOB£º×î´ó³¤¶È4G
NCLOB£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ×Ö·ûÊý¾Ý£¬×î´ó³¤¶È4G
ÊýÖµÀàÐÍ
NUMBER(p,s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+126 £¿£¿
ÓÐЧλ£º´Ó×ó±ßµÚÒ»¸ö²»Îª0µÄÊýËãÆðµÄλÊý
S>0£¬¾«È·µ½Ð¡ÊýµãÓÒ±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p
Eg:198.34 ànumber(6,1)à198.3,
198.34ànumber(3,1)àerror
S<0£¬¾«È·µ½Ð¡Êýµã×ó±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p+|s|
Eg:198.34ànumber(6,-1)à200
19834567.34ànumber(6,-1)àerror(ÓÐЧλ8>6+1)
S=0£¬number±íʾÕûÊý
Oracle 10gÒÔ ......
×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB
CLOB£º×î´ó³¤¶È4G
NCLOB£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ×Ö·ûÊý¾Ý£¬×î´ó³¤¶È4G
ÊýÖµÀàÐÍ
NUMBER(p,s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+126 £¿£¿
ÓÐЧλ£º´Ó×ó±ßµÚÒ»¸ö²»Îª0µÄÊýËãÆðµÄλÊý
S>0£¬¾«È·µ½Ð¡ÊýµãÓÒ±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p
Eg:198.34 ànumber(6,1)à198.3,
198.34ànumber(3,1)àerror
S<0£¬¾«È·µ½Ð¡Êýµã×ó±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p+|s|
Eg:198.34ànumber(6,-1)à200
19834567.34ànumber(6,-1)àerror(ÓÐЧλ8>6+1)
S=0£¬number±íʾÕûÊý
Oracle 10gÒÔ ......
×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB
CLOB£º×î´ó³¤¶È4G
NCLOB£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ×Ö·ûÊý¾Ý£¬×î´ó³¤¶È4G
ÊýÖµÀàÐÍ
NUMBER(p,s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+126 £¿£¿
ÓÐЧλ£º´Ó×ó±ßµÚÒ»¸ö²»Îª0µÄÊýËãÆðµÄλÊý
S>0£¬¾«È·µ½Ð¡ÊýµãÓÒ±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p
Eg:198.34 ànumber(6,1)à198.3,
198.34ànumber(3,1)àerror
S<0£¬¾«È·µ½Ð¡Êýµã×ó±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ<=p+|s|
Eg:198.34ànumber(6,-1)à200
19834567.34ànumber(6,-1)àerror(ÓÐЧλ8>6+1)
S=0£¬number±íʾÕûÊý
Oracle 10gÒÔ ......
´ó¼Ò¶¼ÖªµÀJAVAÖÐ int ÀàÐÍҪת»¯³É String ÀàÐÍ£¬¿ÉÒÔÓÐÈýÖÖ·½Ê½£¬·Ö±ðÊÇ£º
* (1) String.valueOf(i)
* (2) Integer.toString(i)
* (3) i+""
ÒòΪǰÁ½Ì죬дһ¸ö³ÌÐòʱ£¬ÒªÓõ½ int ת String ,²¢ÇÒÊý¾ÝÁ¿ºÜ´ó£¬Òò´ËÏë¿´¿´ÕâÈýÖÖ·½Ê½µÄЧÂÊÔõÑù£¬Ð´ÁËһϼòµ¥µÄ²âÊÔ³ÌÐò£¬Ôڴ˼ǼһÏ¡£
Java´úÂë
public class TestIntToStr {
public static void main(String[] args) {
int[] intArr = new int[1000000];
String[] strArr1 = new String[1000000];//ΪÁ˹«Æ½·Ö±ð¶¨ÒåÈý¸öÊý×é
String[] strArr2 = new String[1000000];
String[] strArr3 = new String[1000000];
//¸³Öµ
Long t1 = System.currentTimeMillis();
for(int i=0;i<1000000;i++){   ......
ÒýÑÔ
ÓÐJAVA¿ª·¢¾ÑéµÄÅóÓÑÃÇÒ»¶¨Åöµ½¹ýÏÂÃæµÄÕâÖÖÇé¿ö,ÄǾÍÊÇ×Ô¼ºËù¿ª·¢µÄÓ¦ÓÃÔËÐÐÁËÒ»¶Îʱ¼äºóÆäÐÔÄÜ»ò ÕßÏìÓ¦ËÙ¶È»áÓÐÃ÷ÏԵĽµµÍ.ÕâÊÇÓÉ¶à·½ÃæµÄÔÒòÔì³ÉµÄ¼´ÓгÌÐò±¾ÉíµÄÓÅ»¯ÎÊÌâ,Ò²ÓÐÔËÐл·¾³ÎÊÌâ.´ËÔËÐл·¾³¼´°üÀ¨Ó²¼þ»·¾³Ò²°üÀ¨Èí¼þ»·¾³.´ó¶àÊýÈ˵ÚÒ» ¸öÄÜÏëµ½µÄ½â¾ö·½·¨ÊÇÌáÉýÓ²¼þµÄÅäÖöøºöÂÔÁ˳ÌÐò±¾ÉíµÄÔËÐл·¾³JVMÒ²ÌṩÁ˱Ƚ϶àµÄµ÷ÓÅÑ¡Ïî.±¾ÎĽ«ÖصãÃèÊöÀûÓÃJVMµÄһЩѡÏî¶ÔGC½øÐе÷ÓÅ.
Ô¼¶¨:
1.¶ÁÕßÓ¦¾ß±¸Ò»¶¨JAVAµÄ֪ʶ.
2.±¾ÎÄÖеÄJVMÑ¡Ïî¾ùÒÔSUN¹«Ë¾·¢²¼µÄHotSpot JVM 5Ϊ׼£¨²»¹ý´ó¶àÊýµÄÑ¡ÏîÔÚJVM1.3,JVM1.4ÖÐÒ²ÊÇ¿ÉÓõģ©.
3.ÒÔJAVA_HOMEÏÂdemo/jfc/SwingSet2/SwingSet2.jarΪÀý½øÐÐ˵Ã÷.
4.ÔĶÁ±¾ÎÄÐèҪһЩ¹ØÓÚGCµÄ֪ʶ£¬¿ÉÒÔµ½¸½Â¼AÖÐÁ˽âÕâЩ֪ʶ¡£
¹Ø¼ü×Ö:
JVM(javaÐéÄâ»ú),µ÷ÓÅ,GC(À¬»ø»ØÊÕ)
JVM GCµ÷ÓÅ
ΪÁËÄܹ»½«JVM GCµÄµ÷ÓÅÄܹ»Ê¹ÓÃÔÚ¾ßÌåµÄʵ¼ùµ±ÖÐ,ÏÂÃæ½«ÀûÓÃÈô¸É¸öÀý×ÓÀ´ËµÃ÷GCµÄµ÷ÓÅ.
Àý1£ºHeap size ÉèÖÃ
JVM ¶ÑµÄÉèÖÃÊÇÖ¸java³ÌÐòÔËÐйý³ÌÖÐJVM¿ÉÒÔµ÷ÅäʹÓõÄÄÚ´æ¿Õ¼äµÄÉèÖÃ.JVMÔÚÆô¶¯µÄʱºò»á×Ô¶¯ÉèÖÃHeap sizeµÄÖµ£¬Æä³õʼ¿Õ¼ä(¼´-Xms)ÊÇÎïÀíÄÚ´æµÄ1/64£¬×î´ó¿Õ¼ä(-Xmx)ÊÇÎïÀíÄÚ´æµÄ1/4¡£¿ÉÒÔÀûÓÃJVMÌṩµÄ-Xmn -Xms -Xm ......
JAVA·´Éä»úÖÆÊÇÔÚÔËÐÐ״̬ÖÐ,¶ÔÓÚÈÎÒâÒ»¸öÀà,¶¼Äܹ»µÃµ½Õâ¸öÀàµÄËùÓÐÊôÐԺͷ½·¨;¶ÔÓÚÈÎÒâÒ»¸ö¶ÔÏó,¶¼Äܹ»µ÷ÓÃËüµÄÈÎÒâÒ»¸ö·½·¨;ÕâÖÖ¶¯Ì¬»ñÈ¡µÄÐÅÏ¢ÒÔ¼°¶¯Ì¬µ÷ÓöÔÏóµÄ·½·¨µÄ¹¦ÄܳÆÎªjavaÓïÑԵķ´Éä»úÖÆ.
¸ÅÀ¨Ò»ÏÂ:
·´Éä¾ÍÊÇÈÃÄã¿ÉÒÔͨ¹ýÃû³ÆÀ´µÃµ½¶ÔÏó(Àà,ÊôÐÔ,·½·¨)µÄ¼¼Êõ¡£
ÀýÈçÎÒÃÇ¿ÉÒÔͨ¹ýÀàÃûÀ´Éú³ÉÒ»¸öÀàµÄʵÀý;
ÖªµÀÁË·½·¨Ãû,¾Í¿ÉÒÔµ÷ÓÃÕâ¸ö·½·¨;ÖªµÀÁËÊôÐÔÃû¾Í¿ÉÒÔ·ÃÎÊÕâ¸öÊôÐÔµÄÖµ¡£
1¡¢»ñÈ¡Àà¶ÔÓ¦µÄClass¶ÔÏó
ÔËÓÃ(ÒÑÖª¶ÔÏó)getClass():ObjectÀàÖеķ½·¨,ÿ¸öÀà¶¼ÓµÓд˷½·¨¡£
Èç: String str = new String();
Class strClass = str.getClass();ÔËÓÃ(ÒÑÖª×ÓÀàµÄclass) Class.getSuperclass():ClassÀàÖеķ½·¨,·µ»Ø¸ÃClassµÄ¸¸ÀàµÄClass;ÔËÓÃ(ÒÑÖªÀàÈ«Ãû):Class.forName() ¾²Ì¬·½·¨ÔËÓÃ(ÒÑÖªÀà): ÀàÃû.class
2¡¢Í¨¹ýÀàÃûÀ´¹¹ÔìÒ»¸öÀàµÄʵÀý
a¡¢µ÷ÓÃÎ޲εĹ¹Ô캯Êý:
Class newoneClass = Class.forName(ÀàÈ ......
½ñÈÕÔÚÍøÉÏżȻÅöµ½Ò»¸ö³õѧÕßµÄjavaÌâÄ¿£¬¾Í³¢ÊÔµÄ×öÁËһϣ¬µ«Ã»Ïëµ½Ò»×ö¾ÍÊǽӽüÒ»¸öÖÓÍ·°¡£¬¿´À´javaѧϰµÄ·ÉÏ»¹ÊÇ·ÂþÂþÙâÐÞÔ¶°¡¡£
ÌâÄ¿ÈçÏ£º
±àдһ¸öJava Application ³ÌÐò£¬½ÓÊÜÓû§ÊäÈëµÄÒ»¸ö¸¡µãÊý£¬½«ÆäµÄÕûÊý²¿·ÖºÍСÊý²¿·Ö·Ö±ðÊä³ö¡£
È磺ÊäÈë56.6 £¬ÔòÓÐ
¡¡¡¡¡¡¡¡¡¡¡¡ÕûÊý²¿·Ö£º56
¡¡¡¡¡¡¡¡¡¡¡¡Ð¡Êý²¿·Ö£º0.6
¡¡¡¡ÊäÈë-56.6 £¬ÔòÓÐ
¡¡¡¡¡¡¡¡¡¡¡¡ÕûÊý²¿·Ö£º-56
¡¡¡¡¡¡¡¡¡¡¡¡Ð¡Êý²¿·Ö£º-0.6
ÎÒÒ»¿ªÊ¼µÄ˼·ºÜ¼òµ¥¾ÍÊǽÓÊÕÒ»¸ödoubleÀàÐ͵ÄÓû§ÊäÈëd£¬È»ºóÓÃMath.floor()º¯ÊýºÍMath.ceil()À´ÇóÆäÕûÊý²¿·Ö£¬È»ºó½«Æäת»»³ÉintÐÍi¡£È»ºóÓÃd-iÇóÆäСÊý²¿·Ö¡£´úÂëÈçÏ£º
public static void main(String[] args) {
Scanner input = new Scanner(System.in);
System.out.println("Input your double number?");
double d = input.nextDouble();
if (d >= 0) {
&nb ......
´Ë¸öÀàÊÇΪÁË·½±ã³õѧÕß¶ÔXMLµ½ javabean µÄÏ໥ת»»²»ÊìϤ¶øÐ´µÄ:
import com.thoughtworks.xstream.XStream;
import com.thoughtworks.xstream.io.xml.DomDriver;
public class XmlBean {
/*
* @AUTHOR:ZHONG
* @CREATETIME:2010/02/10
* @PREAM:OBJECT(JAVABEAN)
* @RETURN:XML STRING
*/
public static String GenerateXML(Object model){
XStream xstream = new XStream(new DomDriver());
//ת»»³É xml ¸ñʽ
String xml = xstream.toXML(model);
return xml;
}
/*
* @AUTHOR:ZHONG
* @CREATETIME:2010/02/10
* @PREAM:STRING(XML)
* @RETURN:(javabean)OBJECT
*/
public static Object fromXML(String xmlString){
XStream xs = new XStream(new DomDriver());
Object ob = xs.fromXML(xmlString);
System.out.println(ob);
return ob;
}
ʹÓÃʵ ......