tomcat5.5配置连接池总结

最新推荐文章于 2024-07-19 18:43:10 发布

置顶 hyanqing1

最新推荐文章于 2024-07-19 18:43:10 发布

阅读量311

点赞数

分类专栏： jsp&amp;j2ee 文章标签： tomcat import exception sqlserver stylesheet jdbc

本文链接：https://blog.csdn.net/hyanqing1/article/details/1663235

版权

jsp&j2ee 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

tomcat5.5配置：别忘了复制jdbc驱动到tomcat的lib文件夹下。
1.server.xml:
    <GlobalNamingResources>
         <Resource
           name="jdbc/bn"
           type="javax.sql.DataSource"
           maxActive="10"
           maxIdle="5"
           username="sa"
           maxWait="5000"
           driverClassName="net.sourceforge.jtds.jdbc.Driver"
           password=""
           url="jdbc:jtds:sqlserver://localhost:1433/ds"/>
    </GlobalNamingResources>
2.在项目的META-INF文件夹下新建：context.xml
   <?xml version="1.0" encoding="UTF-8"?>
   <Context path="/myds">
      <ResourceLink global="jdbc/bn" name="jdbc/bn"                            type="javax.sql.DataSource"/>
   </Context>
3.在项目的web.xml下加上以下代码：
   <resource-ref>
        <description>DB Connection</description>
        <res-ref-name>jdbc/bn</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
   </resource-ref>
4.编写通用的数据库连接javabean：DatabaseConn.java
连接数据库用：Connection conn=DatabaseConn.getConnection();
package com.database;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class DatabaseConn
{

    public DatabaseConn()
    {
    }
    public static synchronized Connection getConnection()throws          Exception
    {
        try
        {
            Context initCtx=new InitialContext();
            Context envCtx=(Context)initCtx.lookup("java:comp/env");
            DataSource ds=(DataSource)envCtx.lookup("jdbc/bn");
            return ds.getConnection();
        }
        catch (Exception e)
        {
            throw e;
        }

    }

}
5.测试index.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="GBk"%>
<%@page import="com.database.DatabaseConn" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

    <title>测试数据源</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
    <%
        java.sql.Connection conn = DatabaseConn.getConnection();
        java.sql.Statement stmt=conn.createStatement();
        java.sql.ResultSet rs=stmt.executeQuery("select * from myuser");


            while(rs.next())
            {
                out.print(rs.getString("username"));
                out.print(rs.getString("password"));


            }
            out.print("数据源配置成功！");

            conn.close();
            stmt.close();
            rs.close();

        %>

</body>
</html>

hyanqing1

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
tomcat5.5配置连接池总结

tomcat5.5配置：别忘了复制jdbc驱动到tomcat的lib文件夹下。1.server.xml: name="jdbc/bn" type="javax.sql.DataSource" maxActive="10" maxIdle="5" username="sa"
复制链接

扫一扫