SpringBoot 中的各种配置文件及配置文件转 Bean

╰+哭是因爲堅強的太久メ 2022-11-17 13:49 248阅读 0赞

## 1、SpringBoot 基本 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.imooc</groupId>
    	<artifactId>o2o</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>war</packaging>
    
    	<name>o2o</name>
    	<description>Demo project for Spring Boot</description>
    
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>2.1.6.RELEASE</version>
    		<relativePath /> 
    	</parent>
    
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    		<java.version>1.8</java.version>
    	</properties>
    
    	<dependencies>
    		
    		<dependency>
    			<groupId>ch.qos.logback</groupId>
    			<artifactId>logback-classic</artifactId>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>javax.servlet</groupId>
    			<artifactId>javax.servlet-api</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.fasterxml.jackson.core</groupId>
    			<artifactId>jackson-databind</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>commons-collections</groupId>
    			<artifactId>commons-collections</artifactId>
    			<version>3.2.2</version>
    		</dependency>
       		<dependency>
    			<groupId>com.mchange</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.5.4</version>
    		</dependency>		
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>net.coobird</groupId>
    			<artifactId>thumbnailator</artifactId>
    			<version>0.4.8</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.github.penggle</groupId>
    			<artifactId>kaptcha</artifactId>
    			<version>2.3.2</version>
    		</dependency>
    		<dependency>
    			<groupId>commons-fileupload</groupId>
    			<artifactId>commons-fileupload</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>redis.clients</groupId>
    			<artifactId>jedis</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>2.0.1</version>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>com.google.zxing</groupId>
    			<artifactId>javase</artifactId>
    			<version>3.3.0</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.quartz-scheduler</groupId>
    			<artifactId>quartz</artifactId>
    			<version>2.3.0</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-context-support</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>fastjson</artifactId>
    			<version>1.2.45</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.squareup.okhttp3</groupId>
    			<artifactId>okhttp</artifactId>
    			<version>3.9.1</version>
    		</dependency>
          	<dependency>
    			<groupId>com.google.code.gson</groupId>
    			<artifactId>gson</artifactId>
    			<version>2.8.6</version>
    		</dependency>
    	</dependencies>
    
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>
    </project>

## 2、SpringBoot 集成 MyBatis 的 dao 层 xml 文件 ##

## ProductDao.xml
    
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.imooc.o2o.dao.ProductDao">
    	<resultMap id="productMap" type="com.imooc.o2o.entity.Product">
    		<id column="product_id" property="productId" />
    		<result column="product_name" property="productName" />
    		<result column="product_desc" property="productDesc" />
    		<result column="img_addr" property="imgAddr" />
    		<result column="normal_price" property="normalPrice" />
    		<result column="promotion_price" property="promotionPrice" />
    		<result column="priority" property="priority" />
    		<result column="create_time" property="createTime" />
    		<result column="last_edit_time" property="lastEditTime" />
    		<result column="enable_status" property="enableStatus" />
    		<result column="point" property="point" />
    		<association property="productCategory" column="product_category_id" javaType="com.imooc.o2o.entity.ProductCategory">
    			<id column="product_category_id" property="productCategoryId" />
    			<result column="product_category_name" property="productCategoryName" />
    		</association>
    		<association property="shop" column="shop_id" javaType="com.imooc.o2o.entity.Shop">
    			<id column="shop_id" property="shopId" />
    			<result column="owner_id" property="ownerId" />
    			<result column="shop_name" property="shopName" />
    		</association>
    		<collection property="productImgList" column="product_id" ofType="com.imooc.o2o.entity.ProductImg">
    			<id column="product_img_id" property="productImgId" />
    			<result column="detail_img" property="imgAddr" />
    			<result column="img_desc" property="imgDesc" />
    			<result column="priority" property="priority" />
    			<result column="create_time" property="createTime" />
    			<result column="product_id" property="productId" />
    		</collection>
    	</resultMap>
    	<select id="queryProductList" resultType="com.imooc.o2o.entity.Product">
    		SELECT
    		product_id,
    		product_name,
    		product_desc,
    		img_addr,
    		normal_price,
    		promotion_price,
    		priority,
    		create_time,
    		last_edit_time,
    		enable_status,
    		point,
    		product_category_id,
    		shop_id
    		FROM
    		tb_product
    		<where>
    			<if test="productCondition.shop!=null and productCondition.shop.shopId!=null">
    				and shop_id = #{productCondition.shop.shopId}
    			</if>
    			<if test="productCondition.productCategory!=null and productCondition.productCategory.productCategoryId!=null">
    				and product_category_id =
    				#{productCondition.productCategory.productCategoryId}
    			</if>
    			
    			<if test="productCondition.productName!=null">
    				and product_name like '%${productCondition.productName}%'
    			</if>
    			<if test="productCondition.enableStatus!=null">
    				and enable_status = #{productCondition.enableStatus}
    			</if>
    		</where>
    		ORDER BY
    		priority DESC
    		LIMIT #{rowIndex},#{pageSize};
    	</select>
    
    	<select id="queryProductCount" resultType="int">
    		SELECT count(1) FROM tb_product
    		<where>
    			<if test="productCondition.shop!=null and productCondition.shop.shopId!=null">
    				and shop_id = #{productCondition.shop.shopId}
    			</if>
    			<if test="productCondition.productCategory!=null and productCondition.productCategory.productCategoryId!=null">
    				and product_category_id =
    				#{productCondition.productCategory.productCategoryId}
    			</if>
    			<if test="productCondition.productName!=null">
    				and product_name like '%${productCondition.productName}%'
    			</if>
    			<if test="productCondition.enableStatus!=null">
    				and enable_status = #{productCondition.enableStatus}
    			</if>
    		</where>
    	</select>
    	<select id="queryProductById" resultMap="productMap" parameterType="Long">
    		
    		SELECT
    		p.product_id,
    		p.product_name,
    		p.product_desc,
    		p.img_addr,
    		p.normal_price,
    		p.promotion_price,
    		p.priority,
    		p.create_time,
    		p.last_edit_time,
    		p.enable_status,
    		p.point,
    		p.product_category_id,
    		p.shop_id,
    		pm.product_img_id,
    		pm.img_addr AS detail_img,
    		pm.img_desc,
    		pm.priority,
    		pm.create_time
    		FROM
    		tb_product p
    		LEFT JOIN
    		tb_product_img pm
    		ON
    		p.product_id =
    		pm.product_id
    		WHERE
    		p.product_id =
    		#{productId}
    		ORDER BY
    		pm.priority DESC
    	</select>
    	<insert id="insertProduct" parameterType="com.imooc.o2o.entity.Product" useGeneratedKeys="true" keyProperty="productId" keyColumn="product_id">
    		INSERT INTO
    		tb_product(product_name,product_desc,img_addr,
    		normal_price,promotion_price,priority,create_time,
    		last_edit_time,enable_status,point,product_category_id,
    		shop_id)
    		VALUES
    		(#{productName},#{productDesc},#{imgAddr},
    		#{normalPrice},#{promotionPrice},#{priority},#{createTime},
    		#{lastEditTime},#{enableStatus},#{point},#{productCategory.productCategoryId},
    		#{shop.shopId})
    	</insert>
    	<insert id="batchInsertProductImg" parameterType="java.util.List">	
    		INSERT INTO
    		tb_product_img(img_addr,img_desc,priority,
    		create_time,product_id)
    		VALUES
    		<foreach collection="list" item="productImg" index="index" separator=",">
    			(
    			#{productImg.imgAddr},
    			#{productImg.imgDesc},
    			#{productImg.priority},
    			#{productImg.createTime},
    			#{productImg.productId}
    			)
    		</foreach>
    	</insert>
    	<update id="updateProduct" parameterType="com.imooc.o2o.entity.Product" keyProperty="product_id" useGeneratedKeys="true">
    		UPDATE tb_product
    		<set>
    			<if test="productName != null">product_name=#{productName},</if>
    			<if test="productDesc != null">product_desc=#{productDesc},</if>
    			<if test="imgAddr != null">img_addr=#{imgAddr},</if>
    			<if test="normalPrice != null">normal_price=#{normalPrice},</if>
    			<if test="promotionPrice != null">promotion_price=#{promotionPrice},</if>
    			<if test="priority != null">priority=#{priority},</if>
    			<if test="lastEditTime != null">last_edit_time=#{lastEditTime},</if>
    			<if test="enableStatus != null">enable_status=#{enableStatus},</if>
    			<if test="point != null">point=#{point},</if>
    			<if test="productCategory != null and productCategory.productCategoryId != null">
    				product_category_id=#{productCategory.productCategoryId}
    			</if>
    		</set>
    		WHERE product_id = #{productId}
    		AND shop_id=#{shop.shopId}
    	</update>
    	<update id="updateProductCategoryToNull" parameterType="Long">
    		UPDATE
    		tb_product
    		SET
    		product_category_id = null
    		WHERE product_category_id =
    		#{productCategoryId}
    	</update>
    	<delete id="deleteProduct">
    		DELETE FROM
    		tb_product
    		WHERE
    		product_id = #{productId}
    		AND shop_id=#{shopId}
    	</delete>
    	<delete id="batchDeleteShopCategory" parameterType="long">
    		DELETE FROM
    		tb_shop_category
    		WHERE shop_category_id IN
    		<foreach collection="list" item="shopCategoryId" open="(" separator="," close=")">
    			#{shopCategoryId}
    		</foreach>
    	</delete>
    </mapper>

## 3、ProductDao.java ##

package com.imooc.o2o.dao;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Param;
    
    import com.imooc.o2o.entity.Product;
    
    public interface ProductDao { 
    	/** * 查询商品列表并分页，可输入的条件有： 商品名（模糊），商品状态，店铺Id,商品类别 * * @param productCondition * @param rowIndex * @param pageSize * @return */
    	List<Product> queryProductList(@Param("productCondition") Product productCondition, @Param("rowIndex") int rowIndex,
    			@Param("pageSize") int pageSize);
    
    	/** * 查询对应的商品总数 * * @param productCondition * @return */
    	int queryProductCount(@Param("productCondition") Product productCondition);
    
    	/** * 通过productId查询唯一的商品信息 * * @param productId * @return */
    	Product queryProductById(long productId);
    
    	/** * 插入商品 * * @param product * @return */
    	int insertProduct(Product product);
    	
    	/** * 批量添加商品详情图片 * * @param productImgList * @return */
    	int batchInsertProductImg(List<ProductImg> productImgList);
    
    	/** * 更新商品信息 * * @param product * @return */
    	int updateProduct(Product product);
    
    	/** * 删除商品类别之前，将商品类别ID置为空 * * @param productCategoryId * @return */
    	int updateProductCategoryToNull(long productCategoryId);
    
    	/** * 删除商品 * * @param productId * @return */
    	int deleteProduct(@Param("productId") long productId, @Param("shopId") long shopId);
    
    	/** * 批量删除店铺类别 * * @param shopCategoryIdList * @return */
    	int batchDeleteShopCategory(List<Long> shopCategoryIdList);
    }

## 4、mybatis-config.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	<settings>
    		
    		<setting name="useGeneratedKeys" value="true" />
    
    		
    		<setting name="useColumnLabel" value="true" />
    
    		
    		<setting name="mapUnderscoreToCamelCase" value="true" />
    	</settings>
    </configuration>

## 5、logback.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    <configuration scan="true" scanPeriod="60 seconds" debug="false">
    	
    	
    	
    	<property name="log.level" value="debug" />
    	<property name="log.maxHistory" value="30" />
    	<property name="log.filePath" value="${catalina.base}/logs/webapps" />
    	<property name="log.pattern" value="%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n" />
    	
    	<appender name="consoleAppender" class="ch.qos.logback.core.ConsoleAppender">
    		<encoder>
    			<pattern>${log.pattern}</pattern>
    		</encoder>
    	</appender>
    	
    	<appender name="debugAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		
    		<file>${log.filePath}/debug.log</file>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			
    			<fileNamePattern>${log.filePath}/debug/debug.%d{yyyy-MM-dd}.log.gz
    			</fileNamePattern>
    			
    			<maxHistory>${log.maxHistory}</maxHistory>
    		</rollingPolicy>
    		<encoder>
    			<pattern>${log.pattern}</pattern>
    		</encoder>
    		<filter class="ch.qos.logback.classic.filter.LevelFilter">
    			<level>DEBUG</level>
    			<onMatch>ACCEPT</onMatch>
    			<onMismatch>DENY</onMismatch>
    		</filter>
    	</appender>
    	
    	<appender name="infoAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		
    		<file>${log.filePath}/info.log</file>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			
    			<fileNamePattern>${log.filePath}/info/info.%d{yyyy-MM-dd}.log.gz
    			</fileNamePattern>
    			
    			<maxHistory>${log.maxHistory}</maxHistory>
    		</rollingPolicy>
    		<encoder>
    			<pattern>${log.pattern}</pattern>
    		</encoder>
    		<filter class="ch.qos.logback.classic.filter.LevelFilter">
    			<level>INFO</level>
    			<onMatch>ACCEPT</onMatch>
    			<onMismatch>DENY</onMismatch>
    		</filter>
    	</appender>
    	
    	<appender name="errorAppender" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		
    		<file>${log.filePath}/erorr.log</file>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			
    			<fileNamePattern>${log.filePath}/error/error.%d{yyyy-MM-dd}.log.gz
    			</fileNamePattern>
    			
    			<maxHistory>${log.maxHistory}</maxHistory>
    		</rollingPolicy>
    		<encoder>
    			<pattern>${log.pattern}</pattern>
    		</encoder>
    		<filter class="ch.qos.logback.classic.filter.LevelFilter">
    			<level>ERROR</level>
    			<onMatch>ACCEPT</onMatch>
    			<onMismatch>DENY</onMismatch>
    		</filter>
    	</appender>
    	<logger name="com.imooc.o2o" level="${log.level}" additivity="true">
    		<appender-ref ref="debugAppender"/>
    		<appender-ref ref="infoAppender"/>
    		<appender-ref ref="errorAppender"/>
    	</logger>
    	<root level="info">
    		<appender-ref ref="consoleAppender"/>
    	</root>
    </configuration>

## 6、application.properties ##

server.port=8080
    #加入/o2o前缀
    server.servlet.context-path=/o2o
    
    #DataSource
    #数据库驱动
    jdbc.driver=com.mysql.cj.jdbc.Driver
    #数据库链接
    jdbc.url=jdbc:mysql://106.13.78.180:3306/o2o?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC
    #数据库用户名（已加密）
    jdbc.username=WnplV/ietfQ=
    #数据库密码（已加密）
    jdbc.password=RxQNfAQRZdFbfLs72BFqeQ==
    
    #Mybatis
    mybatis_config_file=mybatis-config.xml
    mapper_path=/mapper/**.xml
    type_alias_package=com.imooc.entity
    
    #Redis配置
    redis.hostname=127.0.0.1
    redis.port=6379
    redis.pool.maxActive=100
    redis.pool.maxIdle=20
    redis.pool.maxWait=3000
    redis.pool.testOnBorrow=true
    
    #Kaptcha的配置
    kaptcha.border=no
    kaptcha.textproducer.font.color=red
    kaptcha.image.width=135
    kaptcha.textproducer.char.string=ACDEFHKPRSTWX345679
    kaptcha.image.height=50
    kaptcha.textproducer.font.size=43
    kaptcha.noise.color=black
    kaptcha.textproducer.char.length=4
    kaptcha.textproducer.font.names=Arial
    
    #Path管理
    win.base.path=D:/projectdev/image
    linux.base.path=/Users/baidu/work/image
    shop.relevant.path=/upload/images/item/shop/
    headline.relevant.path=/upload/images/item/headtitle/
    shopcategory.relevant.path=/upload/images/item/shopcategory/
    
    #微信相关
    wechat.appid=wxd7f6c5b8899fba83
    wechat.prefix=https://open.weixin.qq.com/connect/oauth2/authorize?appid=${wechat.appid}&redirect_uri=
    wechat.middle=&response_type=code&scope=snsapi_userinfo&state=
    wechat.suffix=#wechat_redirect
    
    wechat.auth.url=http://o2o.yitiaojieinfo.com/o2o/shopadmin/addshopauthmap
    wechat.login.url=http://o2o.yitiaojieinfo.com/o2o/wechatlogin/logincheck
    wechat.exchange.url=http://o2o.yitiaojieinfo.com/o2o/shopadmin/exchangeaward
    wechat.productmap.url=http://o2o.yitiaojieinfo.com/o2o/shopadmin/adduserproductmap

## 7、dao 层配置文件转 Bean ##

## DataSourceConfiguration.java
    
    package com.imooc.o2o.config.dao;
    
    import java.beans.PropertyVetoException;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    import com.imooc.o2o.util.DESUtil;
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    
    /** * 配置datasource到ioc容器里面 * */
    @Configuration
    // 配置mybatis mapper的扫描路径
    @MapperScan("com.imooc.o2o.dao")
    public class DataSourceConfiguration { 
    	@Value("${jdbc.driver}")
    	private String jdbcDriver;
    	@Value("${jdbc.url}")
    	private String jdbcUrl;
    	@Value("${jdbc.username}")
    	private String jdbcUsername;
    	@Value("${jdbc.password}")
    	private String jdbcPassword;
    
    	/** * 生成与spring-dao.xml对应的bean dataSource * * @return * @throws PropertyVetoException */
    	@Bean(name = "dataSource")
    	public ComboPooledDataSource createDataSource() throws PropertyVetoException { 
    		// 生成datasource实例
    		ComboPooledDataSource dataSource = new ComboPooledDataSource();
    		// 跟配置文件一样设置以下信息
    		// 驱动
    		dataSource.setDriverClass(jdbcDriver);
    		// 数据库连接URL
    		dataSource.setJdbcUrl(jdbcUrl);
    		// 设置用户名
    		dataSource.setUser(DESUtil.getDecryptString(jdbcUsername));
    		// 设置用户密码
    		dataSource.setPassword(DESUtil.getDecryptString(jdbcPassword));
    		// 配置c3p0连接池的私有属性
    		// 连接池最大线程数
    		dataSource.setMaxPoolSize(30);
    		// 连接池最小线程数
    		dataSource.setMinPoolSize(10);
    		dataSource.setInitialPoolSize(10);
    		// 关闭连接后不自动commit
    		dataSource.setAutoCommitOnClose(false);
    		// 连接超时时间
    		dataSource.setCheckoutTimeout(10000);
    		// 连接失败重试次数
    		dataSource.setAcquireRetryAttempts(2);
    		return dataSource;
    	}
    }

## SessionFactoryConfiguration.java
    
    package com.imooc.o2o.config.dao;
    
    import java.io.IOException;
    
    import javax.sql.DataSource;
    
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.core.io.ClassPathResource;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    import org.springframework.core.io.support.ResourcePatternResolver;
    
    @Configuration
    public class SessionFactoryConfiguration { 
    	// mybatis-config.xml配置文件的路径
    	private static String mybatisConfigFile;
    
    	@Value("${mybatis_config_file}")
    	public void setMybatisConfigFile(String mybatisConfigFile) { 
    		SessionFactoryConfiguration.mybatisConfigFile = mybatisConfigFile;
    	}
    
    	// mybatis mapper文件所在路径
    	private static String mapperPath;
    
    	@Value("${mapper_path}")
    	public void setMapperPath(String mapperPath) { 
    		SessionFactoryConfiguration.mapperPath = mapperPath;
    	}
    
    	// 实体类所在的package
    	@Value("${type_alias_package}")
    	private String typeAliasPackage;
    
    	@Autowired
    	private DataSource dataSource;
    
    	/** * 创建sqlSessionFactoryBean 实例 并且设置configtion 设置mapper 映射路径 设置datasource数据源 * * @return * @throws IOException */
    	@Bean(name = "sqlSessionFactory")
    	public SqlSessionFactoryBean createSqlSessionFactoryBean() throws IOException { 
    		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    		// 设置mybatis configuration 扫描路径
    		sqlSessionFactoryBean.setConfigLocation(new ClassPathResource(mybatisConfigFile));
    		// 添加mapper 扫描路径
    		PathMatchingResourcePatternResolver pathMatchingResourcePatternResolver = new PathMatchingResourcePatternResolver();
    		String packageSearchPath = ResourcePatternResolver.CLASSPATH_ALL_URL_PREFIX + mapperPath;
    		sqlSessionFactoryBean.setMapperLocations(pathMatchingResourcePatternResolver.getResources(packageSearchPath));
    		// 设置dataSource
    		sqlSessionFactoryBean.setDataSource(dataSource);
    		// 设置typeAlias 包扫描路径
    		sqlSessionFactoryBean.setTypeAliasesPackage(typeAliasPackage);
    		return sqlSessionFactoryBean;
    	}
    }

## 8、redis 配置文件转 Bean ##

## RedisConfiguration.java
    
    package com.imooc.o2o.config.redis;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    import com.imooc.o2o.cache.JedisPoolWriper;
    import com.imooc.o2o.cache.JedisUtil;
    
    import redis.clients.jedis.JedisPoolConfig;
    
    /** * spring-redis.xml里的配置 * */
    @Configuration
    public class RedisConfiguration { 
    	@Value("${redis.hostname}")
    	private String hostname;
    	@Value("${redis.port}")
    	private int port;
    	@Value("${redis.pool.maxActive}")
    	private int maxTotal;
    	@Value("${redis.pool.maxIdle}")
    	private int maxIdle;
    	@Value("${redis.pool.maxWait}")
    	private long maxWaitMillis;
    	@Value("${redis.pool.testOnBorrow}")
    	private boolean testOnBorrow;
    
    	@Autowired
    	private JedisPoolConfig jedisPoolConfig;
    	@Autowired
    	private JedisPoolWriper jedisWritePool;
    	@Autowired
    	private JedisUtil jedisUtil;
    
    	/** * 创建redis连接池的设置 * * @return */
    	@Bean(name = "jedisPoolConfig")
    	public JedisPoolConfig createJedisPoolConfig() { 
    		JedisPoolConfig jedisPoolConfig = new JedisPoolConfig();
    		// 控制一个pool可分配多少个jedis实例
    		jedisPoolConfig.setMaxTotal(maxTotal);
    		// 连接池中最多可空闲maxIdle个连接 ，这里取值为20，
    		// 表示即使没有数据库连接时依然可以保持20空闲的连接，
    		// 而不被清除，随时处于待命状态。
    		jedisPoolConfig.setMaxIdle(maxIdle);
    		// 最大等待时间:当没有可用连接时,
    		// 连接池等待连接被归还的最大时间(以毫秒计数),超过时间则抛出异常
    		jedisPoolConfig.setMaxWaitMillis(maxWaitMillis);
    		// 在获取连接的时候检查有效性
    		jedisPoolConfig.setTestOnBorrow(testOnBorrow);
    		return jedisPoolConfig;
    	}
    
    	/** * 创建Redis连接池，并做相关配置 * * @return */
    	@Bean(name = "jedisWritePool")
    	public JedisPoolWriper createJedisPoolWriper() { 
    		JedisPoolWriper jedisPoolWriper = new JedisPoolWriper(jedisPoolConfig, hostname, port);
    		return jedisPoolWriper;
    	}
    
    	/** * 创建Redis工具类，封装好Redis的连接以进行相关的操作 * * @return */
    	@Bean(name = "jedisUtil")
    	public JedisUtil createJedisUtil() { 
    		JedisUtil jedisUtil = new JedisUtil();
    		jedisUtil.setJedisPool(jedisWritePool);
    		return jedisUtil;
    	}
    
    	/** * Redis的key操作 * * @return */
    	@Bean(name = "jedisKeys")
    	public JedisUtil.Keys createJedisKeys() { 
    		JedisUtil.Keys jedisKeys = jedisUtil.new Keys();
    		return jedisKeys;
    	}
    
    	/** * Redis的Strings操作 * * @return */
    	@Bean(name = "jedisStrings")
    	public JedisUtil.Strings createJedisStrings() { 
    		JedisUtil.Strings jedisStrings = jedisUtil.new Strings();
    		return jedisStrings;
    	}
    }

## 9、service 层配置文件转 Bean ##

## TransactionManagementConfiguration.java
    
    package com.imooc.o2o.config.service;
    
    import javax.sql.DataSource;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.transaction.PlatformTransactionManager;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    import org.springframework.transaction.annotation.TransactionManagementConfigurer;
    
    /** * 对标spring-service里面的transactionManager * 继承TransactionManagementConfigurer是因为开启annotation-driven * */
    @Configuration
    // 首先使用注解 @EnableTransactionManagement 开启事务支持后
    // 在Service方法上添加注解 @Transactional 便可
    @EnableTransactionManagement
    public class TransactionManagementConfiguration implements TransactionManagementConfigurer { 
    
    	@Autowired
    	// 注入DataSourceConfiguration里边的dataSource,通过createDataSource()获取
    	private DataSource dataSource;
    
    	@Override
    	/** * 关于事务管理，需要返回PlatformTransactionManager的实现 */
    	public PlatformTransactionManager annotationDrivenTransactionManager() { 
    		return new DataSourceTransactionManager(dataSource);
    	}
    }

## 10、controller 层配置文件转 Bean ##

## MvcConfiguration.java
    
    package com.imooc.o2o.config.web;
    
    import javax.servlet.ServletException;
    
    import org.springframework.beans.BeansException;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.ApplicationContextAware;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.web.multipart.commons.CommonsMultipartResolver;
    import org.springframework.web.servlet.ViewResolver;
    import org.springframework.web.servlet.config.annotation.DefaultServletHandlerConfigurer;
    import org.springframework.web.servlet.config.annotation.EnableWebMvc;
    import org.springframework.web.servlet.config.annotation.InterceptorRegistration;
    import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
    import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
    import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
    import org.springframework.web.servlet.view.InternalResourceViewResolver;
    
    import com.google.code.kaptcha.servlet.KaptchaServlet;
    import com.imooc.o2o.interceptor.shopadmin.ShopLoginInterceptor;
    import com.imooc.o2o.interceptor.shopadmin.ShopPermissionInterceptor;
    import com.imooc.o2o.interceptor.superadmin.SuperAdminLoginInterceptor;
    
    /** * 开启Mvc,自动注入spring容器。 WebMvcConfigurerAdapter：配置视图解析器 * 当一个类实现了这个接口（ApplicationContextAware）之后，这个类就可以方便获得ApplicationContext中的所有bean * */
    @Configuration
    // 等价于<mvc:annotation-driven/>
    @EnableWebMvc
    public class MvcConfiguration implements WebMvcConfigurer, ApplicationContextAware { 
    	// Spring容器
    	private ApplicationContext applicationContext;
    
    	@Override
    	public void setApplicationContext(ApplicationContext applicationContext) throws BeansException { 
    		this.applicationContext = applicationContext;
    	}
    
    	/** * 静态资源配置 * * @param registry */
    	@Override
    	public void addResourceHandlers(ResourceHandlerRegistry registry) { 
    		// registry.addResourceHandler("/resources/**").addResourceLocations("classpath:/resources/");
    		registry.addResourceHandler("/upload/**").addResourceLocations("file:/Users/baidu/work/image/upload/");
    	}
    
    	/**
    	 * 定义默认的请求处理器
    	 */
    	@Override
    	public void configureDefaultServletHandling(DefaultServletHandlerConfigurer configurer) { 
    		configurer.enable();
    	}
    
    	/** * 创建viewResolver * * @return */
    	@Bean(name = "viewResolver")
    	public ViewResolver createViewResolver() { 
    		InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
    		// 设置Spring 容器
    		viewResolver.setApplicationContext(this.applicationContext);
    		// 取消缓存
    		viewResolver.setCache(false);
    		// 设置解析的前缀
    		viewResolver.setPrefix("/WEB-INF/html/");
    		// 设置试图解析的后缀
    		viewResolver.setSuffix(".html");
    		return viewResolver;
    	}
    
    	/** * 文件上传解析器 * * @return */
    	@Bean(name = "multipartResolver")
    	public CommonsMultipartResolver createMultipartResolver() { 
    		CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver();
    		multipartResolver.setDefaultEncoding("utf-8");
    		// 1024 * 1024 * 20 = 20M
    		multipartResolver.setMaxUploadSize(20971520);
    		multipartResolver.setMaxInMemorySize(20971520);
    		return multipartResolver;
    	}
    
    	@Value("${kaptcha.border}")
    	private String border;
    
    	@Value("${kaptcha.textproducer.font.color}")
    	private String fcolor;
    
    	@Value("${kaptcha.image.width}")
    	private String width;
    
    	@Value("${kaptcha.textproducer.char.string}")
    	private String cString;
    
    	@Value("${kaptcha.image.height}")
    	private String height;
    
    	@Value("${kaptcha.textproducer.font.size}")
    	private String fsize;
    
    	@Value("${kaptcha.noise.color}")
    	private String nColor;
    
    	@Value("${kaptcha.textproducer.char.length}")
    	private String clength;
    
    	@Value("${kaptcha.textproducer.font.names}")
    	private String fnames;
    
    	/** * 由于web.xml不生效了，需要在这里配置Kaptcha验证码Servlet */
    	@Bean
    	public ServletRegistrationBean<KaptchaServlet> servletRegistrationBean() throws ServletException { 
    		ServletRegistrationBean<KaptchaServlet> servlet = new ServletRegistrationBean<KaptchaServlet>(new KaptchaServlet(), "/Kaptcha");
    		servlet.addInitParameter("kaptcha.border", border);// 无边框
    		servlet.addInitParameter("kaptcha.textproducer.font.color", fcolor); // 字体颜色
    		servlet.addInitParameter("kaptcha.image.width", width);// 图片宽度
    		servlet.addInitParameter("kaptcha.textproducer.char.string", cString);// 使用哪些字符生成验证码
    		servlet.addInitParameter("kaptcha.image.height", height);// 图片高度
    		servlet.addInitParameter("kaptcha.textproducer.font.size", fsize);// 字体大小
    		servlet.addInitParameter("kaptcha.noise.color", nColor);// 干扰线的颜色
    		servlet.addInitParameter("kaptcha.textproducer.char.length", clength);// 字符个数
    		servlet.addInitParameter("kaptcha.textproducer.font.names", fnames);// 字体
    		return servlet;
    	}
    
    	/** * 添加拦截器配置 */
    	@Override
    	public void addInterceptors(InterceptorRegistry registry) { 
    		/** 店家管理系统拦截部分 **/
    		String interceptPath = "/shopadmin/**";
    		// 注册拦截器
    		InterceptorRegistration loginIR = registry.addInterceptor(new ShopLoginInterceptor());
    		// 配置拦截的路径
    		loginIR.addPathPatterns(interceptPath);
    		/** shopauthmanagement page **/
    		loginIR.excludePathPatterns("/shopadmin/addshopauthmap");
    		/** scan **/
    		loginIR.excludePathPatterns("/shopadmin/adduserproductmap");
    		loginIR.excludePathPatterns("/shopadmin/exchangeaward");
    		// 还可以注册其它的拦截器
    		InterceptorRegistration permissionIR = registry.addInterceptor(new ShopPermissionInterceptor());
    		// 配置拦截的路径
    		permissionIR.addPathPatterns(interceptPath);
    		// 配置不拦截的路径
    		/** shoplist page **/
    		permissionIR.excludePathPatterns("/shopadmin/shoplist");
    		permissionIR.excludePathPatterns("/shopadmin/getshoplist");
    		/** shopregister page **/
    		permissionIR.excludePathPatterns("/shopadmin/getshopinitinfo");
    		permissionIR.excludePathPatterns("/shopadmin/registershop");
    		permissionIR.excludePathPatterns("/shopadmin/shopoperation");
    		/** shopmanage page **/
    		permissionIR.excludePathPatterns("/shopadmin/shopmanagement");
    		permissionIR.excludePathPatterns("/shopadmin/getshopmanagementinfo");
    		/** shopauthmanagement page **/
    		permissionIR.excludePathPatterns("/shopadmin/addshopauthmap");
    		/** scan **/
    		permissionIR.excludePathPatterns("/shopadmin/adduserproductmap");
    		permissionIR.excludePathPatterns("/shopadmin/exchangeaward");
    		/** 超级管理员系统拦截部分 **/
    		interceptPath = "/superadmin/**";
    		// 注册拦截器
    		InterceptorRegistration superadminloginIR = registry.addInterceptor(new SuperAdminLoginInterceptor());
    		// 配置拦截的路径
    		superadminloginIR.addPathPatterns(interceptPath);
    		superadminloginIR.excludePathPatterns("/superadmin/login");
    		superadminloginIR.excludePathPatterns("/superadmin/logincheck");
    		superadminloginIR.excludePathPatterns("/superadmin/main");
    		superadminloginIR.excludePathPatterns("/superadmin/top");
    		superadminloginIR.excludePathPatterns("/superadmin/clearcache4area");
    		superadminloginIR.excludePathPatterns("/superadmin/clearcache4headline");
    		superadminloginIR.excludePathPatterns("/superadmin/clearcache4shopcategory");
    	}
    }

## 11、定时器配置文件转 Bean ##

## QuartzConfiguration.java
    
    package com.imooc.o2o.config.quartz;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.scheduling.quartz.CronTriggerFactoryBean;
    import org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean;
    import org.springframework.scheduling.quartz.SchedulerFactoryBean;
    
    import com.imooc.o2o.service.ProductSellDailyService;
    
    @Configuration
    public class QuartzConfiguration { 
    	@Autowired
    	private ProductSellDailyService productSellDailyService;
    	@Autowired
    	private MethodInvokingJobDetailFactoryBean jobDetailFactory;
    	@Autowired
    	private CronTriggerFactoryBean productSellDailyTriggerFactory;
    
    	/** * 创建jobDetailFactory并返回 * * @return */
    	@Bean(name = "jobDetailFacotry")
    	public MethodInvokingJobDetailFactoryBean createJobDetail() { 
    		// new出JobDetailFactory对象,此工厂主要用来制作一个jobDetail，即制作一个任务。
    		// 由于我们所做的定时任务根本上讲其实就是执行一个方法。所以用这个工厂比较方便。
    		MethodInvokingJobDetailFactoryBean jobDetailFactoryBean = new MethodInvokingJobDetailFactoryBean();
    		// 设置jobDetail的名字
    		jobDetailFactoryBean.setName("product_sell_daily_job");
    		// 设置jobDetail的组名
    		jobDetailFactoryBean.setGroup("job_product_sell_daily_group");
    		// 对于相同的JobDetail，当指定多个Trigger时, 很可能第一个job完成之前，第二个job就开始了。
    		// 指定concurrent设为false，多个job不会并发运行，第二个job将不会在第一个job完成之前开始。
    		jobDetailFactoryBean.setConcurrent(false);
    		// 指定运行任务的类
    		jobDetailFactoryBean.setTargetObject(productSellDailyService);
    		// 指定运行任务的方法
    		jobDetailFactoryBean.setTargetMethod("dailyCalculate");
    		return jobDetailFactoryBean;
    	}
    
    	/** * 创建cronTriggerFactory并返回 * * @return */
    	@Bean("productSellDailyTriggerFactory")
    	public CronTriggerFactoryBean createProductSellDailyTrigger() { 
    		// 创建triggerFactory实例，用来创建trigger
    		CronTriggerFactoryBean triggerFactory = new CronTriggerFactoryBean();
    		// 设置triggerFactory的名字
    		triggerFactory.setName("product_sell_daily_trigger");
    		// 设置triggerFactory的组名
    		triggerFactory.setGroup("job_product_sell_daily_group");
    		// 绑定jobDetail
    		triggerFactory.setJobDetail(jobDetailFactory.getObject());
    		// 设定cron表达式
    		triggerFactory.setCronExpression("0 0 0 * * ? *");
    		return triggerFactory;
    	}
    
    	/** * 创建调度工厂并返回 * * @return */
    	@Bean("schedulerFactory")
    	public SchedulerFactoryBean createSchedulerFactory() { 
    		SchedulerFactoryBean schedulerFactory = new SchedulerFactoryBean();
    		schedulerFactory.setTriggers(productSellDailyTriggerFactory.getObject());
    		return schedulerFactory;
    	}
    }