• SSM+shiro,所有配置文件,详细注释版,自用


    spring配置文件applicationContext.xml,放在resources下

    <?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:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/tx
           http://www.springframework.org/schema/tx/spring-tx.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">
    
        <!--Spring配置文件的核心点( 1、数据源    2、与mybatis的整合   3、事务控制 )-->
    
        <!--业务逻辑组件扫描进来-->
        <context:component-scan base-package="club.iashe">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        <!--==================================================================================================================-->
        <!--数据源的配置-->
        <!--引入外部的配置文件-->
        <context:property-placeholder ignore-unresolvable="true" location="classpath:dbconfig.properties"/>
    
        <!-- 数据库连接池c3p0配置数据源 -->
        <bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="jdbcUrl" value="${jdbc.jdbcUrl}"/>
            <property name="driverClass" value="${jdbc.driverClass}"/>
            <property name="user" value="${jdbc.user}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        <!--==================================================================================================================-->
        <!--配置和mybatis整合-->
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!--指定mybatis全局配置文件的位置-->
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            <!--指定数据源-->
            <property name="dataSource" ref="pooledDataSource"/>
            <!--指定mybatis映射文件的位置-->
            <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"/>
        </bean>
    
        <!--配置扫描器,将mybatis接口的实现,即DAO接口所在包名,加入到IOC容器中-->
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <!--扫描所有dao接口的实现,加入到IOC容器中-->
            <property name="basePackage" value="club.iashe.dao"/>
        </bean>
    
        <!--配置一个可以执行批量的sqlSession-->
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" >
            <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
            <!--<constructor-arg name="executorType" value="BATCH" />-->
        </bean>
    
        <!--==================================================================================================================-->
        <!-- 事务控制的配置,spring声明式事务 -->
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <!--控制住数据源-->
            <property name="dataSource" ref="pooledDataSource"/>
        </bean>
    
        <!--开启基于注解的事务/使用xml配置形式的事务(一般比较重要的都使用xml形式)-->
        <aop:config>
            <!--切入点表达式-->
            <aop:pointcut expression="execution(* club.iashe.service..*(..))" id="txPoint"/>
            <!--<aop:pointcut id="txPoint" expression="execution(* cn.crud.service..*(..))"/>-->
            <!--配置事务增强-->
            <aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
        </aop:config>
    
        <!--配置事务增强,也就是事务如何切入-->
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <!--代表这个切入点的所有方法都是事务方法-->
                <tx:method name="*"/>
                <!--以get开始的所有方法,进行调优-->
                <tx:method name="get*" read-only="true"/>
            </tx:attributes>
        </tx:advice>
        <!--==================================================================================================================-->
    </beans>

    springMVC配置文件,dispatcherServlet-servlet.xml,放在WEB-INF下

    <?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"
           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.xsd
           http://www.springframework.org/schema/mvc
           http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    
        <!--两个标准配置-->
        <!--将springMVC不能处理的请求交给tomcat-->
        <mvc:default-servlet-handler />
        <!--能支持springMVC一些更高级的功能,注释替代XML配置,jrs303校验,快捷的ajax,映射动态请求-->
        <!--<mvc:annotation-driven />-->
        <!-- 使用fastjson替换springMVC默认的Jackson -->
        <mvc:annotation-driven>
            <mvc:message-converters register-defaults="true">
                <!-- 配置fastjson支持 -->
                <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
                    <property name="defaultCharset" value="UTF-8" />
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/html;charset=UTF-8</value>
                            <value>application/json</value>
                        </list>
                    </property>
                </bean>
            </mvc:message-converters>
        </mvc:annotation-driven>
    
        <!--
            springMVC的配置文件,包含网站跳转逻辑的控制、配置
            注释改掉默认扫描所有use-default-filters,设为false
        -->
        <context:component-scan base-package="club.iashe" use-default-filters="false">
            <!--只扫描控制器-->
            <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" />
        </context:component-scan>
    
        <!-- 配置视图解析器,方便页面返回信息 -->
             <!-- 配置 HTML 视图解析器 -->
                 <!-- html视图解析器,必须先配置freemarkerConfig,html没有prefix属性 -->
        <!--<bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer">
            <property name="resourceLoader">
                <value>/html/</value>
            </property>
        </bean>
        <bean id="htmlViewResolver" class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver">
            <property name="suffix" value="html" />
            <property name="order" value="0"/>
            <property name="contentType" value="text/html;charset=UTF-8" />
        </bean>-->
            <!-- 配置 jsp 视图解析器 -->
        <bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <!--<property name="prefix" value="WEB-INF/views/" />       &lt;!&ndash;前缀&ndash;&gt;-->
            <property name="prefix" value="WEB-INF/admin/views/" />       <!--前缀-->
            <property name="suffix" value=".jsp" />                 <!--后缀-->
        </bean>
    
    
    </beans>

    mybatis配置文件,mybatis-config.xml,resources下

    <?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>
            <!-- Globally enables or disables any caches configured in any mapper under this configuration -->
            <setting name="cacheEnabled" value="false"/>
            <!-- Sets the number of seconds the driver will wait for a response from the database -->
            <setting name="defaultStatementTimeout" value="5"/>
            <!-- Enables automatic mapping from classic database column names A_COLUMN to camel case classic Java property names aColumn -->
            <!-- 数据库下划线转为驼峰 -->
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            <!-- Allows JDBC support for generated keys. A compatible driver is required.
            This setting forces generated keys to be used if set to true,
             as some drivers deny compatibility but still work -->
            <setting name="useGeneratedKeys" value="true"/>
        </settings>
    
        <!-- Continue editing here -->
        <!--起别名-->
        <typeAliases>
            <package name="club.iashe.pojo" />
        </typeAliases>
    
        <!--配置PageHelper插件-->
        <plugins>
            <!-- com.github.pagehelper为PageHelper类所在包名 -->
            <plugin interceptor="com.github.pagehelper.PageInterceptor">
                <!-- 使用下面的方式配置参数,后面会有所有的参数介绍 -->
                <!--<property name="param1" value="value1"/>-->
                <!-- 分页参数合理化 -->
                <property name="reasonable" value="true" />
            </plugin>
        </plugins>
    
    </configuration>

    mybatis-generator-config配置文件

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    
        <!-- 引入配置文件 -->
        <properties resource="dbconfig.properties" />
    
        <context id="DB2Tables" targetRuntime="MyBatis3">
    
            <!--配置生成的增删改查方法不要注释-->
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    
            <!--配置数据库链接信息-->
            <jdbcConnection driverClass="${jdbc.driverClass}"
                            connectionURL="${jdbc.jdbcUrl}"
                            userId="${jdbc.user}"
                            password="${jdbc.password}">
            </jdbcConnection>
    
            <javaTypeResolver >
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            <!--java模型生成,指定JavaBean生成的位置-->
            <javaModelGenerator targetPackage="club.iashe.pojo"
                                targetProject=".srcmainjava">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            <!--指定sql映射文件的位置-->
            <sqlMapGenerator targetPackage="mapper"
                             targetProject=".srcmain
    esources">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            <!--指定DAO接口生成的位置-->
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="club.iashe.dao"
                                 targetProject=".srcmainjava">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            <!--指定每个表的生成策略-->
            <!--<table tableName="resident_tag" domainObjectName="ResidentTag" />-->
            <table tableName="resident_info" domainObjectName="ResidentInfo" />
    
        </context>
    </generatorConfiguration>

    数据库配置文件dbconfig.properties

    jdbc.jdbcUrl=jdbc:mysql://localhost:3306/community?serverTimezone=UTC&zeroDateTimeBehavior=round
    jdbc.driverClass=com.mysql.cj.jdbc.Driver
    jdbc.user=root
    jdbc.password=

    最后,web.xml的配置

    <?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
             version="3.1">
    
        <!-- web.xml文件的配置 -->
    
        <!-- 1.启动spring容器 -->
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <!-- spring配置文件路径 -->
            <param-value>classpath:applicationContext.xml</param-value>
        </context-param>
        <!-- spring监听器 -->
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    
        <!-- 2、springMVC的前端控制器,拦截所有请求 -->
        <servlet>
            <!-- 配置springMVC的dispatcherServlet分发请求,实际上它是一个前端控制器 -->
            <servlet-name>dispatcherServlet</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcherServlet</servlet-name>
            <!--拦截所有页面请求-->
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        <!--3、字符编码过滤器,第一位的过滤器-->
        <filter>
            <filter-name>CharacterEncodingFilter</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>
            <init-param>
                <param-name>forceRequestEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
            <init-param>
                <param-name>forceResponseEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>CharacterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
        <!-- 4、使用rest风格的URI,将页面普通的post请求转为指定的delete或者put请求 -->
        <filter>
            <!-- hiddenHttpMethodFilter 可以把把post请求转船成 put delete -->
            <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>
    </web-app>
  • 相关阅读:
    如何在SAP中找表
    SQL SARG
    计算两个时间相差多少年月日的sql算法
    给WordPress添加微博功能
    sqlServer,oracle中case关键字的用法
    SSIS错误之"The Excel Connection Manager is not supported in the 64bit version of SSIS"
    Oracle编程艺术之设置环境
    Quest.Central.For.Databases.v6.1下载地址
    Oracle Database 11g SQL开发指南store模式脚本
    SQL中连接的种类和区别
  • 原文地址:https://www.cnblogs.com/ihaokun/p/9987074.html
Copyright © 2020-2023  润新知