SSM整合

SSM整合

1. ssm文件的配置

   • 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"
            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"
                                >
     ​
           <!--组件扫描-->
           <context:component-scan base-package="com.itheima.controller"></context:component-scan>
     ​
         <!--视图解析器-->
         <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
             <property name="prefix" value="/WEB-INF/pages/"></property>
             <property name="suffix" value=".jsp"></property>
         </bean>
         <!--开放资源-->
         <mvc:default-servlet-handler></mvc:default-servlet-handler>
     ​
         <!--用来解决   @ResponseBody()注解乱码问题-->
         <mvc:annotation-driven>
             <mvc:message-converters>
                 <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                     <property name="supportedMediaTypes" value="text/html;charset=utf-8"></property>
                 </bean>
             </mvc:message-converters>
         </mvc:annotation-driven>
         <!--mvc的注解驱动 这样以来上面的配置处理器映射适配器就不用写了-->
         <mvc:annotation-driven />
     </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"
            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">
     ​
     ​
              <!--组件扫描-->
           <context:component-scan base-package="com.itheima">
               <!--不扫-->
               <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
           </context:component-scan>
     ​
     ​
     </beans>

   • jdbc.properties文件

     jdbc.driver=com.mysql.jdbc.Driver
     jdbc.url=jdbc:mysql://localhost:3306/account
     jdbc.username=root
     jdbc.password=xjj168

   • 日志文件

     ### direct log messages to stdout ###
     log4j.appender.stdout=org.apache.log4j.ConsoleAppender
     log4j.appender.stdout.Target=System.out
     log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
     log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
     ​
     ### direct messages to file mylog.log ###
     log4j.appender.file=org.apache.log4j.FileAppender
     log4j.appender.file.File=c:/mylog.log
     log4j.appender.file.layout=org.apache.log4j.PatternLayout
     log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
     ​
     ### set log levels - for more verbose logging change 'info' to 'debug' ###
     ​
     log4j.rootLogger=debug, stdout

   • sqlMapConfig.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>
     ​
         <!--通过properties标签加载外部properties文件-->
         <properties resource="jdbc.properties"></properties>
     ​
         <!--自定义别名-->
         <typeAliases>
             <package name="com.itheima.domain"/>
         </typeAliases>
     ​
         <!--配置分页助手插件-->
         <!--  <plugins>
               <plugin interceptor="com.github.pagehelper.PageHelper">
                   <property name="dialect" value="mysql"></property>
               </plugin>
           </plugins>-->
         <!--配置分页助手插件-->
         <plugins>
             <plugin interceptor="com.github.pagehelper.PageHelper">
                 <property name="dialect" value="mysql"/>
             </plugin>
     ​
         </plugins>
     ​
         <!--数据源环境-->
         <environments default="development">
             <environment id="development">
                 <transactionManager type="JDBC"></transactionManager>
                 <dataSource type="POOLED">
                     <property name="driver" value="${jdbc.driver}"/>
                     <property name="url" value="${jdbc.url}"/>
                     <property name="username" value="${jdbc.username}"/>
                     <property name="password" value="${jdbc.password}"/>
                 </dataSource>
             </environment>
         </environments>
     ​
         <!--加载映射文件-->
         <mappers>
            <!-- <mapper resource="com/itheima/mapper/AccountMapper.xml"></mapper>-->
             <package name="com/itheima/mapper"/>
         </mappers>
         
     </configuration>

   • Mapper.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.itheima.mapper.AccountMapper">
         <select id="findAllAccount" resultType="account" >
             select * from account
         </select>
     ​
         <insert id="save" parameterType="account">
             insert into account(name,money)values(#{name},#{money});
         </insert>
     ​
     </mapper>