怎样在tomcat5中配置指南mysql数据源_MySQL数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

怎样在tomcat5中配置指南mysql数据源

作者:黑客防线网安MYSQL教程网 来源:黑客防线网安MYSQL教程网 浏览次数:0

本篇关键词:数据指南配置怎样
黑客防线网安网讯:tomcat5中配置mysql数据源: 一、配置环境变量: softe version:tomcat5.0.12/mysql4.1.7/mysql_driver---mysql-coector-java-3.1.4-beta-bin.jarmysql驱动程序可从www.mysql.com官方网站下...
tomcat5中配置mysql数据源: 一、配置环境变量: softe version:tomcat5.0.12/mysql4.1.7/mysql_driver--- mysql-coector-java-3.1.4-beta-bin.jar mysql驱动程序可从www.mysql.com官方网站下载 路径: tomcat5在d:\myweb\tomcat5; mysql在C:\Program Files\MySQL\MySQL Server 4.1 Path(在原来的基础上加上): d:\myweb\tomcat5\bid:\myweb\jdk1.4;d:\myweb\ jdk1.4\bi d:\myweb\tomcat5\common\lib\servlet-api.jar;C:\Program Files\ MySQL\MySQL Server4.1\bin CLAATH:d:\myweb\tomcat5\common\lib\servlet-api.jar;d:\myweb\ tomcat5\common\lib\j-api.jar JAVA_HOME:d:\myweb\jdk1.4 CATALINA_HOME:d:\myweb\tomcat5 二、建立测试数据库 在mysql中建立一个forumdb数据库同时创建一个表member如下: create database forumd create table member ( id int, name varchar(6) ); 然后插入两条测试数据如下: iert into member values(1,"zhang"); iert into member values(2,"wang"); 至此数据库准备完毕 三、配置server.xml 注:我的web在d:\myweb\mya 首先要将mysql的驱动程序放到d:\myweb\tomcat5\common\lib下面,一定要放".jar"的文件,如是".zip"的文件直接改为.jar即可 用文本编辑器打开D:\tomcat5\conf\server.xml,找到结束标志,然后在之前加上如下语句: <Context path="/mya" docBase="d:\myweb\mya" debug="0" reloadable="true" > <Resource name="jdbc/DBCoection" auth="Container" type="javax.sql.DataSource" /> <ResourceParams name="jdbc/DBCoection"> <arameter> <ame>factory</name> <value>org.apache.commo.dbcp.BasicDataSourceFactory</value> </parameter> <!-- Maximum number of dB coectio in pool. Make sure you configure your mysqld max_coectio large enough to handle all of your db coectio. Set to 0 for no limit. --> <arameter> <ame>maxActive</name> <value>10</value> </parameter> <!-- Maximum number of idle dB coectio to retain in pool. Set to 0 for no limit. --> <arameter> <ame>maxIdle</name> <value>3</value> </parameter> <!-- Maximum time to wait for a dB coection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. Maximum time to wait for a dB coection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. --> <arameter> <ame>maxWait</name> <value>10000</value> </parameter> <!-- MySQL dB username and paword for dB coectio --> <arameter> <ame>username</name> <value>root</value> </parameter> <arameter> <ame>aword</name> <value>1234</value> </parameter> <!-- Cla name for mm.mysql JDBC driver --> <arameter> <ame>driverClaame</name> <value>com.mysql.jdbc.Driver</value> </parameter> <!-- The JDBC coection url for coecting to your MySQL dB. The autoRecoect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically recoect if mysqld closed the coection. mysqld by default closes idle coectio after 8 hours. --> <arameter> <ame>url</name> <value>jdbc:mysql://localhost:3306/forumdb?autoRecoect=true</value> </parameter> </ResourceParamgt; </Context> 再次提醒:一定要放在之前! 四、配置web.xml web.xml位于d:\myweb\mya\WEB-INF下,也即是你的WEB里的web.xml。 同样用文本编辑器打开web.xml,然后加入如下语句(在之间) <resource-ref> <descriptiogt;DB Coectiolt;/descriptiogt; <res-ref-name>jdbc/DBCoectiolt;/res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> 五、编写测试j page。 在d:\myweb\mya\下编写一个dbtest.j,代码如下: <%@ page import="java.io.*,java.util.*,java.sql.*,javax.sql.*,javax.naming.*"%> <%@ page contentType="text/html;charset=GB2312"%> <html> <head>lt;title>DataSourse Coection Test</title>lt;/head> <ody> <% try{ java.sql.Coection co Statement stmt; ResultSet r Context ctx = new InitialContext(); DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/DBCoection"); con=ds.getCoection(); stmt=con.createStatement(); rs=stmt.executeQuery("select * from member"); while(rs.next()){ out.print(rs.getInt(1); out.print(rs.getString(2)); } rs.close(); stmt.close(); con.close(); }catch(Exception e){ out.print(e.getMeage()); } %> </body> </html> 六、开始测试 运行tomcat.bat,打开IE在地址栏中输入:http://localhost:8080/mya/dbtest.j 如果能够看到看到如下数据,说明配置成功。
    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-19556-1.html
网站维护教程更新时间:2013-01-01 21:57:29  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer