SpringBoot中的mybatis以及打包部署到云主机

工程目录&＃xff1a;

application.properties

# MySQL 数据源
spring.datasource.url&＃61;jdbc:mysql://111.229.66.196:3306/test
#windows系统
#spring.datasource.url&＃61;jdbc:mysql://111.229.66.196:3306/test?serverTimezone&＃61;UTC
spring.datasource.username&＃61;test
spring.datasource.password&＃61;test
spring.datasource.driver-class-name&＃61;com.mysql.cj.jdbc.Driver#日志信息
logging.level.web&＃61;debug#详细信息
spring.http.log-request-details&＃61;trueserver.port&＃61;9000


Dept.java

package com.newer.mybatis2.pojo;
/*** 部门* &＃64;author Admin**/
public class Dept {/*** 编号*/int id;/*** 名称*/String title;/*** 所在地*/String loc;// 构造器public Dept() {}// getters,setterspublic int getId() {return id;}public void setId(int id) {this.id &＃61; id;}public String getTitle() {return title;}public void setTitle(String title) {this.title &＃61; title;}public String getLoc() {return loc;}public void setLoc(String loc) {this.loc &＃61; loc;}&＃64;Overridepublic String toString() {return "Dept [id&＃61;" &＃43; id &＃43; ", title&＃61;" &＃43; title &＃43; ", loc&＃61;" &＃43; loc &＃43; "]";}}


Staff.java

package com.newer.mybits.pojo;/*** 员工&＃xff08;POJO&＃xff09;实体类* * &＃64;author wtao**/
public class Staff {/*** 编号&＃xff08;PK&＃xff09;*/private int id;/*** 姓名*/private String name;/*** 职位*/private String job;/*** 手机号*/private String phone;public Staff() {}public int getId() {return id;}public void setId(int id) {this.id &＃61; id;}public String getName() {return name;}public void setName(String name) {this.name &＃61; name;}public String getJob() {return job;}public void setJob(String job) {this.job &＃61; job;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone &＃61; phone;}&＃64;Overridepublic String toString() {return "Staff [id&＃61;" &＃43; id &＃43; ", name&＃61;" &＃43; name &＃43; ", job&＃61;" &＃43; job &＃43; ", phone&＃61;" &＃43; phone &＃43; ", getId()&＃61;" &＃43; getId()&＃43; ", getName()&＃61;" &＃43; getName() &＃43; ", getJob()&＃61;" &＃43; getJob() &＃43; ", getPhone()&＃61;" &＃43; getPhone() &＃43; ", getClass()&＃61;"&＃43; getClass() &＃43; ", hashCode()&＃61;" &＃43; hashCode() &＃43; ", toString()&＃61;" &＃43; super.toString() &＃43; "]";}}


DeptMapper.java

package com.newer.mybatis2.mapper;import java.util.List;import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;import com.newer.mybatis2.pojo.Dept;
/*** * 封装了Dept实体类的数据操作*&＃xff08;CRUD)* Mapper:映射&＃xff0c;把对象的字段&＃xff08;或者状态&＃xff09;投影到关系数据中的一条记录* &＃64;author Admin**/
&＃64;Mapper
public interface DeptMapper {&＃64;Select("select * from dept_9")ListfindALL();&＃64;Select("select * fom dept_9 where id&＃61;#{id}")Dept find(int id);// 基于反射&＃xff1a;根据类名知道类的属性&＃xff0c;方法等
// 反射&＃xff1a;某个类型的父类&＃xff0c;实现了那些接口&＃xff0c;字段&＃xff0c;方法&＃64;Insert("insert into dept_9(title,loc) values(#{title},#{loc})")void create (Dept d);&＃64;Update("update dept_9 set title&＃61;#{title},loc&＃61;#{loc} where id&＃61;#{id}")void update(Dept dept);&＃64;Delete("delete from dept_9 where id&＃61;#{id}")void remove(int id);}


StaffMapper.java

package com.newer.mybits.mapper;import java.util.List;import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;import com.newer.mybits.pojo.Staff;/*** 数据持久化&＃xff08;存储&＃xff09;* * MyBatis 是 SQL 映射框架&＃xff08;ORM 对象关系映射 / hibernate JPA &＃xff09;* * &＃64;author wtao**/
// 标签&＃xff0c;扮演特定的角色/具备功能
&＃64;Mapper
public interface StaffMapper {/*** SQL 语句映射成一个抽象方法&＃xff08;MyBatis 框架实现了抽象方法&＃xff09;* * &＃64;param staff*/&＃64;Insert("insert into staff(name,job,phone) values(#{name},#{job},#{phone})")void save(Staff staff);&＃64;Select("select * from staff")List findAll();// #{field} 参数&＃64;Select("select * from staff where id&＃61;#{id}")Staff findById(int id);/*** 删除* * &＃64;param id 是记录主键&＃xff0c;#{id}*/&＃64;Delete("delete from staff where id&＃61;#{id}")void remove(int id);/*** 更新&＃xff1a;SQL --> 抽象方法* * &＃64;param staff 封装了新数据的参数对象*/&＃64;Update("update staff set name&＃61;#{name},job&＃61;#{job},phone&＃61;#{phone} where id&＃61;#{id}")void update(Staff staff);}


DeptController.java

package com.newer.mybatis2.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import com.newer.mybatis2.mapper.DeptMapper;
import com.newer.mybatis2.pojo.Dept;//启用跨域访问
&＃64;CrossOrigin&＃64;RestController
&＃64;RequestMapping("/api/dept")
public class DeptController {/*** 自动装配&＃xff08;注入当前组件依赖的数据操作——&＃xff09;*/&＃64;AutowiredDeptMapper deptMapper;&＃64;GetMapping()public Listlist(){return deptMapper.findALL();}&＃64;GetMapping("/{id}")public Dept load(&＃64;PathVariable int id) {return deptMapper.find(id);}// Post JSON&＃64;PostMapping()public void create(&＃64;RequestBody Dept d) {deptMapper.create(d);}&＃64;PutMapping("/{id}")public void update(&＃64;PathVariable int id,&＃64;RequestBody Dept dept) {// 设置更新数据的iddept.setId(id);deptMapper.update(dept);}&＃64;DeleteMapping("/{id}")public ResponseEntity delete(&＃64;PathVariable int id) {deptMapper.remove(id);// 推荐return new ResponseEntity(HttpStatus.OK);}
}


StaffController.java

package com.newer.mybits.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import com.newer.mybits.mapper.StaffMapper;
import com.newer.mybits.pojo.Staff;/*** 控制器&＃xff1a;定义 RESTful API 接口* * &＃64;author wtao**/
&＃64;RestController
//&＃64;RequestMapping("/api/v1/staff")
&＃64;RequestMapping("/api/staff")
public class StaffController {// 依赖关系&＃xff1a;控制器需要数据访问或业务逻辑// 控制器的方法需要用到 mapper 成为依赖// Spring 容器完成依赖注入&＃xff1a;为 mapper 赋值&＃xff0c;不再为 null&＃64;AutowiredStaffMapper mapper;// GET "/api/staff"&＃64;GetMappingpublic List findAll() {return mapper.findAll();}// GET "/api/staff/{id}"&＃64;GetMapping("/{id}")public Staff findById(&＃64;PathVariable int id) {return mapper.findById(id);}// POST "/api/staff"/*** * &＃64;param staff HTTP 请求头中负载 JSON 格式* &＃64;return*/&＃64;PostMappingpublic ResponseEntity create(&＃64;RequestBody Staff staff) {mapper.save(staff);return new ResponseEntity(HttpStatus.OK);}// PUT "/api/staff/{id}"&＃64;PutMapping("/{id}")public ResponseEntity update(&＃64;PathVariable int id, &＃64;RequestBody Staff staff) {staff.setId(id);mapper.update(staff);return new ResponseEntity<>(HttpStatus.OK);}// DELETE "/api/staff/{id}&＃64;DeleteMapping("/{id}")public void remove(&＃64;PathVariable int id) {mapper.remove(id);// TODO ResponseEntity 可选}}


打包部署到云主机

出现这个&＃xff0c;表示成功

部署的要求&＃xff1a;

扩展&＃xff1a;