SpringBoot整个mycat

怼烎@ 2023-07-21 06:18 42阅读 0赞

## spring boot整合mycat，不需要导入mycat包，只需要按照之前操作MySQL的流程去做就行，需要对SQL语句进行一些简单改造： ##

@Insert(“insert into table(字段) values(xxx,x,xxx)”)

## ①创建springboot项目 引入mysql、mybatis ##

```java
    <dependencies>
      	
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    			<version>2.1.0.RELEASE</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<version>2.1.0.RELEASE</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    		
      		<dependency>
    		    <groupId>mysql</groupId>
    		    <artifactId>mysql-connector-java</artifactId>
    		    <version>5.1.6</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-devtools</artifactId>
    			<version>2.1.0.RELEASE</version>
    		</dependency>
    		
    		<dependency>
    		    <groupId>log4j</groupId>
    		    <artifactId>log4j</artifactId>
    		     <version>1.2.17</version>
    		</dependency>
      </dependencies>
    
    ``

## ②创建application.yml文件配置一下信息 ##

![在这里插入图片描述][20200402221916248.png]

## ③创建Product entity类 ##

![在这里插入图片描述][20200402221933188.png]

## ④编写操作数据的mapper ##

![在这里插入图片描述][20200402221948468.png]

## ⑤编写service ##

![在这里插入图片描述][20200402222004955.png]

## ⑥实现类 ##

![在这里插入图片描述][20200402222020310.png]

## ⑦编写handler ##

![在这里插入图片描述][20200402222034867.png]

## ⑧编写启动类 ##

![在这里插入图片描述][20200402222053643.png]

## 如果在程序中出现 packettoolager 问题是mysql的包版本太高，最好降低一下版本 ##

[20200402221916248.png]: /images/20230528/49cb95f686ca4f4f8163c8637aadf6ec.png
[20200402221933188.png]: /images/20230528/bdfc44a89ecd4b8288e22e84c42e2363.png
[20200402221948468.png]: /images/20230528/a9be6d8c97254470b43b54b7aaf970db.png
[20200402222004955.png]: /images/20230528/afcdb1286ab44079a09a2b99746ef90e.png
[20200402222020310.png]: /images/20230528/3863e90d4ad6455b89c37cf2dc737a99.png
[20200402222034867.png]: /images/20230528/68baad0677d14a719041b53e54c181bf.png
[20200402222053643.png]: /images/20230528/41083e30a96a476a987cddff3db27b54.png