StringBufferÒ²ÊÇ×Ö·û´®£¬ÓëString²»Í¬µÄÊÇStringBuffer¶ÔÏó´´½¨ÍêÖ®ºó¿ÉÒÔÐÞ¸ÄÄÚÈÝ¡£ÓÐÈçϹ¹Ô캯Êý£º
n public StringBuffer(int);
n public StringBuffer(String);
n public StringBuffer();
µÚÒ»ÖÖ¹¹Ô캯ÊýÊÇ´´½¨Ö¸¶¨´óСµÄ×Ö·û´®£¬µÚ¶þ¸ö¹¹Ô캯ÊýÊÇÒÔ¸ø¶¨µÄ×Ö·û´®´´½¨StringBuffer¶ÔÏ󣬵ÚÈý¸ö¹¹Ô캯ÊýÊÇĬÈϵĹ¹Ô캯Êý£¬Éú³ÉÒ»¸ö¿ÕµÄ×Ö·û´®¡£ÏÂÂô۵ĴúÂë·Ö±ðÉú³ÉÁË3¸öStringBuffer¶ÔÏó£º
StringBuffer sb1 = new StringBuffer(50);
StringBuffer sb2 = new StringBuffer("×Ö·û´®³õʼֵ");
StringBuffer sb3 = new StringBuffer();
StringBuffer¶ÔÏó´´½¨ÍêÖ®ºó£¬´óС»áËæ×ÅÄÚÈݵı仯¶ø±ä»¯¡£
StringBufferµÄ³£Ó÷½·¨¼°ÆäÓ÷¨ÈçÏ¡£
ÔÚ×Ö·û´®ºóÃæ× ......
StringÊDZȽÏÌØÊâµÄÊý¾ÝÀàÐÍ£¬Ëü²»ÊôÓÚ»ù±¾Êý¾ÝÀàÐÍ£¬µ«ÊÇ¿ÉÒÔºÍʹÓûù±¾Êý¾ÝÀàÐÍÒ»ÑùÖ±½Ó¸³Öµ£¬²»Ê¹ÓÃnew¹Ø¼ü×Ö½øÐÐʵÀý»¯¡£Ò²¿ÉÒÔÏñÆäËûÀàÐÍÒ»ÑùʹÓùؼü×Önew½øÐÐʵÀý»¯¡£ÏÂÃæµÄ´úÂë¶¼ÊǺϷ¨µÄ£º
String s1 = "this is a string!";
String s2 = new String("this is another string!");
ÁíÍâStringÔÚʹÓõÄʱºò²»ÐèÒªÓÃimportÓï¾äµ¼È룬»¹¿ÉÒÔʹÓÓ+”ÕâÑùµÄÔËËã·û¡£Èç¹ûÏë°Ñ×Ö·û´®Á¬½ÓÆðÀ´£¬¿ÉÒÔʹÓÓ+”Íê³É¡£ÀýÈ磺s1+s2¡£
StringµÄһЩ³£Ó÷½·¨ÈçÏ¡£ÎªÁË˵Ã÷·½·¨£¬·½·¨ÖÐʹÓõÄʾÀý×Ö·û´®Îª£ºstr=“this is a test!”;
Ç󳤶È
·½·¨¶¨Ò壺public int length() ¡£
·½·¨ÃèÊö£º»ñÈ¡×Ö·û´®ÖеÄ×Ö·ûµÄ¸öÊý¡£
ÀýÈ磺
str.length()
½á¹û£º
15
»ñÈ¡×Ö·û´®ÖеÄ×Ö·û
·½·¨¶¨Ò壺public char charAt(int index)¡£
·½·¨ÃèÊö£º»ñÈ¡×Ö·û´®ÖеĵÚindex¸ö×Ö·û£¬´Ó0 ¿ªÊ¼¡£
ÀýÈ磺
str.charAt(3)
½á¹û£º
s
×¢Ò⣺ÊǵÚ4 ¸ö×Ö·û¡£
È¡×Ó´®
ÓÐÁ½ÖÖÐÎʽ¡£ÐÎʽһÈçÏ£º
·½·¨¶¨Ò壺public String substring(int beginIndex,int endIndex)¡£
·½·¨ÃèÊö£º»ñÈ¡´ÓbeginIndex ¿ªÊ¼µ½endIndex ½áÊøµÄ×Ó´®£¬°üÀ¨begin ......
±¾´Î½éÉܵÄStringµÄ·½·¨°üÀ¨£º±È½ÏÄÚÈÝ¡¢´óСдת»»¡¢Ç°×ººÍºó׺£¬²¢¸ø³öÁËÒ»¸öÀý×Ó¡£
±È½Ï×Ö·û´®ÄÚÈÝ
Á½ÖÖÐÎʽ¡£ÐÎʽһÈçÏ£º
·½·¨¶¨Ò壺public boolean equals(Object o)
·½·¨ÃèÊö£º±È½ÏÊÇ·ñÓë²ÎÊýÏàͬ£¬Çø·Ö´óСд¡£
ÀýÈ磺
str.equals(“this”)
½á¹û£º
False
ÐÎʽ¶þÈçÏ£º
·½·¨¶¨Ò壺public boolean equalsIgnoreCase(Object o)
·½·¨ÃèÊö£º±È½ÏÊÇ·ñÓë²ÎÊýÏàͬ£¬²»Çø·Ö´óдС¡£
ÀýÈ磺
str.equalsIgnoreCase(“this”)
½á¹û£º
False
´óСдת»»
ת»»³É´óд»òÕßת»»³ÉСд¡£
ת»»³É´óд£º
·½·¨¶¨Ò壺public String toUpperCase()
·½·¨ÃèÊö£º°Ñ×Ö·û´®ÖеÄËùÓÐ×Ö·û¶¼×ª»»³É´óд¡£
ÀýÈ磺
str.toUpperCase()
½á¹û£º
THIS IS A TEST!
ת»»³ÉСд£º
·½·¨¶¨Ò壺public String toLowerCase()
·½·¨ÃèÊö£º°Ñ×Ö·û´®ÖеÄËùÓÐ×Ö·û¶¼×ª»»³ÉСд¡£
ÀýÈ磺
str.toLowerCase()
½á¹û£º
this is a test!
ǰ׺ºÍºó׺
ÅжÏ×Ö·û´®ÊÇ·ñÒÔÖ¸¶¨µÄ²ÎÊý¿ªÊ¼»òÕß½áβ¡£
ÅжÏǰ׺£º
·½·¨¶¨Ò壺public boolean startsWith(String prefix)
·½·¨ÃèÊö£º×Ö·û´®ÊÇ·ñÒÔ²ÎÊýÖ¸¶¨µÄ×Ó´®ÎªÇ°×º¡£
ÀýÈ磺
str.startsWith(“this”)
½á ......
ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖÎïÀíÊý¾Ý¿âÉè¼Æ¼¼Êõ£¬DBAºÍÊý¾Ý¿â½¨Ä£ÈËÔ±¶ÔÆäÏ൱ÊìϤ¡£ËäÈ»·ÖÇø¼¼Êõ¿ÉÒÔʵÏֺܶàЧ¹û£¬µ«ÆäÖ÷ҪĿµÄÊÇΪÁËÔÚÌØ¶¨µÄSQL²Ù×÷ÖмõÉÙÊý¾Ý¶ÁдµÄ×ÜÁ¿ÒÔËõ¼õÏìӦʱ¼ä¡£
·ÖÇøÖ÷ÒªÓÐÁ½ÖÖÐÎʽ£º//ÕâÀïÒ»¶¨Òª×¢ÒâÐкÍÁеĸÅÄrowÊÇÐУ¬columnÊÇÁУ©
1. ˮƽ·ÖÇø£¨Horizontal Partitioning£©ÕâÖÖÐÎʽ·ÖÇøÊǶԱíµÄÐнøÐзÖÇø£¬Í¨¹ýÕâÑùµÄ·½Ê½²»Í¬·Ö×éÀïÃæµÄÎïÀíÁзָîµÄÊý¾Ý¼¯µÃÒÔ×éºÏ£¬´Ó¶ø½øÐиöÌå·Ö¸î£¨µ¥·ÖÇø£©»ò¼¯Ìå·Ö¸î£¨1¸ö»ò¶à¸ö·ÖÇø£©¡£ËùÓÐÔÚ±íÖж¨ÒåµÄÁÐÔÚÿ¸öÊý¾Ý¼¯Öж¼ÄÜÕÒµ½£¬ËùÒÔ±íµÄÌØÐÔÒÀÈ»µÃÒÔ±£³Ö¡£
¾Ù¸ö¼òµ¥Àý×Ó£ºÒ»¸ö°üº¬Ê®Ä귢Ʊ¼Ç¼µÄ±í¿ÉÒÔ±»·ÖÇøÎªÊ®¸ö²»Í¬µÄ·ÖÇø£¬Ã¿¸ö·ÖÇø°üº¬µÄÊÇÆäÖÐÒ»ÄêµÄ¼Ç¼¡££¨ÅóÞÈ×¢£ºÕâÀï¾ßÌåʹÓõķÖÇø·½Ê½ÎÒÃǺóÃæÔÙ˵£¬¿ÉÒÔÏÈ˵һµã£¬Ò»¶¨ÒªÍ¨¹ýij¸öÊôÐÔÁÐÀ´·Ö¸î£¬Æ©ÈçÕâÀïʹÓõÄÁоÍÊÇÄê·Ý£©
2. ´¹Ö±·ÖÇø£¨Vertical Partitioning£© ÕâÖÖ·ÖÇø·½Ê½Ò»°ãÀ´ËµÊÇͨ¹ý¶Ô±íµÄ´¹Ö±»®·ÖÀ´¼õÉÙÄ¿±ê±íµÄ¿í¶È£¬Ê¹Ä³Ð©Ìض¨µÄÁÐ ±»»®·Öµ½Ìض¨µÄ·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼°üº¬ÁËÆäÖеÄÁÐËù¶ÔÓ¦µÄÐС£
¾Ù¸ö¼òµ¥Àý×Ó£ºÒ»¸ö°üº¬ÁË´ótextºÍBLOBÁÐµÄ±í£¬ÕâЩtextºÍBLOBÁÐÓÖ²»¾³£±»·ÃÎÊ£¬Õâʱºò¾ÍÒª°ÑÕâЩ²»¾³£Ê¹Óà ......
²»ÖªµÀ´ó¼ÒÔÚʹÓÃJBOSS ʱ£¬ÓöûÓöµ½ /opt/jboss/server/default/data/hypersonic/localDB.data ³¬¹ý2G µÄÇé¿ö£¿
Õâ¸öÎÊÌâÀ§ÈÅÁËÎÒÃǺܾã¬ÒòΪÔÚ´ïµ½Õâ¸ö2GµÄ¼«ÏÞʱ JBOSS DOWN µôÁË£¬ËùÓÐÄ£¿é¶¼²»ÄÜÕý³£Í¨ÐÅÁË£¬ÆäËðʧ³Ì¶È¿ÉÏë¶øÖª¡£
ʹÓÃmysql ´úÌæ localDB.data ½«ÕâÒ»ÎÊÌâ³¹µ×½â¾ö¡£
ÏÖ½«·½·¨¹²Ïí£¬ÈçÏ¡£
mysql °²×°£¬ÕâÀï¾Í²»×¸ÊöÁË¡£
1¡¢½¨Á¢Ò»¸ömysqlµÄjndi£º¸´ÖÆ$JBOSS_HOME/docs/examples/jca/mysql-ds.xmlµ½
$JBOSS_HOME/server/default/deploy/mysql-ds.xml ²¢ÐÞ¸ÄÏàÓ¦µÄÓû§Ãû£¬ÃÜÂ룬jndiÃû
2¡¢¸´ÖÆ$JBOSS_HOME/docs/examples/jms/mysql-jdbc2-service.xmlµ½
$JBOSS_HOME/server/default/deploy/jms/mysql-jdbc2-service.xml²¢Ð޸ĸÄÎļþÖеÄ
“<depends optional-attribute-name="ConnectionManager">
jboss.jca:service=DataSourceBinding,name=ÄãµÄjndiÃû
</depends>”
3¡¢É¾³ý$JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml
4¡¢ÐÞ¸Ä$JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc-state-service.xmlÖеÄ
“<depends optional-attribute-name=" ......
phpmyadmin2.11.92 --APMSEVR5.2.6
д´æ´¢¹ý³ÌʱÌáʾerror 1307 (HY000):Failed to create procedure...
-----------------------------------------------------------------------
½«phpmyadminÖеÄmysqlÊý¾Ý¿âÖеıíprocɾ³ý
Ö´ÐÐÒÔÏ´úÂëÖØ½¨¸Ã±í
------------------------------------------------------------------------
CREATE TABLE `proc` (
`db` char(64) character set utf8 collate utf8_bin NOT NULL default '',
`name` char(64) NOT NULL default '',
`type` enum('FUNCTION','PROCEDURE') NOT NULL,
`specific_name` char(64) NOT NULL default '',
`language` enum('SQL') NOT NULL default 'SQL',
`sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL',
`is_deterministic` enum('YES','NO') NOT NULL default 'NO',
`security_type` enum('INVOKER','DEFINER') NOT NULL default 'DEFINER',
`param_list` blob NOT NULL,
`returns` char(64) NOT NULL default '',
`body` longblob NOT NULL,
`definer` char(77) character set utf8 collate utf8_bin NOT NULL de ......