配置Tomcat数据源和连接池

修改C:/Tomcat 6.0/conf/context.xml,在<Context></Context>之间加入：

<Resource name="jdbc/bizapp" 
type="javax.sql.DataSource"
password="gps"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="30" 
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
maxWait="10000"
username="navtech"
url="jdbc:oracle:thin:@90.0.12.10:1521:NAVTECH" maxActive="500"/>

 

引用：java:comp/env/jdbc/bizapp

你可以将此语句写入资源文件Connection.properties中：

datasourcename=java:comp/env/jdbc/bizapp

使用:

     try {
      InputStream is = getClass().getResourceAsStream("/Connection.properties");
      Properties dbProps = new Properties();
         dbProps.load(is);  
      Context initCtx = new InitialContext();
      this.dataSource=(DataSource)initCtx.lookup(dbProps.getProperty("datasourcename"));
     } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

 

 

    public Connection getConnection(){
        Connection con = null;
        try{
            con = this.dataSource.getConnection();
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return con;
    }