WebBuilder的下载以及实现连接Oracle数据

article/2025/9/13 9:50:54

WebBuilder的下载网上有许多就不说了。

首先解压压缩包当中的wb文件到Tomcat的webapp当中去如图:

将压缩包中的wb文件解压到Tomcat中

打开wb问价夹创建一个META-INF文件夹

在meta-inf文件夹当中创建一个context.xml文件

context.xml文件党总的内容为:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Context>
<Context reloadable="true" crossContext="true"><WatchedResource>WEB-INF/web.xml</WatchedResource><!-- <Resource name="jdbc/wb_mysql" auth="Container" type="javax.sql.DataSource"driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/webbuilder?autoReconnect=true&amp;allowMultiQueries=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"username="root" password="webbuilder" maxActive="20" maxIdle="10" maxWait="-1"/> <Resource name="jdbc/wb_sqlserver" auth="Container" type="javax.sql.DataSource"driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=wb"username="sa" password="webbuilder" maxActive="20" maxIdle="10" maxWait="-1"/> --><!--<Resourcename="jdbc/wb_oracle"type="javax.sql.DataSource"maxActive="100" maxIdle="100" maxWait="10000"driverClassName="oracle.jdbc.OracleDriver"url="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.105.20)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wolf)))"username="wolf"password="wolf"/>--><!--<Resource name="jdbc/wb_oracle" auth="Container"factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" type="javax.sql.DataSource"driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:wolf"username="wolf" password="wolf" maxActive="20" maxIdle="10" maxWait="-1" initialSize="5"testWhileIdle="true" testOnBorrow="true" testOnReturn="true" testOnConnect="true"validationQuery="select 1 from dual" validationInterval="30000" removeAbandonedTimeout="180"removeAbandoned="true" timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="60000"logAbandoned="true"logValidationErrors="true"jdbcInterceptors="ConnectionState;StatementFinalizer(useEquals=true,trace=true);StatementCache(callable=true,max=100)"/>--><!--<Resource name="jdbc/wb_oracle" auth="Container"factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" type="javax.sql.DataSource"driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@192.168.110.75:1521:wolfdb"username="wolf" password="wolf" maxActive="200" maxIdle="200" minIdle="50" initialSize="50" maxWait="30000"testWhileIdle="true" testOnBorrow="true" testOnReturn="true" testOnConnect="true"validationQuery="select 1 from dual" validationInterval="30000"timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="60000"removeAbandonedTimeout="300" removeAbandoned="true" logAbandoned="true"logValidationErrors="true" jdbcInterceptors="ConnectionState;StatementFinalizer(useEquals=true,trace=true);StatementCache(callable=true,max=100)" />
--><!-- <Resource name="jdbc/wb_sqlserver" auth="Container" type="javax.sql.DataSource"factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"validationQuery="SELECT 1"validationInterval ="30000" timeBetweenEvictionRunsMillis="30000"maxActive="100" minIdle="10" maxWait="30000" initialSize="10"removeAbandonedTimeout="180" removeAbandoned="true" logAbandoned="false"minEvictableIdleTimeMillis="60000" jmxenabled="true"jdbcinterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"url="jdbc:sqlserver://10.180.102.68:1433;DatabaseName=CKUO" username="ck"password="gtjas.com" /> 10.253.42.200:1521:ckwolf--><!-- 使用阿里巴巴的DruidDataSource配置针对Oracle数据库的JNDI数据源 --><Resourcename="jdbc/wb_oracle"factory="com.alibaba.druid.pool.DruidDataSourceFactory"auth="Container"type="javax.sql.DataSource"driverClassName="oracle.jdbc.OracleDriver"url="jdbc:oracle:thin:@localhost:1521:orcl"username="scott"password="admin"initialSize="10"maxActive="50"minIdle="10"maxWait="10000"maxOpenPreparedStatements="100"validationQuery="select 1 from dual"testOnBorrow="false"testWhileIdle="true"timeBetweenEvictionRunsMillis="60000"removeabandoned="true"removeabandonedtimeout="60"logabandoned="false"filters="stat,wall"/><!-- 使用阿里巴巴的DruidDataSource配置针对MySQL数据库的JNDI数据源 -->
<!--     <Resourcename="jdbc/MysqlDataSource"factory="com.alibaba.druid.pool.DruidDataSourceFactory"auth="Container"type="javax.sql.DataSource"driverClassName="com.mysql.jdbc.Driver"url="jdbc:mysql://192.168.1.233:3306/lead_oams?useUnicode=true&amp;characterEncoding=utf-8"username="lead_system"password="password"maxActive="50"maxWait="10000"removeabandoned="true"removeabandonedtimeout="60"logabandoned="false"filters="stat"/> --><!-- <Resource name="jdbc/wb_mysql" auth="Container" type="javax.sql.DataSource"driverClassName="com.mysql.jdbc.Driver"url="jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true&amp;allowMultiQueries=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"validationQuery="select 1" testWhileIdle="true" testOnBorrow="false"username="root" password="000000" maxTotal="20" maxIdle="10" /> --><!--使用阿里巴巴的DruidDataSource配置针对SQLServer数据库的JNDI数据源--><!--<Resourcename="jdbc/SqlServerDataSource"auth="Container"factory="com.alibaba.druid.pool.DruidDataSourceFactory"type="javax.sql.DataSource"driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"url="jdbc:sqlserver://192.168.1.61:1433;DatabaseName=gaclTest"username="sa"password="p@ssw0rd"maxActive="50"maxWait="10000"removeabandoned="true"removeabandonedtimeout="60"logabandoned="false"filters="stat"/>--></Context>

在上述的xml文件当中有对应的mysql，Oracle和SQLServer相关数据源的配置操作。只要在使用的时候对URL，username，password进行简单的修改之后就可以进行使用了。

在执行完上述操作之后要进行jar包的添加操作