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 );
6 insert into testdata values ( null , ' hello ' , 12345 );
7
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 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
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 " >
5 select 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
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 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
转载于:https://blog.51cto.com/442277/89414