工具:idea
Spring官网:https://spring.io/
详细了解博客连接:https://blog.csdn.net/weixin_43591980/article/details/106255122
视频链接:https://www.bilibili.com/video/BV1jJ411S7xr
创建一个maven项目,作为主项目,然后把目录下的src目录删除。
Springcloud父工程的pom.xml文件:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.cloud</groupId>
<artifactId>springcloud</artifactId>
<version>1.0-SNAPSHOT</version>
<!--这个是建springcloud-api module工程的时候自动加上去的-->
<modules>
<module>springcloud-api</module>
</modules>
<!--打包方式 pom-->
<packaging>pom</packaging>
<!--定义版本号-->
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<junit.verson>4.12</junit.verson>
<lombok.verson>1.18.20</lombok.verson>
<log4j.verson>1.2.17</log4j.verson>
</properties>
<dependencyManagement>
<dependencies>
<!--springcloud依赖-->
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>Greenwich.SR1</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<!--springboot依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>2.3.12.RELEASE</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<!--数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.25</version>
</dependency>
<!--数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.6</version>
</dependency>
<!--springboot启动器-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<!--用于日志-->
<!--log4j-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.versoin}</version>
</dependency>
<!--junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${junit.verson}</version>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${lombok.verson}</version>
</dependency>
<!--logback-->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>Logback-core</artifactId>
<version>1.2.3</version>
</dependency>
</dependencies>
</dependencyManagement>
<build></build>
</project>
创建子项目,springcloud-api
项目连接MySQL
然后可能出现连接不成功的状态
首先点击advanced,找到serverTimezone,填写一下参数。
点击Apply,然后点击general,把forever改成never,再输入密码,database里面填写要连接的数据库
然后会弹出询问,然你确认输入密码
就可以看到连接成功了。
连接成功之后想要点击进入里面,可能还会弹出两次询问密码的询问框,弹出来就输入密码就可以了。
到这之后发现建完表后这里没有数据库的数据
点击schemas,上面的name这一行可以把后面的[2]去掉
选择要连接的数据库。
如果没有数据,就回到general再次输入密码连接,然后再回到schemas就会看到有数据出来了
这里你会发现,有两个一样的连接,但是不影响
继续点击确定
建表
表的名称dept,字段等的填写完成之后,点击execute。
表的字段:deptno int;dname varchar(60);db_source varchar(60);
然后插入数据,选中全部数据,点击执行
看到这个证明成功
可以输入查询语句查询select * from cloud01.dept
方法二、在Navicat导航猫里面创建表,然后在idea导入就可以了。
完整的服务提供者项目目录结构
Springcloud-api的pom.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>springcloud</artifactId>
<groupId>com.cloud</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>
<artifactId>springcloud-api</artifactId>
<!--当前的module自己需要的依赖,如果父依赖中已经配置了版本,这里就不用写了-->
<dependencies>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
</dependencies>
</project>
在Springcloud-api下的src下创建dept实体类
package com.springcloud.pojo;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
@Data
@NoArgsConstructor //无参
public class Dept implements Serializable {
private Long deptno;//主键
private String dname;
//这个数据库存在那个数据库的字段~ 微服务,一个服务对应一个数据库,同一个信息可能存在不同的数据库
private String db_source;
//有参
public Dept(String dname) {
this.dname = dname;
}
}
创建子项目,springcloud-provider-dept-8001
springcloud-provider-dept-8001的pom.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>springcloud</artifactId>
<groupId>com.cloud</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion
<artifactId>springcloud-provider-dept-8001</artifactId>
<dependencies>
<!--要拿实体类,所以要配置api module-->
<dependency>
<groupId>com.cloud</groupId>
<artifactId>springcloud-api</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
<!--junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
</dependency>
<!--数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--druid数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
</dependency>
<!--logback-->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
</dependency>
<!--test-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--jetty-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jetty</artifactId>
</dependency>
<!--热部署-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
</dependencies>
</project>
然后mybatis-config.xml文件,这个文件可有可无
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!--开启二级缓存-->
<setting name="cacheEnabled" value="true"/>
</settings>
</configuration>
application.yml文件
server:
port: 8001
#mybatis配置
mybatis:
type-aliases-package: com.springcloud.pojo
config-location: classpath:mybatis/mybatis-config.xml #mybatis的核心配置
mapper-locations: classpath:mybatis/mapper/*.xml
#spring配置
spring:
application:
name: springcloud-provider-dept
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.gjt.mm.mysql.Driver #com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/cloud01?useUnicode=true&characterEncoding=utf-8
username: root
password: sa123
Main—》com.sringcloud.dao—》DeptDao.class
DeptDao
package com.springcloud.dao;
import com.springcloud.pojo.Dept;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface DeptDao {
//增加
public boolean addDept(Dept dept);
//查询
public Dept queryById(Long id);
//查询所有
public List<Dept> queryAll();
}
Service—》DeptService
DeptService
package com.springcloud.service;
import com.springcloud.pojo.Dept;
import java.util.List;
public interface DeptService {
//增加
public boolean addDept(Dept dept);
//查询
public Dept queryById(Long id);
//查询所有
public List<Dept> queryAll();
}
DeptServiceImp
package com.springcloud.service;
import com.springcloud.dao.DeptDao;
import com.springcloud.pojo.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import java.util.List;
@Service
public class DeptServiceImp implements DeptService {
@Autowired
private DeptDao deptDao;
@Override
public boolean addDept(Dept dept) {
return deptDao.addDept(dept);
}
@Override
public Dept queryById(Long id) {
return deptDao.queryById(id);
}
@Override
public List<Dept> queryAll() {
return deptDao.queryAll();
}
}
controller层
DeptController
package com.springcloud.controller;
import com.springcloud.pojo.Dept;
import com.springcloud.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
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.RestController;
import java.util.List;
//提供restful服务
@RestController
public class DeptController {
@Autowired
private DeptService deptService;
@PostMapping("/dept/add")
public boolean addDept(Dept dept){
return deptService.addDept(dept);
}
@GetMapping("/dept/get/{id}")
public Dept get(@PathVariable("id") Long id){
return deptService.queryById(id);
}
@GetMapping("/dept/list")
public List<Dept> queryAll(){
return deptService.queryAll();
}
}
DeptProvider_8001主启动类
package com.springcloud;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
//启动类
@SpringBootApplication
public class DeptProvider_8001 {
public static void main(String[] args) {
SpringApplication.run(DeptProvider_8001.class,args);
}
}
Resources—》mybatis—》mapper—》DeptMapper.xml
DetMapper文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.springcloud.dao.DeptDao">
<insert id="addDept" parameterType="Dept">
insert into dept(dname,db_source)
values (#{dname},DATABASE())
</insert>
<select id="queryById" resultType="Dept" parameterType="Long">
select * from dept where deptno = #{deptno};
</select>
<select id="queryAll" resultType="Dept">
select * from dept;
</select>
</mapper>
然后启动,发现报错
原因是application.yml里面的spring配置启动的那里不合适。
通过查找资料发现 org.gjt.mm.mysql.Driver 是com.mysql.jdbc.Driver的前身,将 org.gjt.mm.mysql.Driver 替换为 com.mysql.jdbc.Driver 就可以了。
然后启动成功
输入localhost://8001/去操作对应的操作就可以了
效果:
如果是想在请求地址栏里面新增一个部门操作的话是新增不了的,报405错误,只能通过post请求添加,不允许这样子添加,证明post请求是安全的。
到此,SpringCloud的服务提供者的学习结束。