dbtool.java

这是用于数据移植的原码(SYBASE-->DB2)

package com.pansky.dcc.core;

import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.util.ResourceBundle;
import java.util.Properties;

/**
 * Created by IntelliJ IDEA.
 * User: 周宇
 * Date: 2005-6-30
 * Time: 14:29:06
 * To change this template use File | Settings | File Templates.
 */
public class DbTool {

    /**
     * CADbTools 构造子注解。
     */
    public DbTool() {
        super();
    }

    /**
     * 断开数据库连接。
     * 创建日期：(01-1-10 22:13:23)
     */
    public static void disConnect(Connection _con) {
        try {
            if (_con != null && !_con.isClosed()) {
                _con.close();
                _con = null;

            }
        } catch (SQLException sqe) {
            try {
                _con.rollback();
                _con.close();
                _con = null;
            } catch (Exception e) {

            }
        }
    }


    /**
     * 输出SQL错误详细信息。
     * 创建日期：(01-1-10 22:13:23)
     */
    public static void printExceptions(SQLException sqe) {
        while (sqe != null) {

            sqe = sqe.getNextException();
        }
    }

    /**
     * 建立数据库连接。
     * 创建日期：(00-12-10 21:27:34)
     */
    public static Connection getConnectionLink1() {
        try {
            //获取数据用户名、密码、URL
            Connection _con = null;
            ResourceBundle bundle = ResourceBundle.getBundle("DCC");
            Properties pros = System.getProperties();
            pros.put("user", bundle.getString("LINK1_USER"));
            pros.put("password", bundle.getString("LINK1_PASSWORD"));

            Class.forName(bundle.getString("LINK1_CLASS")).newInstance();

            _con = DriverManager.getConnection(bundle.getString("LINK1_URL"), pros);

            _con.setAutoCommit(false);
            System.out.println("使用数据库连接－Normal－link1!!");
            return _con;
        } catch (SQLException sqe) {
            System.out.println("Occur in EBDbTools::GetDBConnection()");
        } catch (Exception e) {
            System.out.println("Occur in EBDbTools::GetDBConnection()");
        }
        return null;
    }

    /**
     * 建立数据库连接。
     * 创建日期：(00-12-10 21:27:34)
     */
    public static Connection getConnectionLink2() {
        try {
            //获取数据用户名、密码、URL
            Connection _con = null;
            ResourceBundle bundle = ResourceBundle.getBundle("DCC");

            Properties pros = System.getProperties();
            pros.put("user", bundle.getString("LINK2_USER"));
            pros.put("password", bundle.getString("LINK2_PASSWORD"));

            Class.forName(bundle.getString("LINK2_CLASS")).newInstance();

            _con = DriverManager.getConnection(bundle.getString("LINK2_URL"), pros);

            _con.setAutoCommit(false);
            System.out.println("使用数据库连接－Normal－link2!!");
            return _con;
        } catch (SQLException sqe) {
            System.out.println("Occur in EBDbTools::GetDBConnection()");
        } catch (Exception e) {
            System.out.println("Occur in EBDbTools::GetDBConnection()");
        }
        return null;
    }
}