jdbcconnection.java

用报表开发工具开发各种报表的小例子

package com.sterning.datasourceReport.jdbcConnection;

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

/**
 * Used for get a JDBC connection for Jasper Report
 */
public class JDBCConnection {

	private String jdbcDriver;

	private String jdbcUrl;

	private String dbUser;

	private String dbPassword;

	public String getDbPassword() {
		return dbPassword;
	}

	public void setDbPassword(String dbPassword) {
		this.dbPassword = dbPassword;
	}

	public String getDbUser() {
		return dbUser;
	}

	public void setDbUser(String dbUser) {
		this.dbUser = dbUser;
	}

	public String getJdbcDriver() {
		return jdbcDriver;
	}

	public void setJdbcDriver(String jdbcDriver) {
		this.jdbcDriver = jdbcDriver;
	}

	public String getJdbcUrl() {
		return jdbcUrl;
	}

	public void setJdbcUrl(String jdbcUrl) {
		this.jdbcUrl = jdbcUrl;
	}

	public JDBCConnection() {
		super();
	}

	/**
	 * Get the Connection
	 * 
	 * @return connection
	 * @throws Exception
	 */
	public Connection getConnection() throws Exception {
		Connection con;
		try {
			check();
			Class.forName(this.jdbcDriver);
			con = DriverManager.getConnection(this.jdbcUrl, this.dbUser,
					this.dbPassword);
			return con;
		} catch (Exception e) {
			e.printStackTrace();
			throw new Exception("打开JDBC连接有错!");
		}
	}

	/**
	 * Check the Configure
	 * 
	 * @throws Exception
	 */
	private void check() throws Exception {
		if (this.jdbcDriver == null || this.jdbcDriver.equals("")
				|| this.jdbcUrl == null || this.jdbcUrl.equals("")
				|| this.dbUser == null || this.dbUser.equals("")
				|| this.dbPassword == null) {
			throw new Exception("Jdbc配置有误!");
		}
	}

}