使用CXF开发WebService程序的总结(七)：Spring+CXF+Mybatis+Mysql共同打造的服务端示例

通过该demo，可以熟悉下 spring+cxf+maven+mybatis+mysql等常见后端技术整合

1. 在前面的父工程 ws_parent 中添加依赖

由于原来的项目是使用的cxf依赖，现在需要集成spring，mybatis，所以需要在父工程添加依赖，最新的父工程的pom文件如下：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

	<modelVersion>4.0.0</modelVersion>

	<groupId>com.lonely.webservice</groupId>

	<artifactId>ws_parent</artifactId>

	<version>0.0.1-SNAPSHOT</version>

	<packaging>pom</packaging>

	<properties>

		<spring-version>4.1.7.RELEASE</spring-version>

		<mybatis.version>3.4.1</mybatis.version>

		<mybatis.spring.version>1.3.0</mybatis.spring.version>

		<pagehelper.version>4.0.0</pagehelper.version>

		<mysql.version>5.1.32</mysql.version>

		<druid.version>1.0.9</druid.version>

		<jstl.version>1.2</jstl.version>

		<servlet-api.version>2.5</servlet-api.version>

		<jsp-api.version>2.0</jsp-api.version>

		<slf4j.api.version>1.7.10</slf4j.api.version>

		<logback.version>1.1.7</logback.version>

		<dbcp.version>1.4</dbcp.version>

	</properties>

	<!-- 配置依赖 -->

	<dependencyManagement>

		<dependencies>

			<!-- spring依赖 -->

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-core</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-beans</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-tx</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-context</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-context-support</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-web</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-webmvc</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-aop</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-aspects</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<dependency>

				<groupId>org.springframework</groupId>

				<artifactId>spring-jdbc</artifactId>

				<version>${spring-version}</version>

			</dependency>

			<!-- cxf依赖 -->

			<dependency>

				<groupId>org.apache.cxf</groupId>

				<artifactId>cxf-core</artifactId>

				<version>3.1.6</version>

			</dependency>

			<dependency>

				<groupId>org.apache.cxf</groupId>

				<artifactId>cxf-rt-frontend-jaxws</artifactId>

				<version>3.1.6</version>

			</dependency>

			<dependency>

				<groupId>org.apache.cxf</groupId>

				<artifactId>cxf-rt-transports-http-jetty</artifactId>

				<version>3.1.6</version>

			</dependency>

			<!-- mybatis依赖 -->

			<dependency>

				<groupId>org.mybatis</groupId>

				<artifactId>mybatis</artifactId>

				<version>${mybatis.version}</version>

			</dependency>

			<dependency>

				<groupId>org.mybatis</groupId>

				<artifactId>mybatis-spring</artifactId>

				<version>${mybatis.spring.version}</version>

			</dependency>

			<dependency>

				<groupId>com.github.pagehelper</groupId>

				<artifactId>pagehelper</artifactId>

				<version>${pagehelper.version}</version>

			</dependency>

			<!-- mysql -->

			<dependency>

				<groupId>mysql</groupId>

				<artifactId>mysql-connector-java</artifactId>

				<version>${mysql.version}</version>

			</dependency>

			<!-- 连接池 -->

			<dependency>

				<groupId>com.alibaba</groupId>

				<artifactId>druid</artifactId>

				<version>${druid.version}</version>

			</dependency>

			<dependency>

				<groupId>commons-dbcp</groupId>

				<artifactId>commons-dbcp</artifactId>

				<version>${dbcp.version}</version>

			</dependency>

			<!-- JSP相关 -->

			<dependency>

				<groupId>jstl</groupId>

				<artifactId>jstl</artifactId>

				<version>${jstl.version}</version>

			</dependency>

			<dependency>

				<groupId>javax.servlet</groupId>

				<artifactId>servlet-api</artifactId>

				<version>${servlet-api.version}</version>

				<scope>provided</scope>

			</dependency>

			<dependency>

				<groupId>javax.servlet</groupId>

				<artifactId>jsp-api</artifactId>

				<version>${jsp-api.version}</version>

				<scope>provided</scope>

			</dependency>

			<!-- 日志处理 -->

			<dependency>

				<groupId>org.slf4j</groupId>

				<artifactId>slf4j-api</artifactId>

				<version>${slf4j.api.version}</version>

			</dependency>

			<dependency>

				<groupId>ch.qos.logback</groupId>

				<artifactId>logback-classic</artifactId>

				<version>${logback.version}</version>

			</dependency>

			<dependency>

				<groupId>ch.qos.logback</groupId>

				<artifactId>logback-core</artifactId>

				<version>${logback.version}</version>

			</dependency>

		</dependencies>

	</dependencyManagement>

	<!-- 配置插件信息 -->

	<build>

		<plugins>

			<plugin>

				<groupId>org.apache.maven.plugins</groupId>

				<artifactId>maven-compiler-plugin</artifactId>

				<configuration>

					<source>1.8</source>

					<target>1.8</target>

					<encoding>UTF-8</encoding>

				</configuration>

			</plugin>

		</plugins>

	</build>

	<modules>

		<module>ws_server</module>

		<module>ws_client</module>

		<module>ws_ssm_server</module>

	</modules>

</project>

2. 新建一个maven子工程 ws_ssm_server

2.1 新建一个子工程，打包方式为 war格式，因为spring的很多依赖有重复，经整理后其pom文件如下：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <parent>

    <groupId>com.lonely.webservice</groupId>

    <artifactId>ws_parent</artifactId>

    <version>0.0.1-SNAPSHOT</version>

  </parent>

  <artifactId>ws_ssm_server</artifactId>

  <packaging>war</packaging>

  <dependencies>

		<!-- spring依赖 -->

		<dependency>

			<groupId>org.springframework</groupId>

			<artifactId>spring-context-support</artifactId>

		</dependency>

		<dependency>

			<groupId>org.springframework</groupId>

			<artifactId>spring-webmvc</artifactId>

		</dependency>

		<dependency>

			<groupId>org.springframework</groupId>

			<artifactId>spring-aspects</artifactId>

		</dependency>

		<dependency>

			<groupId>org.springframework</groupId>

			<artifactId>spring-jdbc</artifactId>

		</dependency>

		<!-- 添加 cxf 依赖 -->

		<dependency>

			<groupId>org.apache.cxf</groupId>

			<artifactId>cxf-core</artifactId>

		</dependency>

		<dependency>

			<groupId>org.apache.cxf</groupId>

			<artifactId>cxf-rt-frontend-jaxws</artifactId>

		</dependency>

		<dependency>

			<groupId>org.apache.cxf</groupId>

			<artifactId>cxf-rt-transports-http-jetty</artifactId>

		</dependency>

		<!-- mybatis依赖 -->

		<dependency>

			<groupId>org.mybatis</groupId>

			<artifactId>mybatis</artifactId>

		</dependency>

		<dependency>

			<groupId>org.mybatis</groupId>

			<artifactId>mybatis-spring</artifactId>

		</dependency>

		<!-- mysql -->

		<dependency>

			<groupId>mysql</groupId>

			<artifactId>mysql-connector-java</artifactId>

		</dependency>

		<!-- 连接池 -->

		<dependency>

			<groupId>commons-dbcp</groupId>

			<artifactId>commons-dbcp</artifactId>

		</dependency>

		<!-- 日志处理 -->

		<dependency>

			<groupId>org.slf4j</groupId>

			<artifactId>slf4j-api</artifactId>

		</dependency>

		<dependency>

			<groupId>ch.qos.logback</groupId>

			<artifactId>logback-classic</artifactId>

		</dependency>

		<dependency>

			<groupId>ch.qos.logback</groupId>

			<artifactId>logback-core</artifactId>

		</dependency>

	</dependencies>

</project>

2.2 spring整合cxf

2.2.1 在web.xml中添加 cxf 拦截器处理器配置,以及 spring容器启动创建配置

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.5"

         xmlns="http://java.sun.com/xml/ns/javaee"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

    <!-- 字符编码过滤器，必须放在过滤器的最上面 -->

    <filter>

        <filter-name>encodingFilter</filter-name>

        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

        <init-param>

            <param-name>forceEncoding</param-name>

            <param-value>true</param-value>

        </init-param>

        <init-param>

            <param-name>encoding</param-name>

            <param-value>UTF-8</param-value>

        </init-param>

        <init-param>

            <param-name>characterEncoding</param-name>

            <param-value>UTF-8</param-value>

        </init-param>

    </filter>

    <filter-mapping>

        <filter-name>encodingFilter</filter-name>

        <url-pattern>/*</url-pattern>

    </filter-mapping>

    <context-param>

        <param-name>contextConfigLocation</param-name>

        <param-value>classpath:spring/application.xml</param-value>

    </context-param>

    <listener>

        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

    </listener>

	<!-- 配置cxf拦截器 -->

	<servlet>

		<servlet-name>cxfServlet</servlet-name>

		<servlet-class>org.apache.cxf.transport.servlet.CXFServlet</servlet-class>

	</servlet>

	<servlet-mapping>

		<servlet-name>cxfServlet</servlet-name>

		<url-pattern>/cxf/*</url-pattern>

	</servlet-mapping>

    <welcome-file-list>

        <welcome-file>/index.jsp</welcome-file>

    </welcome-file-list>

</web-app>

2.2.2 在resource目录下创建文件夹 spring，在里面创建spring与cxf集成的配置文件： spring-cxf.xml

这里注意要添加一个 jaxws的命名空间，以及引入两个 cxf中的 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:jaxws="http://cxf.apache.org/jaxws"

	xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd

		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<import resource="classpath:META-INF/cxf/cxf.xml" />

	<import resource="classpath:META-INF/cxf/cxf-servlet.xml" />

	<!-- 定义服务提供者 -->

	<jaxws:endpoint implementor="#userService" address="/UserService" >

		<!-- 添加入 in 拦截器 -->

		<jaxws:inInterceptors>

			<bean class="com.lonely.interceptor.AuthInterceptor"></bean>

			<bean class="org.apache.cxf.interceptor.LoggingInInterceptor"></bean>

		</jaxws:inInterceptors>

		<!-- 添加 出 out 拦截器 -->

		<jaxws:outInterceptors>

			<bean class="org.apache.cxf.interceptor.LoggingOutInterceptor"></bean>

		</jaxws:outInterceptors>

	</jaxws:endpoint>

</beans>

2.2.3 jaxws:endpoint 中的 implementor:对应的服务接口的实现类，而 address ：对应发布的接口路径，注意在实际的接口实现类上使用注解 @Component让spring 扫描发现管理，给个别名用于在了 implementor属性上

UserService

package com.lonely.service;

import java.util.List;

import java.util.Map;

import javax.jws.WebService;

import javax.xml.bind.annotation.adapters.XmlJavaTypeAdapter;

import com.lonely.adapter.MapConvertAdapter;

import com.lonely.model.Clazz;

import com.lonely.model.User;

@WebService

public interface UserService {

	/**

	 * 根据班级信息返回该班级的学生列表

	 *

	 * @param clazz

	 * @return

	 */

	List<User> findUsersByClass(Clazz clazz);

	/**

	 * 查看所有班级信息以及班级下的所有学生

	 *

	 * @return

	 */

	@XmlJavaTypeAdapter(value = MapConvertAdapter.class)

	Map<String, List<User>> findAll();

}

UserServiceImpl

package com.lonely.service.impl;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.jws.WebService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

import com.lonely.dao.UserDao;

import com.lonely.model.Clazz;

import com.lonely.model.User;

import com.lonely.service.UserService;

@Component("userService")

@WebService

public class UserServiceImpl implements UserService {

	@Autowired

	private UserDao userDao;

	@Override

	public List<User> findUsersByClass(Clazz clazz) {

		return this.userDao.findUsersByClass(clazz);

	}

	@Override

	public Map<String, List<User>> findAll() {

		List<Clazz> clazzList = this.userDao.findAll();

		if (clazzList != null && clazzList.size() != 0) {

			Map<String, List<User>> map = new HashMap<>();

			for (Clazz clazz : clazzList) {

				map.put(clazz.getClassName(), clazz.getUsers());

			}

			return map;

		}

		return null;

	}

}

2.3 spring整合mybatis

2.3.1 在spring目录下，添加 spring与mybatis集成的配置： spring-datasource.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:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd">

	<!-- 配置数据源 -->

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

		<property name="username" value="${jdbc.jdbcUsername}"></property>

		<property name="password" value="${jdbc.jdbcPassword}"></property>

		<property name="url" value="${jdbc.jdbcUrl}"></property>

		<property name="driverClassName" value="${jdbc.driverClassName}"></property>

	</bean>

	<!-- 配置sqlsessionfactory -->

	<bean  id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">

		<!-- 配置数据源 -->

		<property name="dataSource" ref="dataSource"></property>

		<!-- 配置mybatis配置 -->

		<property name="configuration">

			<bean class="org.apache.ibatis.session.Configuration">

				<!-- 开启驼峰命名法 -->

				<property name="mapUnderscoreToCamelCase" value="true"></property>

				<!-- 当检测出未知列（或未知属性）时，如何处理，默认情况下没有任何提示，这在测试的时候很不方便，不容易找到错误。

					可选值：

						NONE : 不做任何处理 (默认值)

						WARNING : 警告日志形式的详细信息

						FAILING : 映射失败，抛出异常和详细信息

				-->

				<property name="autoMappingUnknownColumnBehavior" value="WARNING"></property>

			</bean>

		</property>

		<!-- 配置mapping扫描 -->

		<property name="mapperLocations" value="classpath:mapper/**/*.xml"></property>

		<!-- 配置别名包扫描 -->

		<property name="typeAliasesPackage" value="com.lonely.model"></property>

		<!-- 配置pagehelper 数据库方言 -->

		<property name="plugins">

			<list>

				<bean class="com.github.pagehelper.PageHelper">

					<property name="properties">

						<value>dialect=mysql</value>

					</property>

				</bean>

			</list>

		</property>

	</bean>

	<!-- 配置 接口与 mapper的映射 -->

	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

		<property name="basePackage" value="com.lonely.dao"></property>

		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"></property>

	</bean>

	<!-- 配置事务 -->

	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

		<property name="dataSource" ref="dataSource"></property>

	</bean>

	<!-- 开启事务注解 -->

	<tx:annotation-driven transaction-manager="transactionManager"/>

</beans>

2.3.2 在 basePackage 对应的路径下编写 dao层的接口

package com.lonely.dao;

import java.util.List;

import com.lonely.model.Clazz;

import com.lonely.model.User;

public interface UserDao {

	List<User> findUsersByClass(Clazz clazz);

	List<Clazz> findAll();

}

2.3.3 在 mapperLocations 对应的路径下编写 mybatis的sql操作的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.lonely.dao.UserDao">

	<resultMap type="clazz" id="clazzMap">

		<id property="classId" column="classId"/>

		<result property="className" column="className"/>

		<collection property="users" ofType="user">

			<id column="id" property="id"/>

			<result property="userName" column="userName"/>

			<result property="classId" column="classId"/>

		</collection>

	</resultMap>

    <!-- 根据班级信息查询所有学生 -->

    <select id="findUsersByClass" parameterType="clazz" resultType="user">

    	SELECT * from user u where u.classId = #{classId}

    </select>

    <!-- 查询所有班级信息以及班级下的所有学生列表 -->

    <select id="findAll" resultMap="clazzMap">

    	SELECT

			*

		FROM

			clazz c

		JOIN USER u ON c.classId = u.classId

    </select>

</mapper>

2.3.4 在这里使用了 mybatis的一对多，所以在 Clazz实体类上多加了一个属性 List<User> users;

2.3.5 忘了前面还需要一个 jdbc.properties

## jdbc环境配置

jdbc.driverClassName                = com.mysql.jdbc.Driver

jdbc.jdbcUrl                        = jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&allowMultiQueries=true

jdbc.jdbcUsername                   = root

jdbc.jdbcPassword                   = xxx

#jdbc.logAbandoned                   = false

#jdbc.initialSize                    = 20

#jdbc.maxActive                      =1000

#jdbc.maxIdle=100

#jdbc.maxWait                        = 1000

#jdbc.minEvictableIdleTimeMillis     = 300000

#jdbc.minIdle                        = 10

#jdbc.removeAbandoned                = true

#jdbc.removeAbandonedTimeout         = 3000

#jdbc.timeBetweenEvictionRunsMillis  = 10000

#jdbc.testOnBorrow                   = false

#jdbc.testWhileIdle                  = true

#jdbc.validSql                       = select now()

2.4 spring+cxf+mybatis

2.4.1 在spring目录下创建一个spring的核心文件 application.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:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">

	<!-- 引入配置文件 -->

	<context:property-placeholder file-encoding="UTF-8" location="classpath:properties/jdbc.properties"/>

	<!-- 包扫描 -->

	<context:component-scan base-package="com.lonely"></context:component-scan>

	<!-- spring与mybaties的整合 -->

	<import resource="spring-datasource.xml"/>

	<!-- spring与cxf的整合 -->

	<import resource="spring-cxf.xml"/>

</beans>

2.4.2 至此，spring+cxf+mybatis整合完毕，整个项目结构如下

秒客网

使用CXF开发WebService程序的总结(七)：Spring+CXF+Mybatis+Mysql共同打造的服务端示例

1. 在前面的父工程 ws_parent 中添加依赖

2. 新建一个maven子工程 ws_ssm_server

3. 使用wsdl2java工具生成客户端代码，跟原来的ws_client类似，直接测试即可

使用CXF开发WebService程序的总结(七)：Spring+CXF+Mybatis+Mysql共同打造的服务端示例

1. 在前面的 父工程 ws_parent 中 添加依赖

2. 新建一个maven子工程 ws_ssm_server

3. 使用wsdl2java工具生成客户端代码，跟原来的ws_client类似，直接测试即可

1. 在前面的父工程 ws_parent 中添加依赖