Tomcate6.0连接池的配置及实例

最新推荐文章于 2024-04-03 12:09:24 发布

原创最新推荐文章于 2024-04-03 12:09:24 发布 · 744 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #import #stylesheet #string #microsoft #jsp

Tomcate 专栏收录该内容

3 篇文章

订阅专栏

Tomcat6.0 连接池的配置及实例

1．配置Tomcat目录文件夹conf下的context.xml文件添加如下节点：

SqlServer为:

MySql为：

2．找到WEB-INF/web.xml 在<web-app>..</web-app>中添加如下节点

<resource-ref>

<description>TestDB</description>

<res-ref-name>jdbc/testDB</res-ref-name>

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

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

</resource-ref>

3．编写测试程序代码如下:

package com.szkp;

import java.sql.*;

import javax.naming.*;

import javax.sql.DataSource;

import java.util.*;

public class Conn {

public Connection getCon(){

Connection con=null;

try {

Context ic=new InitialContext();

DataSource data=(DataSource)ic.lookup("java:comp/env/jdbc/testDB");

con=data.getConnection();

} catch (NamingException e) {

e.printStackTrace();

}catch (SQLException e) {

e.printStackTrace();

}

return con;

}

public List getData(Connection con){

List<String> name=null;

String sql="select au_lname from authors";

try {

Statement s=con.createStatement();

ResultSet rs=s.executeQuery(sql);

name=new ArrayList<String>();

while(rs.next()){

String ss=rs.getString(1);

name.add(ss);

}

} catch (SQLException e) {

e.printStackTrace();

}finally{

try {

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

return name;

}

4. 编写测试Jsp页面

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

<%@ page import="com.szkp.*" %>

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

request.setCharacterEncoding("gbk");

response.setContentType("text/html; charset=gb2312");

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

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

<!--

-->

</head>

<body>

This is my JSP page. <br>

<%Conn c=new Conn(); %>

<%Connection con=c.getCon(); %>

<%List name=c.getData(con);

for(int i=0;i<name.size();i++){

out.println(name.get(i)+"<br>");

}%>

</body>

</html>