JAVA·ÃÎÊfirebirdÊý¾Ý¿âÖ®Jaybird
¹ØÓÚJaybird-2.1.6JDK_1.5µÄʹÓ÷½·¨ÈçÏ£º
Ê×ÏÈ£º°²×°Jaybird
µÚÒ»²½£º½«¸ùĿ¼ÏµÄ
jaybird21.dll,
GDS32.DLL,
icudt30.dll,
icuuc30.dll,
fbembed.dll,
icuin30.dll
fbclient.dll(¶ÔÓÚ·ÇǶÈëʽÐÍFBÊý¾Ý¿âµÄÁ¬½ÓΪ±ØÐë)
Õ⼸¸öÎļþ·ÅÔÚsystem32ÏÂÃæ
µÚ¶þ²½:°Ñ jaybird ÀïµÄÈý¸öjarÎļþ·ÅÔÚÓ¦ÓóÌÐòµÄÏàÓ¦µÄclasspathÀï,È»ºó
µÚÈý²½£º
¼ÓÔØʵÀý£º
¹ØÓÚʵÀýÎļþDataSourceExample.javaµÄʹÓÃ
Èç¹ûÊÇÁ¬½Ó·ÇǶÈëʽFBÊý¾Ý¿â£¬Ôò½«
dataSource.setType("EMBEDDED");¸ÄΪdataSource.setType("LOCAL")
¡¾Î»ÓÚDataSourceExample.javaÔ´ÎļþÖУ¬Èç¹û²»Ð޸ģ¬ÔòÏÔʾ²»ÄÜÁ¬½Ó³É¹¦¡¿
Æä´Î£º
javaÖÐÁ¬½ÓÎļþµÄд·¨£º
driverName = "org.firebirdsql.jdbc.FBDriver";
URLName = "jdbc:firebirdsql:embedded:E:/Project/test.fdb";
user = "sysdba";
password = "masterkey";
½ñÈÕ£ºÑо¿FBÊý¾Ý¿âÐí¾Ã£¬²Î¿¼ÁËÍøÓѵÄ×ÊÁÏ£¬²»Ê¤¸Ð¼¤£¡ÓÚMyEclipse6.0.1Éϵ÷ÊԳɹ¦£¬ÔÚ´Ëͬ´ó¼Ò·ÖÏí¡£
DLL×ÊÔ´£º¼ûÎÒµÄ×ÊÔ´£¡£¡£¡
Ïà¹ØÎĵµ£º
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔÇ°£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......
Ò»¡¢JDBCµ÷Óô洢¹ý³Ì
creat proc proc_select
¡¡¡¡@pid varchar(20)
¡¡¡¡@address varchar(20) output
¡¡¡¡as
¡¡¡¡select @address=address from userinfo where pid=@pid
¡¡¡¡go
¡¡¡¡ÓÃjavaµ÷ÓÃ:
¡¡¡¡class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\"); //¼ÓÔØÇý¶¯
¡¡¡¡Connection con=DriverManager.ge ......
ʹÓÃJava·¢ËÍGET¡¢POSTÇëÇó
——½ÚÑ¡×Ô¡¶·è¿ñJava½²Òå¡·
URLµÄopenConnection()·½·¨½«·µ»ØÒ»¸öURLConnection¶ÔÏ󣬸öÔÏó±íʾӦÓóÌÐòºÍ URL Ö®¼äµÄͨÐÅÁ´½Ó¡£³ÌÐò¿ÉÒÔͨ¹ýURLConnectionʵÀýÏò¸ÃURL·¢ËÍÇëÇ󡢶ÁÈ¡URLÒýÓõÄ×ÊÔ´¡£
ͨ³£´´½¨Ò»¸öºÍ URL µÄÁ¬½Ó£¬²¢·¢ËÍÇëÇ󡢶ÁÈ¡´Ë URL ÒýÓõÄ×ÊÔ´ÐèÒªÈçÏ ......
TBCPMessageFactory.java
/**
* ÎļþÃû: TBCPMessageFactory.java
*/
package tbcpstack;
import java.text.MessageFormat;
import org.apache.log4j.Logger;
import TBCPException;
/**
*
* TODO TBCPÏûÏ¢¹¹½¨¹¤³§
*/
public class TBCPMessageFactory {
/**
* Logger for this class
......
²»ÌᳫʹÓõķ½·¨ÊÇΪ֧³ÖÏòºó¼æÈÝÐÔ¶ø±£ÁôµÄÄÇЩ·½·¨£¬ËüÃÇÔÚÒÔºóµÄ°æ±¾ÖпÉÄܳöÏÖ£¬Ò²¿ÉÄܲ»³öÏÖ¡£Java ¶àÏß³ÌÖ§³ÖÔÚ°æ±¾ 1.1 ºÍ°æ±¾ 1.2 ÖÐ×öÁËÖØ´óÐÞ¶©£¬stop()¡¢suspend() ºÍ resume() º¯ÊýÒѲ»ÌᳫʹÓá£ÕâЩº¯ÊýÔÚ JVM ÖпÉÄÜÒýÈë΢ÃîµÄ´íÎó¡£ËäÈ»º¯ÊýÃû¿ÉÄÜÌýÆðÀ´ºÜÓÕÈË£¬µ«ÇëµÖÖÆÓÕ»ó²»ÒªÊ¹ÓÃËüÃÇ¡£
µ÷ÊÔÏ̻߳¯µÄ ......