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