connectionfactory.java

文件上传用例,纯sql分页源码,有用的着地方请下载 试用

package org.derrick.jdbc;

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

import org.apache.log4j.Logger;
/**
 * 
 * @author 刘冬宝Oct 26, 2006
   版权申明：所有人员均可自由修改源码并再发布，但必须保留此相关信息
 *
 */
public class ConnectionFactory {
    private static ConnectionFactory instance = null;

    public static ConnectionFactory getInstance() {
        synchronized (ConnectionFactory.class) {
            if (null == instance) {
                instance = new ConnectionFactory();
            }
            return instance;
        }
    }

    private static Logger logger = Logger.getLogger(ConnectionFactory.class);

    private String sDBDriver;

    private String sDBPassword;

    private String sDBUrl;

    private String sDBUser;

    private DBConfig dbConfig;

    public void setDbConfigFile(String dbconfig_file) {
        dbConfig.setDbConfigFile(dbconfig_file);
    }

    private ConnectionFactory() {
        dbConfig = DBConfig.getInstance();
     }

    public void init() {     
        sDBDriver = dbConfig.getDriver();
        sDBUrl = dbConfig.getURL();
        sDBUser = dbConfig.getUsername();
        sDBPassword = dbConfig.getPassword();
        if (logger.isDebugEnabled()) {
            logger.debug("Driver:" + sDBDriver);
            logger.debug("URL:" + sDBUrl);
            logger.debug("Username:" + sDBUser);
            logger.debug("Password:" + sDBPassword);
        }
    }

    public static void closeConnection(Connection conn) {
        if (conn != null) {
            try {
                conn.close();
                conn = null;
            } catch (SQLException ex) {
                logger.error(null, ex);
            }
        }
    }

    public static void closeStatement(Statement st) {
        if (st != null) {
            try {
                st.close();
                st = null;
            } catch (SQLException ex) {
                logger.error(null, ex);
            }
        }
    }

    public static void closeResultSet(ResultSet rs) {
        if (rs != null) {
            try {
                rs.close();
                rs = null;
            } catch (SQLException ex) {
                logger.error(null, ex);
            }
        }
    }

    public Connection getConnection() {
        try {
            Class.forName(sDBDriver);
            return DriverManager.getConnection(sDBUrl, sDBUser, sDBPassword);
        } catch (SQLException ex) {
            logger.fatal(null, ex);
            throw new RuntimeException(ex);
        } catch (ClassNotFoundException ex) {
            logger.fatal(null, ex);
            throw new RuntimeException(ex);
        }
    }

    public String toString() {
        String s = null;
        s = String.valueOf(String.valueOf((new StringBuffer("sDBDriver is： "))
                .append(sDBDriver).append("\n").append("sDBUrl is: ").append(
                        sDBUrl).append("\n").append("sDBUser is: ").append(
                        sDBUser).append("\n").append("sDBPassword is: ")
                .append(sDBPassword).append("\n")));
        return s;
    }

    public static void main(String args[]) {
        ConnectionFactory db = new ConnectionFactory();
        Connection conn = db.getConnection();
        System.out.print(conn);
    }

}