\conf\context.xml :
<Resource name="oswf" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/oswf" username="root" password="root" initialSize="3" maxActive="25" maxIdle="10" maxWait="3000" />
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page session="false"%>
<html>
<head>
<title>MySQL 数据源测试</title>
<%
out.print("MySQL 数据源测试开始..." + "<br>");
DataSource ds = null;
try {
InitialContext ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/oswf");
Connection conn = ds.getConnection();
conn.close();
out.print("MySQL 数据源测试成功!");
} catch (Exception ex) {
out.print("出现意外,信息是:" + ex.getMessage());
ex.printStackTrace();
}
%>
</head>
</html><%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page session="false"%>
<html>
<head>
<title>MySQL 数据源测试</title>
<%
out.print("MySQL 数据源测试开始..." + "<br>");
DataSource ds = null;
try {
InitialContext ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/oswf");
Connection conn = ds.getConnection();
conn.close();
out.print("MySQL 数据源测试成功!");
} catch (Exception ex) {
out.print("出现意外,信息是:" + ex.getMessage());
ex.printStackTrace();
}
%>
</head>
</html>