此博客为转载内容，原链接为https://blog.51cto.com/442277/89414 ，涉及Java和数据库相关信息技术内容。
1.把驱动拷贝到%TOMCAT_HOME%/common/lib目录下
2.新建数据库表，并向表中添加记录
2.新建数据库表，并向表中添加记录
1
use test;
2 create table testdata (
3 id int not null auto_increment primary key,
4 foo varchar(25),
5 bar int);
6insert into testdata values(null, 'hello', 12345);
7
use test;2
create table testdata (3
id int not null auto_increment primary key,4
foo varchar(25), 5
bar int);6
insert into testdata values(null, 'hello', 12345);7
3.在%TOMCAT_HOME%/config/server.xml文件中加入如下一段配置信息(在</Host>之前)
1 <!--数据库连接池配置-->
2 <!--path:Your webApp directory-->
3<Context path="/WS4Motel" docBase="WS4Motel"
4 debug="5" reloadable="true" crossContext="true">
5
6 <!-- maxActive: Maximum number of dB connections in pool. Make sure you
7 configure your mysqld max_connections large enough to handle
8 all of your db connections. Set to 0 for no limit.
9 -->
10
11 <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
12 Set to -1 for no limit. See also the DBCP documentation on this
13 and the minEvictableIdleTimeMillis configuration parameter.
14 -->
15
16 <!-- maxWait: Maximum time to wait for a dB connection to become available
17 in ms, in this example 10 seconds. An Exception is thrown if
18 this timeout is exceeded. Set to -1 to wait indefinitely.
19 -->
20
21 <!-- username and password: MySQL dB username and password for dB connections -->
22
23 <!-- driverClassName: Class name for the old mm.mysql JDBC driver is
24 org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
25 Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
26 -->
27
28 <!-- url: The JDBC connection url for connecting to your MySQL dB.
29 The autoReconnect=true argument to the url makes sure that the
30 mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
31 connection. mysqld by default closes idle connections after 8 hours.
32 -->
33
34 <Resource name="jdbc/WS4Motel" auth="Container" type="javax.sql.DataSource"
35 maxActive="100" maxIdle="30" maxWait="10000"
36 username="root" password="83072674" driverClassName="com.mysql.jdbc.Driver"
37 url="jdbc:mysql://localhost:3306/test?autoReconnect=true"/>
38
39</Context>
40 <!--数据库连接池配置-->
41
<!--数据库连接池配置-->2
<!--path:Your webApp directory-->3
<Context path="/WS4Motel" docBase="WS4Motel"4
debug="5" reloadable="true" crossContext="true">5
6
<!-- maxActive: Maximum number of dB connections in pool. Make sure you7
configure your mysqld max_connections large enough to handle8
all of your db connections. Set to 0 for no limit.9
-->10
11
<!-- maxIdle: Maximum number of idle dB connections to retain in pool.12
Set to -1 for no limit. See also the DBCP documentation on this13
and the minEvictableIdleTimeMillis configuration parameter.14
-->15
16
<!-- maxWait: Maximum time to wait for a dB connection to become available17
in ms, in this example 10 seconds. An Exception is thrown if18
this timeout is exceeded. Set to -1 to wait indefinitely.19
-->20
21
<!-- username and password: MySQL dB username and password for dB connections -->22
23
<!-- driverClassName: Class name for the old mm.mysql JDBC driver is24
org.gjt.mm.mysql.Driver - we recommend using Connector/J though.25
Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.26
-->27
28
<!-- url: The JDBC connection url for connecting to your MySQL dB.29
The autoReconnect=true argument to the url makes sure that the30
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the31
connection. mysqld by default closes idle connections after 8 hours.32
-->33
34
<Resource name="jdbc/WS4Motel" auth="Container" type="javax.sql.DataSource"35
maxActive="100" maxIdle="30" maxWait="10000"36
username="root" password="83072674" driverClassName="com.mysql.jdbc.Driver"37
url="jdbc:mysql://localhost:3306/test?autoReconnect=true"/>38
39
</Context>40
<!--数据库连接池配置-->41
4.写个简单程序测试下：
1<%@ taglib uri="[url]http://java.sun.com/jsp/jstl/sql[/url]" prefix="sql" %>
2<%@ taglib uri="[url]http://java.sun.com/jsp/jstl/core[/url]" prefix="c" %>
3
4<sql:query var="rs" dataSource="jdbc/TestDB">
5select id, foo, bar from testdata
6</sql:query>
7
8<html>
9 <head>
10 <title>DB Test</title>
11 </head>
12 <body>
13
14 <h2>Results</h2>
15
16<c:forEach var="row" items="${rs.rows}">
17
Foo $
{row.foo}<br/>
18 Bar ${row.bar}<br/>
19</c:forEach>
20
21 </body>
22</html>
23
<%@ taglib uri="[url]http://java.sun.com/jsp/jstl/sql[/url]" prefix="sql" %>2
<%@ taglib uri="[url]http://java.sun.com/jsp/jstl/core[/url]" prefix="c" %>3
4
<sql:query var="rs" dataSource="jdbc/TestDB">5
select id, foo, bar from testdata6
</sql:query>7
8
<html>9
<head>10
<title>DB Test</title>11
</head>12
<body>13
14
<h2>Results</h2>15
16
<c:forEach var="row" items="${rs.rows}">17
Foo ${row.foo}<br/>18
Bar ${row.bar}<br/>19
</c:forEach>20
21
</body>22
</html>23
转载于:https://blog.51cto.com/442277/89414
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
