Tomcat5.5.17+MySQL构建数据源

最新推荐文章于 2024-09-11 13:50:45 发布

hikiboy

最新推荐文章于 2024-09-11 13:50:45 发布

阅读量815

点赞数

文章标签： mysql tomcat import exception application jsp

本文链接：https://blog.csdn.net/hikiboy/article/details/1286775

版权

C:/Tomcat 5.5/conf/server.xml中添加
<Context path="/DataTool" reloadable="true" docBase="E:/workspace/DataTool" workDir="E:/workspace/DataTool/work" >

<Resource name="jdbc/mysql/test"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=gb2312"
username="root"
password=""
maxActive="20"
maxIdle="10"
maxWait="-1"
/>
</Context>

</Host>

E:/workspace/DataTool/WEB-INF/web.xml
<?mxl version="1.0" ecnoding="ISO-8859-1"?>

<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

<description>datepool</description>

<resource-ref>
<description>datesource</description>

<res-ref-name>jdbc/mysql/test</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

</web-app>

E:/workspace/DataTool/show.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>

<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>

<html>
<head>

<title>My JSP 'testPool.jsp' starting page</title>

</head>

<body>
my JSP page. <br>
<%
try {
Connection conn=null;

Context initCtx=new InitialContext();

Context ctx = new InitialContext();

javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/mysql/test");

conn=ds.getConnection();

Statement stmt=conn.createStatement();

PreparedStatement ps=conn.prepareStatement("select * from student");

ResultSet rs=ps.executeQuery();

while(rs.next()){

out.println(rs.getString(3)+"<br>");

}

rs.close();
stmt.close();
out.println("ok");

}

catch(Exception e) {

System.out.println(e.toString());
}

%>
</body>
</html>

hikiboy

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Tomcat5.5.17+MySQL构建数据源

C:/Tomcat 5.5/conf/server.xml中添加auth="Container"type="javax.sql.DataSource"driverClassName="com.mysql.jdbc.Driver"url="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=gb2312"username
复制链接

扫一扫