jdbcfixture.java

Chinaxp 论坛源代码

/*
 * XP Forum
 *	
 * Copyright (c) 2002-2003 RedSoft Group.  All rights reserved.
 *
 */
package org.redsoft.forum.fixture;

import org.apache.commons.dbcp.BasicDataSource;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * JDBC Fixture
 *
 * @author <a href="mailto:[e-mail]">John Wong</a>
 *
 * @version $Id: JdbcFixture.java,v 1.1.1.1 2004/02/04 03:52:13 mustang Exp $
 *
 * Changes when update from struts 1.0 to struts 1.1 :
 * Since <code>GenericDataSource</code> is deprecated, use BasicDataSource
 */
public class JdbcFixture {
    private BasicDataSource ds = null;

    public void setUp() throws Exception {
        ds = new BasicDataSource();
        ds.setDefaultAutoCommit( false );
        ds.setDriverClassName( "org.gjt.mm.mysql.Driver" );
        ds.setUrl( "jdbc:mysql://localhost/forum" );
        ds.setUsername( "xpforum" );
        ds.setPassword( "demo1234" );
    }

    /* Old code in struts 1.0
    private GenericDataSource ds = null;
    public void setUp() throws Exception {
		ds = new GenericDataSource();

		ds.setAutoCommit(false);
		ds.setDriverClass("org.gjt.mm.mysql.Driver");
		ds.setMaxCount(10);
		ds.setMinCount(2);
		ds.setPassword("demo1234");
		ds.setUser("xpforum");
		ds.setUrl("jdbc:mysql://localhost/forum");
    }
    */

	public void tearDown() throws Exception {

	}

	public DataSource getDataSource() {
		return ds;
	}

	public Connection getConnection() throws SQLException {
		return ds.getConnection();
	}

}