Next insert some test data into the testdata table.
|
|
|
|
mysql> insert into testdata values(null, 'hello', 12345);
Query OK, 1 row affected (0.00 sec)
mysql> select * from testdata;
+----+-------+-------+
| ID | FOO | BAR |
+----+-------+-------+
| 1 | hello | 12345 |
+----+-------+-------+
1 row in set (0.00 sec)
mysql>
|
|
|
|
|
2. Context configuration
Configure the JNDI DataSource in Tomcat by adding a declaration for your resource to your Context.
For example:
3. web.xml configuration
Now create a WEB-INF/web.xml for this test application.
|
|
|
|
MySQL Test App
DB Connection
jdbc/TestDB
javax.sql.DataSource
Container
|
|
|
|
|
4. Test code
Now create a simple test.jsp page for use later.
|
|
|
|
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
select id, foo, bar from testdata
DB Test
Results
Foo ${row.foo}
Bar ${row.bar}
|
|
|
|
|
That JSP page makes use of JSTL's SQL and Core taglibs. You can get it from Apache Tomcat
Taglibs - Standard Tag Library project — just make sure you get a 1.1.x release. Once you have JSTL, copy jstl.jar andstandard.jar to your web app's WEB-INF/lib directory.
Finally deploy your web app into $CATALINA_BASE/webapps either as a warfile called DBTest.war or into a sub-directory called DBTest
Once deployed, point a browser at http://localhost:8080/DBTest/test.jsp to view the fruits of your hard work.
下载本文
