SSM框架整合

最新推荐文章于 2023-01-30 17:24:40 发布

.小小先生

最新推荐文章于 2023-01-30 17:24:40 发布

阅读量170

点赞数

文章标签： mybatis spring java ssm 数据库

小小先生

本文链接：https://blog.csdn.net/weixin_43740574/article/details/116333256

版权

SSM框架搭建

大概思路

整合SSM框架，即将Spring，SpringMVC，Mybatis整合起来，使用与web项目。

整合过程和网上的教程大致相同，首先写底层，即Mybatis，并直接用Spring整合它，写好需要进行测试，有bug早发现。然后写web层，写完之后我的建议是进行测试，单纯测试web层模块，尽量避免404和500错误。最后补全service层。

用户从网页中获取数据的步骤如下：

1：根据网页中的地址找到controller层中对应的方法
2：controller里面的方法则会调用service层的方法（有些可能直接return页面）
3：service层中会有接口，在接口的实现类中，调用dao层的方法
4:dao层则会实现具体的业务逻辑，在xml文件中编写sql语句，与数据库进行交互
5:数据库则将业务逻辑实现，并将数据返回
6:dao层得到数据后，返回给service层
7:service层继续将数据返回到controller层
8:controller层则将得到的数据通过视图解析器返回到具体的页面

接下来开始正文

创建工程

创建一个新的maven工程

然后填写工程名即可

导入jar包

<?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>06</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

    <dependencies>
<!--        日志用的-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
<!--        偷懒用的-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
        </dependency>
<!--        测试用的-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
<!--        连接MySQL用的-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>
<!--        mybatis的-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
<!--        spring整合mybatis用的-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>
<!--        spring的核心jar包-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.2.0.RELEASE</version>
        </dependency>
<!--        spring的数据源-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.0.RELEASE</version>
        </dependency>
<!--        下面三个springMVC用的-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.1</version>
        </dependency>
    </dependencies>

</project>

修改pom.xml文件都要刷新一下

添加web目录

右键工程名字-->add Framework support-->

然后添加lib目录

File-->ProjectStructure-->Aartifacts-->

文件夹的名字为lib

选择全部，没有出现则说明pom.xml没有刷新

然后ok

接下来我个人的习惯是先将骨架创建好

编写dao层

数据库：

表名：user

User类

package com.lzx.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @Author 小先生
 * @Date 2021年04月30日22:35
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;

}

dao层接口

package com.lzx.mapper;

import com.lzx.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author 小先生
 * @Date 2021年04月30日22:36
 */

public interface UserMapper {
    //增加一个用户
    int addUser(User user);

    //删除一个用户
    int deleteUserById(@Param("id") int id);

    //修改一个用户
    int updateUserById(@Param("id") int id);

    //查找一个用户
    User queryUserById(@Param("id") int id);

    //查找全部用户
    List<User> findAll();
}

这里不写dao层接口的实现类，直接使用mybatis-spring jar包中的MapperScannerConfigurer，通过在配置文件中配置它，直接扫描dao层接口，动态的将dao接口注入到Spring容器中。

编写UserMapper.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.lzx.mapper.UserMapper">

    <insert id="addUser" parameterType="User">
        insert into user (id,name,pwd)
        values (#{id},#{name},#{pwd});
    </insert>

    <delete id="deleteUserById" parameterType="int">
        delete
        from user
        where id=#{id};
    </delete>

    <update id="updateUserById" parameterType="User">
        update user
        set name=#{name},pwd=#{pwd}
        where id=#{id};
    </update>

    <select id="queryUserById" parameterType="int" resultType="User">
        select *
        from user where id=#{id};
    </select>

    <select id="findAll" resultType="User">
        select *
        from user;
    </select>

</mapper>

编写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>
<!--    开启log4j日志-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>
<!--配置别名-->
    <typeAliases>
        <typeAlias type="com.lzx.pojo.User" alias="User"/>
    </typeAliases>
<!-- 关联mapper.xml文件-->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>
</configuration>

使用Spring整合mybatis，编写spring-dao.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 https://www.springframework.org/schema/context/spring-context.xsd">

    <!--   加载配置文件 -->
    <context:property-placeholder location="classpath:db.properties"/>

<!--    配置数据源-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
    </bean>
    
    <!--    sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--        绑定Mybatis的配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
<!--        <property name="mapperLocations" value="mapper/UserMapper.xml"/>-->
    </bean>

db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis01?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC&useSSL=false&allowPublticKeyrooRetrieval=true
jdbc.username=root
jdbc.password=root

这里有一个注意点：每个人的数据库版本可能不一致，8.0以上的版本需要配置时区serverTimezone=UTC（有几种），5.几的版本不需要

log4j.properties

### 设置###
log4j.rootLogger = debug,stdout,D,E
### 输出信息到控制抬 ###
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 = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n
### 输出DEBUG 级别以上的日志到=E://logs/error.log ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = ./logs/0421/log.log
log4j.appender.D.Append = true
log4j.appender.D.Encoding=UTF8
log4j.appender.D.Threshold = DEBUG
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  - [ %p ]  %l %c %t - %m %n 
### 输出ERROR 级别以上的日志到=E://logs/error.log ###
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.File =./logs/0421/error.log
log4j.appender.E.Append = true
log4j.appender.E.Encoding=UTF8
log4j.appender.E.Threshold = ERROR
log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  - [ %p ]  %l %c %t - %m %n

另外在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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <import resource="spring-dao.xml"/>
    <import resource="spring-mvc.xml"/>
    <import resource="spring-service.xml"/>
</beans>

dao层配置完毕，开始测试，测试代码如下：

import com.lzx.mapper.UserMapper;
import com.lzx.pojo.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

/**
 * @Author 小先生
 * @Date 2021年04月30日22:41
 */
public class Test {
    @org.junit.Test
    public void test01(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        List<User> all = userMapper.findAll();
        for (User user : all) {
            System.out.println(user);
        }
    }
}

没毛病，继续！

编写controller层

首先完成web.xml。配置DispatcherServlet和Filter

<?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">
    <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:applicationContext.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <filter>
        <filter-name>encodingFilter</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>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

接下来配置spring-mvc.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">

    <!--    注解驱动-->
    <mvc:annotation-driven/>

    <!--    静态资源过滤-->
    <mvc:default-servlet-handler/>

    <!--    扫描包:controller-->
    <context:component-scan base-package="com.lzx.controller"/>

    <!--    视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

编写HelloController类，测试controller层

package com.lzx.controller;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * @Author 小先生
 * @Date 2021年04月30日23:27
 */
@Controller
public class HelloController {
    @RequestMapping("/hello")
    public String test01(Model model){
        model.addAttribute("msg","hello");
        return "hello";
    }
}

hello.jsp

<%--
  Created by IntelliJ IDEA.
  User: 小先生
  Date: 2021/4/30
  Time: 23:31
  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>

${msg}
</body>
</html>

没毛病，下一个！

编写service层

service层属于位于中间层次，下面连接着dao层，上面连接着controller层，只要前面两个层测试没问题，接下来就尽管这条service层，出问题也只会出这。

首先编写service接口

import com.lzx.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author 小先生
 * @Date 2021年04月30日23:35
 */
public interface UserService {
    //增加一个用户
    int addUser(User user);

    //删除一个用户
    int deleteUserById(@Param("id") int id);

    //修改一个用户
    int updateUserById(@Param("id") int id);

    //查找一个用户
    User queryUserById(@Param("id") int id);

    //查找全部用户
    List<User> findAll();
}

实现其接口

package com.lzx.service;

import com.lzx.mapper.UserMapper;
import com.lzx.pojo.User;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @Author 小先生
 * @Date 2021年04月30日23:35
 */
@Service
public class UserServiceImpl implements UserService{

    private UserMapper userMapper;

    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }

    @Override
    public int addUser(User user) {
        return userMapper.addUser(user);
    }

    @Override
    public int deleteUserById(int id) {
        return userMapper.deleteUserById(id);
    }

    @Override
    public int updateUserById(int id) {
        return userMapper.updateUserById(id);
    }

    @Override
    public User queryUserById(int id) {
        return userMapper.queryUserById(id);
    }

    @Override
    public List<User> findAll() {
        return userMapper.findAll();
    }
}

编写spring-service.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 https://www.springframework.org/schema/context/spring-context.xsd">
    <context:component-scan base-package="com.lzx.service"/>

    <!--    声明式事务配置-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <bean id="UserServiceImpl" class="com.lzx.service.UserServiceImpl">
        <property name="userMapper" ref="userMapper"/>
    </bean>


</beans>

接下就测试整个框架

测试

controller层编写代码

package com.lzx.controller;

import com.lzx.pojo.User;
import com.lzx.service.UserService;
import com.lzx.service.UserServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

/**
 * @Author 小先生
 * @Date 2021年04月30日23:41
 */
@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    @Qualifier("UserServiceImpl")
    private UserService userService;

    //查询全部
    @RequestMapping("/allUser")
    public String list(Model model){
        List<User> list = userService.findAll();
        model.addAttribute("list",list);
        return "allUser";
    }

}

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: 小先生
  Date: 2021/4/30
  Time: 23:27
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>首页</title>
</head>
<body>
<h3>
  <a href="/user/allUser">所有用户</a>
</h3>
</body>
</html>

allUser.jsp

<%--
  Created by IntelliJ IDEA.
  User: 小先生
  Date: 2021/4/30
  Time: 23:42
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>所有用户</title>
</head>
<body>
<h1>用户</h1>
</body>
</html>

业务半成品，只是测试

SSM

这是同款SSM框架，实现了增删改查及搜索等简单的业务