JDBC

package com.zhenjw.web;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @author zhenjw
 * @createDate 2010-4-9 下午01:38:43
 * @since 1.0
 * @version 1.0
 */
public class JDBC {

    public static void main(String[] args) throws ClassNotFoundException, Exception, IllegalAccessException {

    }

    public Connection getOracleConnection() throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {
	//需要导入ojdbc14.jar
	String driverClassName = "oracle.jdbc.driver.OracleDriver";

	String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";

	String user = "test";

	String password = "test";

	return this.getConnection(driverClassName, url, user, password);

    }

    public Connection getMySqlConnection() throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {
	//需要导入 mysql-connector-java-5.1.6-bin.jar
	String driverClassName = "com.mysql.jdbc.Driver";

	String url = "jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true";

	String user = "test";

	String password = "test";

	return this.getConnection(driverClassName, url, user, password);

    }

    /**
     *  注意：假如你使用db2java.zip,且web服务器使用Tomcat的话,请将db2java.zip改名为db2java.jar,最好将zip解压再用jar命令打包,
     *       直接改文件类型也行(呵呵,按照jar文件严格意义上来讲这是不符合文法的<少了描述性文件:MANIFEST.MF>,能用就行)
     *       还有一般情况下：就是使用 db2java.zip的话需要安装db2客户端,
     *       使用db2jcc.jar是通过网络直接来连接的无需安装db2客户端(假如用在type2上还是要装客户端的)
     *  type2:
     *       使用<db2java.zip>:
     *       jdbc.driverClassName=COM.ibm.db2.jdbc.app.DB2Driver
     *       jdbc.url=jdbc:db2:dataBaseName
     *                   
     *  假如你的工具使用的是myeclipse且使用的是tomcat plugin的话，请将db2jdbc.dll 拷贝到 %JAVA_HOME%/bin下，否则不行地啦
     *  使用<db2jcc.jar>:
     *  	jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
     *  	jdbc.url=jdbc:db2:dataBaseName
     *  type3:
     *  	驱动：db2java.zip
     *           jdbc.driverClassName=COM.ibm.db2.jdbc.net.DB2Driver
     *           jdbc.url=jdbc:db2://ip:6789/DBNAME
     *  注意：要在数据库上执行 db2jstrt 6789 （这句启动了db2jd进程，6789是默认的服务器侦听jdbc2连接的端口，也可以设置成另外的任意不冲突的端口。）
     *  type4:
     *   驱动:db2jcc.jar
     *    数据库字符集必须设置为utf-8
     *    jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
     *    jdbc.url=jdbc:db2://ip:port/DBNAME 
     */
    public Connection getDB2Connection() throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {
	//需要导入 db2jcc.jar

	String driverClassName = "com.ibm.db2.jcc.DB2Driver";

	String url = "jdbc:db2:dataBaseName";

	String user = "test";

	String password = "test";

	return this.getConnection(driverClassName, url, user, password);

    }

    public Connection getMSSqlConnection() throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {
	//  mssqlserver.jar,msutil.jar,msbase.jar
	String driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=dbname";

	String user = "test";

	String password = "test";

	return this.getConnection(driverClassName, url, user, password);

    }

    public Connection getConnection(String driverClassName, String url, String user, String password) throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {

	Class cc = Class.forName(driverClassName);

	Driver driver = (Driver) cc.newInstance();

	DriverManager.registerDriver(driver);

	return DriverManager.getConnection(url, user, password);

    }

}