Tomcat5.5 配置mysql数据库连接池

最新推荐文章于 2024-03-25 14:05:07 发布

最新推荐文章于 2024-03-25 14:05:07 发布 · 237 阅读

文章标签：

#MySQL #Tomcat #Java #SQL Server #SQL

java基础专栏收录该内容

38 篇文章

订阅专栏

环境:Tomcat5.5.23 Eclipse3.2.2 MyEclipse 5.1.1 GA mysql4.0.16 一、在Server.xml中配置

 <Resource name="jdbc/myown" auth="Container" type="javax.sql.DataSource" maxActive="10" maxIdle="3" maxWait="10000" username="root" password="" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test" />

放到　</GlobalNamingResources>中。二、F:\soft\apache-tomcat-5.5.23\conf\Catalina\localhost目录中新建一个工程名.xml文件，F:\soft\apache-tomcat-5.5.23为tomcat安装目录。在工程名.xml中写下面的内容：

<Context> <Resource name="jdbc/myown" auth="Container" type="javax.sql.DataSource" maxActive="10" maxIdle="3" maxWait="10000" username="root" password="" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test" /> </Context>

三、添加数据库驱动jar文件到F:\soft\apache-tomcat-5.5.23\common\lib与工程web目录\lib下. 四、写jsp页面测试：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>

<html>
	<body>
		<%
			DataSource ds = null;
			Connection conn = null;
			ResultSet rs = null;
			Statement stmt = null;
			InitialContext ctx = null;
			try {
				ctx = new InitialContext();			
				ds = (DataSource) ctx.lookup("java:comp/env/jdbc/myown"); 				
				conn = ds.getConnection();				
				stmt = conn.createStatement();				
				rs = stmt.executeQuery("select * from users");
				while (rs.next()) {
					out.println(rs.getString(1) + "");
					out.println(rs.getString(2) + "");
				}
			} catch (Exception ex) {
				ex.printStackTrace();
			} finally {
				try {
					if (rs != null)
						rs.close();
					if (stmt != null)
						stmt.close();
					if (conn != null)
						conn.close();
					if (ctx != null)
						ctx.close();
				} catch (SQLException e) {
					System.out.println("SQL关闭异常");
					e.printStackTrace();
				} catch (NamingException e) {
					System.out.println("命名空间关闭异常");
					e.printStackTrace();
				}

			}
		%>

	</body>
</html>