一、项目介绍
-
CMS项目介绍
项目的主要功能:包含后台图片管理,后台职位管理,用户登录,用户注册,用户邮箱激活,前台展示,用户登录,高级查询。
项目的主要技术:
web框架spring+springmvc+springjdbc
前端框架:bootstrap
职位和轮播图的CRUD
分页对象—显示职位和轮播管理信息
富文本编辑器wangeditor—优化相关展示信息
页面静态化技术freemarker—优化访问服务器过多,效率低
缓存技术ehcache----优化访问服务器过多,效率低
高级查询技术—简单提供职位的精确查询
邮箱激活技术
Spring拦截器—后台访问安全
二. 项目的搭建和实现
开发工具:eclipse
服务器:Tomcat7.0.57
调试浏览器:火狐
数据库:mysql
1.采用maven项目结构:
![maven项目结构](https://img-blog.csdnimg.cn/20190223231042318.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzYzNjI5MQ==,size_16,color_FFFFFF,t_70) 2.项目分层
dao层----数据层,与数据库做交互
service层---业务层,处理前台逻辑
web层---处理前台请求,返回页面
![项目分层](https://img-blog.csdnimg.cn/20190224224957765.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzYzNjI5MQ==,size_16,color_FFFFFF,t_70)
3.项目配置
采用Spring+SpringMVC+Springjdbc
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_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>cms</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>
<!-- 文件过滤器,支持UTF-8编码 -->
<filter>
<filter-name>characterEncoding</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 核心过滤器的配置 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 设置开启服务器进行初始化,更快加载 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
SpringMVC——servlet配置
<?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"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tool="http://www.springframework.org/schema/tool"
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
http://www.springframework.org/schema/tool
http://www.springframework.org/schema/tool/spring-tool-4.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
">
<!--开启静态资源访问 -->
<mvc:default-servlet-handler/>
<!--开启mvc注解扫描 -->
<mvc:annotation-driven/>
<!-- 开启组件扫描路径 扫描cn.xxx下面所有包 -->
<context:component-scan base-package="cn.xxx"></context:component-scan>
<!-- 开启视图处理器 自动拼接的路径文件:/views/xxx.jsp-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/views/" />
<property name="suffix" value=".jsp" />
</bean>
<!-- 配置文件上传解析器:id="multipartResolver",这个id不能乱写
设置一个maxUploadSize属性,就是上传文件的大小
-->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize">
<value>2000000000</value>
</property>
</bean>
<import resource="classpath:applicationContext.xml"/>
</beans>
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:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
">
<!-- 配置连接池 -->
<context:property-placeholder location="classpath:db.properties" system-properties-mode="NEVER"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${driverClassName}"></property>
<property name="url" value="${url}"></property>
<property name="username" value="${username}"></property>
<property name="password" value="${password}"></property>
</bean>
<!-- 配置springjdbc -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 配置拦截器 -->
<mvc:interceptors>
<!-- 拦截器 -->
<mvc:interceptor>
<!-- 要拦截的配置 所有路径都要拦截-->
<mvc:mapping path="/**" />
<!-- 设置不拦截的配置 -->
<mvc:exclude-mapping path="/login" />
<mvc:exclude-mapping path="/static/**" />
<mvc:exclude-mapping path="/imgs/*" />
<mvc:exclude-mapping path="/template/*" />
<mvc:exclude-mapping path="/upload/*" />
<mvc:exclude-mapping path="/index" />
<mvc:exclude-mapping path="/query" />
<mvc:exclude-mapping path="/condition" />
<mvc:exclude-mapping path="/signup" />
<mvc:exclude-mapping path="/update" />
<!-- 配置拦截器 -->
<bean class="cn.xxx.domain.MyInterceptor" />
</mvc:interceptor>
</mvc:interceptors>
</beans>
数据库的配置:db.properties
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=
password=
缓存的配置:ehcache.xml
<!--ehcache的相关约束 -->
<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../config/ehcache.xsd">
<!--磁盘保存路径 -->
<diskStore path="C:/ehcache"/>
<!--缓存的名字,通过名字找到相关配置 -->
<!-- name="jobsCache" -->
<!--缓存中允许创建的最大对象数 -->
<!-- maxElementsInMemory="10000" -->
<!--缓存中对象是否为永久的,如果是,超时设置将被忽略,对象从不过期 -->
<!-- eternal="false" -->
<!--缓存数据的钝化时间 -->
<!-- timeToIdleSeconds="120" -->
<!--缓存数据的生存时间 -->
<!-- timeToLiveSeconds="120" -->
<!--内存不足时,是否启用磁盘缓存 -->
<!-- overflowToDisk="true" -->
<!--内存最大对象 -->
<!-- maxElementsOnDisk="10000000" -->
<!-- 设定虚拟机重启时是否进行磁盘存储 -->
<!-- diskPersistent="false" -->
<!-- 对象检测线程时间 -->
<!-- diskExpiryThreadIntervalSeconds="120" -->
<!--缓存淘汰算法 LRU最近最少使用 FIFO先进先出 -->
<!-- memoryStoreEvictionPolicy="LRU" -->
<cache
name="jobsCache"
maxElementsInMemory="10000"
eternal="false"
timeToIdleSeconds="120"
timeToLiveSeconds="120"
overflowToDisk="true"
maxElementsOnDisk="10000000"
diskPersistent="false"
diskExpiryThreadIntervalSeconds="120"
memoryStoreEvictionPolicy="LRU"
/>
</ehcache>
4.相关内容的实现
1.职位的CRUD
职位的CRUD使用Springjdbc+Springmvc
难点:地址的显示
需求:前端的地址需要由后台查询
思路:将地址封装,而jobs对象只存储地址的编号,数据库专门建立地址表,并提供职位与地址的视图查询
package cn.xxx.domain;
/**
* @author peng
*存储工作地址的字段
*/
public class Address {
//地址的id
private Long address_id;
//地址的名字
private String address;
//父id
private Integer pid;
@Override
public String toString() {
return "Address [address_id=" + address_id + ", address=" + address + ", pid=" + pid + "]";
}
public Address() {
super();
// TODO Auto-generated constructor stub
}
public Long getAddress_id() {
return address_id;
}
public void setAddress_id(Long address_id) {
this.address_id = address_id;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public Address(Long address_id, String address, Integer pid) {
super();
this.address_id = address_id;
this.address = address;
this.pid = pid;
}
}
domain层:
package cn.itsource.domain;
import java.io.Serializable;
import java.util.Date;
/**
* @author peng
*工作类
*/
public class Jobs implements Serializable{
//工作的编号
private Integer id;
//工作标题
private String title;
//多表查询的address
private String address;
//工作地址编号
private Long address_id;
//招聘人数
private Integer jobnum;
//薪资
private Integer treatment;
//工作描述
private String describes;
//工作要求
private String requires;
private String htmlurl;
//工作类型:全职or兼职
private Integer positiontype;
//是否启用
private Boolean isenabled;
//上传时间
private Date inputdate=new Date();
public Jobs() {
super();
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Jobs [id=" + id + ", title=" + title + ", address=" + address + ", address_id=" + a