mariadb 数据库连接使用
mariadb 数据库连接使用 mariadb 数据库连接使用mariadb 数据库连接使用mariadb 数据库连接使用
·
今天测试了使用mariadb的使用,我使用的springboot + mariadb 来操作数据库,和以前的代码基本一样,就数据变成了mariadb ,驱动还是使用mysql的。
pom 文件如下
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.2.2.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.handan</groupId> <artifactId>deda</artifactId> <version>0.0.1-SNAPSHOT</version> <name>deda</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.1</version> </dependency> <!-- 与数据库操作相关依赖 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.62</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <!--<dependency>--> <!--<groupId>com.oracle.ojdbc</groupId>--> <!--<artifactId>ojdbc8</artifactId>--> <!--<scope>runtime</scope>--> <!--</dependency>--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-typehandlers-jsr310</artifactId> <version>1.0.1</version> </dependency> <!--<dependency>--> <!--<groupId>io.springfox</groupId>--> <!--<artifactId>springfox-swagger2</artifactId>--> <!--<version>2.9.2</version>--> <!--</dependency>--> <!--<dependency>--> <!--<groupId>io.springfox</groupId>--> <!--<artifactId>springfox-swagger-ui</artifactId>--> <!--<version>2.9.2</version>--> <!--</dependency>--> <!--<dependency>--> <!--<groupId>io.swagger</groupId>--> <!--<artifactId>swagger-core</artifactId>--> <!--<version>1.5.22</version>--> <!--</dependency>--> <!--<dependency>--> <!--<groupId>io.swagger</groupId>--> <!--<artifactId>swagger-models</artifactId>--> <!--<version>1.5.22</version>--> <!--</dependency>--> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.25</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>1.1.11</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>1.1.11</version> </dependency> <!--后台调用restful接口的jar包--> <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpclient</artifactId> <version>4.5.6</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> </excludes> </configuration> </plugin> </plugins> </build> </project>
mapper 层的代码如下
@Repository public interface StuMapper { @Insert("insert into stu(sid,name,number,age) values(#{sid},#{name},#{number},#{age})") public void add(Stu stu); }
配置文件如下
server: port: 8050 tomcat: max-http-header-size: 8192 uri-encoding: utf-8 #测试环境 spring: datasource: url: jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&serverTimezone=CTT&useSSL=false&useUnicode=true&autoReconnect=true username: root password: root driver-class-name: com.mysql.cj.jdbc.Driver mybatis: type-aliases-package: com.handan.deda.entity mapper-locations: classpath:mappers/*.xml swagger: enable: true
最后是可以成功添加数据,估计是两个的驱动是可以互换的
开启远程连接代码入下:
grant all privileges on *.* to 'root'@'%'identified by 'root';
刷新配置: flush privileges;
更多推荐
已为社区贡献1条内容
所有评论(0)