Tomcat 6.0配置Mysql数据库连接池
来源:互联网 发布:什么linux好用 编辑:程序博客网 时间:2024/06/05 22:37
在NetBaen里新建一个Web项目,打开配置文件context.xml,输入以下内容:
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true" reloadable="true" path="/nutz_Text">
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="50" maxWait="5000" maxldle="10" name=自定义出一个变量名 password=数据库密码 username=数据库管理员type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/bat?autoReconnect=true" />
</Context>
注: <Context crossContext="true" reloadable="true" path="/nutz_Text"> 里不要有antiJARLocking="true",因为antiJARLocking="true"会有一些副作用,包括屏蔽了JSP文件在运行服务器上的重新加载。
Ok,编写测试程序:
package com;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.*;
//import java.sql.*;
import javax.naming.*;
import org.nutz.Nutz;
import org.nutz.dao.Dao;
import org.nutz.dao.impl.NutDao;
/**
*
* @author Administrator
*/
public class NewServlet extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
out.print("jiang");
Context context = new InitialContext();
DataSource source = (DataSource)context.lookup("java:comp/env/自定义的变量名");
out.print("jiang");
Dao dao =new NutDao(source); //Nutz.dao
out.print("jiang");
text p = new text();
out.print("jiang");
//p.setAge(20);
//p.setName("ABC");
dao.delete(text.class,"ABC");//根据名称删除
// out.print("删除成功: "+p.getName()+"\n");
java.util.List<text> list = dao.query(text.class, null, null);
java.util.Iterator<text> it = list.iterator();
while(it.hasNext()){
text tmp =(text)it.next();
out.print(tmp.getId()+" "+tmp.getName()+" "+tmp.getAge());
out.print("\n");
}
} catch (NamingException ex) {
//Logger.getLogger(NewServlet.class.getName()).log(Level.SEVERE, null, ex);
out.print("出错");
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
启动Tomcat,运行这个Servlet,搞定.....
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true" reloadable="true" path="/nutz_Text">
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="50" maxWait="5000" maxldle="10" name=自定义出一个变量名 password=数据库密码 username=数据库管理员type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/bat?autoReconnect=true" />
</Context>
注: <Context crossContext="true" reloadable="true" path="/nutz_Text"> 里不要有antiJARLocking="true",因为antiJARLocking="true"会有一些副作用,包括屏蔽了JSP文件在运行服务器上的重新加载。
Ok,编写测试程序:
package com;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.*;
//import java.sql.*;
import javax.naming.*;
import org.nutz.Nutz;
import org.nutz.dao.Dao;
import org.nutz.dao.impl.NutDao;
/**
*
* @author Administrator
*/
public class NewServlet extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
out.print("jiang");
Context context = new InitialContext();
DataSource source = (DataSource)context.lookup("java:comp/env/自定义的变量名");
out.print("jiang");
Dao dao =new NutDao(source); //Nutz.dao
out.print("jiang");
text p = new text();
out.print("jiang");
//p.setAge(20);
//p.setName("ABC");
dao.delete(text.class,"ABC");//根据名称删除
// out.print("删除成功: "+p.getName()+"\n");
java.util.List<text> list = dao.query(text.class, null, null);
java.util.Iterator<text> it = list.iterator();
while(it.hasNext()){
text tmp =(text)it.next();
out.print(tmp.getId()+" "+tmp.getName()+" "+tmp.getAge());
out.print("\n");
}
} catch (NamingException ex) {
//Logger.getLogger(NewServlet.class.getName()).log(Level.SEVERE, null, ex);
out.print("出错");
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
启动Tomcat,运行这个Servlet,搞定.....
- tomcat 6.0 + mysql + jndi 数据库连接池配置
- Tomcat 6.0配置Mysql数据库连接池
- tomcat 配置mysql 数据库连接池
- tomcat配置mysql数据库连接池
- Tomcat 6.0 配置数据库连接池(oracle,mysql,sqlserver)
- Tomcat 5.5 配置 MySQL 数据库连接池
- Tomcat 5.5 配置 MySQL 数据库连接池
- Tomcat下配置MySQL数据库连接池
- Tomcat 5.5 配置 MySQL 数据库连接池
- Eclipse+TomCat+MySQL配置数据库连接池
- Tomcat下配置MySQL数据库连接池
- Tomcat下配置MySQL数据库连接池
- Tomcat下配置MySQL数据库连接池
- Tomcat配置MySQL JDBC数据库连接池
- Tomcat 5.5 配置 MySQL 数据库连接池
- Tomcat下配置MySQL数据库连接池
- 学习Tomcat下配置MySQL数据库连接池
- Tomcat下配置MySQL数据库连接池
- Windows下下载Android源代码,eclipse中关联android源代码
- 易混淆的知识点学习记录1
- 《C语言名题精选百则----11》
- Maven学习笔记(一) 安装和构建简单应用
- java之构造方法
- Tomcat 6.0配置Mysql数据库连接池
- 不同电脑的iTunes音乐和应用同步方法
- 算法设计中的排列问题
- Unix script - 14 hints and tips
- Eclipse上GIT插件EGIT使用手册之二_使用EGIT前的配置
- 对STL容器线程安全性的期待现实一些
- 安装vmware tools时,kernel版本不匹配问题的解决方法
- JS操作Cookies
- Eclipse上GIT插件EGIT使用手册之三_新建GIT仓库