基于CXF发布CRM服务
需求:
- 创建CRM数据库用户和CRM客户表
- 导入客户模拟数据到客户表
- 发布服务
步骤:
- 在Oracle数据库中添加一个用户,并赋予权限
- 创建一个maven项目管理CRM系统(作为服务器端)
- 配置web.xml文件
- spring的核心监听器加载applicationContext.xml文件
- 配置cxf的Servlet的拦截器
web.xml(服务端)
<?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"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">
<display-name>crm</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>cxf</servlet-name>
<servlet-class>org.apache.cxf.transport.servlet.CXFServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>cxf</servlet-name>
<url-pattern>/cxf/*</url-pattern>
</servlet-mapping>
</web-app>
- 配置spring配置文件applicationContext.xml文件
- 连接池
- spring整合JPA
- 事务管理器
- 组件扫描
- 事务注解的支持
- 整合spring data jpa的包扫描
- 添加Customer的实体类
- 启动项目,完成自动建表(记得修改pom.xml的文件的信息)
- 导入客户模拟数据
- 编写业务代码
- 在spring配置文件中注册Webservice服务
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:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:task="http://www.springframework.org/schema/task"
xmlns:jaxws="http://cxf.apache.org/jaxws" xmlns:soap="http://cxf.apache.org/bindings/soap"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/data/jpa
http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
http://cxf.apache.org/bindings/soap
http://cxf.apache.org/schemas/configuration/soap.xsd
http://cxf.apache.org/jaxws
http://cxf.apache.org/schemas/jaxws.xsd">
<!-- 连接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.150.128:1521:ORCL" />
<property name="user" value="crm" />
<property name="password" value="lry" />
</bean>
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 指定扫描的包,存放实体类 -->
<property name="packagesToScan" value="com.lyric.crm.domain" />
<!-- 指定持久层提供者为Hibernate -->
<property name="persistenceProvider">
<bean class="org.hibernate.ejb.HibernatePersistence" />
</property>
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<!-- 自动建表 -->
<property name="generateDdl" value="true" />
<property name="database" value="ORACLE" />
<property name="databasePlatform" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="showSql" value="true" />
</bean>
</property>
<property name="jpaDialect">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
</property>
</bean>
<!-- 事务管理器 -->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>
<!-- 组件扫描 @Service @Controller @Repository -->
<context:component-scan base-package="com.lyric.crm.service" />
<!-- 事务注解支持 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- Spring 初始化容器时将会扫描 base-package 指定的包目录及其子目录,为继承 Repository 或其子接口的接口创建代理对象,并将代理对象注册为
Spring Bean,业务层便可以通过注解注入的方式来直接使用该对象。 -->
<jpa:repositories base-package="com.lyric.crm.dao" />
<bean id="customerService" class="com.lyric.service.impl.CustomerServiceImpl"></bean>
<jaxws:server address="/customer">
<jaxws:serviceBean>
<ref bean="customerService"/>
</jaxws:serviceBean>
</jaxws:server>
</beans>
定区关联客户(BOS系统通过webservice远程调用CRM系统)
需求:
- 选择一个定区,查询到所有已关联的客户和未关联的客户
- 通过webservice远程来调用crm系统中的service方法查询相关客户
- 绑定单机事件,选中所有的需要绑定定区的客户,调用crm中的service方法来改变定区id
步骤:
- 在选定一个定区之后,点击关联客户按钮
- 只能选定一个定区
- 每次选择之前要清空下拉框的数据(防止数据的累加)
- 左边的选择框是未绑定定区的客户,右边的选择框是绑定了定区的客户
- 通过AJAX发起一个异步请求,在FixedAreaAction中提供两个方法,一个查询未绑定的客户, 一个查询绑定了定区的客户, service层的代码是通过webservice远程访问的.(建立一个crm系统, 编写service和dao的代码)
- 给中间的左移和右移绑定点击事件
- 给”关联客户”绑定点击事件, 将传出两个数据, 一个是需要绑定的客户的id(需要在提交之前将所有的选项都选中), 一个是定区的id,用于将所有的定区中的客户中的定区id转为空
前端页面
function doAssociations() {
var rows = $("#grid").datagrid("getSelections")
if (rows.length == 1) {
$("#customerWindow").window('open');
$("#noassociationSelect").empty();
$("#associationSelect").empty();
var url1 = "../../fixedAreaAction_findByFixedAreaIdIsNull.action";
$.post(url1, {}, function(data) {
if(data != "")
{
for (var i = 0; i < data.length; i++) {
//解析服务端响应的json数据,展示到下拉框中
$("#noassociationSelect").append(
"<option value='"+data[i].id+"'>"
+ data[i].username + "</option>");
}
}
})
var url2 = "../../fixedAreaAction_findByFixedAreaId.action";
$.post(url2, {"fixedAreaId":rows[0].id}, function(data) {
if(data != "")
{
for (var i = 0; i < data.length; i++) {
//解析服务端响应的json数据,展示到下拉框中
$("#associationSelect").append(
"<option value='"+data[i].id+"'>"
+ data[i].username + "</option>");
}
}
})
$("#toRight").click(function(){
$("#associationSelect").append($("#noassociationSelect option:selected"))
})
$("#toLeft").click(function(){
$("#noassociationSelect").append($("#associationSelect option:selected"))
})
$("#associationBtn").click(function(){
if($("#customerForm").form("validate")){
$("#associationSelect option").attr("selected","selected");
$("#customerFixedAreaId").val(rows[0].id);
$("#customerForm").submit();
}})
}else{
$.messager.alert("提示信息","请选择一条定区数据","warning");
}
}
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:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:jpa="http://www.springframework.org/schema/data/jpa"
xmlns:task="http://www.springframework.org/schema/task"
xmlns:jaxws="http://cxf.apache.org/jaxws"
xmlns:soap="http://cxf.apache.org/bindings/soap"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/data/jpa
http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
http://cxf.apache.org/bindings/soap
http://cxf.apache.org/schemas/configuration/soap.xsd
http://cxf.apache.org/jaxws
http://cxf.apache.org/schemas/jaxws.xsd
">
<!-- 连接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.150.128:1521:ORCL" />
<property name="user" value="lyric_bos" />
<property name="password" value="lry" />
</bean>
<!-- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver" />
<property name="jdbcUrl" value="jdbc:mysql:///test" />
<property name="user" value="root" />
<property name="password" value="root" />
</bean> -->
<!-- spring整合JPA -->
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 指定扫描的包,存放实体类 -->
<property name="packagesToScan" value="com.lyric.bos.domain" />
<!-- 指定持久层提供者为Hibernate -->
<property name="persistenceProvider">
<bean class="org.hibernate.ejb.HibernatePersistence" />
</property>
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<!-- 自动建表 -->
<property name="generateDdl" value="true" />
<property name="database" value="ORACLE" />
<property name="databasePlatform" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="showSql" value="true" />
</bean>
</property>
<property name="jpaDialect">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
</property>
</bean>
<!-- 事务管理器 -->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>
<!-- 组件扫描 @Service @Controller @Repository -->
<context:component-scan base-package="com.lyric.bos.service,com.lyric.bos.web"/>
<!-- 事务注解支持 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- Spring 初始化容器时将会扫描 base-package 指定的包目录及其子目录,为继承 Repository 或其子接口的接口创建代理对象,并将代理对象注册为 Spring Bean,业务层便可以通过注解注入的方式来直接使用该对象。
-->
<jpa:repositories base-package="com.lyric.bos.dao" />
<jaxws:client id="customerService" address="http://localhost:8889/crm/cxf/customer?wsdl" serviceClass="com.lyric.crm.customer.CustomerServiceImpl"></jaxws:client>
</beans>
FixedAreaAction(客户端)
package com.lyric.bos.web.action.base;
import java.io.IOException;
import java.util.List;
import javax.annotation.Resource;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.context.annotation.Scope;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Controller;
import com.lyric.bos.domain.base.FixedArea;
import com.lyric.bos.service.base.FixedAreaService;
import com.lyric.bos.web.action.common.CommonAction;
import com.lyric.crm.customer.Customer;
import com.lyric.crm.customer.CustomerServiceImpl;
@Namespace("/")
@ParentPackage("struts-default")
@Controller
@Scope("prototype")
public class FixedAreaAction extends CommonAction<FixedArea>{
@Resource
private FixedAreaService fixedAreaService;
@Resource
private CustomerServiceImpl customerService;
private String fixedAreaId;
private List<Integer> customerIds;
public void setCustomerIds(List<Integer> customerIds) {
this.customerIds = customerIds;
}
public void setFixedAreaId(String fixedAreaId) {
this.fixedAreaId = fixedAreaId;
}
@Action(value="fixedAreaAction_save",results={@Result(name="success",location="/pages/base/fixed_area.html",type="redirect")})
public String save(){
fixedAreaService.save(this.getModel());
return SUCCESS;
}
@Action(value="fixedAreaAction_pageQuery")
public String pageQuery() throws IOException{
Pageable pageable = new PageRequest(page-1, rows);
Page<FixedArea> page = fixedAreaService.pageQuery(pageable);
this.page2Json(page, new String[]{"subareas","couriers"});
return NONE;
}
@Action(value="fixedAreaAction_findByFixedAreaIdIsNull")
public String findByFixedAreaIdIsNull() throws IOException{
List<Customer> list = customerService.findByFixedAreaIdIsNull();
this.list2Json(list, new String[] {});
return NONE;
}
@Action(value="fixedAreaAction_findByFixedAreaId")
public String findByFixedAreaId() throws IOException{
List<Customer> list = customerService.findByFixedAreaId(fixedAreaId);
this.list2Json(list, new String[] {});
return NONE;
}
@Action(value="fixedAreaAction_assignCustomers2FixedArea",results={@Result(name="success",location="/pages/base/fixed_area.html",type="redirect")})
public String fixedAreaAction_assignCustomers2FixedArea(){
System.out.println("areaid" + fixedAreaId);
System.out.println("cuslist" + customerIds.size());
customerService.setFixedAreaIdIsNull(fixedAreaId);
if(customerIds != null && customerIds.size()>0){
for (Integer integer : customerIds) {
System.out.println("cusid"+integer);
customerService.assignCustomers2FixedArea(fixedAreaId, integer);
}
}
return SUCCESS;
}
}
customerService(服务端)
package com.lyric.service.impl;
import java.util.List;
import javax.annotation.Resource;
import javax.jws.WebService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.lyric.crm.dao.CoustomerDao;
import com.lyric.crm.domain.Customer;
import com.lyric.service.CustomerService;
@WebService
@Service
@Transactional
public class CustomerServiceImpl implements CustomerService {
@Resource
private CoustomerDao coustomerDao;
@Override
public List<Customer> findAll(){
return coustomerDao.findAll();
}
@Override
public List<Customer> findByFixedAreaIdIsNull() {
return coustomerDao.findByFixedAreaIdIsNull();
}
@Override
public List<Customer> findByFixedAreaId(String fixedAreaId) {
return coustomerDao.findByFixedAreaId(fixedAreaId);
}
@Override
public void setFixedAreaIdIsNull(String fixedAreaId) {
coustomerDao.setFixedAreaIdIsNull(fixedAreaId);
}
@Override
public void assignCustomers2FixedArea(String fixedAreaId, Integer customerId) {
coustomerDao.assignCustomers2FixedArea(fixedAreaId, customerId);
}
}