关于SSI和TOMCAT连接池的环境配置

 

写SSI TOMCAT dbcp连接池的实现，东拼西凑

所需jar包

一、Tomcat配置

以往都是在service里配置context标签，4以后就可以在lib下添加context文件也可以实现，那就俩个都试试吧！

1.1、

<Context path="/UserManage" docBase="UserManage" reloadable="true" crossContext="true"> <Resource name="jdbc/usermanage" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="scott" password="tiger" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:book"/> </Context>

参数：

maxActive连接池支持的最大连接数
maxIdle连接池中最多可空闲maxIdle个连接
minIdle连接池中最少空闲maxIdle个连接
initialSize初始化连接数目
maxWait连接池中连接用完时,新的请求等待时间,毫秒 

1.2、在context.xml中的context标签内加入以下代码:

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

2、在web.xml中web-app下加入以下代码

<resource-ref> <res-ref-name>jdbc/usermanage</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth></resource-ref>

3. 在SPRING的配置文件中加入如下代码

  <bean id="dataSourcetarget" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="java:comp/env/jdbc/usermanage"></property> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter"> <property name="targetDataSource"> <ref bean="dataSourcetarget" /> </property> </bean> <bean id="sqlClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="dataSource"> <ref local="dataSource"/> </property> <property name="configLocation"> <value>classpath:config.xml</value> </property> </bean> 

二、各个文件

1、Login.java

 

package org.login.actions;import java.util.List;import javax.servlet.http.HttpServletRequest;import org.apache.struts2.interceptor.ServletRequestAware;import org.login.service.IUserService;import org.login.vo.Users;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Service;import com.opensymphony.xwork2.ActionSupport;@SuppressWarnings({"serial","unchecked"})@Service("login")public class Login extends ActionSupport implements ServletRequestAware {private static final String UPDATE = "update";private HttpServletRequest request = null;@Autowired(required = false)@Qualifier("userService")private IUserService userService = null;private String id = null;private String name = null;private String password = null;public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getId() {return id;}public void setId(String id) {this.id = id;}public IUserService getUserService() {return userService;}public void setUserService(IUserService userService) {this.userService = userService;}@Overridepublic String execute() throws Exception {Users user = new Users();user.setUserName(name);user.setPassword(password);if (getUserService().isLogin(user)) {return SUCCESS;}return INPUT;}public String save() throws Exception {Users user = new Users();user.setUserName(name);user.setPassword(password);if (getUserService().insertUser(user)) {return SUCCESS;}return ERROR;}public String update() throws Exception {Users user = null;String action = request.getParameter("action");String id = request.getParameter("id");if ("loading".equals(action)) {user = new Users();user = getUserService().getUserById(Integer.valueOf(id));if (null != user) {request.setAttribute("user", user);}return UPDATE;} else {user = new Users();user.setUserName(name);user.setPassword(password);user.setId(Integer.valueOf(id));if (getUserService().updateUser(user)) {return SUCCESS;}}return ERROR;}public String delete() throws Exception {String id = request.getParameter("id");if (getUserService().deleteUser(Integer.valueOf(id))) {return SUCCESS;}return ERROR;}public String findAllUsers() throws Exception {List<Users> list = getUserService().getAllUser(); if (list.size() > 0) {request.setAttribute("list", list);return SUCCESS;}return ERROR;}public void setServletRequest(HttpServletRequest request) {this.request = request;}}

2、UserDAO.java

 

package org.login.dao.Impl;import java.sql.SQLException;import java.util.List;import org.login.dao.IUserDAO;import org.login.vo.Users;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Service;import com.ibatis.sqlmap.client.SqlMapClient;@SuppressWarnings("unchecked")@Service("userDAO")public class UserDAO implements IUserDAO { @Autowired(required=false) @Qualifier("sqlClient") private SqlMapClient client = null; public SqlMapClient getClient() { return client; } public void setClient(SqlMapClient client) { this.client = client; } public boolean deleteUser(Integer id) { try { client.delete("deleteUser", id); return true; } catch (SQLException e) { e.printStackTrace(); } return false; } public List<Users> getAllUser() { List<Users> list = null; try { list = client.queryForList("getAllUser"); } catch (SQLException e) { e.printStackTrace(); } return list; } public boolean insertUser(Users user) { try { client.insert("insertUser", user); return true; } catch (SQLException e) { e.printStackTrace(); } return false; } public boolean updateUser(Users user) { try { client.update("updateUser", user); return true; } catch (SQLException e) { e.printStackTrace(); } return false; } public boolean isLogin(Users user) { try { Users u = (Users) client.queryForObject("checkUser", user); if (u != null) { return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } public Users getUserById(Integer id) { Users u = null; try { u = (Users) client.queryForObject("getUserById", id); } catch (SQLException e) { e.printStackTrace(); } return u; }}

3、IUserDAO

package org.login.dao;import java.util.List;import org.login.vo.Users;public interface IUserDAO { List<Users> getAllUser(); Users getUserById(Integer id); boolean isLogin(Users user); boolean insertUser(Users user); boolean updateUser(Users user); boolean deleteUser(Integer id);}
4、UserService.java

package org.login.service.Impl;import java.util.List;import org.login.dao.IUserDAO;import org.login.service.IUserService;import org.login.vo.Users;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Service;@Service("userService")public class UserService implements IUserService { @Autowired(required=false) @Qualifier("userDAO") private IUserDAO userDAO = null; public IUserDAO getUserDAO() { return userDAO; } public void setUserDAO(IUserDAO userDAO) { this.userDAO = userDAO; } public boolean deleteUser(Integer id) { return userDAO.deleteUser(id); } public List<Users> getAllUser() { return userDAO.getAllUser(); } public boolean insertUser(Users user) { return userDAO.insertUser(user); } public boolean isLogin(Users user) { return userDAO.isLogin(user); } public boolean updateUser(Users user) { return userDAO.updateUser(user); } public Users getUserById(Integer id) { return userDAO.getUserById(id); }}

5、IUserService.java

 

package org.login.service;import java.util.List;import org.login.vo.Users;public interface IUserService { List<Users> getAllUser(); Users getUserById(Integer id); boolean isLogin(Users user); boolean insertUser(Users user); boolean updateUser(Users user); boolean deleteUser(Integer id);}

6、User.java

 

package org.login.vo;public class Users { private Integer id; private String userName; private String password; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Users() { } public Users(Integer id, String userName, String password) { super(); this.id = id; this.userName = userName; this.password = password; } }

7、User.xml   映射文件

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="users"> <typeAlias alias="users" type="org.login.vo.Users"/> <resultMap class="users" id="get-all-user"> <result property="id" column="id"/> <result property="userName" column="username"/> <result property="password" column="password"/> </resultMap> <select id="checkUser" parameterClass="users" resultClass="users"> <!--[CDATA[ SELECT id, username, password FROM users WHERE username = #userName# and password = #password# ]]> </select> <select id="getUserById" parameterClass="java.lang.Integer" resultClass="users"> <![CDATA[ SELECT id, username, password FROM users WHERE id = #id# ]]> </select> <select id="getAllUser" resultMap="get-all-user"> <![CDATA[ SELECT id, username, password FROM users ]]> </select> <insert id="insertUser" parameterClass="users"> <![CDATA[ INSERT INTO users (id,username, password) VALUES (SEQ.NEXTVAL,#userName#, #password#) ]]> </insert> <update id="updateUser" parameterClass="users"> <![CDATA[ UPDATE users SET username=#userName#, password=#password# WHERE id=#id# ]]> </update> <delete id="deleteUser" parameterClass="java.lang.Integer"> <![CDATA[ DELETE FROM users WHERE id = #id# ]]--> </delete></sqlMap>
8、config.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <sqlMap resource="org/login/vo/Users.xml"/></sqlMapConfig>
9、struts.properties

 

struts.locale=zh_CNstruts.i18n.encoding=UTF-8 struts.objectFactory=spring

9、struts.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"><struts> <include file="struts-default.xml"/> <package name="struts2" extends="struts-default"> <action name="logon" class="login"> <result name="success">/success.jsp</result> <result name="input">/login.jsp</result> </action> <action name="save" class="login" method="save"> <result name="success">/success.jsp</result> <result name="error">/error.jsp</result> </action> <action name="update" class="login" method="update"> <result name="success">/success.jsp</result> <result name="update">/update.jsp</result> <result name="error">/error.jsp</result> </action> <action name="delete" class="login" method="delete"> <result name="success">/success.jsp</result> <result name="error">/error.jsp</result> </action> <action name="show" class="login" method="findAllUsers"> <result name="success">/list.jsp</result> <result name="error">/error.jsp</result> </action> </package></struts>