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

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"
        /> -->
    <!--
    <Resource
        name="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数据源 -->
     <Resource
            name="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数据源 -->
<!--     <Resource
            name="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数据源-->
    <!--<Resource
            name="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包的添加操作

将上述的四个jar包添加到Tomcat8的lib目录之下。

完成上述操作之后就开始进行Tomcat的启动，然后访问指定的网址：

http://localhost:8080/wb/

将会出现webBuilder的安装界面:

注意在该界面当中将会有一个JNDI：里面要进行填写的数据为:

java:comp/env/jdbc/wb_oracle

其中Oracle之前的内容是固定的，之后后面的会发生改变Eg：mysql的应该写：java:comp/env/+向对应的资源名

此处的资源名就是上述的context.xml文件当中的resources 标签对象当中的name之中的内容，用于告知服务器是对哪一个数据源对象进行加载连接操作。

然后进行下一步操作:

此处界面会有警告，但是我看不懂，所以直接选择的下一步.然后就完成了WebBuilder在本地机当中的安装操作

默认的用户名和密码都是admin