如何创建一个完整的CRM工程

最新推荐文章于 2025-07-09 08:48:40 发布

weixin_34050389

最新推荐文章于 2025-07-09 08:48:40 发布

阅读量95

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/panchanghong/p/4698548.html

本文详细介绍了CRM系统中涉及的模块与组件，包括登录、分页、新建、客户销售机会管理等功能。同时，展示了如何配置web.xml、springDispatcherServlet等关键步骤，以及通过applicationContext.xml、ehcache-hibernate.xml等配置文件实现数据持久化和事务管理。此外，还提供了登录操作的实现方式，并通过实体类如User、Role、Authority展示了权限管理和用户认证的实现细节。

CRM包括很多功能模块，如登录，分页，新建，客户销售机会管理等，在这里zh

00_jar包

antlr-2.7.7.jar

c3p0-0.9.2.1.jar

com.springsource.net.sf.cglib-2.2.0.jar

com.springsource.org.aopalliance-1.0.0.jar

com.springsource.org.aspectj.weaver-1.6.8.RELEASE.jar

commons-logging-1.1.3.jar

dom4j-1.6.1.jar

ehcache-core-2.4.3.jar

hibernate-c3p0-4.2.4.Final.jar

hibernate-commons-annotations-4.0.2.Final.jar

hibernate-core-4.2.4.Final.jar

hibernate-ehcache-4.2.4.Final.jar

hibernate-entitymanager-4.2.4.Final.jar

hibernate-jpa-2.0-api-1.0.1.Final.jar

javassist-3.15.0-GA.jar

jboss-logging-3.1.0.GA.jar

jboss-transaction-api_1.1_spec-1.0.1.Final.jar

mchange-commons-java-0.2.3.4.jar

ojdbc14.jar

slf4j-api-1.6.1.jar

spring-aop-4.0.0.RELEASE.jar

spring-aspects-4.0.0.RELEASE.jar

spring-beans-4.0.0.RELEASE.jar

spring-context-4.0.0.RELEASE.jar

spring-core-4.0.0.RELEASE.jar

spring-data-commons-1.6.2.RELEASE.jar

spring-data-jpa-1.4.2.RELEASE.jar

spring-expression-4.0.0.RELEASE.jar

spring-jdbc-4.0.0.RELEASE.jar

spring-orm-4.0.0.RELEASE.jar

spring-tx-4.0.0.RELEASE.jar

spring-web-4.0.0.RELEASE.jar

spring-webmvc-4.0.0.RELEASE.jar

01_配web.xml

<context-param>

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

<param-value> classpath:applicationContext*.xml </param-value>

</context-param >

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

</listener >

<filter-name> OpenEntityManagerInViewFilter</filter-name >

<filter-class> org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter </filter-class>

</filter >

<filter-mapping >

<filter-name> OpenEntityManagerInViewFilter</filter-name >

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

</filter-mapping >

<filter-name> CharacterEncodingFilter</filter-name >

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

</filter >

<filter-mapping >

<filter-name> CharacterEncodingFilter</filter-name >

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

</filter-mapping >

<!--

配置可以把 POST 请求解析为 PUT 或 DELETE 请求的 Filter.

　　注意: 该 Filter 必须配置在 CharacterEncodingFilter 的后面

否则会导致 CharacterEncodingFilter 无效.

-->

<filter-name> HiddenHttpMethodFilter</filter-name >

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

</filter >

<filter-mapping >

<filter-name> HiddenHttpMethodFilter</filter-name >

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

</filter-mapping >

<servlet-name> springDispatcherServlet</servlet-name >

<servlet-class> org.springframework.web.servlet.DispatcherServlet</servlet-class >

<load-on-startup> 1</ load-on-startup>

</servlet >

<servlet-mapping >

<servlet-name> springDispatcherServlet</servlet-name >

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

</servlet-mapping >

02_配置springDispatcherServlet-sevlet.xml

<context:component-scanbase-package="com.atuigu.crm"use-default-filters="false">

<context:include-filter type= "annotation" expression="org.springframework.stereotype.Controller" />

<context:include-filter type= "annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice" />

</context:component-scan >

</bean >

<mvc:default-servlet-handler />

<mvc:annotation-driven ></mvc:annotation-driven>

03_配置applicationContext.xml

<description>Spring 公共配置</description>

<context:component-scan base-package="com.atguigu.crm">
          <context:exclude-filter type="annotation"
               expression="org.springframework.stereotype.Controller" />
          <context:exclude-filter type="annotation"
               expression="org.springframework.web.bind.annotation.ControllerAdvice" />
     </context:component-scan>

     
     
     <context:property-placeholder location="classpath:application.properties"/>

     
     <bean id="dataSource"
          class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
          <property name="driverClass" value="${jdbc.driver}" />
          <property name="url" value="${jdbc.url}" />
          <property name="username" value="${jdbc.username}" />
          <property name="password" value="${jdbc.password}" />
     </bean>

     
     <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
          <property name="dataSource" ref="dataSource"></property>
          <property name="jpaVendorAdapter">
               <bean id="jpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/>
          </property>
          <property name="packagesToScan" value="com.atguigu.crm"></property>
          <property name="jpaProperties">
               <props>
                    
                    <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
                    <prop key="net.sf.ehcache.configurationResourceName">ehcache-hibernate.xml</prop>

                    
                    <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>

                    
                    <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.format_sql">true</prop>
                    <prop key="hibernate.hbm2ddl.auto">update</prop>
               </props>
          </property>
     </bean>

     
     <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
          <property name="entityManagerFactory" ref="entityManagerFactory"></property>
     </bean>

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

     
     <jpa:repositories base-package="com.atguigu.crm"
          entity-manager-factory-ref="entityManagerFactory"></jpa:repositories>

</beans>

04_配置application.properties

#jdbc.driver=com.mysql.jdbc.Driver

#jdbc.url=jdbc:mysql:///crm5?useUnicode=true&characterEncoding=utf-8
#jdbc.username=root
#jdbc.password=1230

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.username=atguigu
jdbc.password=atguigu

jdbc.pool.maxIdle=5

jdbc.pool.maxActive=40

05_配置ehcache-hibernate.xml

</ehcache>

06_配置i18n.proerties

user.login.disabled=\u7528\u6237\u88AB\u9501\u5B9A!

07_完成登录操作（jsp页面）

[1].在index.jsp里面

<jsp:forward page="/WEB-INF/views/login.jsp"></jsp:forward>

【2】.login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ include file="/commons/common.jsp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<HEAD>
     <TITLE>客户关系管理系统</TITLE>
     <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=GB2312">

</script>

用户名

</th> <td>

</td> </tr>

</table>

08—完成登录操作功能模块（entity类）

[0]超级类

@MappedSuperclass
public abstract class IdEntity {

     protected Long id;

     @Id
     @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="CRM_SEQ")
     @SequenceGenerator(name="CRM_SEQ", sequenceName="CRM_SEQ", allocationSize=1)
     public Long getId() {
          return id;
     }

     public void setId(Long id) {
          this.id = id;
     }

}

【1】.User类

@Entity
@Table(name="USERS")

public class User extends IdEntity{

private String name;
private String password;

private int enabled ;

     //盐值, 进行密码加密
     private String salt;
     //该用户拥有的角色

private Role role;

public User() {

// TODO Auto-generated constructor stub }

public User(Long id) {

this.id = id; }

public String getName() {

return name; }

public void setName(String name) {

this.name = name; }

public String getPassword() {

return password; }

public void setPassword(String password) {

this.password = password; }

public int getEnabled() {

return enabled; }

     public void setEnabled(int enabled) {
          this.enabled = enabled;
     }

     public String getSalt() {

return salt; }

public void setSalt(String salt) {

this.salt = salt; }

     @ManyToOne
     @JoinColumn(name="ROLE_ID")
     public Role getRole() {

return role; }

public void setRole(Role role) {

this.role = role; }

     @Transient
     public Collection<String> getRoleList() {
          Collection<String> roles = new ArrayList<>();

          if(role != null){

for(Authority authority: role.getAuthorities()){

roles.add(authority.getName()); } }

return roles; }}

【2】Roles类

@Table(name="ROLES")
@Entity
@Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
public class Role extends IdEntity {

     // 角色名称
     private String name;
     // 角色描述
     private String description;
     // 角色状态: 角色是否可用
     private boolean enabled;
     // 角色拥有的权限
     private List<Authority> authorities = new ArrayList<>();
     //该角色分配给了哪些用户
     private Set<User> users = new HashSet<>();

     public String getName() {
          return name;
     }

     public void setName(String name) {
          this.name = name;
     }

     public String getDescription() {

return description; }

public void setDescription(String description) {

this.description = description; }

public boolean isEnabled() {

return enabled; }

public void setEnabled(boolean enabled) {

this.enabled = enabled; }

     @ManyToMany
     @JoinTable(
          name="ROLE_AUTHORITY",
          joinColumns={@JoinColumn(name="ROLE_ID")},
          inverseJoinColumns={@JoinColumn(name="AUTHORITY_ID")}
     )
     @Fetch(FetchMode.JOIN)
     @OrderBy("ID")
     @Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
     public List<Authority> getAuthorities() {

return authorities; }

public void setAuthorities(List<Authority> authorities) {

this.authorities = authorities; }

     public void setAuthorities2(List<String> authorities){
          this.authorities.clear();

for(String authorityId: authorities){

this.authorities.add(new Authority(Long.parseLong(authorityId))); } }

     @Transient
     public List<String> getAuthorities2(){
          List<String> authorites = new ArrayList<>();

for(Authority authority:this.authorities){

authorites.add("" + authority.getId()); }

return authorites; }

@OneToMany(mappedBy="role")

public Set<User> getUsers() {

return users; }

public void setUsers(Set<User> users) {

this.users = users;

}}

【3】、Authority类；（权限管理）

@Table(name="AUTHORITIES")
@Entity
@Cache(usage=CacheConcurrencyStrategy.READ_WRITE)
public class Authority extends IdEntity{

     //权限的名字, 用于显示
     private String displayName;
     //权限的名字: 用于配置 Shiro
     private String name;
     //权限允许的行为: 即权限的具体内容.
     private String permissions;
     //父权限
     private Authority parentAuthority;
     //URL 地址
     private String url;
     //子权限
     private List<Authority> subAuthorities = new ArrayList<>();

     public Authority(Long id) {
          this.id = id;
     }

     public Authority() {
          // TODO Auto-generated constructor stub
     }

     public String getDisplayName() {
          return displayName;
     }

     public void setDisplayName(String displayName) {
          this.displayName = displayName;
     }

     public String getName() {
          return name;
     }

     public void setName(String name) {
          this.name = name;
     }

     public String getPermissions() {
          return permissions;
     }

     public void setPermissions(String permissions) {
          this.permissions = permissions;
     }

     @ManyToOne
     @JoinColumn(name="PARENT_AUTHORITY_ID")
     public Authority getParentAuthority() {
          return parentAuthority;
     }

     public void setParentAuthority(Authority parentAuthority) {
          this.parentAuthority = parentAuthority;
     }

     @OneToMany(mappedBy="parentAuthority")
     public List<Authority> getSubAuthorities() {
          return subAuthorities;
     }

     public void setSubAuthorities(List<Authority> subAuthorities) {
          this.subAuthorities = subAuthorities;
     }

     @Transient
     public List<String> getPermissionList(){
          return Arrays.asList(permissions.split(","));
     }

     public String getUrl() {
          return url;
     }

     public void setUrl(String url) {
          this.url = url;
     }

}