JavaÁ¬½ÓDB2Ïà¹Ø
1. ¹ØÓÚConnection Pool
JDBC±¾Éí²»ÌṩÁ¬½Ó³Ø¼¼Êõ£¬ÐèÒªµÚÈý·½¿âµÄÖ§³Ö¡£
ÔÚÐèҪƵ·±»ñµÃÁ¬½ÓµÄApplicationÖÐ×îºÃÓÃConnection Pool£¬ÈçWeb ApplicationÖÐ
¶ÔÓÚÒ»°ãµÄJava ApplicationÔò¿ÉÒÔÖ±½ÓÓÃJDBCÁ¬½ÓÊý¾Ý¿â¡£
2. Java ApplicationÖÐÁ¬½ÓDB2
°²×°DB2 Personal Edition V9Ö®ºó£¬ÔÚÆäÖеÄjavaĿ¼¿ÉÒÔÕÒµ½ÕâÁ½¸öÎļþ£ºdb2jcc.jar; db2jcc_license_cu.jar
db2jcc.jarÖеÄcom.ibm.db2.jcc.DB2DriverÇý¶¯³ÌÐò±»³ÆÎªÍ¨ÓÃÇý¶¯£¬ÍƼöʹÓã¨ÔÒò¿´µÚ5µã£©¡£ÔÚʹÓÃËüʱ£¬ÐèÒªdb2jcc_license_cu.jar£¬·ñÔò»áÌáʾûÓÐlicense¶øÎÞ·¨¹¤×÷¡£
DB2µÄÁ¬½ÓµØÖ·£ºjdbc:db2://localhost:50000/Database
3. Web ApplicationÖÐÁ¬½ÓDB2
Ò»¡¢ÒÔWASΪÀý£¬ÅäÖÃDB2 Data Source
1) ½øÈë¿ØÖÆÌ¨
Æô¶¯Websphere6.0·þÎñ£¬ ´ò¿ªä¯ÀÀÆ÷£¬ÔÚµØÖ·À¸ÖÐÊäÈ룺http://localhost:9060/ibm/console/£¬µÇ½Websphere6.0¹ÜÀí¿ØÖÆÌ¨
2) ÉèÖû·¾³±äÁ¿
ÔÚµ¼º½À¸×ó²àÑ¡Ôñ: Environment -> Websphere Variables, ÕÒµ½DB2UNIVERSAL_JDBC_DRIVER_PATH, ÊäÈëDB2Êý¾Ý¿âÇý¶¯jar°üµÄλÖ㬱ÈÈçC:\Program Files\IBM\SQLLIB\java¡£È·¶¨£¬±£´æ¡£
×¢Ò⣺ͨ¹ý¹ÜÀí¹¤¾ß·ÃÎÊÔ¶³Ì»úÆ÷µÄʱºò£¬ÉèÖõÄÊý¾Ý¿âÇý¶¯³ÌÐòjar°ü£¬ÐëΪӦÓ÷þÎñÆ÷ËùÔÚ»úÆ÷µÄλÖ㬶ø²»ÊDZ¾»úÇý¶¯ËùÔÚλÖ㬷ñÔò·þÎñ½«ÎÞ·¨¼ÓÔØÇý¶¯³ÌÐò£¬²âÊÔÊý¾ÝÔ´Á¬½Ó½«Ê§°Ü¡£
3) ´´½¨JDBC Provider
ÔÚµ¼º½À¸×ó²àÑ¡Ôñ: Resources -> JDBC -> JDBC Providers¡£ÔÚÓÒ²àµãNew. ÉèÖÃDatabase typeÑ¡ÔñDB2; Provider type Ñ¡Ôñ DB2 Universal JDBC Driver Provider; Implementation type Ñ¡Ôñ Connection pool data source(ÕâÀïÐèҪעÒâµÄÊÇ£¬·ÇÓ¢ÎÄÓû§¿ÉÄÜ»á³ö´í£¬Ö»Ðè´ò¿ª¿ØÖÆÃæ°å -> ÇøÓòºÍÓïÑÔÑ¡Ïî -> ÇøÓòÑ¡Ïî ÖÐµÄ ±ê×¼ºÍ¸ñʽѡ³ÉÓ¢Óï(ÃÀ¹ú)¼´¿É); Name¿ÉÒÔËæÒâÉèÖÃ; µã»÷Next; Next; Finish; Save¡£
4) ´´½¨Data source
ÔÚµ¼º½À¸×ó²àÑ¡Ôñ: Resources -> JDBC -> Data sources. ÔÚÓÒ²àµãNew. ÉèÖÃData source name; ÉèÖÃJNDI name; Next; Ñ¡Ôñ¸Õ²Åн¨µÄJDBC Provider; Next; Database name Éè³ÉÄãµÄÊý¾Ý¿âÃû; Driver type Ñ¡ 4; Server name Éè³ÉserverµÄip; Port ÉèΪ 50000; Next; Finish; Save.
5) Ñ¡Ôñ¸Õ´´½¨µÄData source, ÔÚRelated ItemsÖÐÅäÖÃJAAS, AliasÉèÖñðÃû; User IDºÍPasswordÉèΪ·
Ïà¹ØÎĵµ£º
¿ÉÒÔ°ÑÆÕͨµÄJava³ÌÐò×ö³ÉÕæÕýµÄexe,Ò²¾ÍÊǵ¥Ò»¸öexe¾Í¿ÉÒÔÔÚûÓа²×°JVMµÄ»úÆ÷ÉÏÔËÐС£ÕâÑùµÄ¹¤¾ß³£¼ûµÄÓÐJETºÍgcj.ǰÕßÊÇÊշѵ쬶øÇÒ×ö³öÀ´µÄexe»¹ÊÇÐèÒªÒ»¶Ñdll¡£ÍƼöʹÓÃgcj.ËûÓÐwindowsºÍLinux°æ£¬Ö±½ÓÏÂÔØzip°ü£¬²»ÐèÒª°²×°£¬ÀïÃæÓв»ÉÙÀý×Ó£¬Ò»Ð©buildµÄÅú´¦ÀíÎļþ¡£´ÓÔÀíÀ´Ëµgcj×Ô¼ºÊµÏÖÁËJVM¹æ·¶£¬Ò²¾ÍÊÇÄ ......
Javaµ÷Óô洢¹ý³Ì
±¾ÎIJûÊöÁËÔõôʹÓÃDBMS´æ´¢¹ý³Ì¡£ÎÒ²ûÊöÁËʹÓô洢¹ý³ÌµÄ»ù±¾µÄºÍ¸ß¼¶ÌØÐÔ£¬±ÈÈç·µ»ØResultSet¡£±¾ÎļÙÉèÄã¶ÔDBMSºÍJDBCÒѾ·Ç³£ÊìϤ£¬Ò²¼ÙÉèÄãÄܹ»ºÁÎÞÕϰµØÔĶÁÆäËüÓïÑÔд³ÉµÄ´úÂ루¼´²»ÊÇJavaµÄÓïÑÔ£©£¬µ«ÊÇ£¬²¢²»ÒªÇóÄãÓÐÈκδ洢¹ý³ÌµÄ±à³Ì¾Àú¡£
´æ´¢¹ý³ÌÊÇÖ¸±£´æÔÚ ......
1.µÃµ½µ±Ç°µÄʱ¼ä
Calendar cal = Calendar.getInstance();
String time=formatter.format(cal.getTime());
String strEnd=time.substring(0, 16);// 2007-10-30 09:30
Calendar cal = Calendar.getInstance();
String time=formatter.format(cal.getTime());
String strEnd=time.subst ......
package thread.lock;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.locks.Lock;
import java.util.concurrent.locks.ReentrantLock;
import java.util.concurrent.locks.ReentrantReadWriteLock;
/**
* @file_name ReadAndWriteLockDemo.java
* @description ¶ÁÐ ......
ժѡ×Ô¡¶Java±à³Ì˼Ïë¡·
1£® ¼Ä´æÆ÷£¨register£©¡£ÕâÊÇ×î¿ìµÄ´æ´¢Çø£¬ÒòΪËüλÓÚ²»Í¬ÓÚÆäËû´æ´¢ÇøµÄµØ·½——´¦ÀíÆ÷ÄÚ²¿¡£µ«ÊǼĴæÆ÷µÄÊýÁ¿¼«ÆäÓÐÏÞ£¬ËùÒԼĴæÆ÷ÓɱàÒëÆ÷¸ù¾ÝÐèÇó½øÐзÖÅä¡£Äã²»ÄÜÖ±½Ó¿ØÖÆ£¬Ò²²»ÄÜÔÚ³ÌÐòÖиоõµ½¼Ä´æÆ÷´æÔÚµÄÈκμ£Ïó¡£
2£®¶ÑÕ»£¨stack£©¡£Î»ÓÚͨÓÃRAM£¨random-access memory£¬ ......