标题:首先从创建项目开始说起
1.复制模板中 pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.ls</groupId>
<artifactId>study</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>study Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<!-- spring版本号 -->
<spring.version>4.3.8.RELEASE</spring.version>
<!-- mybatis版本号 -->
<mybatis.version>3.2.8</mybatis.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.7.7</slf4j.version>
<log4j.version>1.2.17</log4j.version>
<jackson.version>2.8.9</jackson.version>
<fastjson.version>1.2.28</fastjson.version>
<commons-lang3.version>3.3.2</commons-lang3.version>
<shiro.version>1.4.0</shiro.version>
<freemarker.version>2.3.28</freemarker.version>
<!--redis 版本-->
<redis.version>2.9.0</redis.version>
<spring-data-redis.version>1.8.3.RELEASE</spring-data-redis.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.aliyun</groupId>
<artifactId>aliyun-java-sdk-core</artifactId>
<version>4.0.3</version>
</dependency>
<!-- 加密解密包 -->
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.9</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>${commons-lang3.version}</version>
</dependency>
<!-- spring核心包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jms</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- 导入java ee jar 包 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
</dependency>
<!-- 导入Mysql数据库链接jar包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!-- hikari 数据库连接池 -->
<dependency>
<groupId>hikari-cp</groupId>
<artifactId>hikari-cp</artifactId>
<version>2.6.0</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<!-- 格式化对象,方便输出日志 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.1.41</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- log end -->
<!-- jackson 处理包 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${jackson.version}</version>
</dependency>
<!-- alibaba fastjson 处理包 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>${fastjson.version}</version>
</dependency>
<!-- 上传组件包 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.9</version>
</dependency>
<dependency>
<groupId>com.aliyun</groupId>
<artifactId>aliyun-java-sdk-core</artifactId>
<version>4.0.3</version>
</dependency>
<!-- shiro -->
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-core</artifactId>
<version>${shiro.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-web</artifactId>
<version>${shiro.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-spring</artifactId>
<version>${shiro.version}</version>
</dependency>
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-ehcache</artifactId>
<version>${shiro.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/net.mingsoft/shiro-freemarker-tags -->
<dependency>
<groupId>net.mingsoft</groupId>
<artifactId>shiro-freemarker-tags</artifactId>
<version>1.0.0</version>
</dependency>
<!-- <dependency> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId>
<version>1.1.0.Final</version> </dependency> <dependency> <groupId>org.hibernate.validator</groupId>
<artifactId>hibernate-validator</artifactId> <version>5.2.4.Final</version>
</dependency> -->
<!-- freemarker -->
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>${freemarker.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alipay.sdk/alipay-sdk-java -->
<dependency>
<groupId>com.alipay.sdk</groupId>
<artifactId>alipay-sdk-java</artifactId>
<version>3.7.4.ALL</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.4</version>
</dependency>
<!-- redis -->
<!-- https://mvnrepository.com/artifact/redis.clients/jedis -->
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
<version>${redis.version}</version>
</dependency>
<!-- spring data redis -->
<!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-redis -->
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-redis</artifactId>
<version>${spring-data-redis.version}</version>
</dependency>
</dependencies>
<build>
<finalName>demo010302</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
2.创建文件夹
**1>java改成源文件**
**2>resourse改成资源文件
3.在java文件夹下建五个文件夹
**1> entity -->实体类和get/set方法 和 构造方法
**2> dao -->...Mapper -->写方法名和sql语句
**3> service --> 再建一个impl文件夹存放service实现类,在serviceImpl的类上方写上@Service,才能够被controller层调用,内部写上处理dao层代码的逻辑代码
**4> controller -->需要跳转页面在homeController中写,在类上方写@Controller
不需要跳转页面的也就是做具体的逻辑代码的处理在各自的controller类上方写@RestController 和 @RequestMapping("/url地址一部分")
**5> util -->目前写的是redis的工具类,包装了一些常用方法直接调用方便快捷。
CourseServiceImpl类
@Service
public class CourseServiceImpl implements CourseService {
@Autowired
CourseMapper courseMapper;
@Autowired
RedisTemplate<String,Object> redisTemplate;
public static final String COURSE_MAP_KEY = "courseMap";
@Override
public CourseEntity searchOne(int courseNo) {
CourseEntity courseEntity = null;
if(RedisUtils.getRedisServiceIsAlive()){
//从redis中获取信息
courseEntity = (CourseEntity)redisTemplate.opsForHash().get(COURSE_MAP_KEY,courseNo);
if(courseEntity==null){
//如果redis中没有信息就从数据库进行查询
courseEntity = courseMapper.selectOne(courseNo);
//将结果放入redis
redisTemplate.opsForHash().put(COURSE_MAP_KEY,courseNo,courseEntity);
}
}else {
courseEntity = courseMapper.selectOne(courseNo);
}
return courseEntity;
}
@Override
public boolean addOne(CourseEntity courseEntity) {
int success = courseMapper.addCourse(courseEntity);
if(success>0){
//添加的话需要往redis中放值。put(新值)
redisTemplate.opsForHash().put(COURSE_MAP_KEY,courseEntity.getCourseNo(),courseEntity);
return true;
}else{
return false;
}
}
@Override
public boolean deleteOne(int courseNo) {
int success = courseMapper.deleteOne(courseNo);
if(success>0){
//删除需要将redis中的值也删除
redisTemplate.opsForHash().delete(COURSE_MAP_KEY,courseNo);
return true;
}else{
return false;
}
}
@Override
public boolean modify(CourseEntity courseEntity) {
int success = courseMapper.modify(courseEntity);
if(success>0){
//修改也是直接放值就行
redisTemplate.opsForHash().put(COURSE_MAP_KEY,courseEntity.getCourseNo()+"",courseEntity);
return true;
}else{
return false;
}
}
}
HomeController类
@Controller
public class HomeController{
@Autowired
StudentMapper studentMapper;
@Autowired
CourseMapper courseMapper;
// 注入redisTemplate (缓存模板)
@Autowired
private RedisTemplate<String, Object> redisTemplate;
@RequestMapping("/")
public ModelAndView index() {
ModelAndView mv = new ModelAndView("stu_Index");
List<StudentEntity> studentList = new ArrayList<>();
if (RedisUtils.getRedisServiceIsAlive()) {
// redis 存活,就直接从redis中查找
Collection<Object> stuCollection = redisTemplate.opsForHash().entries(StudentServiceImpl.STUDENT_MAP_KEY).values();
// 将集合对象转化成list
studentList = RedisUtils.getCollectionObjectList(stuCollection, StudentEntity.class);
if (null == studentList || studentList.isEmpty()) { // redis中没有数据
studentList = studentMapper.findAll(); // 从数据库中查询数据
for (StudentEntity stu : studentList) {
redisTemplate.opsForHash().put(StudentServiceImpl.STUDENT_MAP_KEY, stu.getStuNo(), stu); //将数据存放进redis
}
}
} else {
studentList = studentMapper.findAll(); // 从数据库中查询数据
}
mv.addObject("studentList", studentList);
return mv;
}
@RequestMapping("/course")
public ModelAndView course() {
ModelAndView mv = new ModelAndView("course");
List<CourseEntity> courseList = new ArrayList<>();
if(RedisUtils.getRedisServiceIsAlive()) {
Collection<Object> courseCollection = redisTemplate.opsForHash().entries(CourseServiceImpl.COURSE_MAP_KEY).values();
//将集合对象转化成list
courseList = RedisUtils.getCollectionObjectList(courseCollection, CourseEntity.class);
if (null == courseList || courseList.isEmpty()) {
//如果redis中没有数据,就从数据库查
courseList = courseMapper.findAll();
//然后将结果放到redis中,但是多条语句要循环插入
for (CourseEntity course : courseList) {
redisTemplate.opsForHash().put(CourseServiceImpl.COURSE_MAP_KEY, course.getCourseNo(), course);
}
}
}else {
courseList = courseMapper.findAll();
}
//将结果放入Map集合
mv.addObject("courseList", courseList);
return mv;
}
}
CourseController类
@RestController
@RequestMapping("/course")
public class CourseController {
@Autowired
CourseService courseService;
@RequestMapping(value="/selectOne",method = RequestMethod.POST)
public Map<String,Object> selectOne(@RequestBody Map<String,Object> param){
Map<String,Object> resMap = new HashMap<>();
int courseNo = Integer.valueOf((String)(param.get("courseNo")));
CourseEntity courseEntity = courseService.searchOne(courseNo);
if(courseEntity!=null){
resMap.put("success",true);
resMap.put("data",courseEntity);
}else{
resMap.put("success",false);
resMap.put("msg","没有该课程");
}
return resMap;
}
@RequestMapping(value = "/add",method = RequestMethod.POST)
public Map<String,Object> addOne(@RequestBody Map<String,Object> param){
Map<String,Object> resMap = new HashMap<>();
boolean success = false;
try{
int courseNo = Integer.valueOf((String)param.get("courseNo"));
String courseName = (String)param.get("courseName");
CourseEntity courseEntity = new CourseEntity();
courseEntity.setCourseNo(courseNo);
courseEntity.setCourseName(courseName);
success = courseService.addOne(courseEntity);
}catch (Exception e){
resMap.put("success",false);
}
if(success){
resMap.put("success",true);
}else{
resMap.put("success",false);
}
return resMap;
}
@RequestMapping(value = "/del",method = RequestMethod.POST)
public Map<String,Object> deleteOne(@RequestBody Map<String,Object> param){
Map<String,Object> resMap = new HashMap<>();
int courseNo = Integer.valueOf((String)param.get("courseNo"));
boolean success = courseService.deleteOne(courseNo);
if(success){
resMap.put("success",true);
}else{
resMap.put("success",false);
}
return resMap;
}
@RequestMapping(value = "/modify",method = RequestMethod.POST)
public Map<String,Object> modify(@RequestBody Map<String,Object> param){
Map<String,Object> resMap = new HashMap<>();
int courseNo = Integer.valueOf((String)param.get("courseNo"));
String courseName = (String)param.get("courseName");
CourseEntity courseEntity = courseService.searchOne(courseNo);
courseEntity.setCourseNo(courseNo);
courseEntity.setCourseName(courseName);
boolean success = courseService.modify(courseEntity);
if(success){
resMap.put("success",true);
resMap.put("data",courseEntity);
}else{
resMap.put("success",false);
}
return resMap;
}
}
PropertiesManager.class
public class PropertiesManager {
//声明一个单例,volatile保证线程的可见性(可以不要)
private static volatile PropertiesManager instance;
// 声明一个辅助对象,用于synchronized加锁用
static Object object = new Object();
private PropertiesManager() {
// 私有构造方法,防止被其他类new
}
/*获取实例对象*/
public static PropertiesManager getInstance() {
// 判断单例对象instance是否存在,存在,则直接返回已存在的instance
if (null == instance) {
synchronized (object){
if (null == instance) {
// 不存在,则创建instance单例再返回
instance = new PropertiesManager();
}
}
}
// 最后返回
return instance;
}
/*读取 **.properties 配置文件中属性,传入的参数表示读取哪个配置文件*/
public Properties loadProperties(String propertiesName) {
Properties properties = new Properties();
try {
InputStream in = new FileInputStream(new File(PropertiesManager.class.getResource(
"/properties/" + propertiesName).toURI()));
properties.load(in);
} catch (IOException e) {
e.printStackTrace();
} catch (URISyntaxException e) {
e.printStackTrace();
}
return properties;
}
}
RedisUtil.class
public class RedisUtils {
private static String hostname;
private static int port;
private static String password;
/*
* properties:获取redis.properties配置文件中所有redis属性配置
* hostname:redis的主机ip地址
* port:redis的端口号
* password:redis的密码
*
* */
static {
Properties properties = PropertiesManager.getInstance().loadProperties("redis.properties");
hostname = properties.getProperty("redis.hostname", "127.0.0.1");
port = Integer.valueOf(properties.getProperty("redis.port", "6379"));
password = properties.getProperty("redis.password", "");
}
/* 判断redis服务是否存活 */
public static boolean getRedisServiceIsAlive() {
boolean isAlive = false;
try {
Jedis jedis = new Jedis(hostname, port);
String pong = jedis.ping();
if ("PONG".equals(pong)) {
isAlive = true;
}
} catch (Exception e) {
isAlive = false;
System.out.println("Redis 服务已经死掉了");
} finally {
return isAlive;
}
}
/* 将存在redis中的map对象转化成list对象 */
public static <T> List<T> getCollectionObjectList(Collection<Object> collection, Class T) {
List<T> list = new ArrayList<T>(collection.size());
for (Object obj : collection) {
T target = (T) obj;
list.add(target);
}
return list;
}
}
4.在resourse文件夹下建三个文件夹
**1> config -->放各种配置文件,包括Spring.xml\\\Spring-redis.xml\\\SpringMvc.xml等
**2> mapper -->这里可以下载插件然后使用自动生成sql语句时候使用这个文件夹,目前为了提升自己sql语句熟练度,暂时不使用该项功能。
**3> properties -->项目中要使用到的各种不变属性配置,包括jdbc.properties\\\
freemarker.properties\\\redis.properties等
Config文件夹中Spring.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:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd ">
<!-- 自动扫描 service -->
<context:component-scan
base-package="service"/>
<!-- 引入配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<array>
<value>classpath:properties/jdbc.properties</value>
<!--引入redis.properties配置文件-->
<value>classpath:properties/redis.properties</value>
</array>
</property>
</bean>
<!--引入Spring-redis.xml配置-->
<import resource="Spring-redis.xml"/>
<!-- 数据库连接池 -->
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource">
<property name="driverClassName" value="${jdbc.driver}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="maximumPoolSize"
value="${jdbc.maximumPoolSize}"></property>
</bean>
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!-- 自动扫描mapping.xml文件 -->
<!-- <property name="mapperLocations"-->
<!-- value="classpath:mapper/*.xml"></property>-->
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="dao"/>
<property name="sqlSessionFactoryBeanName"
value="sqlSessionFactory"></property>
</bean>
<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 开启事务注解 -->
<tx:annotation-driven
transaction-manager="transactionManager"/>
</beans>
Config文件夹中SpringMvc.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 开启注解驱动 -->
<mvc:annotation-driven/>
<!-- 静态资源处理器 -->
<mvc:default-servlet-handler/>
<!-- 扫描controller 包 -->
<context:component-scan
base-package="controller"></context:component-scan>
<!-- 文件上传 -->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 默认编码 -->
<property name="defaultEncoding" value="utf-8"/>
<!-- 文件大小最大值 -->
<property name="maxUploadSize" value="10485760000"/>
<!-- 内存中的最大值 -->
<property name="maxInMemorySize" value="40960"/>
</bean>
<!-- 开启AOP 就可以使用aop 例如记录日志 -->
<aop:config proxy-target-class="true"></aop:config>
<!-- 视图解析器: freemarker 或 thymeleaf 或 jsp -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass"
value="org.springframework.web.servlet.view.JstlView"/>
<property name="prefix" value="/WEB-INF/view/"/>
<property name="suffix" value=".html"/>
<property name="order" value="1"></property>
</bean>
<bean id="freemarkerConfiguration"
class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="location"
value="classpath:properties/freemarker.properties"></property>
</bean>
<bean
class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer">
<property name="freemarkerSettings"
ref="freemarkerConfiguration"/>
<property name="templateLoaderPath">
<value>/WEB-INF/view/</value>
</property>
</bean>
<bean id="htmlviewResolver"
class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver">
<property name="suffix" value=".html"></property>
<property name="order" value="0"></property>
<property name="contentType" value="text/html;charset=UTF-8"></property>
<property name="requestContextAttribute" value="base"></property>
</bean>
</beans>
Config文件夹中Spring-redis.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd">
<!--jedis pool config-->
<bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig">
<property name="maxTotal" value="${redis.pool.maxTotal}"/>
<property name="maxIdle" value="${redis.pool.maxIdle}"/>
<property name="maxWaitMillis" value="${redis.pool.maxWaitMillis}"/>
<property name="testOnBorrow" value="${redis.pool.testOnBorrow}"/>
</bean>
<!--jedis connection factory config-->
<bean id="jedisConnectionFactory" class="org.springframework.data.redis.connection.jedis.JedisConnectionFactory">
<property name="hostName" value="${redis.hostname}"/>
<property name="port" value="${redis.port}"/>
<property name="password" value=""/>
<property name="poolConfig" ref="jedisPoolConfig"/>
</bean>
<!--redisTemplate config-->
<bean id="redisTemplate" class="org.springframework.data.redis.core.RedisTemplate">
<property name="connectionFactory" ref="jedisConnectionFactory"/>
</bean>
</beans>
properties文件夹中jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/study?characterEncoding=utf-8&useSSL=false&useUnicode=true
jdbc.username=root
jdbc.password=123456
jdbc.maximumPoolSize=20
properties文件夹中freemarker.properties
tag_syntax=auto_detect
template_update_delay=60
default_encoding=UTF-8
output_encoding=UTF-8
locale=en_US
date_format=yyyy-MM-dd
time_format=HH:mm:ss
datetime_format=yyyy-MM-dd HH:mm:ss
classic_compatible=true
template_exception_handler=ignore
#auto_import=spring.ftl as spring
properties文件夹中redis.properties
#redis config
redis.pool.maxTotal=100
redis.pool.maxIdle=20
redis.pool.maxWaitMillis=1000
redis.pool.testOnBorrow=true
redis.hostname=127.0.0.1
redis.port=6379
redis.password=
5.在webapp文件夹下建static文件夹
6.在webapp -->WEB-INF下建view文件夹存放html页面
course.html内有freemarker的写法,使用了easyui框架
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script type="text/javascript" src="${base.contextPath}/static/js/jquery-1.8.3.min.js"></script>
<script type="text/javascript" src="${base.contextPath}/static/js/jquery.easyui.min.js"></script>
<link rel="stylesheet" href="${base.contextPath}/static/themes/default/easyui.css" type="text/css">
<link rel="stylesheet" href="${base.contextPath}/static/themes/icon.css" type="text/css">
<script type="text/javascript" src="${base.contextPath}/static/js/common.js"></script>
<script type="text/javascript" src="${base.contextPath}/static/js/course.js"></script>
</head>
<body>
<div>
<div id="container" style="width: 100%; height: 100%">
<div id="header" style="background-color: pink;">
<h1 style="margin-bottom: 0; text-align: center;">课程信息管理中心</h1>
</div>
<div id="menu" style="height: 40%; width: 20%; float: left;">
<a href="#" class="easyui-linkbutton" id="addOne${co.courseName}" onclick="add()"
data-options="iconCls:'icon-add'">添加课程</a>
<#-- <button id="add" type="button" onclick="window.location.href='add.html'">添加课程</button>-->
<br>
<button id="delete" type="button" onclick="window.location.href='deleteOne.html'">删除课程</button>
<br>
<button id="modify" type="button" onclick="window.location.href='modify.html'">修改课程信息</button>
<br>
<button id="selectOne" type="button" onclick="window.location.href='searchOne.html'">查看信息</button>
<br>
<button id="index" type="button" onclick="window.location.href='stu_index.html'">Student Information Index
</button><br>
<button id="course" type="button" onclick="window.location.href='course.html'">课程 Information Index</button>
</div>
<div id="content" style="background-color: gray; height: 600px; width: 80%; float: left;">
<table border="1">
<tr>
<th>课程编号</th>
<th>课程名称</th>
<th>操作</th>
</tr>
<!-- 用freemarker循环输出菜谱 -->
<#list courseList as course>
<tr>
<td>${course.courseNo}</td>
<td>${course.courseName}</td>
<td>
<#--这里表示一个查看按钮,点击出现弹框-->
<a href="#" class="easyui-linkbutton" id="selectOne${course.courseNo}"
onclick="searchOne('${course.courseNo}')" data-options="iconCls:'icon-search'">查看</a>
<a href="#" class="easyui-linkbutton" id="modify${course.courseNo}"
onclick="modify('${course.courseNo}')" data-options = "iconCls:'icon-edit'">修改</a>
<a href="#" class="easyui-linkbutton" id="delete${course.courseNo}"
onclick="deleteOne('${course.courseNo}')" data-options = "iconCls:'icon-cancel'">删除</a>
</td>
</tr>
</#list>
</table>
<#--查看单个信息-->
<div id="info-dialog" class="easyui-dialog" style="width: 400px;height: 300px;"
data-options="title:'详细信息',iconCls:'icon-search',closed:true,modal:true,buttons:'#dlg-btn'">
课程编号:<input class="easyui-textbox" style="width: 300px;" id="info-courseNo" value="" readonly="readonly"><br>
课程名称:<input class="easyui-textbox" style="width: 300px;" id="info-courseName" value="" readonly="readonly"><br>
</div>
<div id="dlg-btn">
<#-- 如果是修改的话,则需要保存按钮,此处是查看信息,不需要-->
<#-- <a href="#" class="easyui-linkbutton" onclick="add();">保存</a>-->
<#-- 取消就是直接关闭对话框即可-->
<a href="#" class="easyui-linkbutton" onclick="cancel('info-dialog');">取消</a>
</div>
<#-- 添加课程 -->
<div id="info-dialog-add" class="easyui-dialog" style="width: 400px;height: 300px;"
data-options="title:'添加课程',iconCls:'icon-search',closed:true,modal:true,buttons:'#dlg-btn-add'">
课程编号:<input class="easyui-textbox" style="width: 300px;" id="info-courseNo-add" value=""><br>
课程名称:<input class="easyui-textbox" style="width: 300px;" id="info-courseName-add" value=""><br>
</div>
<div id="dlg-btn-add">
<a href="#" class="easyui-linkbutton" onclick="saveadd();">保存</a>
<a href="#" class="easyui-linkbutton" onclick="cancel('info-dialog-add');">取消</a>
</div>
<#-- 修改课程 -->
<div id="info-dialog-edit" class="easyui-dialog" style="width: 400px;height: 300px;"
data-options="title:'修改课程',iconCls:'icon-edit',closed:true,modal:true,buttons:'#dlg-btn-edit'">
课程编号:<input class="easyui-textbox" style="width: 300px;" id="info-courseNo-edit" value=""><br>
课程名称:<input class="easyui-textbox" style="width: 300px;" id="info-courseName-edit" value=""><br>
</div>
<div id="dlg-btn-edit">
<a href="#" class="easyui-linkbutton" onclick="saveedit();">保存</a>
<a href="#" class="easyui-linkbutton" onclick="cancel('info-dialog-edit');">取消</a>
</div>
</div>
<div id="footer" style="background-color: white; clear: both; text-align: center;">Copyright © w3cschool.cn
</div>
</div>
</div>
</body>
</html>
搭配以上的course.js,某些直接用的库未放
function cancel(dialogId) {
$("#" + dialogId).dialog('close');
}
/*
* 根据编号获取课程信息
* */
function getCourseInfoByNo(courseNo) {
var course;
var url = baseUrl+"/course/selectOne";
var param = {};
param.courseNo = courseNo + "";
$.ajax({
url:url,
type:'post',
data:JSON.stringify(param),
dataType:'json',
async: false, // 取消异步执行,按照代码顺序同步执行
contentType:'application/json;charset=utf-8',
success:function (result) {
if(result.success){
course = result.data;
}else{
alert(result.msg);// 查询失败,则提示失败信息
}
}
})
return course;
}
function searchOne(courseNo) {
console.log(courseNo);
var course = getCourseInfoByNo(courseNo);
console.log(course);
$("#info-courseNo").textbox('setText',course.courseNo);
$("#info-courseName").textbox('setText',course.courseName);
$("#info-dialog").dialog('open');
}
function add() {
$("#info-dialog-add").dialog('open');
}
function saveadd() {
var courseNo = $("#info-courseNo-add").textbox("getText",courseNo);
var courseName = $("#info-courseName-add").textbox("getText",courseName);
var param={};
param.courseNo = courseNo+"";
param.courseName = courseName;
url = baseUrl+"/course/add";
$.ajax({
url:url,
type:'post',
data:JSON.stringify(param),
dataType:'json',
contentType:'application/json;charset=utf-8',
success:function (result) {
if(result.success){
param = result.data;
$.messager.alert("success","添加成功","info");
window.location.reload();
}else{
$.messager.alert("error","添加失败","error");
}
}
})
$("#info-dialog-add").dialog('open')
}
function deleteOne(courseNo) {
var param = {};
param.courseNo = courseNo+"";
url = baseUrl+"/course/del";
$.ajax({
url:url,
type:'post',
data:JSON.stringify(param),
dataType:'json',
contentType:'application/json;charset=utf-8',
success:function (result) {
if(result.success){
window.location.reload();
}else{
$.messager.alert("error","删除失败!","error");
}
}
})
}
function modify(courseNo) {
var course = getCourseInfoByNo(courseNo);
//回填参数
$("#info-courseNo-edit").textbox("setText",course.courseNo);
$("#info-courseName-edit").textbox("setText",course.courseName);
$("#info-dialog-edit").dialog('open');
}
function saveedit() {
var param = {};
param.courseNo = $("#info-courseNo-edit").textbox("getText");
param.courseName = $("#info-courseName-edit").textbox("getText");
url = baseUrl+"/course/modify";
$.ajax({
url:url,
type:'post',
data:JSON.stringify(param),
dataType:'json',
contentType:'application/json;charset=utf-8',
success:function (result) {
if(result.success){
course = result.data;
$.messager.alert("success","修改成功!","info",function (){
window.location.href="";
})
}else{
$.messager.alert("error","修改失败!","error");
}
}
})
}
7.修改web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!-- Spring上下文的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<!-- 加载spring 的bean -->
<param-value>classpath:config/Spring.xml</param-value>
</context-param>
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<!-- <async-supported>true</async-supported>-->
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener
</listener-class>
</listener>
<!-- Spring MVC 配置 -->
<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:config/SpringMvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
<!-- <async-supported>true</async-supported>-->
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>stu_Index.html</welcome-file>
</welcome-file-list>
</web-app>