SSM框架整合(Spring+SpringMVC+Mybatis)

1、创建数据库

2、创建表

在这里插入图片描述

3、创建maven工程

导入坐标


        
        
            org.springframework
            spring-context
            5.0.5.RELEASE
        
        
            org.aspectj
            aspectjweaver
            1.8.7
        
        
            org.springframework
            spring-jdbc
            5.0.5.RELEASE
        
        
            org.springframework
            spring-tx
            5.0.5.RELEASE
        
        
            org.springframework
            spring-test
            5.0.5.RELEASE
        
        
            org.springframework
            spring-webmvc
            5.0.5.RELEASE
        

        
        
            javax.servlet
            servlet-api
            2.5
        
        
            javax.servlet.jsp
            jsp-api
            2.0
        

        
        
            org.mybatis
            mybatis
            3.4.5
        
        
            org.mybatis
            mybatis-spring
            1.3.1
        
        
            mysql
            mysql-connector-java
            5.1.6
        
        
            c3p0
            c3p0
            0.9.1.2
        

        
            junit
            junit
            4.12
        
        
            jstl
            jstl
            1.2
        

    
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

4、编写实体类

package com.xmp.domain;

public class Account {

    private Integer id;
    private String name;
    private Double money;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

5、编写Mapper接口

package com.xmp.mapper;

import com.xmp.domain.Account;

import java.util.List;

public interface AccountMapper {

    public void save(Account account);

    public List findAll();

}
1
2
3
4
5
6
7
8
9
10
11
12
13

6、编写Service接口

package com.xmp.service;

import com.xmp.domain.Account;

import java.util.List;

public interface AccountService {

    public void save(Account account);

    public List findAll();

}
1
2
3
4
5
6
7
8
9
10
11
12
13

7、编写Service接口实现

package com.xmp.service.impl;

import com.xmp.domain.Account;
import com.xmp.mapper.AccountMapper;
import com.xmp.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("accountService")
public class AccountServiceImpl implements AccountService {

    @Autowired
    private AccountMapper accountMapper;

    @Override
    public void save(Account account) {
        accountMapper.save(account);
    }

    @Override
    public List findAll() {
        return accountMapper.findAll();
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

8、编写Controller

package com.xmp.controller;

import com.xmp.domain.Account;
import com.xmp.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

@Controller
@RequestMapping("/account")
public class AccountController {

    @Autowired
    private AccountService accountService;

    //保存
    @RequestMapping(value = "/save",produces = "text/html;charset=UTF-8")
    @ResponseBody
    public String save(Account account){
        accountService.save(account);
        return "保存成功";
    }

    //查询
    @RequestMapping("/findAll")
    public ModelAndView findAll(){
        List accountList = accountService.findAll();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("accountList",accountList);
        modelAndView.setViewName("accountList");
        return modelAndView;
    }

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

9、编写添加页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


    添加账户信息表单
    
        账户名称:

        账户金额:

        

    


1
2
3
4
5
6
7
8
9
10
11
12
13
14

10、编写列表页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>


    Title


    展示账户数据列表
    
            
        
            账户id
            账户名称
            账户金额
        

        
                ${account.id}
                ${account.name}
                ${account.money}
            
        

    


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

账户id	账户名称	账户金额
${account.id}	${account.name}	${account.money}

11、编写相应配置文件

Spring配置文件：applicationContext.xml

SprngMVC配置文件：spring-mvc.xml

MyBatis映射文件：AccountMapper.xml




    
        insert into account values(#{id},#{name},#{money})
    
    

1
2
3
4
5
6
7
8
9
10
11
12

MyBatis核心文件：sqlMapConfig-spring.xml

数据库连接信息文件：jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=root
jdbc.passwords=root
1
2
3
4

Web.xml文件：web.xml




    
    
        contextConfigLocation
        classpath:applicationContext.xml
    
    
        org.springframework.web.context.ContextLoaderListener
    

    
    
        DispatcherServlet
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:spring-mvc.xml
        
        1
    
    
        DispatcherServlet
        /
    

    
    
        CharacterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            UTF-8
        
    
    
        CharacterEncodingFilter
        /*
    



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

日志文件：log4j.xml

#
# Hibernate, Relational Persistence for Idiomatic Java
#
# License: GNU Lesser General Public License (LGPL), version 2.1 or later.
# See the lgpl.txt file in the root directory or .
#

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.err
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 hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.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=all, stdout
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

相关阅读:
three.js中关于摄影机
 C Primer Plus(6) 中文版第3章数据和C 3.1 示例程序
 【SQL语法基础】什么是存储过程，在实际项目中用得多么？
vagrant+virtualbox的踩坑记录
 python爬虫模板和网页表格生成表格文件
 HP E1406A 端子模块
 creo草绘图形技巧-透视图
 Docker初级篇
 Java项目：ssm汽车租赁系统设计
 HashMap 是怎么解决哈希冲突的？
原文地址：https://blog.csdn.net/qq_53463544/article/details/126221610