SpringBoot入门demo

1、三层架构简介

/**
* springboot的三层架构,分为dao层、service层、controller层、还有单独的entity层
* dao层为存储层,即为数据库操作层,
* service层为业务处理层
* controller层为页面展示层
* 实现过程,首先在dao层定义数据库操作接口,进而在service层创建dao层接口的对象,进行dao层的调用
* 之后又在controller层创建service层类的对象,进行service层的调用
* 层层嵌套
* entity层在其他三个层中均调用,主要进行参数的设置
*/

项目创建步骤

(1)如下图
在这里插入图片描述
2. 如下图在这里插入图片描述

2、入门级demo展示

2.1 springboot的启动类
package com.example;

import com.example.controller.AdminInfoController;
import org.mybatis.spring.annotation.MapperScan;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.dao") //将dao层的所有接口转换为可实现类
public class DemohelloApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemohelloApplication.class, args);
        Logger logger = LoggerFactory.getLogger(AdminInfoController.class);
        logger.warn("这是一个demo");
    }

}
2.2 entity层
package com.example.extity;

/**
 * @author Janson
 * @version 1.0
 * @date 2021/7/6 17:23
 */
public class AdminInfo {
    private Long id;
    private String name;
    private String password;
    private String nickName;
    private String sex;
    private Integer age;
    private String birthday;
    private String phone;
    private String address;
    private String code;
    private String email;
    private String cardId;
    private Integer level;
    private Double account;

    public Long getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getNickName() {
        return nickName;
    }

    public void setNickName(String nickName) {
        this.nickName = nickName;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getCardId() {
        return cardId;
    }

    public void setCardId(String cardId) {
        this.cardId = cardId;
    }

    public Integer getLevel() {
        return level;
    }

    public void setLevel(Integer level) {
        this.level = level;
    }

    public Double getAccount() {
        return account;
    }

    public void setAccount(Double account) {
        this.account = account;
    }
}
2.3 dao层
package com.example.dao;

import com.example.extity.AdminInfo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author Janson
 * @version 1.0
 * @date 2021/7/6 17:23
 */
@Repository
public interface AdminInfoDao {
    @Select("SELECT * FROM admin_info ")
    List<AdminInfo> fingAll();
    @Select("SELECT name From admin_info WHERE name='猪头'")
    List<AdminInfo> findCount();
}

2.4 service层
package com.example.service;

import com.example.dao.AdminInfoDao;
import com.example.extity.AdminInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author Janson
 * @version 1.0
 * @date 2021/7/6 17:24
 */
@Service
public class AdminInfoService {
    @Resource
    private AdminInfoDao adminInfoDao;
    public List<AdminInfo> getAll(){
        return adminInfoDao.fingAll();
    }
    public List<AdminInfo> getCount(){
        return adminInfoDao.findCount();
    }
}

2.5 controller层
package com.example.controller;

import com.example.extity.AdminInfo;
import com.example.service.AdminInfoService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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;

/**
 * @author Janson
 * @version 1.0
 * @date 2021/7/6 17:24
 */
@RestController
public class AdminInfoController {
    @Autowired
    private AdminInfoService adminInfoService;
    @RequestMapping("/get")
    public List<AdminInfo> get(){
        return adminInfoService.getAll();
    }
    @GetMapping("/getCount")
    public List<AdminInfo> getCount(){
        return adminInfoService.getCount();
    }
}

3.数据库脚本及实现展示

/*
SQLyog Ultimate v8.32 
MySQL - 5.7.26 : Database - admin_info
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`admin_info` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `admin_info`;

/*Table structure for table `admin_info` */

DROP TABLE IF EXISTS `admin_info`;

CREATE TABLE `admin_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `nickName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `sex` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
  `age` int(10) DEFAULT NULL COMMENT '年龄',
  `birthday` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '生日',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '编号',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `cardId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身份证',
  `account` double(10,2) DEFAULT NULL COMMENT '余额',
  `level` int(10) NOT NULL DEFAULT '1' COMMENT '权限等级',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员信息表';

/*Data for the table `admin_info` */

insert  into `admin_info`(`id`,`name`,`password`,`nickName`,`sex`,`age`,`birthday`,`phone`,`address`,`code`,`email`,`cardId`,`account`,`level`) values (2,'admin2','e10adc3949ba59abbe56e057f20f883e','管理员','男',23,'2020-11-07 12:42:52','18843232356','北京市','222','bb@163.com','342425199001116376',0.00,1),(3,'admin3','e10adc3949ba59abbe56e057f20f883e','管理员','女',32,'2020-11-07 12:42:52','18843232356','合肥市','333','cc@163.com','342425199001116323',0.00,1),(4,'admin4','e10adc3949ba59abbe56e057f20f883e','管理员','女',24,'2020-11-07 12:42:52','18843232356','北京市','444','hahaha@126.com','342425199001116837',0.00,1),(5,'admin5','e10adc3949ba59abbe56e057f20f883e','管理员','男',25,'2020-11-07 12:42:52','18843232356','合肥市','555','hello@126.com','342425199001116309',0.00,1),(6,'admin6','e10adc3949ba59abbe56e057f20f883e','管理员','男',26,'2020-11-07 12:42:52','18843232356','北京市','666','1212@qq.com','342425199001116984',0.00,1),(7,'admin7','e10adc3949ba59abbe56e057f20f883e','管理员','男',21,'2020-11-07 12:42:52','18843232356','合肥市','777','8765@qq.com','342425199001116303',0.00,1),(8,'admin8','e10adc3949ba59abbe56e057f20f883e','管理员','男',31,'2020-11-07 12:42:52','18843232356','北京市','888','9080@qq.com','342425199001116910',0.00,1),(9,'admin9','e10adc3949ba59abbe56e057f20f883e','管理员','男',18,'2020-11-07 12:42:52','18843232356','牛峡社','999','shjs@126.com','342425199001116345',0.00,1),(10,'admin10','e10adc3949ba59abbe56e057f20f883e','管理员','女',33,'2020-11-07 12:42:52','18843232356','深圳市','000','666@qq.com','342425199001116234',0.00,1),(11,'豆包','e10adc3949ba59abbe56e057f20f883e','管理员','女',24,'1997-09-12 00:00:00','17777779087','山东省烟台市烟台精神病院','666','jiba@163.com','622424191202122300',NULL,1),(12,'猪头','e10adc3949ba59abbe56e057f20f883e','管理员','男',12,'2021-07-06 09:57:52','18978090987','山东省烟台市烟台精神病院','777','jan@qq.com','622424109009091230',NULL,1),(13,'df','6512bd43d9caa6e02c990b0a82652dca',NULL,'男',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

4、application.yml文件配置

server:
  port: 8888
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/b_filmBuy?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8


5、以上则完成了整个demo实现的过程,在浏览器中输入 http://localhost:8888/get 就能展示数据。

  • 3
    点赞
  • 9
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 3
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Janson666

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值