从零开始写项目第一篇【搭建环境】

灰太狼 2021-09-30 19:44 402阅读 0赞

# 使用Maven搭建SSM环境 #

SSM需要的基础jar包有哪些？？整理一下：

2017/10/24 16:00:31

我去的是：http://mvnrepository.com/这个网站中找jar包，**大多数使用最新的jar包**

## pom.xml文件配置 ##

**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/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <packaging>war</packaging>    <name>fuchengWeb</name>    <groupId>fuchengWeb</groupId>    <artifactId>fuchengWeb</artifactId>    <version>1.0-SNAPSHOT</version>        <build>        <finalName>zhongfucheng</finalName>        <plugins>            <plugin>                <groupId>org.mybatis.generator</groupId>                <artifactId>mybatis-generator-maven-plugin</artifactId>                <version>1.3.2</version>                <configuration>                    <verbose>true</verbose>                    <overwrite>true</overwrite>                </configuration>            </plugin>        </plugins>    </build>    <dependencies>                <dependency>            <groupId>c3p0</groupId>            <artifactId>c3p0</artifactId>            <version>0.9.1.2</version>        </dependency>                <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-core-asl</artifactId>            <version>1.9.13</version>        </dependency>        <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-mapper-asl</artifactId>            <version>1.9.13</version>        </dependency>                <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis-spring</artifactId>            <version>1.3.1</version>        </dependency>                <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.34</version>        </dependency>                <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-aop</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.aspectj</groupId>            <artifactId>aspectjweaver</artifactId>            <version>1.8.11</version>        </dependency>        <dependency>            <groupId>org.aopalliance</groupId>            <artifactId>com.springsource.org.aopalliance</artifactId>            <version>1.0.0</version>        </dependency>        <dependency>            <groupId>net.sourceforge.cglib</groupId>            <artifactId>com.springsource.net.sf.cglib</artifactId>            <version>2.1.3</version>        </dependency>                <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.apache.commons</groupId>            <artifactId>com.springsource.org.apache.commons.logging</artifactId>            <version>1.1.1</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-beans</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-expression</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>3.2.2.RELEASE</version>            <scope>test</scope>        </dependency>                <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-orm</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-jdbc</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>org.springframework.transaction</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>                <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-web</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-webmvc</artifactId>            <version>3.2.2.RELEASE</version>        </dependency>                <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.4.5</version>        </dependency>        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-log4j12</artifactId>            <version>1.7.25</version>            <scope>test</scope>        </dependency>        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-api</artifactId>            <version>1.7.25</version>        </dependency>        <dependency>            <groupId>log4j</groupId>            <artifactId>log4j</artifactId>            <version>1.2.17</version>        </dependency>        <dependency>            <groupId>org.javassist</groupId>            <artifactId>javassist</artifactId>            <version>3.22.0-CR2</version>        </dependency>        <dependency>            <groupId>cglib</groupId>            <artifactId>cglib</artifactId>            <version>3.2.5</version>        </dependency>        <dependency>            <groupId>org.objectweb.asm</groupId>            <artifactId>com.springsource.org.objectweb.asm</artifactId>            <version>2.2.3</version>        </dependency>    </dependencies></project>
    <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/maven-v4_0_0.xsd">
    
        <modelVersion>4.0.0</modelVersion>
        <packaging>war</packaging>
    
        <name>fuchengWeb</name>
        <groupId>fuchengWeb</groupId>
        <artifactId>fuchengWeb</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        
        <build>
            <finalName>zhongfucheng</finalName>
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                </plugin>
            </plugins>
        </build>
        <dependencies>
    
    
            
            <dependency>
                <groupId>c3p0</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.codehaus.jackson</groupId>
                <artifactId>jackson-core-asl</artifactId>
                <version>1.9.13</version>
            </dependency>
    
            <dependency>
                <groupId>org.codehaus.jackson</groupId>
                <artifactId>jackson-mapper-asl</artifactId>
                <version>1.9.13</version>
            </dependency>
    
    
            
    
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.3.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.34</version>
            </dependency>
    
            
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.11</version>
            </dependency>
    
            <dependency>
                <groupId>org.aopalliance</groupId>
                <artifactId>com.springsource.org.aopalliance</artifactId>
                <version>1.0.0</version>
            </dependency>
    
            <dependency>
                <groupId>net.sourceforge.cglib</groupId>
                <artifactId>com.springsource.net.sf.cglib</artifactId>
                <version>2.1.3</version>
            </dependency>
    
            
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>com.springsource.org.apache.commons.logging</artifactId>
                <version>1.1.1</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-expression</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>3.2.2.RELEASE</version>
                <scope>test</scope>
            </dependency>
    
    
            
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>org.springframework.transaction</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>3.2.2.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.5</version>
            </dependency>
    
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>1.7.25</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.25</version>
            </dependency>
    
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
    
            <dependency>
                <groupId>org.javassist</groupId>
                <artifactId>javassist</artifactId>
                <version>3.22.0-CR2</version>
            </dependency>
    
            <dependency>
                <groupId>cglib</groupId>
                <artifactId>cglib</artifactId>
                <version>3.2.5</version>
            </dependency>
    
            <dependency>
                <groupId>org.objectweb.asm</groupId>
                <artifactId>com.springsource.org.objectweb.asm</artifactId>
                <version>2.2.3</version>
            </dependency>
        </dependencies>
    
    
    </project>

如果觉得下载太慢的话，我们可以使用阿里云的私服。只要在settings下配置如下代码即可：

<mirror>        <id>nexus-aliyun</id>        <mirrorOf>*</mirrorOf>        <name>Nexus aliyun</name>        <url>http://maven.aliyun.com/nexus/content/groups/public</url>    </mirror>
            <id>nexus-aliyun</id>
            <mirrorOf>*</mirrorOf>
            <name>Nexus aliyun</name>
            <url>http://maven.aliyun.com/nexus/content/groups/public</url>
        </mirror>

## 创建mysql用户和数据库 ##

mysql用户：

数据库：

## mybatis配置文件 ##

**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>        <typeAliases>        <package name="zhongfucheng.entity"/>    </typeAliases></configuration>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        <typeAliases>
            <package name="zhongfucheng.entity"/>
        </typeAliases>
    </configuration>

## application-context配置文件 ##

<?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:tx="http://www.springframework.org/schema/tx"       xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:context="http://www.springframework.org/schema/context"       xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-3.2.xsd    http://www.springframework.org/schema/tx    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">        <property name="driverClass" value="com.mysql.jdbc.Driver"/>        <property name="jdbcUrl"                  value="jdbc:mysql://localhost:3306/xxxx?useUnicode=true&characterEncoding=UTF-8"/>        <property name="user" value="xxxx"/>        <property name="password" value="xxxx"/>    </bean>        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="configLocation" value="classpath:myBatis-config.xml"/>                <property name="mapperLocations" value="classpath:mapper/*.xml"/>    </bean>        <bean id="transactionManager"          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean>        <tx:advice id="advice" transaction-manager="transactionManager">        <tx:attributes>                        <tx:method name="insert*" propagation="REQUIRED"                       rollback-for="Exception"/>            <tx:method name="update*" propagation="REQUIRED"                       rollback-for="Exception"/>            <tx:method name="delete*" propagation="REQUIRED"                       rollback-for="Exception"/>            <tx:method name="*" propagation="SUPPORTS"/>        </tx:attributes>    </tx:advice>        <aop:config>        <aop:advisor advice-ref="advice"                     pointcut="execution(* zhongfucheng.service.impl.*.*(..))"/>    </aop:config>        <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>    </bean>        <context:component-scan base-package="zhongfucheng">        <context:exclude-filter type="annotation"                                expression="org.springframework.stereotype.Controller"/>    </context:component-scan>        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />        <property name="basePackage" value="zhongfucheng.dao" />    </bean></beans>
    <beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"       xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:context="http://www.springframework.org/schema/context"       xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-3.2.xsd    http://www.springframework.org/schema/tx    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">
    
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="com.mysql.jdbc.Driver"/>
            <property name="jdbcUrl"                  value="jdbc:mysql://localhost:3306/xxxx?useUnicode=true&characterEncoding=UTF-8"/>
            <property name="user" value="xxxx"/>
            <property name="password" value="xxxx"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            <property name="configLocation" value="classpath:myBatis-config.xml"/>
            
            <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    
        </bean>
    
        
        <bean id="transactionManager"          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:advice id="advice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="insert*" propagation="REQUIRED"                       rollback-for="Exception"/>
                <tx:method name="update*" propagation="REQUIRED"                       rollback-for="Exception"/>
                <tx:method name="delete*" propagation="REQUIRED"                       rollback-for="Exception"/>
                <tx:method name="*" propagation="SUPPORTS"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:advisor advice-ref="advice"                     pointcut="execution(* zhongfucheng.service.impl.*.*(..))"/>
        </aop:config>
    
        
        <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>
    
        
        <context:component-scan base-package="zhongfucheng">
            <context:exclude-filter type="annotation"                                expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
            <property name="basePackage" value="zhongfucheng.dao" />
        </bean>
    </beans>

## 配置spring-mvc ##

**spring-mvc.xml**

## 逆向生成的配置文件 ##

**generatorConfig.xml**

<?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>        <classPathEntry            location="X:\Users\ozc\Desktop\zhongfuchengWeb\mysql\mysql-connector-java\5.1.34\mysql-connector-java-5.1.34.jar"/>        <context id="context1">        <commentGenerator>                        <property name="suppressAllComments" value="true"/>                        <property name="suppressDate" value="true"/>        </commentGenerator>        <jdbcConnection driverClass="com.mysql.jdbc.Driver"                        connectionURL="jdbc:mysql://localhost:3306/zhongfucheng" userId="zhongfucheng"                        password="zhong"/>                <javaModelGenerator targetPackage="zhongfucheng.entity" targetProject="src/main/java"/>                <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>                <javaClientGenerator type="XMLMAPPER" targetPackage="zhongfucheng.dao" targetProject="src/main/java"/>                <table schema="" tableName="EB_ORDER_DETAIL" enableCountByExample="false"               enableUpdateByExample="false" enableDeleteByExample="false"               enableSelectByExample="false" selectByExampleQueryId="false"        >        </table>    </context></generatorConfiguration>
    <!DOCTYPE generatorConfiguration PUBLIC        "-//mybatis.org//DTD MyBatis Generator Configuration        1.0//EN"        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"        >
    <generatorConfiguration>
        
        <classPathEntry            location="X:\Users\ozc\Desktop\zhongfuchengWeb\mysql\mysql-connector-java\5.1.34\mysql-connector-java-5.1.34.jar"/>
        
        <context id="context1">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
                
                <property name="suppressDate" value="true"/>
            </commentGenerator>
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"                        connectionURL="jdbc:mysql://localhost:3306/zhongfucheng" userId="zhongfucheng"                        password="zhong"/>
            
            <javaModelGenerator targetPackage="zhongfucheng.entity" targetProject="src/main/java"/>
            
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="zhongfucheng.dao" targetProject="src/main/java"/>
    
            
            <table schema="" tableName="EB_ORDER_DETAIL" enableCountByExample="false"               enableUpdateByExample="false" enableDeleteByExample="false"               enableSelectByExample="false" selectByExampleQueryId="false"        >
            </table>
        </context>
    </generatorConfiguration>

## web.xml配置 ##

**web.xml**

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.4"         xmlns="http://java.sun.com/xml/ns/j2ee"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">        <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:applicatoin-context.xml</param-value>    </context-param>        <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:spring-mvc.xml</param-value>        </init-param>    </servlet>    <servlet-mapping>        <servlet-name>springmvc</servlet-name>        <url-pattern>*.do</url-pattern>    </servlet-mapping>        <filter>        <filter-name>SpringCharacterEncodingFilter</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>SpringCharacterEncodingFilter</filter-name>        <url-pattern>*.do</url-pattern>    </filter-mapping></web-app>
    <web-app version="2.4"         xmlns="http://java.sun.com/xml/ns/j2ee"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    
    
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:applicatoin-context.xml</param-value>
        </context-param>
    
        
        <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:spring-mvc.xml</param-value>
            </init-param>
        </servlet>
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>*.do</url-pattern>
        </servlet-mapping>
    
        
        <filter>
            <filter-name>SpringCharacterEncodingFilter</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>SpringCharacterEncodingFilter</filter-name>
            <url-pattern>*.do</url-pattern>
        </filter-mapping>
    </web-app>

## log4j配置文件 ##

**log4j.properties**

# Rules reminder:# DEBUG < INFO < WARN < ERROR < FATAL# Global logging configurationlog4j.rootLogger=debug,stdout# My logging configuration...log4j.logger.cn.jbit.mybatisdemo=DEBUG## Console output...log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%nlog4j.logger.org.apache.ibatis=DEBUG## log4j.logger.org.apache.jdbc.SimpleDataSource=DEBUGlog4j.logger.org.apache.ibatis.jdbc.ScriptRunner=DEBUG## log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapclientDelegate=DEBUGlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG
    
    # Global logging configuration
    log4j.rootLogger=debug,stdout
    
    # My logging configuration...
    log4j.logger.cn.jbit.mybatisdemo=DEBUG
    
    
    ## Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%n
    
    log4j.logger.org.apache.ibatis=DEBUG
    ## log4j.logger.org.apache.jdbc.SimpleDataSource=DEBUG
    log4j.logger.org.apache.ibatis.jdbc.ScriptRunner=DEBUG
    ## log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapclientDelegate=DEBUG
    log4j.logger.java.sql.Connection=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

## 测试逆向工程 ##

不知道是不是我的mysql驱动包太高了，出现了如下的问题：

The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone.'�й���׼ʱ��' is unrecognized or represents more than one time zone.

于是乎我就去找到了解决方案，只要在url后面加上时区就好了：

jdbc:mysql://localhost:3306/zhongfucheng?serverTimezone=UTC

随后又出现了下面的问题：

Column name pattern can not be NULL or empty

找到的解决方案，又是往后面加参数：

jdbc:mysql://localhost:3306/zhongfucheng?serverTimezone=UTC&useSSL=false&nullNamePatternMatchesAll=true

最终就成功了…

![640?wx\_fmt=png][640_wx_fmt_png]

…还有问题:在刚开始的时候没注意到:**Mybatis Generator 生成的mapper只有insert方法**

链接:**http://blog.csdn.net/qq\_15127715/article/details/78139228**

又去查了一大堆的资料，发现还是因为mysql的驱动包太高的问题。只能往下转了。

**Failed to read candidate component class错误分析:**

**spring 3.2不支持1.8编译环境，解决办法就是降为1.7编译环境**

解决连接:**http://www.cnblogs.com/cxj20160928/p/5954336.html**

# 编写BaseMapper #

/** * 将通用的方法抽取在BaseMapper中，那么就不用在每个单独的Mapper都要写对应的方法了。 * @param <T> */public interface BaseMapper<T> {    int insert(T entity);    int insertSelective(T entity);    int deleteByPrimaryKey(String id);    T selectByPrimaryKey(String id);    int updateByPrimaryKeySelective(T entity);    int updateByPrimaryKey(T entity);}
    public interface BaseMapper<T> {
        
    
        int insert(T entity);
    
        int insertSelective(T entity);
    
        int deleteByPrimaryKey(String id);
    
        T selectByPrimaryKey(String id);
    
        int updateByPrimaryKeySelective(T entity);
    
        int updateByPrimaryKey(T entity);
    
    }

# 编写BaseService #

/** * 将通用的业务方法抽取到BaseService中，那么实现它的Service都有这些方法了。 * @param <T> */public interface BaseService<T> {    int insert(T entity);    int insertSelective(T entity);    int deleteByPrimaryKey(String id);    T selectByPrimaryKey(String id);    int updateByPrimaryKeySelective(T entity);    int updateByPrimaryKey(T entity);}
    public interface BaseService<T> {
        
    
        int insert(T entity);
    
        int insertSelective(T entity);
    
        int deleteByPrimaryKey(String id);
    
        T selectByPrimaryKey(String id);
    
        int updateByPrimaryKeySelective(T entity);
    
        int updateByPrimaryKey(T entity);
    }

## BaseServiceImpl ##

/** * 使用initBaseMapper()将baseMapper实例化，service实现类是什么类型，baseMapper就是什么类型 * 将所有的Mapper都定义出来，那么子类service就可以直接使用了 * @param <T> */public class BaseServiceImpl<T> implements BaseService<T> {    protected BaseMapper<T> baseMapper;    @Autowired    protected StoreHouseMapper storeHouseMapper;    @PostConstruct    private void initBaseMapper() throws Exception{        //获取泛型的信息        ParameterizedType type =(ParameterizedType) this.getClass().getGenericSuperclass();        Class clazz = (Class)type.getActualTypeArguments()[0];        //拼接成“泛型”Mapper字符串        String localField = clazz.getSimpleName().substring(0,1).toLowerCase()+clazz.getSimpleName().substring(1)+"Mapper";        //通过反射来获取成员变量的值        Field field=this.getClass().getSuperclass().getDeclaredField(localField);        Field baseField = this.getClass().getSuperclass().getDeclaredField("baseMapper");        //将baseDao来进行实例化        baseField.set(this, field.get(this));        System.out.println("------this:" + this);        System.out.println("------baseMapper:" + baseMapper);    }    public int insert(T entity) {        return baseMapper.insert(entity);    }    public int insertSelective(T entity) {        return baseMapper.insertSelective(entity);    }    public int deleteByPrimaryKey(String id) {        return baseMapper.deleteByPrimaryKey(id);    }    public T selectByPrimaryKey(String id) {        return baseMapper.selectByPrimaryKey(id);    }    public int updateByPrimaryKeySelective(T entity) {        return baseMapper.updateByPrimaryKeySelective(entity);    }    public int updateByPrimaryKey(T entity) {        return baseMapper.updateByPrimaryKey(entity);    }}
    public class BaseServiceImpl<T> implements BaseService<T> {
        
    
        protected BaseMapper<T> baseMapper;
    
        @Autowired
        protected StoreHouseMapper storeHouseMapper;
    
        @PostConstruct
        private void initBaseMapper() throws Exception{
        
    
            //获取泛型的信息
            ParameterizedType type =(ParameterizedType) this.getClass().getGenericSuperclass();
            Class clazz = (Class)type.getActualTypeArguments()[0];
    
            //拼接成“泛型”Mapper字符串
            String localField = clazz.getSimpleName().substring(0,1).toLowerCase()+clazz.getSimpleName().substring(1)+"Mapper";
    
            //通过反射来获取成员变量的值
            Field field=this.getClass().getSuperclass().getDeclaredField(localField);
            Field baseField = this.getClass().getSuperclass().getDeclaredField("baseMapper");
    
            //将baseDao来进行实例化
            baseField.set(this, field.get(this));
    
            System.out.println("------this:" + this);
            System.out.println("------baseMapper:" + baseMapper);
        }
    
        public int insert(T entity) {
        
            return baseMapper.insert(entity);
        }
    
        public int insertSelective(T entity) {
        
            return baseMapper.insertSelective(entity);
        }
    
        public int deleteByPrimaryKey(String id) {
        
            return baseMapper.deleteByPrimaryKey(id);
        }
    
        public T selectByPrimaryKey(String id) {
        
            return baseMapper.selectByPrimaryKey(id);
        }
    
        public int updateByPrimaryKeySelective(T entity) {
        
            return baseMapper.updateByPrimaryKeySelective(entity);
        }
    
        public int updateByPrimaryKey(T entity) {
        
            return baseMapper.updateByPrimaryKey(entity);
        }
    
    }

# 测试Spring和Mybatis是否整合完成 #

@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations={"/application-context.xml"})public class TestSpringAndMybatis {    @Autowired    private StoreHouseService hoseService;    @Test    public void add() {        StoreHouse storeHouse = hoseService.selectByPrimaryKey("1");        System.out.println(storeHouse);    }}
    @ContextConfiguration(locations={
        "/application-context.xml"})
    public class TestSpringAndMybatis {
        
    
        @Autowired
        private StoreHouseService hoseService;
    
        @Test
        public void add() {
        
            StoreHouse storeHouse = hoseService.selectByPrimaryKey("1");
            System.out.println(storeHouse);
    
        }
    
    
    }

![640?wx\_fmt=png][640_wx_fmt_png 1]

# 编写BaseAction #

/** * 将所有的service实现都定义出来，controller子类使用的使用就不需要定义了。 */public class BaseController {    @Autowired    protected StoreHouseService storeHoseService;}
    public class BaseController {
        
        @Autowired
        protected StoreHouseService storeHoseService;
    
    }

## StoreHouseController ##

@Controller@RequestMapping("/store")public class StoreHouseController extends BaseController {    @RequestMapping("/getById.do")    public void getById(String id ) {        StoreHouse storeHouse = storeHoseService.selectByPrimaryKey(id);        System.out.println(storeHouse);    }}
    @RequestMapping("/store")
    public class StoreHouseController extends BaseController {
        
    
        @RequestMapping("/getById.do")
        public void getById(String id ) {
        
            StoreHouse storeHouse = storeHoseService.selectByPrimaryKey(id);
            System.out.println(storeHouse);
        }
    }

## 测试spring-mvc ##

在测试的时候出现了： `org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)`的异常。

上网上查看之后，\*\*\*\*。因此我就将StoreHouseMapper.xml放到resouces下了。

同时，我们的application-context.xml加载配置文件和generator.xml逆向配置文件的位置也要修改。

![640?wx\_fmt=png][640_wx_fmt_png 2]  
说要把生成出来的mapper.xml放在resouces目录下才能识别出来

<property name="mapperLocations" value="classpath:mapper/*.xml"/>
            <property name="mapperLocations" value="classpath:mapper/*.xml"/>

<sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>

## 测试JSON ##

测试代码：

@RequestMapping("/getById.do")    @ResponseBody    public Object getById(String id ) {        StoreHouse storeHouse = storeHoseService.selectByPrimaryKey(id);        System.out.println(storeHouse);        return storeHouse;    }"/getById.do")
        @ResponseBody
        public Object getById(String id ) {
        
            StoreHouse storeHouse = storeHoseService.selectByPrimaryKey(id);
            System.out.println(storeHouse);
    
            return storeHouse;
    
        }

![640?wx\_fmt=png][640_wx_fmt_png 3]

# 开发环境总结 #

到目前为止、SSM已整合完成。

创建web常用的目录结构。

![640?wx\_fmt=png][640_wx_fmt_png 4]

## 花了一个晚上总结出:不能太装逼去玩新的jar包、资料太少了，非常容易出错! ##

想用新版本的jar包遇到了很多的麻烦

> 如果文章有错的地方欢迎指正，大家互相交流。习惯在微信看技术文章，想要获取更多的Java资源的同学，可以**关注微信公众号:Java3y**

[640_wx_fmt_png]: /images/20210827/a62a6e515c3a49ed94800b67c489ba71.png?wx_fmt=png
[640_wx_fmt_png 1]: /images/20210827/fc3aead20d924b2bb586703ceb330d17.png?wx_fmt=png
[640_wx_fmt_png 2]: /images/20210827/848622626cea4f6c9b80bd0ec9090934.png?wx_fmt=png
[640_wx_fmt_png 3]: /images/20210827/8f7cb31dc3df430594aceb0517bea84b.png?wx_fmt=png
[640_wx_fmt_png 4]: /images/20210827/4159e14fcb32402699e6b5d794342ea6.png?wx_fmt=png