CRM_SSH(二)

客户模块---新增客户

1、创建表

CREATE TABLE `cst_customer` (
  `cust_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '客户编号(主键)',
  `cust_name` varchar(32) NOT NULL COMMENT '客户名称(公司名称)',
  `cust_source` varchar(32) DEFAULT NULL COMMENT '客户信息来源',
  `cust_industry` varchar(32) DEFAULT NULL COMMENT '客户所属行业',
  `cust_level` varchar(32) DEFAULT NULL COMMENT '客户级别',
  `cust_phone` varchar(64) DEFAULT NULL COMMENT '固定电话',
  `cust_mobile` varchar(16) DEFAULT NULL COMMENT '移动电话',
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

2、创建实体和映射

• 创建实体

public class Customer {

	private long cust_id;
	private String cust_name;
	private String cust_source;
	private String cust_industry;
	private String cust_level;
	private String cust_phone;
	private String cust_mobile;

    get/set...
}

• 创建映射

    <hibernate-mapping>
    	<class name="com.ithou.crm.domain.Customer" table="cst_customer">
    		<id name="cust_id" column="cust_id">
    			<generator class="native"/>
    		</id>
    		<property name="cust_name" column="cust_name"/>
    		<property name="cust_source" column="cust_source"/>
    		<property name="cust_industry" column="cust_industry"/>
    		<property name="cust_level" column="cust_level"/>
    		<property name="cust_phone" column="cust_phone"/>
    		<property name="cust_mobile" column="cust_mobile"/>
    	</class>
    </hibernate-mapping>

3、创建Action

public class CustomerAction extends ActionSupport implements ModelDriven<Customer> {

	private Customer customer = new Customer();
	@Override
	public Customer getModel() {
		return customer;
	}

	private CustomerService customerService;
	public void setCustomerService(CustomerService customerService) {
		this.customerService = customerService;
	}
}

4、创建Service

public class CustomerServiceImpl implements CustomerService{
	
	private CustomerDao customerDao;
	public void setCustomerDao(CustomerDao customerDao) {
		this.customerDao = customerDao;
	}
}

5、创建Dao

public class CustomerDaoImpl extends BaseDaoImpl<Customer> implements CustomerDao{

}

6、配置Action、Service、Dao

	<!-- 配置客户管理的相关的类 -->
	<bean id="customerDao" class="com.ithou.crm.dao.impl.CustomerDaoImpl">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<bean id="customerService" class="com.ithou.crm.service.impl.CustomerServiceImpl">
		<property name="customerDao" ref="customerDao" />
	</bean>
	<bean id="customerAction" class="com.ithou.crm.web.action.CustomerAction">
		<property name="customerService" ref="customerService" />
	</bean>

7、跳转到添加页面，修改menu.jsp菜单页面

8、编写Action中的saveUI的方法

	/**
	 * 客户管理：跳转到添加页面的方法：saveUI
	 */
	public String saveUI() {
		return "saveUI";
	}

9、配置Action的跳转

	<action name="customer_*" class="com.ithou.crm.web.action.CustomerAction" method="{1}">
		<result name="saveUI">/jsp/customer/add.jsp</result>
	</action>

引入数据字典

数据字典：用来规范某些地方具体值和数据

1、创建数据字典表

CREATE TABLE `base_dict` (
  `dict_id` varchar(32) NOT NULL COMMENT '数据字典id(主键)',
  `dict_type_code` varchar(10) NOT NULL COMMENT '数据字典类别代码',
  `dict_type_name` varchar(64) NOT NULL COMMENT '数据字典类别名称',
  `dict_item_name` varchar(64) NOT NULL COMMENT '数据字典项目名称',
  `dict_item_code` varchar(10) DEFAULT NULL COMMENT '数据字典项目(可为空)',
  `dict_sort` int(10) DEFAULT NULL COMMENT '排序字段',
  `dict_enable` char(1) NOT NULL COMMENT '1:使用 0:停用',
  `dict_memo` varchar(64) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、客户表和字典表的关系分析

3、创建字典的实体和映射

• 创建实体

public class BaseDict {

	private String dict_id;
	private String dict_type_code;
	private String dict_type_name;
	private String dict_item_name;
	private String dict_item_code;
	private String dict_sort;
	private String dict_enable;
	private String dict_memo;

    get/set...
}

• 创建映射

    <hibernate-mapping>
    	<class name="com.ithou.crm.domain.BaseDict" table="base_dict">
    		<id name="dict_id" column="dict_id">
    			<generator class="native"/>
    		</id>
    		<property name="dict_type_code" column="dict_type_code"/>
    		<property name="dict_type_name" column="dict_type_name"/>
    		<property name="dict_item_name" column="dict_item_name"/>
    		<property name="dict_item_code" column="dict_item_code"/>
    		<property name="dict_sort" column="dict_sort"/>
    		<property name="dict_enable" column="dict_enable"/>
    		<property name="dict_memo" column="dict_memo"/>
    	</class>
    </hibernate-mapping>

4、修改字典和客户的关系映射

• 修改客户的实体

public class Customer {

	private long cust_id;
	private String cust_name;
	/*private String cust_source;
	private String cust_industry;
	private String cust_level;*/
	private String cust_phone;
	private String cust_mobile;
	private String cust_image;
	
	/**
	 * 客户和字典表示多对一，需要在多的一方放的时一的一方的对象
	 */
	private BaseDict baseDictSource;
	private BaseDict baseDictIndustry;
	private BaseDict baseDictLevel;

    get/set...
}

• 修改客户的映射

    <hibernate-mapping>
    	<class name="com.ithou.crm.domain.Customer" table="cst_customer">
    		<id name="cust_id" column="cust_id">
    			<generator class="native"/>
    		</id>
    		<property name="cust_name" column="cust_name"/>
    		<property name="cust_phone" column="cust_phone"/>
    		<property name="cust_mobile" column="cust_mobile"/>
    		<property name="cust_image" column="cust_image"/>
    		
                <!-- 配置客户与字典的多对一的映射 -->
    		<many-to-one name="baseDictSource" class="com.ithou.crm.domain.BaseDict" column="cust_source"></many-to-one>
    		<many-to-one name="baseDictIndustry" class="com.ithou.crm.domain.BaseDict" column="cust_industry"></many-to-one>
    		<many-to-one name="baseDictLevel" class="com.ithou.crm.domain.BaseDict" column="cust_level"></many-to-one>
    	</class>
    </hibernate-mapping>

5、将映射文件交给spring

	<!-- 引入映射文件 -->
	<property name="mappingResources">
		<list>
			<value>/com/ithou/crm/domain/user.hbm.xml</value>
			<value>/com/ithou/crm/domain/customer.hbm.xml</value>
			<value>/com/ithou/crm/domain/baseDict.hbm.xml</value>
		</list>
	</property>

在添加页面上异步加载字典数据

1、创建字典的Action、Service、Dao

• 编写Dao

public class BaseDictDaoImpl extends BaseDaoImpl<BaseDict> implements BaseDictDao{

}

• 编写Service

public class BaseDictServiceImpl implements BaseDictService {

	private BaseDictDao baseDictDao;
	public void setBaseDictDao(BaseDictDao baseDictDao) {
		this.baseDictDao = baseDictDao;
	}
}

• 编写Action

public class BaseDictAction extends ActionSupport implements ModelDriven<BaseDict> {

	private BaseDict baseDict = new BaseDict();
	@Override
	public BaseDict getModel() {
		return baseDict;
	}
	
	private BaseDictService baseDictService;
	public void setBaseDictService(BaseDictService baseDictService) {
		this.baseDictService = baseDictService;
	}
}

2、将字典类交给Spring

	<!-- 配置字典管理的相关的类 -->
	<bean id="baseDictDao" class="com.ithou.crm.dao.impl.BaseDictDaoImpl">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<bean id="baseDictService" class="com.ithou.crm.service.impl.BaseDictServiceImpl">
		<property name="baseDictDao" ref="baseDictDao" />
	</bean>
	<bean id="baseDictAction" class="com.ithou.crm.web.action.BaseDictAction">
		<property name="baseDictService" ref="baseDictService" />
	</bean>

3、引入jequery的js(在添加页面jsp/customer/add.jsp上)

4、编写异步加载的方法

<script type="text/javascript">
	$(function() {
		$.post("${pageContext.request.contextPath }/baseDict_findByTypeCode.action",{"dict_type_code" : "002"}, function(data) {
			$(data).each(function(i, n) {
				$("#cust_source").append("<option value='"+n.dict_id+"'>"+ n.dict_item_name+ "</option>");
				});
			}, "json");
	});
</script>

5、编写Action

package com.ithou.crm.web.action;

import java.io.IOException;
import java.util.List;

import org.apache.struts2.ServletActionContext;
import org.springframework.transaction.annotation.Transactional;

import com.ithou.crm.domain.BaseDict;
import com.ithou.crm.service.BaseDictService;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

import net.sf.json.JSONArray;
import net.sf.json.JsonConfig;

public class BaseDictAction extends ActionSupport implements ModelDriven<BaseDict> {

	private BaseDict baseDict = new BaseDict();
	@Override
	public BaseDict getModel() {
		return baseDict;
	}
	
	private BaseDictService baseDictService;
	public void setBaseDictService(BaseDictService baseDictService) {
		this.baseDictService = baseDictService;
	}
	
        //根据类型名称查询字典的方法
	public String findByTypeCode() throws IOException {
		List<BaseDict> list = baseDictService.findByTypeCode(baseDict.getDict_type_code());
		//将list转换成json
		/*
		 * JSONConfig：转JSON的配置对象
		 * JSONArray：将数组和list集合转成JSON
		 * JSONObject：将对象和Map集合转成JSON
		 */
		JsonConfig jsonConfig = new JsonConfig();
		jsonConfig.setExcludes(new String[]{"dict_sort","dict_enable","dict_memo"});
		JSONArray jsonArray = JSONArray.fromObject(list, jsonConfig);
		System.out.println(jsonArray.toString());
		
		//将json打印到页面
		ServletActionContext.getResponse().setContentType("text/html;charset=UTF-8");
		ServletActionContext.getResponse().getWriter().println(jsonArray.toString());
		return NONE;
	}
}

6、编写Service

public class BaseDictServiceImpl implements BaseDictService {

	private BaseDictDao baseDictDao;
	public void setBaseDictDao(BaseDictDao baseDictDao) {
		this.baseDictDao = baseDictDao;
	}

	@Override
	public List<BaseDict> findByTypeCode(String dict_type_code) {
		return baseDictDao.findByTypeCode(dict_type_code);
	}
}

7、编写Dao

public class BaseDictDaoImpl extends BaseDaoImpl<BaseDict> implements BaseDictDao{

	@Override
	public List<BaseDict> findByTypeCode(String dict_type_code) {
		return (List<BaseDict>) this.getHibernateTemplate().find("from BaseDict where dict_type_code = ?", dict_type_code);
	}
}

8、加载其他字典项数据

<script type="text/javascript">
	$(function() {
		$.post("${pageContext.request.contextPath }/baseDict_findByTypeCode.action",{"dict_type_code" : "002"}, function(data) {
			$(data).each(function(i, n) {
				$("#cust_source").append("<option value='"+n.dict_id+"'>"+ n.dict_item_name+ "</option>");
				});
			}, "json");
	});
	$(function() {
		$.post("${pageContext.request.contextPath }/baseDict_findByTypeCode.action",{"dict_type_code" : "006"}, function(data) {
			$(data).each(function(i, n) {
				$("#cust_level").append("<option value='"+n.dict_id+"'>"+ n.dict_item_name+ "</option>");
				});
			}, "json");
	});
	$(function() {
		$.post("${pageContext.request.contextPath }/baseDict_findByTypeCode.action",{"dict_type_code" : "001"}, function(data) {
			$(data).each(function(i, n) {
				$("#cust_industry").append("<option value='"+n.dict_id+"'>"+ n.dict_item_name+ "</option>");
				});
			}, "json");
	});
</script>

保存数据到数据库中

1、修改添加页面

• 修改表单项名称

2、编写Action

	public String save() throws IOException {
		customerService.save(customer);
		return "saveSuccess";
	}

3、编写Service

	public void save(Customer customer) {
		customerDao.save(customer);
	}

4、编写Dao

public class CustomerDaoImpl extends BaseDaoImpl<Customer> implements CustomerDao{
    public void save(Customer customer){
        this.getHibernateTemplete().save(customer);
    }
}

5、添加事务

客户管理---分页查询客户

1、修改menu.jsp

2、编写Action中findAll的方法

	public String findAll() {
		// 接收参数：分页参数
		// 封装离线条件查询对象，使用DetachedCriteria对象(条件查询--带分页)
		DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Customer.class);
		
		PageBean<Customer> pageBean = customerService.findByPage(detachedCriteria, currPage, pageSize);
		//将pageBean的数据存入到值栈
		ActionContext.getContext().getValueStack().push(pageBean);
		return "findAll";
	}

3、编写Service

	public PageBean<Customer> findByPage(DetachedCriteria detachedCriteria, Integer currPage, Integer pageSize) {
		PageBean<Customer> pageBean = new PageBean<Customer>();
		pageBean.setCurrPage(currPage);//封装当前页
		pageBean.setPageSize(pageSize);//封装每页记录数
		
		Integer totalCount = customerDao.findCount(detachedCriteria);
		pageBean.setTotalCount(totalCount);//封装总记录数
		
		Double tc = totalCount.doubleValue();
		Double num = Math.ceil(tc/pageSize);
		pageBean.setTotalPage(num.intValue());//封装总页数
		
		Integer begin = (currPage-1)*pageSize;
		List<Customer> list = customerDao.findByPage(detachedCriteria,begin,pageSize);
		pageBean.setList(list);
		return pageBean;
	}

4、编写Dao

	@Override
        //Dao中带条件统计个数的方法
	public Integer findCount(DetachedCriteria detachedCriteria) {
		detachedCriteria.setProjection(Projections.rowCount());
		List<Long> list = (List<Long>) this.getHibernateTemplate().findByCriteria(detachedCriteria);
		if(list.size()>0) {
			return list.get(0).intValue();
		}
		return null;
	}

	@Override
        //Dao中分页查询客户的方法
	public List<T> findByPage(DetachedCriteria detachedCriteria, Integer currPage, Integer pageSize) {
		detachedCriteria.setProjection(null);
		return (List<T>) this.getHibernateTemplate().findByCriteria(detachedCriteria, currPage, pageSize);
	}

5、配置页面跳转

    <action name="customer_*" class="com.ithou.crm.web.action.CustomerAction" method="{1}">
	    <result name="saveUI">/jsp/customer/add.jsp</result>
	    <result name="findAll">/jsp/customer/list.jsp</result>
    </action>