Struts+iBatis+Spring+mysql整合开发

转载请注明：http://www.cnblogs.com/tiantianbyconan/archive/2013/03/03/2941554.html

本文使用Struts+iBatis+Spring三层框架开实现对user表的CRUD。

分层如下：

 

iBatis配置文件（sqlMapConfig.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>

    <settings cacheModelsEnabled="true" enhancementEnabled="true"
        lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"
        maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />

    <sqlMap resource="com/tiantian/ibatis/model/user.xml" />
    
</sqlMapConfig>

 

struts.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
    "http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>
    <package name="ibatis_test" extends="struts-default">
        <!-- 注册User action -->
        <action name="registerUser" class="registerUserAction">
        </action>
        <!-- 删除User action -->
        <action name="deleteUser" class="deleteUserAction">
        </action>
        <!-- 更新User action -->
        <action name="updateUser" class="updateUserAction">
        </action>
        <!-- 查询所有User action -->
        <action name="findAllUsers" class="findAllUsersAction">
        </action>
        <!-- 查询指定id的User action -->
        <action name="findUserById" class="findUserByIdAction">
        </action>
        <!-- 模糊查询User action -->
        <action name="findUsersBykeyword" class="findUsersBykeywordAction">
        </action>
        
    </package>
    
</struts>

 

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>
    <!-- 为Student类取个别名 -->
    <typeAlias alias="UserAlias" type="com.tiantian.ibatis.model.User"/>
    
    <!-- 配置表和实体Bean之间的映射关系 -->  
    <resultMap id="userMap" class="com.tiantian.ibatis.model.User">  
        <result property="id" column="id"/>
        <result property="username" column="username"/>
        <result property="password" column="password"/>
        <result property="age" column="age"/>
    </resultMap>
    <!-- 添加数据 -->
    <insert id="registerUser" parameterClass="UserAlias">
        INSERT INTO user VALUES (NULL, #username#, #password#, #age#);
    </insert>
    <!-- 删除指定id的数据 -->
    <delete id="deleteUser" parameterClass="UserAlias">
        DELETE FROM user WHERE id = #id#;
    </delete>
    <!-- 修改指定id的数据 -->
    <update id="updateUser" parameterClass="UserAlias">
        UPDATE user 
        SET username = #username#, password = #password#, age = #age#
        WHERE id = #id#;
    </update>
    <!-- 查询所有User信息 -->
    <select id="findAllUsers" resultMap="userMap">
        SELECT * FROM user;
    </select>
    <!-- 查询指定id的User信息 -->
    <select id="findUserById" resultMap="userMap">
        SELECT * FROM user WHERE id = #id#;
    </select>
    <!-- 模糊查询 -->
    <select id="findUsersByKeyword" resultMap="userMap">
        SELECT * FROM user WHERE username LIKE '%$keyword$%';
    </select>
    
</sqlMap>

 

applicationContext.xml配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/test" />
        <property name="username" value="root" />
        <property name="password" value="XXXX" />
        
        <property name="validationQuery" value="select user.id from user"></property>
        <property name="maxIdle" value="15"></property>
        <property name="maxActive" value="15"></property>
        <property name="maxWait" value="1000"></property>
    </bean>
    
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation" value="classpath:sqlMapConfig.xml"></property>
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 事务管理 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    
    <!-- 声明式事务管理 -->
    <bean id="baseTransactionProxy"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
        abstract="true">
        <property name="transactionManager" ref="transactionManager"></property>
        <property name="transactionAttributes">
            <props>
                <!-- 
                    表示设置事务属性所有以"find"和"get"开头的方法：
                    - PROPAGATION_REQUIRED: 当前存在事务则使用存在的事务，如果不存在，则开启一个新的事务
                    - readOnly:表示只读的事务
                 -->
                <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="*">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>
    <!-- *****************************以上一般只需修改数据库配置******************************** -->
    
    <!-- ********************************************************************* -->
    <!-- *******************************DAO*********************************** -->
    <!-- ********************************************************************* -->
    <!-- DAO、Service一般都配置成singleton（可以不写，因为默认是singleton） -->
    <bean id="userDao" class="com.tiantian.ibatis.dao.impl.UserDaoImpl" scope="singleton">
        <property name="sqlMapClient" ref="sqlMapClient"></property>
    </bean>
    
    <!-- ************************************************************************* -->
    <!-- *******************************Service*********************************** -->
    <!-- ************************************************************************* -->
    <!-- Service，没有事务功能 -->
    <bean id="userServiceTarget" class="com.tiantian.ibatis.service.impl.UserServiceImpl">
        <property name="userDao" ref="userDao"></property>
    </bean>
    <!-- Service的代理，目的是为Service添加事务的功能 -->
    <bean id="userService" parent="baseTransactionProxy">
        <property name="target" ref="userServiceTarget"></property>
    </bean>
    
    <!-- ************************************************************************ -->
    <!-- *******************************Action*********************************** -->
    <!-- ************************************************************************ -->
    <!-- Action一般都配置成prototype（必须要写!） -->
<!-- **User Actions** -->
    <bean id="registerUserAction" class="com.tiantian.ibatis.action.user.RegisterUserAction" scope="prototype">
        <property name="userService" ref="userService"></property>
    </bean>
    <bean id="deleteUserAction" class="com.tiantian.ibatis.action.user.DeleteUserAction" scope="prototype">
        <property name="userService" ref="userService"></property>
    </bean>
    <bean id="updateUserAction" class="com.tiantian.ibatis.action.user.UpdateUserAction" scope="prototype">
        <property name="userService" ref="userService"></property>
    </bean>
    <bean id="findAllUsersAction" class="com.tiantian.ibatis.action.user.FindAllUsersAction">
        <property name="userService" ref="userService"></property>
    </bean>
    <bean id="findUserByIdAction" class="com.tiantian.ibatis.action.user.FindUserByIdAction">
        <property name="userService" ref="userService"></property>
    </bean>
    <bean id="findUsersBykeywordAction" class="com.tiantian.ibatis.action.user.FindUsersByKeywordAction">
        <property name="userService" ref="userService"></property>
    </bean>

</beans>

 

DAO接口：

/**
 * @author wangjie
 * @version 创建时间：2013-3-1 下午5:44:21
 */
public interface UserDao {
    public void registerUser(User user);
    public boolean deleteUser(User user);
    public boolean updateUser(User user);
    public List<User> findAllUsers();
    public User findUserById(User user);
    public List<User> findUsersByKeyword(String keyword);
}

DAO实现类（执行各个Action所需的数据库查询操作）：

package com.tiantian.ibatis.dao.impl;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.tiantian.ibatis.dao.UserDao;
import com.tiantian.ibatis.model.User;

/**
 * @author wangjie
 * @version 创建时间：2013-3-1 下午6:09:53
 */
public class UserDaoImpl extends SqlMapClientDaoSupport implements UserDao{

    public void registerUser(User user) {
        getSqlMapClientTemplate().insert("registerUser", user);
    }

    public boolean deleteUser(User user) {
        boolean result = false;
        int effectedRow = getSqlMapClientTemplate().delete("deleteUser", user);
        System.out.println("delete effectedRow: " + effectedRow);
        result = effectedRow > 0 ? true : false;
        return result;
    }

    public boolean updateUser(User user) {
        boolean result = false;
        int effectedRow = getSqlMapClientTemplate().update("updateUser", user);
        System.out.println("update effectedRow: " + effectedRow);
        result = effectedRow > 0 ? true : false;
        return result;
    }

    public List<User> findAllUsers() {
        return (List<User>)getSqlMapClientTemplate().queryForList("findAllUsers");
    }

    public User findUserById(User user) {
        return (User) getSqlMapClientTemplate().queryForObject("findUserById", user);
    }

    public List<User> findUsersByKeyword(String keyword) {
        return (List<User>)getSqlMapClientTemplate().queryForList("findUsersByKeyword", keyword);
    }
    
    
}

Action类（以RegisterUserAction为例）：

package com.tiantian.ibatis.action.user;

import com.opensymphony.xwork2.ActionSupport;
import com.tiantian.ibatis.model.User;
import com.tiantian.ibatis.service.UserService;
import com.tiantian.ibatis.service.impl.UserServiceImpl;

/**
 * @author wangjie
 * @version 创建时间：2013-3-2 下午11:26:18
 */
public class RegisterUserAction extends ActionSupport{
    private UserService userService;
    private User user;
    
    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }
    
    public UserService getUserService() {
        return userService;
    }

    public void setUserService(UserService userService) {
        this.userService = userService;
    }

    @Override
    public String execute() throws Exception {
        userService.registerUser(user);
        System.out.println("数据已经插入");
        return null;
    }
}