快速搭建一个SSM项目

最新推荐文章于 2022-09-21 09:23:40 发布

小黑不高兴

最新推荐文章于 2022-09-21 09:23:40 发布

阅读量199

点赞数

分类专栏： SSM整合CRUD小项目文章标签： ssm spring springmvc mybatis java

本文链接：https://blog.csdn.net/weixin_46242593/article/details/115840222

版权

SSM整合CRUD小项目专栏收录该内容

2 篇文章 0 订阅

订阅专栏

一、加入依赖

spring，springmvc，mybatis，mybatis-spring，事务，jdbc，druid（数据源），servlet，jsp

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <!--<scope>test</scope>-->
    </dependency>

    <!--spring-->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.3.4</version>
    </dependency>

    <!-- Spring事务 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>5.3.4</version>
    </dependency>

    <!-- Spring JDBC包 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.4</version>
    </dependency>

    <!-- SpringMVC包 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.3.4</version>
    </dependency>

    <!--mybatis-->
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>

    <!--mybatis-spring-->
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.6</version>
    </dependency>

    <!--druid-->
    <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.2.5</version>
    </dependency>

    <!--servlet-->
    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
      <scope>provided</scope>
    </dependency>

    <!--jsp-->
    <!-- https://mvnrepository.com/artifact/javax.servlet/jsp-api -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.0</version>
      <scope>provided</scope>
    </dependency>

    <!--MBG：mybatis-generator 用于逆向工程-->
    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>1.4.0</version>
      <scope>compile</scope>
    </dependency>
    <dependency>
      <groupId>org.junit.jupiter</groupId>
      <artifactId>junit-jupiter</artifactId>
      <version>RELEASE</version>
      <scope>compile</scope>
    </dependency>
    <dependency>
      <groupId>org.testng</groupId>
      <artifactId>testng</artifactId>
      <version>RELEASE</version>
      <scope>compile</scope>
    </dependency>

    <!-- spring整合junit工具包 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.3.4</version>
      <!-- <scope>test</scope> -->
    </dependency>

    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.23</version>
    </dependency>
  </dependencies>

插件：在maven中添加 >mybatis-generator

<build>
    <plugins>
      <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.4.0</version>
      </plugin>
    </plugins>
  </build>

在这里插入图片描述

需要注意的是：版本要一致，不然可能导致冲突

二、创建基本的包

在这里插入图片描述

三、配置文件

1、spring 配置文件

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"
       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/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!--spring 配置文件-->
    <!--1、引入数据库配置信息-->
    <context:property-placeholder location="classpath:jdbc.properties" />

    <!--2、配置数据源-->
    <bean id="MyDataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="maxActive" value="${jdbc.max}" />
    </bean>

    <!--3、配置扫描器-->
    <context:component-scan base-package="com.bart.service" />

    <!--4、spring和mybatis的整合-->
    <!--4.1 注册 SqlSessionFactoryBean-->
    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="MyDataSource" /> <!--数据源-->
        <property name="mapperLocations" value="classpath:mapper/*.xml" /> <!--mapper 映射文件-->
    </bean>

    <!--4.2 定义 mapper 扫描配置器-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
        <property name="basePackage" value="com.bart.dao"/>
    </bean>

    <!--批量执行的SqlSession-->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean" />
        <constructor-arg name="executorType" value="BATCH" />
    </bean>

    <!--5、事务配置-->
    <!--5.1 配置事务控制 声明事务管理器对象-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="MyDataSource" />
    </bean>

    <!--5.2 配置 aop-->
    <aop:config>
        <!--配置切入点表达式：指定哪些包中的类，要使用事务-->
        <aop:pointcut id="servicePt" expression="execution(* *..service..*.*(..))"/>
        <!--配置增强其：关联 advice 和 pointcut-->
        <aop:advisor advice-ref="myAdvice" pointcut-ref="servicePt" />
    </aop:config>

    <tx:advice id="myAdvice" transaction-manager="transactionManager">
        <!--tx:attributes：配置事务属性-->
        <tx:attributes>
            <!-- 所有方法都是事务方法 -->
            <tx:method name="*"/>
            <!--以get开始的所有方法  -->
            <tx:method name="get*" read-only="true"/>
        </tx:attributes>
    </tx:advice>
</beans>

2、springmvc 配置文件

dispatcherServlet.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"
       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 https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--springmvc 配置文件-->
    <!--声明组件扫描器-->
    <context:component-scan base-package="com.bart.controller" />

    <!--两个标准配置-->
    <!--将springmvc不能处理的请求交给tomcat-->
    <mvc:default-servlet-handler />
    <!--能支持springmvc更高级的一些功能，JSR303校验，快捷的ajax...-->
    <mvc:annotation-driven />
</beans>

3、mybatis-generator 逆向工程的配置文件

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="D:\study\Maven\maven_repository\mysql\mysql-connector-java\6.0.6\mysql-connector-java-6.0.6.jar"/>
    <context id="DB2Tables"  targetRuntime="MyBatis3">
        <commentGenerator>
            <!--<property name="suppressDate" value="true"/>-->
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库链接URL，用户名、密码 -->
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/ssm_crud?serverTimezone=UTC&amp;nullCatalogMeansCurrent=true"
                        userId="root" password="root">
        </jdbcConnection>

        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <!-- 生成模型的包名和位置-->
        <javaModelGenerator targetPackage="com.bart.bean" targetProject="./src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!-- 生成映射文件的包名和位置-->
        <sqlMapGenerator targetPackage="mapper" targetProject="./src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
        <!-- 生成mapper位置-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.bart.dao" targetProject="./src/main/java">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名-->
        <table tableName="tbl_emp" domainObjectName="Employee"></table>
        <table tableName="tbl_dept" domainObjectName="Department"></table>

    </context>
</generatorConfiguration>

4、mybatis 配置文件

mybatis.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="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <!-- 配置别名 实体类的位置 方便引用-->
    <typeAliases>
        <package name="com.bart.crud.dao"/>
    </typeAliases>
</configuration>

四、通过 mybatis-generator 逆向工程自动创建实体类，mapper映射文件等

1、在数据库中创建表

在这里插入图片描述

2、生成对象的两种方法

1）直接使用 maven 插件生成

在这里插入图片描述
如果 maven 插件中没有 mybatis-generator，那是因为你的 pom.xml 中的插件：pluginManagement 和 plugins 要同级，不要把 plugins 放在 pluginManagement 里

2）配置命令 mybatis-generator:generate -e

在这里插入图片描述

五、项目目录

在这里插入图片描述

六、我遇到的 bug 以及解决方案

1、Error creating bean with name ‘MyDataSource’ defined in class path resource [applicationContext.xml]: BeanPostProcessor before instantiation of bean failed;

Error creating bean with name 'MyDataSource' defined in class path resource [applicationContext.xml]: 
BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0': 
Cannot resolve reference to bean 'txPoint' while setting bean property 'pointcut'; 
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txPoint': Lookup method resolution failed; 
nested exception is java.lang.IllegalStateException: Failed to introspect Class [org.springframework.aop.aspectj.AspectJExpressionPointcut] 
from ClassLoader [ParallelWebappClassLoader

原因

没有加入 aspectj 依赖

解决方案

加入 aspectj 依赖就可以了

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-aspects</artifactId>
  <version>5.3.4</version>
</dependency>

2、Error creating bean with name ‘sqlSessionFactory’ defined in class path resource [applicationContext.xml]: Invocation of init method failed;

调用init方法失败

Error creating bean with name 'sqlSessionFactory' defined in class path resource [applicationContext.xml]: 
Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 
'file [D:\study\java资料\代码\SSM整合\ssm-crud\target\ssm-crud-1.0-SNAPSHOT\WEB-INF\classes\mapper\DepartmentMapper.xml]'; 
nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file 
[D:\study\java资料\代码\SSM整合\ssm-crud\target\ssm-crud-1.0-SNAPSHOT\WEB-INF\classes\mapper\DepartmentMapper.xml]'. Cause: 
java.lang.IllegalArgumentException: Result Maps collection already contains value for com.bart.crud.dao.DepartmentMapper.BaseResultMap

原因

应该是你多次使用 mybatis-generator 创建文件，然后没删除原先的文件，导致重复

解决方案

删除重复的，重新创建即可

3、Unsatisfied dependency expressed through field ‘departmentService’;

Error creating bean with name 'departmentController': Unsatisfied dependency expressed through field 'departmentService'; 
nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 
'com.bart.crud.service.DepartmentService' available: expected at least 1 bean which qualifies as autowire candidate. 
Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}

解决方案

在spring 配置文件中配置扫描器

<!--0、配置扫描器-->
<context:component-scan base-package="com.bart.crud.service" />

4、org.junit.vintage.engine.descriptor.RunnerTestDescriptor warnAboutUnfilterableRunner

org.junit.vintage.engine.descriptor.RunnerTestDescriptor warnAboutUnfilterableRunner
警告: Runner org.junit.internal.runners.ErrorReportingRunner (used on class com.bart.crud.test.MapperTest) 
does not support filtering and will therefore be run completely.

原因

导错 junit 包了

解决方案

//import org.junit.jupiter.api.Test; //错的包
import org.junit.Test;

本人菜鸟一个，有问题欢迎大佬指出！😃

小黑不高兴

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

快速搭建一个SSM项目

一、加入依赖

需要注意的是：版本要一致，不然可能导致冲突

二、创建基本的包

三、配置文件

1、spring 配置文件

2、springmvc 配置文件

3、mybatis-generator 逆向工程的配置文件

4、mybatis 配置文件

四、通过 mybatis-generator 逆向工程 自动创建实体类，mapper映射文件等

1、在数据库中创建表

2、生成对象的两种方法

1）直接使用 maven 插件生成

2）配置命令 mybatis-generator:generate -e

五、项目目录

六、我遇到的 bug 以及解决方案

1、Error creating bean with name ‘MyDataSource’ defined in class path resource [applicationContext.xml]: BeanPostProcessor before instantiation of bean failed;

原因

解决方案

2、Error creating bean with name ‘sqlSessionFactory’ defined in class path resource [applicationContext.xml]: Invocation of init method failed;

原因

解决方案

3、Unsatisfied dependency expressed through field ‘departmentService’;

解决方案

4、org.junit.vintage.engine.descriptor.RunnerTestDescriptor warnAboutUnfilterableRunner

原因

解决方案

四、通过 mybatis-generator 逆向工程自动创建实体类，mapper映射文件等