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Öе÷ÓÃservlet˵Ã÷£º
ÎÒÃÇÓÐʱ¿ÉÄÜÐèÒªÔÚJavaÀàÖе÷ÓÃServlet´Ó¶øÊµÏÖÄ³Ð©ÌØÊâµÄ¹¦ÄÜ£¬ÔÚJavaAPIÖÐÌṩÁËÒ»¸öURLµÄÀ࣬ÆäÖÐopenStream( )·½·¨¿ÉÒÔ´ò¿ªURLµÄÁ¬½Ó£¬²¢·µ»ØÒ»¸öÓÃÓÚ¸ÃÁ¬½Ó¶ÁÈëµÄInputStream¡£
¶þ¡¢JavaÖе÷ÓÃservletÓ¦ÓþÙÀý£º
package com.solid.test;
import java.io.BufferedReader;
import ja ......
´ÓʱàÂë7Äê¶àÁË
¶ÔÓÚjava ºÍc# ÎÒÓÐ×Å×Ô¼ºµÄÀí½â
ÔÚ2009ÄêµÄ9ÔÂÕâ¸öʱ¼äµãÎÒ¿´À´java c#ÊÇÐÂʽÓïÑԵĴú±í
{ÒòΪÎÒÈÏΪ¼ÆËã»úµÄ·¢Õ¹Àú³ÌÊÇ
µÚÒ»½×¶Î ´ò¿×»ú(¶þ½øÖÆ),
µÚ2½×¶Î »ã±à, (±È¶þ½øÖÆ·½±ãµÄÓïÑÔ),
µÚ3½×¶Î c (¸üÒ×ÓÚ¿´Ã÷°×µÄ¸ß¼¶ÓïÑÔ),
µÚ4½×¶ÎµÚ1²ã c++ (´Ó¶ÔÏó½Ç¶ÈÀí½âµÄ¸ß¼¶ÓïÑÔ),
µÚ4½×¶ÎµÚ2² ......
¶ÔÓÚÔÓïÀàÐ͵ÄÊý×飬Èçint[] a,ÔÚCÀïÃæÖ»ÒªÕâÑù¶¨ÒåÖ®ºó¾Í¿ÉÒÔÓÃa[i]ʹÓÃÁË£¬µ«ÊÇÔÚJAVAÀïÃæÊDz»Ðе쬱ØÐëÓÃint[] a = new int[LENGTH];À´ÎªÊý×é·ÖÅä¿Õ¼ä¡£ÕâÀïµÄa¸üÓ¦¸Ã¿´³ÉCÀïÃæµÄÖ¸Õ룬ËüºÍCÀïÃæµÄint* aÊÇÒ»ÑùµÄ£¬ÒòΪÕâ¸öa£¨CÀïÃæµÄ£©Ò²ÒªÏÈmallocÒ»¸ö¿Õ¼äÖ®ºó²Å¿ ......
ÔÚ¡¶JDBC Driver For SQL2000/2005/2008
¡·Ò»ÎÄÖУ¬ÑûÔ½éÉÜÁËÈçºÎÏÂÔØ²¢Ê¹ÓÃjdbcÁ¬½ÓSQL Server,
½ñÌìÓÐÈËÎÊÆð£¬ÈçºÎÒÔwindows¼¯³É·½Ê½Á¬½ÓSQL Server,Õâ¸öÒÔÇ°ÕæÃ»ÊÔ¹ý¡£
ÓÚÊÇ£¬´ò¿ªnetBeans²âÊÔÁËһϣ¬´úÂëÈçÏ£º
/*
* To change this template, choose Tools | Templates
* and open the template in the edit ......
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 ¶ÁÐ ......