Tomcat6.0 SQL2000连接池配置详细分析

最新推荐文章于 2021-03-06 23:18:17 发布

taste品味

最新推荐文章于 2021-03-06 23:18:17 发布

阅读量1.4k

点赞数

分类专栏： java 文章标签： tomcat sql string myeclipse sqlserver microsoft

本文链接：https://blog.youkuaiyun.com/duck04551/article/details/5812462

版权

java 专栏收录该内容

13 篇文章

订阅专栏

Tomcat6.0安装在：C:/Program Files/Tomcat 6.0/conf

1.在Tomcat中布暑项目，Tomcat 6.0/conf目录下新建目录Catalina/localhost，在该文件夹下新建一个XML文件，内容如下所示：

<?xml version="1.0" encoding="UTF-8" ?>
<Context path="/myBlog" docBase="F:/Workspaces/myBlog/WebRoot" debug="0" privileged="true" antiResourceLocking="false" antiJARLocking="false" reloadable="true">
</Context>

说明：path项目所在文件夹 docBase项目所在的路径

2.Tomcat 6.0/conf/context.xml该文件中填写连接池语句，如下所示：

<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>

    
    
<Resource name="jdbc/blogdatabase" type="javax.sql.DataSource" password="895278" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" maxIdle="2" maxWait="5000" username="sa" url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=blog;" maxActive="4" />
</Context>

3.将驱动包msbase.jar，mssqlserver.jar，msutil.jar复制到Tomcat 6.0/lib目录。

到此已经完成配置。

在项目中引起连接池，在myEclipse8.5建立一个HttpServlet，内容如下所示：

package cn.com.jodedu.blog;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.sql.DataSource;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.dbutils.QueryRunner;

public class BlogServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  // 解决从JSP页面接受中文参数乱码的问题
  request.setCharacterEncoding("UTF-8");
  String title = request.getParameter("title");
  String content = request.getParameter("content");
  String catagoryId = request.getParameter("catagory");

  DataSource ds = null;
  int result = 0;
  String message = "";

  // 方法一 //数据源对象可以理解为连接池的管理者，通过它可以获取数据库的连接
  try {
   Context context = new InitialContext();
   ds = (DataSource) context.lookup("java:comp/env/jdbc/blogdatabase");
  } catch (Exception e) {
   System.out.print("获取数据源出错");
   message = "获取数据源出错";
  }
  try {
   Connection conn = ds.getConnection();
   String sqlStr = "insert into blogContent(blotTitle, blogType, blogtext) values(?,?,?)";
   // ?通过预编译方式赋值
   PreparedStatement statement = conn.prepareStatement(sqlStr);
   statement.setString(1, title);
   statement.setInt(2, Integer.parseInt(catagoryId));
   statement.setString(3, content);
   result = statement.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
   message = "getConnection出错";
  }

  if (result == 1) {
   message = "添加成功";
  } else {
   message = "添加失败";
  }