关于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; } @Override public 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_CN struts.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>