创建第一个SSM框架整合项目

weighless1129

已于 2023-05-08 11:55:33 修改

阅读量246

点赞数 6

文章标签： java ide mybatis spring mvc

于 2023-05-06 22:32:50 首次发布

本文链接：https://blog.csdn.net/weighless/article/details/130535799

版权

项目的最开始当然是搞数据库啦！！

注意我用的是mysql8.0，如果用不一样记得改pom里的sql依赖

语句如下：

use db_tgt;
CREATE TABLE Goods (  
  Id int(11) unsigned not null AUTO_INCREMENT,  
  name varchar(20) NOT NULL,  
  price float not null,
  more varchar(20) not null,
  PRIMARY KEY (id) );

insert into Goods values(1,"平板电脑",1200.12,"电子产品");
insert into Goods values(null,"平凡的世界",66.66,"书籍");
insert into Goods values(null,"酒精",16.66,"医疗");
select * from Goods

然后就是搞java，在idea上创建一个空项目，名字大家就自己弄吧

整个项目结构如图

先添加web模块

添加完后整个结构应该就差不多了，tomcat在后面来部署

先整和Mybatis和Spring

先导入依赖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>org.example</groupId>
    <artifactId>SpringMvc1</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <spring.version>5.1.5.RELEASE</spring.version>
    </properties>

    <dependencies>
        <!-- ServletAPI -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
        <!-- SpringMVC -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.21</version>
        </dependency>
        <!--Spring框架核心库 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <!-- aspectJ AOP 织入器 -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.9</version>
        </dependency>
        <!--mybatis-spring整合包 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <!--Spring java数据库访问包，在本例中主要用于事务管理 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <!--MySQL数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>
        <!--log4j日志包 -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <!-- mybatis ORM框架 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>
        <!-- JUnit单元测试工具 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <!--c3p0 连接池 -->
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>
        <!-- spring-test：测试包 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.5.RELEASE</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

</project>

然后弄配置文件

db.properties(数据库的jdbc驱动包，路径，密码啥的，小伙伴要改成自己的啊！)

前面jdbc.前缀不要删（不然后续会报错）

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_tgt?characterEncoding=utf-8&serverTimezone=UTC
jdbc.username=root
jdbc.password=root

log4j.properties

# Global logging configuration\uff0c\u5efa\u8bae\u5f00\u53d1\u73af\u5883\u4e2d\u8981\u7528debug
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
log4j.logger.com.mchange.v2.async.ThreadPoolAsynchronousRunner = ERROR

mybatis的核心配置文件：mybatis-config.xml（其实啥也不用配，链接什么的都在Spring中配置）

<?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>
</configuration>

Spring核心配置文件beans.xml（没有用aop，等等和SpringMVC融合的内容也在里面了，其实就是一个扫包的范围）

<?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">


    <!--1.引入外部配置信息文件-->
    <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>

    <!--2.开启注解配置-->
    <context:component-scan base-package="com.tianguiti">
        <!--因为controller已经在springMVC中扫描过了,所以在spring扫描的时候,要把controller过滤掉-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!--3.配置数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
        <!--当c3p0连接池中连接耗尽时一次同时获取的连接数-->
        <property name="acquireIncrement" value="5"></property>
        <!--初始连接池数量-->
        <property name="initialPoolSize" value="10"></property>
        <!--连接池中最小连接数量-->
        <property name="minPoolSize" value="5"></property>
        <!--连接池中最大连接数量-->
        <property name="maxPoolSize" value="20"></property>
    </bean>


    <!--4.配置SqlSessionFactoryBean  MyBatis整合Spring核心API之一
    作用是代替MyBatis核心配置文件，用来配置数据连接，别名，映射器等数据操作相关内容，
    也可以直接加载MyBatis核心配置文件-->

    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--指定数据源-->
        <property name="dataSource" ref="dataSource"></property>

        <!--给包取别名-->
        <property name="typeAliasesPackage" value="com.tianguiti.Pojo"></property>

        <!--映射文件-->
        <property name="mapperLocations" value="classpath*:com/tianguiti/mapper/*Mapper.xml"></property>

        <!--读取Mybatis核心配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>


    <!--5.将接口对象注入到容器中 MyBatis整合Spring核心API之一，作用是扫面接口所在包内容，
        按照SqlSessionFactoryBean中的相关信息，产生接口对象
        Spring使用当前配置将接口所在包下的所有的接口对象注入到容器中-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"></property>
        <property name="basePackage" value="com.tianguiti.mapper"></property>
    </bean>

</beans>

配置完文件，从下往上写，先mybatis中的mappe

Goods.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.tianguiti.mapper.GoodsMapper">
    <insert id="insert" parameterType ="com.tianguiti.Pojo.Goods">
        insert into Goods values (null,#{name},#{price},#{more})
    </insert>
    <select id="selects" resultType="com.tianguiti.Pojo.Goods" >
        select * from Goods
    </select>

</mapper>

注意所在的包要和接口一致，如果后面编译文件不和右图一致，就是没放一起，路径问题

GoodsMapper.java

package com.tianguiti.mapper;


import com.tianguiti.Pojo.Goods;
import org.springframework.stereotype.Repository;


import java.util.List;

@Repository
public interface GoodsMapper {

    List<Goods> selects ();
    int insert(Goods goods);
}

重要的事情在提醒一次，路径要和xml文件一样

我这里就定义两个方法，查询和插入，需要其他的小伙伴自己加哈。

然后就是下放的Pojo包中的数据类了

（这个和数据名保持一致就行，如果和数据库不一样，记得在xml中设置ResultMap来映射）

Goods类

package com.tianguiti.Pojo;

public class Goods {
    private int id;
    private float price;
    private String name;
    private String more;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public float getPrice() {
        return price;
    }

    public void setPrice(float price) {
        this.price = price;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public  String getMore() {
        return more;
    }

    public void setMore(String more) {
        this.more = more;
    }

    @Override
    public String toString() {
        return "Items{" +
                "id=" + id +
                ", price=" + price +
                ", name=" + name +
                ", more=" + more +
                '}';
    }
}

后面就是写服务层了service

先定义接口，后写实现类

GoodsService接口

package com.tianguiti.service;


import com.tianguiti.Pojo.Goods;

import java.util.List;

public interface GoodsService {
    List<Goods> selectAll();

    boolean insert(Goods goods);
}

实现类

package com.tianguiti.service.Impl;

import com.tianguiti.Pojo.Goods;
import com.tianguiti.mapper.GoodsMapper;
import com.tianguiti.service.GoodsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;


@Service
public class GoodsServiceImpl implements GoodsService {
    @Autowired
    private GoodsMapper goodsMapper;
    @Override
    public List<Goods> selectAll() {

        return goodsMapper.selects();
    }

    @Override
    public boolean insert(Goods Goods) {
        int i =goodsMapper.insert(Goods);
        if (i>0){
            return true;
        }
        return false;
    }
}

到这里我们完成了mybatis和spring的整合。

我们得测一下写的对不对啊（不能白忙活半天啊！）

我们在test包下写一个测试类

测试代码如下

package com.tianguiti;


import com.tianguiti.Pojo.Goods;
import com.tianguiti.service.GoodsService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;


import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:beans.xml")
public class test1 {
    @Autowired
    private GoodsService goodsService;
    @Test
    public void m1(){
        List<Goods> goods = goodsService.selectAll();
        if (goods==null){
            System.out.println("无记录");
        }else {
            for (Goods item:goods){
                System.out.println(item.toString());
            }

        }

    }
}

点绿色的三角开始按钮，看到控制台输出一堆日志后终于出现了我们的数据库数据（这就是测试成功）

接下来就是Spring和MVC的整合了

因为spring和springMVC同源，所以只要区分开各自的bean就好，通过扫包来区分。

前面spring的配置文件已经设置了排除@controller注解的bean

就剩最后两个个配置文件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:p="http://www.springframework.org/schema/p"
       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 https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--配置SpringMVC包的扫描,因为当前springmvc也是使用了容器,所以它扫描的组件不能和spring扫描的组件重复-->
    <context:component-scan base-package="com.tianguiti.controller" use-default-filters="false">
        <!--所以要使用排除法,SpringMVC只扫描自己的controller包-->
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>



    <!--配置默认的servlet-->
    <mvc:default-servlet-handler/>
    <!--启用注解驱动-->
    <mvc:annotation-driven/>
   
</beans>

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_4_0.xsd"
         version="4.0">
    <!--引入SpringMVC的核心控制器DispatchServlet-->
    <servlet>
        <servlet-name>servlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

        <!--配置SpringMVC的核心配置文件-->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springMvc.xml</param-value>
        </init-param>
    </servlet>

    <!--配置Spring监听器启动,在服务器启动的时候最先启动-->
    <listener>
        <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>

    <!--配置SpringMVC核心配置文件-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:beans.xml</param-value>
    </context-param>

    <!-- 访问DispatcherServlet对应的路径 -->
    <!--配置Servlet映射,默认/ 不是/*-->
    <servlet-mapping>
        <servlet-name>servlet</servlet-name>
        <url-pattern>/</url-pattern> <!--/不过滤jsp防止死循环-->
    </servlet-mapping>
</web-app>

然后就是我们的controller了

在controller包建一个java的控制类

package com.tianguiti.controller;

import com.tianguiti.Pojo.Goods;
import com.tianguiti.service.GoodsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@Controller
public class IndexController {
    @Autowired
    private GoodsService goodsService;

    @RequestMapping(value = "/loging")
    public String test(String userName, String passWord) throws Exception{
        if ("张三".equals(userName)&&"123".equals(passWord)){

            return "login.jsp";
        }
        return "erro.jsp";
    }


    @RequestMapping(value = "/getData",produces = "text/html;charset=utf-8")
    @ResponseBody
    public String data() throws Exception{
        List<Goods> Goods = goodsService.selectAll();
        return Goods.toString();
    }
}

有了控制层，我们打开浏览器试一下能不能拿到数据库的数据

把项目部署到服务器上

先创建部署工件——

在设置中打开项目设置然后如下两图

上方是检查web模块的对应，不然后面拿不到静态资源（webapp文件夹图片要有小蓝点）

接着就是创建工件，然后在tomcat上部署

配置tomcat，点右上角如图

大家按自己tomcat所在安装位置配置哈

其他设置如图

然后就是启动他，接着我们在浏览器中输入 localhost:9528/SpringMvc1_war_exploded/getData

显示如下就是成功了

————————————————————————————————————

到这里就ssm融合成功了

下面是利用ssm进行一个简单的登录查询

在web模块下创建如下jsp文件

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: TGT
  Date: 2023/5/6
  Time: 19:49
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<form action="/SpringMvc1_war_exploded/loging">
    <h1>欢迎来到登录页面</h1>
    <input name="userName"><br/>
    <input name="passWord"><br/>
    <input type="submit" value="登录">
</form>
</body>
</html>

erro.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h1>您的账号或者密码错误</h1>
<a href="/SpringMvc1_war_exploded/index.jsp">点我返回</a>
</body>
</html>

item.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h1>来自数据库的数据</h1><br>
${requestScope.data}
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h1>登录成功</h1>
<a href="/SpringMvc1_war_exploded/getData">点我查询数据库</a>
</body>
</html>

再改一下controller中的data方法代码就结束啦！！！

  @RequestMapping(value = "/getData",produces = "text/html;charset=utf-8")
    public String data(ModelMap mm) throws Exception{
        List<Goods> Goods = goodsService.selectAll();
        mm.put("data", Goods);
        return "item.jsp";
    }j

最后进入浏览器自己尝试一下吧