constdbbean.java

使用jsp查询oracle数据库生成excel文件

/*
 * Created on 2004-4-16
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package dbexport;

/**
 * ---------------------<br> 
 * 文件名：ConstDBBean.java<br>
 * ---------------------<br>
 * (C) Copyright 2004, by Codeline Limited. <br>
 * 说明：维护数据库访问的系统常量<br> 
 * 原作者：肖俊<br>
 * 其他作者：<br>
 * 创建时间：2004-4-15<br>
 * 版本: 1.0<br>
 * 更改记录：<br>
 * -------------------------------------------------------------------------<br>
 *   改动人  时间          原因<br>
 * -------------------------------------------------------------------------<br>
 *   肖俊    2004-4-15     创建文件<br>
 */
public class ConstDBBean {
	//dbDriver,dbURL,dbUser,dbPassword 根据数据库的不同进行替换
	
	//缺省数据库驱动名
	private  String dbDriver = null;
	
	//缺省数据库统一定位地址
	private  String dbURL = null;
	
	//缺省数据库用户名
	private  String dbUser = null;
	
	//缺省数据库用户密码
	private  String dbPassword = null;
	
	public ConstDBBean(){
		dbDriver = "oracle.jdbc.driver.OracleDriver";
		dbURL = "jdbc:oracle:thin:@10.128.64.1:1521:shrpt";
		dbUser = "scott";
		dbPassword = "tiger";
	}
	
	//dbDriver的get和set方法
	public String getDbDriver(){
		return this.dbDriver;
	}
    
    public  void setDbDriver(String dbDriver){
    	this.dbDriver = dbDriver;
    }
    
    //dbURL的get和set方法
	public  String getDbURL(){
			return this.dbURL;
	}
    
	public  void setDbURL(String dbURL){
			this.dbURL = dbURL;
	}
	
    //dbUser的get和set方法
	public  String getDbUser(){
			  return this.dbUser;
	}
    
	public  void  setDbUser(String dbUser){
		  this.dbUser = dbUser;
	}
	  
	//dbPassword的get和set方法
	public  String getDbPassword(){
				  return this.dbPassword;
	}
    
    public  void setDbPassword(String dbPassword){
				  this.dbPassword = dbPassword;
	}
}