连接各类数据库

/*
 * <p>Title:       JDBC-ODBC连接数据库</p>
 * <p>Description: 连接OracleDSN ODBC data source的一个类</p>
 * <p>Copyright:   Copyright (c) 2005</p>
 * <p>Company:     ***</p>
 */
package com.soft.basedao;

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

/**
 * 类ODBCConnection.java的实现描述：连接各类数据库
 *
 * @author         wdw004 wdw004@163.com
 * @version        1.0
 * Date            2005-5-19
 * @see            java.lang.Class
 * History:
 *    <author>     <time>      <version>      <desc>
 */
public class ODBCConnection
{

    private Connection conn;

    /**
     * 连接JDBC-ODBC驱动
     * @return
     */
    public Connection getJDBCODBCConnection()
    {
        /**
         *
         * 说明：java中操作Oracle数据库,经过以下几个步骤，
         *
         1.将OracleHome/jdbc/lib/目录的所有文件添加到jre/lib/ext目录；(配置JDBC驱动)
         2.创建odbc源，在控制面板=》管理工具=》数据源（odbc）中添加DSN,比如取名为OracleDSN,选择一个Service,输入用户名密码，测试连接，若通过说明成功；
         3.在程序中加载jdbc驱动（下面的例子用的是JdbcOdbc驱动),建立连接，执行Query.

         */

        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:odbc:OracleDSN";
            conn = DriverManager.getConnection(url, "system", "system_passwd");

        } catch (Exception e)
        {
            e.printStackTrace();
        }

        return conn;
    }

    /**
     * 连接Oracle8/8i/9i数据库（thin模式）
     * @return
     */
    public Connection getOracle9i()
    {
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";

        //orcl为数据库的SID
        String user = "test";
        String password = "test";

        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            conn = DriverManager.getConnection(url, user, password);
        } catch (InstantiationException e)
        {
            e.printStackTrace();
        } catch (IllegalAccessException e)
        {
            e.printStackTrace();
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 连接DB2数据库
     * @return
     */
    public Connection getDB2()
    {
        String url = "jdbc:db2://localhost:5000/sample";

        //sample为你的数据库名
        String user = "admin";
        String password = "";
        try
        {
            Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
            conn = DriverManager.getConnection(url, user, password);
        } catch (InstantiationException e)
        {
            e.printStackTrace();
        } catch (IllegalAccessException e)
        {
            e.printStackTrace();
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 连接Sql Server7.0/2000数据库
     * @return
     */
    public Connection getSqlServer()
    {
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";

        //mydb为数据库
        String user = "sa";
        String password = "";
        try
        {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
                    .newInstance();
            conn = DriverManager.getConnection(url, user, password);
        } catch (InstantiationException e)
        {
            e.printStackTrace();
        } catch (IllegalAccessException e)
        {
            e.printStackTrace();
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 连接MySQL数据库
     * @return
     */
    public Connection getMySQL()
    {
        //myDB为数据库名
        String url = "jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
        try
        {
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            conn = DriverManager.getConnection(url);
        } catch (InstantiationException e)
        {
            e.printStackTrace();
        } catch (IllegalAccessException e)
        {
            e.printStackTrace();
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        return conn;
    }
   
    /**
     * 通过ODBC桥连接Access库
     * @return
     */
    public Connection getOdbcAccess()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:stockdb");
           
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
  
        return conn;
    }

}