「这是我参与2022首次更文挑战的第30天,活动详情查看:2022首次更文挑战」。
搭建开发环境
1. 创建crm项目
创建Empty Project,作为项目的工作空间
2. 创建crm模块
创建maven类型的模块,作为开发工程
3. 为项目添加maven依赖
(1)mysql驱动
<!-- MySQL数据库连接驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.43</version>
</dependency>
(2)JDBC 数据源连接池:Druid
<!-- JDBC数据源连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.1</version>
</dependency>
还有:c3p0连接池、dbcp 连接池等。
(3)Mybatis 框架依赖
<!-- MyBatis框架依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
(4)Spring 相关依赖配置
<!-- Spring框架依赖的JAR配置 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
(5)Spring AOP依赖
<!-- Spring AOP支持-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.9</version>
</dependency>
(6)Mybatis 与 Spring 整合依赖
<!-- MyBatis与Spring整合依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
(7)添加项目对JSP的支持
<!-- servlet及jstl标签库依赖的JAR配置 -->\
<dependency>\
<groupId>javax.servlet</groupId>\
<artifactId>javax.servlet-api</artifactId>\
<version>3.1.0</version>\
</dependency>\
<dependency>\
<groupId>javax.servlet.jsp.jstl</groupId>\
<artifactId>jstl-api</artifactId>\
<version>1.2</version>\
</dependency>\
<dependency>\
<groupId>org.apache.taglibs</groupId>\
<artifactId>taglibs-standard-spec</artifactId>\
<version>1.2.1</version>\
</dependency>\
<dependency>\
<groupId>org.apache.taglibs</groupId>\
<artifactId>taglibs-standard-impl</artifactId>\
<version>1.2.1</version>\
</dependency>
加载jackson插件依赖
(8)Jackson插件依赖
<!-- 加载jackson插件依赖 -->\
<dependency>\
<groupId>com.fasterxml.jackson.core</groupId>\
<artifactId>jackson-core</artifactId>\
<version>2.7.3</version>\
</dependency>\
<dependency>\
<groupId>com.fasterxml.jackson.core</groupId>\
<artifactId>jackson-databind</artifactId>\
<version>2.7.3</version>\
</dependency>\
<dependency>\
<groupId>com.fasterxml.jackson.core</groupId>\
<artifactId>jackson-annotations</artifactId>\
<version>2.7.3</version>\
</dependency>
(9)poi依赖
<!--poi依赖-->\
<dependency>\
<groupId>org.apache.poi</groupId>\
<artifactId>poi</artifactId>\
<version>3.15</version>\
</dependency>
(10)fileupload依赖
<!-- 文件上传 -->\
<dependency>\
<groupId>commons-fileupload</groupId>\
<artifactId>commons-fileupload</artifactId>\
<version>1.3.1</version>\
</dependency>
(11)Log4j依赖
<!-- Log4j2依赖的JAR配置 -->
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-api</artifactId>
<version>2.3</version>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
<version>2.3</version>
</dependency>