配置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;
}