《MySql面试专题》
《MySql性能优化的21个最佳实践》
《MySQL高级知识笔记》
文中展示的资料包括:**《MySql思维导图》《MySql核心笔记》《MySql调优笔记》《MySql面试专题》《MySql性能优化的21个最佳实践》《MySq高级知识笔记》**如下图
关注我,点赞本文给更多有需要的人
我们首先创建一个springBoot项目用于用于存放一些公共服务接口及公共的Bean等
项目结构如下:
接下来我们先把通用服务以及实体类写好
User
public class User {
private Integer id;
private String userName;
private String passWord;
private Integer enabled;
public User(){}
public User(Integer id, String userName){
this.id=id;
this.userName=userName;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassWord() {
return passWord;
}
public void setPassWord(String passWord) {
this.passWord = passWord;
}
public Integer getEnabled() {
return enabled;
}
public void setEnabled(Integer enabled) {
this.enabled = enabled;
}
}
BaseResult
package com.cloud.api.po;
import com.fasterxml.jackson.annotation.JsonInclude;
import org.springframework.util.ObjectUtils;
@JsonInclude(JsonInclude.Include.NON_NULL)
public class BaseResult {
private static final long serialVersionUID = 1L;
private Integer code;
private String msg;
private Object data;
private Long count;
public BaseResult() {
}
public BaseResult(Integer code, String msg, Object data, Long count) {
this.code = code;
this.msg = msg;
this.data = data;
this.count = count;
}
public void markSuccess(String msg, Object data, Long count) {
this.code = 200;
this.msg = msg;
this.data = data;
this.count = count;
}
public void markSysError(String msg) {
this.code = 500;
this.msg = msg;
}
public void markWarning(String msg) {
this.code = 0;
this.msg = msg;
}
public boolean checkSuccess() {
return ObjectUtils.isEmpty(this.getCode()) && 200 == this.getCode();
}
public boolean checkSuccessWData() {
return this.checkSuccess() && ObjectUtils.isEmpty(this.getData());
}
public Integer getCode() {
return this.code;
}
public void setCode(Integer code) {
this.code = code;
}
public String getMsg() {
return this.msg;
}
public void setMsg(String msg) {
this.msg = msg;
}
public Object getData() {
return this.data;
}
public void setData(Object data) {
this.data = data;
}
public Long getCount() {
return this.count;
}
public void setCount(Long count) {
this.count = count;
}
public String toString() {
return “BaseResult [code=” + this.code + “, msg=” + this.msg + “, data=” + this.data + “, count=” + this.count + “]”;
}
}
UserService
package com.cloud.api.provider.service;
import com.cloud.api.provider.po.User;
public interface UserService {
public User getUser(Integer userId,String userName);
}
注意:在打包之前去掉spring-boot-maven-plugin插件,点击此处查看原因
=========================================================================
新建一个SpringBoot web项目用于Eureka注册中心
org.springframework.cloud
spring-cloud-starter-netflix-eureka-server
2.2.1.RELEASE
com.cloud
api
0.0.1-SNAPSHOT
server.port=8080
#eureka.instance.hostname Eureka服务端实例名称
eureka.instance.hostname=eureka-server
#eureka.client.register-with-eureka 是否向注册中心注册自己
eureka.client.register-with-eureka=false
#eureka.client.fetch-registry 是否从Eureka上获取服务的注册信息,自己就是注册中心,本身职责就是维护服务实例,并不需要去检索服务
eureka.client.fetch-registry=false
#eureka.client.service-url.defaultZone 设置与Eureka Server交互的地址(查询服务、注册服务等)
eureka.client.service-url.defaultZone=http://localhost:${server.port}/eureka/
3.在主程序类上添加@EnableEurekaServer注解启用注册中心功能
package com.cloud.eureka;
import com.cloud.api.po.BaseBean;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.netflix.eureka.server.EnableEurekaServer;
@SpringBootApplication
@EnableEurekaServer //启用Eureka注册中心功能
public class EurekaApplication {
public static void main(String[] args) {
SpringApplication.run(EurekaApplication.class, args);
}
}
4.启动项目后访问http://localhost:8080/查看服务启动情况
=======================================================================
新建SpringBoot web项目用于服务提供者
org.springframework.cloud
spring-cloud-starter-netflix-eureka-client
2.2.5.RELEASE
com.cloud
api
0.0.1-SNAPSHOT
server.port=8081
spring.application.name=user-provider
#eureka.instance.prefer-ip-address 注册服务的时候使用服务的ip地址
eureka.instance.prefer-ip-address=true
eureka.client.service-url.defaultZone=http://localhost:8080/eureka/
UserServiceImpl
package com.cloud.provider.serviceImpl;
import com.cloud.api.provider.po.User;
import com.cloud.api.provider.service.UserService;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl implements UserService {
@Override
public User getUser(Integer userId,String userName) {
return new User(userId,userName);
}
}
总结
总的来说,面试是有套路的,一面基础,二面架构,三面个人。
最后,小编这里收集整理了一些资料,其中包括面试题(含答案)、书籍、视频等。希望也能帮助想进大厂的朋友
ice {
@Override
public User getUser(Integer userId,String userName) {
return new User(userId,userName);
}
}
总结
总的来说,面试是有套路的,一面基础,二面架构,三面个人。
最后,小编这里收集整理了一些资料,其中包括面试题(含答案)、书籍、视频等。希望也能帮助想进大厂的朋友
[外链图片转存中…(img-B9MUmLBl-1715649896209)]
[外链图片转存中…(img-iWYFuLcQ-1715649896209)]