正规做网站,可以写代码的网站有哪些问题,win2012r2 建设网站,莞城网站建设公司Tlias智能学习辅助系统 01 创建员工、部门表创建springboot工程#xff0c;引入对应的起步依赖(web、mybatis、mysql驱动、lombok)准备 Mapper、Service、Controller 等基础结构MapperServiceControllerpojo封装类application.properties 接口开发规范 创建员工、部门表
-- 创… Tlias智能学习辅助系统 01 创建员工、部门表创建springboot工程引入对应的起步依赖(web、mybatis、mysql驱动、lombok)准备 Mapper、Service、Controller 等基础结构MapperServiceControllerpojo封装类application.properties 接口开发规范 创建员工、部门表
-- 创建tlias数据库
sql create database tlias;-- 部门管理
create table dept(id int unsigned primary key auto_increment comment 主键ID,name varchar(10) not null unique comment 部门名称,create_time datetime not null comment 创建时间,update_time datetime not null comment 修改时间
) comment 部门表;insert into dept (id, name, create_time, update_time) values(1,学工部,now(),now()),(2,教研部,now(),now()),(3,咨询部,now(),now()), (4,就业部,now(),now()),(5,人事部,now(),now());-- 员工管理(带约束)
create table emp (id int unsigned primary key auto_increment comment ID,username varchar(20) not null unique comment 用户名,password varchar(32) default 123456 comment 密码,name varchar(10) not null comment 姓名,gender tinyint unsigned not null comment 性别, 说明: 1 男, 2 女,image varchar(300) comment 图像,job tinyint unsigned comment 职位, 说明: 1 班主任,2 讲师, 3 学工主管, 4 教研主管, 5 咨询师,entrydate date comment 入职时间,dept_id int unsigned comment 部门ID,create_time datetime not null comment 创建时间,update_time datetime not null comment 修改时间
) comment 员工表;INSERT INTO emp(id, username, password, name, gender, image, job, entrydate,dept_id, create_time, update_time) VALUES(1,jinyong,123456,金庸,1,1.jpg,4,2000-01-01,2,now(),now()),(2,zhangwuji,123456,张无忌,1,2.jpg,2,2015-01-01,2,now(),now()),(3,yangxiao,123456,杨逍,1,3.jpg,2,2008-05-01,2,now(),now()),(4,weiyixiao,123456,韦一笑,1,4.jpg,2,2007-01-01,2,now(),now()),(5,changyuchun,123456,常遇春,1,5.jpg,2,2012-12-05,2,now(),now()),(6,xiaozhao,123456,小昭,2,6.jpg,3,2013-09-05,1,now(),now()),(7,jixiaofu,123456,纪晓芙,2,7.jpg,1,2005-08-01,1,now(),now()),(8,zhouzhiruo,123456,周芷若,2,8.jpg,1,2014-11-09,1,now(),now()),(9,dingminjun,123456,丁敏君,2,9.jpg,1,2011-03-11,1,now(),now()),(10,zhaomin,123456,赵敏,2,10.jpg,1,2013-09-05,1,now(),now()),(11,luzhangke,123456,鹿杖客,1,11.jpg,5,2007-02-01,3,now(),now()),(12,hebiweng,123456,鹤笔翁,1,12.jpg,5,2008-08-18,3,now(),now()),(13,fangdongbai,123456,方东白,1,13.jpg,5,2012-11-01,3,now(),now()),(14,zhangsanfeng,123456,张三丰,1,14.jpg,2,2002-08-01,2,now(),now()),(15,yulianzhou,123456,俞莲舟,1,15.jpg,2,2011-05-01,2,now(),now()),(16,songyuanqiao,123456,宋远桥,1,16.jpg,2,2007-01-01,2,now(),now()),(17,chenyouliang,123456,陈友谅,1,17.jpg,NULL,2015-03-21,NULL,now(),now());mysql select * from emp;
-------------------------------------------------------------------------------------------------------------------------
| id | username | password | name | gender | image | job | entrydate | dept_id | create_time | update_time |
-------------------------------------------------------------------------------------------------------------------------
| 1 | jinyong | 123456 | 金庸 | 1 | 1.jpg | 4 | 2000-01-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 2 | zhangwuji | 123456 | 张无忌 | 1 | 2.jpg | 2 | 2015-01-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 3 | yangxiao | 123456 | 杨逍 | 1 | 3.jpg | 2 | 2008-05-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 4 | weiyixiao | 123456 | 韦一笑 | 1 | 4.jpg | 2 | 2007-01-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 5 | changyuchun | 123456 | 常遇春 | 1 | 5.jpg | 2 | 2012-12-05 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 6 | xiaozhao | 123456 | 小昭 | 2 | 6.jpg | 3 | 2013-09-05 | 1 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 7 | jixiaofu | 123456 | 纪晓芙 | 2 | 7.jpg | 1 | 2005-08-01 | 1 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 8 | zhouzhiruo | 123456 | 周芷若 | 2 | 8.jpg | 1 | 2014-11-09 | 1 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 9 | dingminjun | 123456 | 丁敏君 | 2 | 9.jpg | 1 | 2011-03-11 | 1 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 10 | zhaomin | 123456 | 赵敏 | 2 | 10.jpg | 1 | 2013-09-05 | 1 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 11 | luzhangke | 123456 | 鹿杖客 | 1 | 11.jpg | 5 | 2007-02-01 | 3 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 12 | hebiweng | 123456 | 鹤笔翁 | 1 | 12.jpg | 5 | 2008-08-18 | 3 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 13 | fangdongbai | 123456 | 方东白 | 1 | 13.jpg | 5 | 2012-11-01 | 3 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 14 | zhangsanfeng | 123456 | 张三丰 | 1 | 14.jpg | 2 | 2002-08-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 15 | yulianzhou | 123456 | 俞莲舟 | 1 | 15.jpg | 2 | 2011-05-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 16 | songyuanqiao | 123456 | 宋远桥 | 1 | 16.jpg | 2 | 2007-01-01 | 2 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 17 | chenyouliang | 123456 | 陈友谅 | 1 | 17.jpg | NULL | 2015-03-21 | NULL | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
-------------------------------------------------------------------------------------------------------------------------
17 rows in set (0.00 sec)mysql select * from dept;
------------------------------------------------------
| id | name | create_time | update_time |
------------------------------------------------------
| 1 | 学工部 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 2 | 教研部 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 3 | 咨询部 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 4 | 就业部 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
| 5 | 人事部 | 2024-05-29 15:41:51 | 2024-05-29 15:41:51 |
------------------------------------------------------
5 rows in set (0.00 sec)创建springboot工程引入对应的起步依赖(web、mybatis、mysql驱动、lombok) 创建完载入 Maven 项目 文件树 准备 Mapper、Service、Controller 等基础结构 Mapper数据访问层首先创建Mapper接口和对应的XML文件或者注解配置用于定义数据访问的方法和SQL语句 Service业务逻辑层接着创建Service接口定义业务逻辑的方法然后创建其实现类实现接口中定义的方法并处理业务逻辑 Controller表示层最后创建Controller类处理请求和响应并调用Service层的方法完成业务逻辑 Mapper DeptMapper.java
package com.futao.tliasspringbootweb.mapper;import org.apache.ibatis.annotations.Mapper;/*** 部门管理*/
Mapper
public interface DeptMapper {
}EmpMapper.java
package com.futao.tliasspringbootweb.mapper;import org.apache.ibatis.annotations.Mapper;/*** 员工管理*/
Mapper
public interface EmpMapper {
}Service DeptService.java
package com.futao.tliasspringbootweb.service;/*** 部门管理*/
public interface DeptService {
}EmpService.java
package com.futao.tliasspringbootweb.service;/*** 员工管理*/
public interface EmpService {
}impl/DeptServiceImpl.java
package com.futao.tliasspringbootweb.service.impl;import com.futao.tliasspringbootweb.service.DeptService;
import org.springframework.stereotype.Service;Service
public class DeptServiceImpl implements DeptService {
}impl/EmpServiceImpl.java
package com.futao.tliasspringbootweb.service.impl;import com.futao.tliasspringbootweb.service.EmpService;
import org.springframework.stereotype.Service;Service
public class EmpServiceImpl implements EmpService {
}Controller DeptController.java
package com.futao.tliasspringbootweb.controller;import org.springframework.web.bind.annotation.RestController;/*** 部门管理Controller*/
RestController
public class DeptController {
}EmpController.java
package com.futao.tliasspringbootweb.controller;import org.springframework.web.bind.annotation.RestController;/*** 员工管理Controller*/
RestController
public class EmpController {
}pojo封装类 Dept.java
package com.futao.tliasspringbootweb.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.time.LocalDateTime;/*** 部门实体类*/
Data
NoArgsConstructor
AllArgsConstructor
public class Dept {private Integer id; //IDprivate String name; //部门名称private LocalDateTime createTime; //创建时间private LocalDateTime updateTime; //修改时间
}Emp.java
package com.futao.tliasspringbootweb.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.time.LocalDate;
import java.time.LocalDateTime;/*** 员工实体类*/
Data
NoArgsConstructor
AllArgsConstructor
public class Emp {private Integer id; //IDprivate String username; //用户名private String password; //密码private String name; //姓名private Short gender; //性别 , 1 男, 2 女private String image; //图像urlprivate Short job; //职位 , 1 班主任 , 2 讲师 , 3 学工主管 , 4 教研主管 , 5 咨询师private LocalDate entrydate; //入职日期private Integer deptId; //部门IDprivate LocalDateTime createTime; //创建时间private LocalDateTime updateTime; //修改时间
}接口统一响应结果封装类 Result.java
package com.futao.tliasspringbootweb.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;Data
NoArgsConstructor
AllArgsConstructor
public class Result {private Integer code;//响应码1 代表成功; 0 代表失败private String msg; //响应信息 描述字符串private Object data; //返回的数据//增删改 成功响应public static Result success(){return new Result(1,success,null);}//查询 成功响应public static Result success(Object data){return new Result(1,success,data);}//失败响应public static Result error(String msg){return new Result(0,msg,null);}
}// { code: , msg: , data: }application.properties
#驱动类名称
spring.datasource.driver-class-namecom.mysql.cj.jdbc.Driver#数据库连接的url
spring.datasource.urljdbc:mysql://localhost:3306/tlias#连接数据库的用户名
spring.datasource.usernameroot#连接数据库的密码
spring.datasource.password你的密码#配置mybatis的日志, 指定输出到控制台
mybatis.configuration.log-implorg.apache.ibatis.logging.stdout.StdOutImpl#开启mybatis的驼峰命名自动映射开关 a_column ------ aCloumn
mybatis.configuration.map-underscore-to-camel-casetrue接口开发规范 REST规范 || 传统规范
