SSM新手-简单接口实现

Yk...

已于 2022-07-26 01:38:59 修改

阅读量2k

点赞数

分类专栏： SSM 文章标签： spring boot mybatis mysql

于 2022-07-24 18:27:30 首次发布

本文链接：https://blog.csdn.net/qq_44848009/article/details/125962016

版权

SSM 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

(一) 简单接口实现

前言

SSM新手教程，从简单的开始实现，以注解形式，无XML注入，防止无端Bug

文件目录

一、ssm是什么？

Spring+SpringMVC+mybatis

二、使用步骤

1.创建项目，一路next下去

代码如下（示例）：

2.导入pom依赖并刷新

<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>com.example</groupId>
    <artifactId>demo</artifactId>
    <name>demo</name>
    <version>0.0.1-SNAPSHOT</version>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.1.RELEASE</version>
    </parent>

    <dependencies>

        <!-- web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- test -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>


        <!-- 热部署 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>

        <!-- 引入starter-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!-- MySQL的JDBC驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- 引入第三方数据源 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.6</version>
        </dependency>

    </dependencies>


    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-surefire-plugin</artifactId>
                <version>2.21.0</version>
                <configuration>
                    <testFailureIgnore>true</testFailureIgnore>
                </configuration>
            </plugin>

        </plugins>
    </build>

</project>

3.配置application.properties

server.port = 8080

#数据库指向
spring.datasource.url=jdbc:mysql://localhost:3306/ssm_yk?useUnicode=true&characterEncoding=utf-8    #ssm_yk数据库名
#数据库用户名
spring.datasource.username=root
#数据库密码
spring.datasource.password=123456
#数据库驱动 可以自动识别
#spring.datasource.driver-class-name =com.mysql.jdbc.Driver
#spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver

4.创建实体

package com.example.demo.pojo;



public class Yk {

    private int id;

    private String name;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    @Override
    public String toString() {
        return "Yk{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }
}

5.写mapper层--对数据库的操作接口

package com.example.demo.mapper;

import com.example.demo.pojo.Yk;
import org.apache.ibatis.annotations.*;

import java.util.List;


public interface YkMapper {
    @Select("select * from yk")
    @Options(useGeneratedKeys=true, keyProperty="id", keyColumn="id")
    @Results({
            @Result(id = true,column = "id",property = "id"),
            //mybatis.configuration.map-underscore-to-camel-case=true 同样可以实现下方效果
            @Result(column = "name",property = "name")
    })
    List<Yk> listYk();

}

6.写service层和实现类

service

package com.example.demo.service;


import com.example.demo.pojo.Yk;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public interface YkService {
    List<Yk> listYk();
}

impl

package com.example.demo.service.impl;


import com.example.demo.mapper.YkMapper;
import com.example.demo.pojo.Yk;
import com.example.demo.service.YkService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class YkServiceImpl implements YkService {

    @Autowired
    private YkMapper ykMapper;

    @Override
    public List<Yk> listYk() {
        return ykMapper.listYk();
    }
}

7.controller层实现

package com.example.demo.controller;


import com.example.demo.pojo.Yk;
import com.example.demo.service.YkService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;


@RestController
@RequestMapping("/api/v1/pub/yk")
public class YkController {

    @Autowired
    private YkService ykService;

    @GetMapping("/list")
    public List<Yk> listYk(){
        return  ykService.listYk();
    }
}

8.配置扫描包

9.数据库

三、运行

（二）信息显示到前端

1，新增pom

<!--防止tomcat不兼容-->
<properties>
        <java.version>1.8</java.version>
        <tomcat.version>8.5.37</tomcat.version>
</properties>

<!--添加Servlet的依赖-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
       <!--让springboot支持jsp-->
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
            <scope>provided</scope>
        </dependency>

        <!--添加Jsp的依赖-->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>

        <!--添加jstl的依赖包-->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <dependency>
            <groupId>javax.annotation</groupId>
            <artifactId>javax.annotation-api</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

2. controller

//@RestController
@Controller
@RequestMapping("/api/v1/pub/yk")
public class YkController {

    @Autowired
    private YkService ykService;

    @GetMapping("/list")
    public List<Yk> listYk(){

        return  ykService.listYk();

    }

    @RequestMapping("/selectAll")
    public String selectAll(Model model){
        List<Yk> list=ykService.selectAll();
        model.addAttribute("list",list);
        return "/showAll";
    }


//    @GetMapping("/exception")
//    public JsonData testExt(){
//        int i=1/0;
//        return JsonData.buildError("");
//    }

}

2.mapper

public interface YkMapper {
    @Select("select * from yk")
    @Options(useGeneratedKeys=true, keyProperty="id", keyColumn="id")
    @Results({
            @Result(id = true,column = "id",property = "id"),
            //mybatis.configuration.map-underscore-to-camel-case=true 同样可以实现下方效果
            @Result(column = "name",property = "name")
    })
    List<Yk> listYk();

    @Select({"select * from yk"})
    List<Yk> selectAll();

}

3.service


@Service
public interface YkService {
    public List<Yk> listYk();

    List<Yk> selectAll();
}

4.Impl

@Service
public class YkServiceImpl implements YkService {

    @Autowired
    private YkMapper ykMapper;

    @Override
    public List<Yk> listYk() {
        return ykMapper.listYk();
    }

    @Override
    public List<Yk> selectAll() {
        List<Yk> list=ykMapper.selectAll();
        return list;
    }


}

5.前端页面showAll.jsp

<%--
  Created by IntelliJ IDEA.
  User: 左岸咖啡
  Date: 2022/7/25
  Time: 23:44
  To change this template use File | Settings | File Templates.
--%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>Bootstrap 101 Template</title>

    <!-- Bootstrap -->
    <link href="${pageContext.request.contextPath}/static/css/bootstrap.min.css" rel="stylesheet">

    <!-- HTML5 shim 和 Respond.js 是为了让 IE8 支持 HTML5 元素和媒体查询（media queries）功能 -->
    <!-- 警告：通过 file:// 协议（就是直接将 html 页面拖拽到浏览器中）访问页面时 Respond.js 不起作用 -->
    <!--[if lt IE 9]>
    <script src="https://cdn.jsdelivr.net/npm/html5shiv@3.7.3/dist/html5shiv.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/respond.js@1.4.2/dest/respond.min.js"></script>
    <![endif]-->
</head>
<body>
<%--class="container-fluid"  style="background-color: #4cae4c"--%>
<div class="container">
    <table class="table table-bordered table-striped table-hover table-condensed">
        <thead>
        <tr>
            <th>id</th>
            <th>name</th>

        </tr>
        </thead>
        <tbody>
        <c:forEach var="yk" items="${list}">
            <tr>
                <th>${yk.id}</th>
                <th>${yk.name}</th>

            </tr>
        </c:forEach>
        </tbody>
    </table>

</div>


<!-- jQuery (Bootstrap 的所有 JavaScript 插件都依赖 jQuery，所以必须放在前边) -->
<script src="${pageContext.request.contextPath}/static/js/jquery-3.2.1.js"></script>
<!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->
<script src="${pageContext.request.contextPath}/static/js/bootstrap.min.js"></script>
</body>
</html>