java ¸÷ÖÖÊý¾Ý¿âÁ¬½Ójdbc
JDBC Name: jTDS
URL: http://jtds.sourceforge.net/
Version: 0.5.1
Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291
Óï·¨:
Class.forName("net.sourceforge.jtds.jdbc.Driver
");
Connection con =
DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");
or
Connection con =
DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");
MySQL
JDBC Name: Connector/J 3.0
URL: http://www.mysql.com/
Version: 3.0.8-stable
Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html
Óï·¨:
Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html
Óï·¨:
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");
Oracle
JDBC Name: Connector/J 3.0
URL: http://otn.oracle.com/
Version: 3.0.8-stable
Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
Óï·¨:
Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
Óï·¨:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con =
DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");
Sybase
Driver: jConnect 4.5/5.5 (JDBC 2.0 ÇëʹÓÃ5.5)
Óï·¨:
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
DriverManager.getConnection("jdbc:sybase:Tds:IPµØÖ·:2638?ServiceName="+Êý¾Ý¿âÃû³Æ,"Õ˺Å","ÃÜÂë");
Postgresql
JDBC Name: PostgreSQL JDBC
URL: http://jdbc.postgresql.org/
Version: 7.3.3
build 110
Download URL: http://jdbc.postgresql.org/download.html
Óï·¨:
Download URL: http://jdbc.postgresql.org/download.html
Óï·¨:
Class.forName("org.postgresql.Driver");
Connection
con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");
IBM AS400Ö÷»úÔÚÓõÄJDBCÓï·¨
ÓÐ×°V4R4ÒÔÉϰ汾µÄClient Access Express
¿ÉÒÔÔÚC:Program
FilesIBMClient
Ïà¹ØÎĵµ£º
1.±äÁ¿£º
¶ÔÓÚ»ù±¾ÀàÐ͵ÄÈ«¾Ö±äÁ¿£¬ÈôûÓгõʼ»¯£¬ÏµÍ³»á×Ô¶¯³õʼ»¯Îª¸ÃÀàÐ͵ijõʼֵ£»¶ø¶ÔÓÚ¾Ö²¿±äÁ¿£¬Ôò±ØÐëÏÔʾµÄ½øÐгõʼ»¯¡£
2.³£Á¿£º
final int M_Max=111;
final±íʾֻÄܸø±äÁ¿M_MAX¸³ÖµÒ»´Î£¬¸³ÖµÖ®ºó£¬M_MAXµÄÖµ¾Í²»¿ÉÒÔÖØÐ¸³Öµ¡£Ëù¸³µÄÖµ¿ÉÒÔÊÇÒ»¸ö±í´ïʽ£¬Ò²¿ÉÒÔÊÇÒ»¸ö¾ßÌåµÄÖµ¡£
3.Àà³£Á¿£º
static fina ......
Àà¼ÓÔØÆ÷ÊÇ Java ÓïÑÔµÄÒ»¸ö´´Ð£¬Ò²ÊÇ Java ÓïÑÔÁ÷ÐеÄÖØÒªÔÒòÖ®Ò»¡£ËüʹµÃ Java Àà¿ÉÒÔ±»¶¯Ì¬¼ÓÔØµ½ Java ÐéÄâ»úÖв¢Ö´ÐС£Àà¼ÓÔØÆ÷´Ó JDK 1.0 ¾Í³öÏÖÁË£¬×î³õÊÇΪÁËÂú×ã Java Applet µÄÐèÒª¶ø¿ª·¢³öÀ´µÄ¡£Java Applet ÐèÒª´ÓÔ¶³ÌÏÂÔØ Java ÀàÎļþµ½ä¯ÀÀÆ÷Öв¢Ö´ÐС£ÏÖÔÚÀà¼ÓÔØÆ÷ÔÚ Web ÈÝÆ÷ºÍ OSGi Öеõ½Á˹㷺µÄʹÓá ......
ÏÂÔØµØÖ· ¿ÉÒÔÔÚeclpseÖÐÅܵÄ
Éú²úexcelÓ¦Óãº
package com.lihp.exl;
/**
Ä¿µÄ£ºÌṩÓÉÊý¾Ý¶ÔÏ󼯺ÏÀࣨVector£©Éú³ÉExcel¹¤×÷±íµÄ¹¦ÄÜ
×÷Õߣºlihaipeng
*/
import java.io.*;
import java.util.*;
import java.lang.reflect.Method;
import org.apache.poi.hssf.usermodel.HSSFSheet;
impor ......
±¾ÎĽéÉܵÄJAVA¹æÔòµÄ˵Ã÷·ÖΪ3¸öÖ÷Òª¼¶±ð£¬±¾ÆªÅׯúÁËÆ½Ê±¿ª·¢ÖкÜÉÙÓöµ½µÄÇé¿ö£¬ÄÇЩÓõñȽÏÉÙµÄÒÔºóÔٸ߼¶ÆªÀïÃæ³öÏÖ¡£²¢ÓÐÁù¸öÓÐÓõĹú¼ÊÈí¼þ¿ª·¢ÖØÒª×¢ÒâµÄÓйØStringµÄÎÊÌ⣬×ñÊØÁËÕâЩ¹æÔò¿ÉÒÔÌá¸ß³ÌÐòµÄЧÂÊ¡¢Ê¹´úÂëÓÖ¸üºÃµÄ¿É¶ÁÐԵȡ£
£¨1£© Èç¹ûÓÐJDBCÁ¬½ÓûÓйصôµÄ»°£¬ÐèÒªÔÚ"finally"·½·¨Öйصô
Èç ......