技术教程网 -- 实用技术参考 (转)

技术教程网 -- 实用技术参考 (转)[@more@]

tomcat4.1.24+Mysql连接池配法

1.修改CATALINA_HOMEconfserver.XML

<!-- Tomcat root Context --&gt

bug="0">


apache.catalina.logger.FileLogger"
prefix="localhost_dbTest_log." suffix=".txt"
timestamp="true"/>

source name="JDBC/MYSQLDB"
auth="Container"
type="Javax.sql.DataSource"/>



factory
org.apache.commons.dbcp.BasicDataSourceFactory


<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
--&gt

maxActive
100


<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
--&gt

maxIdle
30


<!-- Maximum time to wait for a dB connection 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.
--&gt

maxWait
10000


<!-- MySQL dB username and password for dB connections --&gt

username
sa


password
111111


<!-- Class name for mm.mysql JDBC driver --&gt

driverClassName
org.gjt.mm.mysql.Driver


<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
--&gt

url
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEnco ding=GBK

<!--Here must use & not use  & --&gt









2.修改webapps/ROOT/INF-WEB/web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
BR>"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">

MySQL Test App

DB Connection
jdbc/MysqlDB
javax.sql.DataSource
Container



3.测试用的testdb.JSP内容:




try{

Context initCtx = new InitialContext();

Context ctx = (Context) initCtx.lookup("java:comp/env");
//获取连接池对象

object obj = (Object) ctx.lookup("jdbc/MysqlDB");

//类型转换

javax.sql.DataSource ds = (javax.sql.DataSource)obj;

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

String strSql = " insert into test(id,name) values('007','hello,中国!') ";

stmt.executeUpdate(strSql);

strSql = " select id,name from test ";

ResultSet rs = stmt.executeQuery(strSql);
while(rs.next()){

out.println(rs.getString(1));

out.println(rs.getString(2)+"
");

}
conn.close();

}catch(Exception ex){

ex.printStackTrace();
throw new SQLException("cannot get Connection pool.");
}


%>

---

4.最后浏览 http://localhost/testdb.jsp

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10752043/viewspace-956688/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10752043/viewspace-956688/