struts2+spring+mybatis案例

步骤还是从web.xml开始_(:з」∠)_~ 可无视log4j~ლ(╹◡╹ლ)

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
 
  <context-param>
  	<param-name>webAppRootKey</param-name>
  	<param-value>ssi.root</param-value>
  </context-param> 
 
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
    <init-param>
      <param-name>actionPackages</param-name>
      <param-value>com.cstor.network.action</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath*:resource/applicationContext*.xml</param-value>
  </context-param>
  <listener>
    <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
  </listener>
  
  <!-- log4j -->
  <context-param>
    <param-name>log4jConfigLocation</param-name>
    <param-value>/WEB-INF/classes/resource/log4j.properties</param-value>
  </context-param>
  <context-param>
    <param-name>log4jRefreshInterval</param-name>
    <param-value>60000</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
  </listener>
  
</web-app>

 

秉承先搞定配置文件的执着↓↓↓↓↓↓↓↓applicationContext.xml↓↓↓↓↓↓↓↓↓↓↓↓(数据源换成c3p0了)

<?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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
       http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.springframework.org/schema/tx 
       http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

	<aop:aspectj-autoproxy proxy-target-class="true" />

	<!-- dataSource -->
	
	<bean name="c3p0DS" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
		<property name="jdbcUrl" value="jdbc:mysql://localhost/test"></property>
		<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
		<property name="user" value="root"></property>
		<property name="password" value="root"></property>
	</bean>

	<!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url"
			value="jdbc:mysql://localhost/test?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"></property>
		<property name="username" value="root"></property>
		<property name="password" value="root"></property>
		<property name="maxActive" value="100"></property>
		<property name="maxIdle" value="30"></property>
		<property name="maxWait" value="500"></property>
		<property name="defaultAutoCommit" value="true"></property>
	</bean> -->

	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="c3p0DS" />
	</bean>

	<!-- dao -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="c3p0DS" />
		<property name="typeAliasesPackage" value="com.wporoad.app.entity" />
	</bean>

	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.dao" />
	</bean>
	
	
</beans>

 

 然后需要mapper接口和xml↓↓↓↓↓↓↓↓

UserMapper.java

package com.dao;

import java.util.List;

import com.entity.User;

public interface UserMapper {
	public void addUser(User user);
	
	public List<User> queryUsers();
	
	public void delUser(String id);
}

 

 UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.UserMapper">

	<resultMap id="UserMap" type="com.entity.User">
		<result property="id" column="ID" />
		<result property="userName" column="USERNAME" />
		<result property="password" column="PASSWORD" />
		<result property="email" column="EMAIL" />
		<result property="isbn" column="ISBN"/>
	</resultMap>

	<insert id="addUser" parameterType="User">
		INSERT INTO USER(
		ID,
		USERNAME,
		PASSWORD,
		EMAIL,
		ISBN
		)
		VALUES (
		#{id},
		#{userName},
		#{password},
		#{email},
		#{isbn}
		)
	</insert>
	
	<select id="queryUsers" resultMap="UserMap" >
		SELECT * FROM USER
	</select>
	
	<!-- 删除信息 -->
	<delete id="delUser" parameterType="string">
		DELETE FROM USER WHERE ID = #{id}
	</delete>
	
</mapper>

 

补上实体类User.java

package com.entity;

import java.io.Serializable;

public class User implements Serializable {

	private static final long serialVersionUID = 1L;

	private String id;
	private String userName;
	private String password;
	private String email;
	private String isbn;

	........get、set...........
	
}

 

 继续写业务层的接口和实现↓↓↓↓↓↓↓↓↓↓↓

UserService.java

package com.service;

import java.util.List;

import com.entity.User;

public interface UserService {
	public void addUser(User user);
	
	public List<User> queryUsers();
	
	public void delUser(String id);
}

 

UserServiceImpl.java

package com.serviceImpl;

import java.util.List;

import com.dao.UserMapper;
import com.entity.User;
import com.service.UserService;

public class UserServiceImpl implements UserService{
	private UserMapper userMapper;
	
	public UserMapper getUserMapper() {
		return userMapper;
	}

	public void setUserMapper(UserMapper userMapper) {
		this.userMapper = userMapper;
	}
	
	public void addUser(User user) {
		userMapper.addUser(user);
	}

	public List<User> queryUsers() {
		List<User> userList = userMapper.queryUsers();
		return userList;
	}

	public void delUser(String id) {
		userMapper.delUser(id);
	}

}

 

Actionლ(╹◡╹ლ) Actionლ(╹◡╹ლ) Actionლ(╹◡╹ლ)

UserAction.java

package com.web;

import java.util.List;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;

import org.apache.log4j.Logger;
import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;
import com.entity.User;
import com.service.UserService;

public class UserAction extends ActionSupport {
	private static final long serialVersionUID = 1L;
	private static Logger logger = Logger.getLogger(UserAction.class);

	public UserService userService;

	public UserService getUserService() {
		return userService;
	}

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

	private String id;
	private String userName;
	private String password;
	private String email;
	private String isbn;
	
	List<User> userList;

	public String addUser() {
		User user = new User();
		try {
			System.out.println(1);
			String iid = UUID.randomUUID().toString();
			user.setId(iid);
			user.setUsername(userName);
			user.setPassword(password);
			user.setEmail(email);
			user.setIsbn(isbn);
			userService.addUser(user);
			System.out.println(2);
		} catch (Exception e) {
			logger.error("exception in add user", e);
			return ERROR;
		}
		return SUCCESS;
	}

	public String queryUsers() {
		try {
			userList = userService.queryUsers();
			HttpServletRequest request = ServletActionContext.getRequest();
			request.setAttribute("list", userList);
			return "list";
		} catch (Exception e) {
			logger.error("Exception in queryUsers", e);
			return ERROR;
		}
	}

	public String delUser() {
		try {
			userService.delUser(id);
		} catch (Exception e) {
			logger.error("Exception in delUser", e);
			return ERROR;
		}
		return SUCCESS;
	}

	........get、set............
}

 

 至此已一本Ok了，至于struts.xml←这货和页面什么的~自行YY即可√ლ(╹◡╹ლ)