Struts+iBatis+Spring+mysql整合开发


本文使用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;
}
}

 

 

 



来源博客:Wang Jie's Blog
本文链接:https://blog.wangjiegulu.com/2013/03/03/Struts-iBatis-Spring-mysql整合开发/
版权声明:本博客所有文章除特别声明外,均采用 CC BY 4.0 CN协议 许可协议。转载请注明出处。