SpringBoot如何整合MyBatis?

2025-05-12 14:55:36

1、新建项目maven项目：microcloud-provider-dept-8001

3、创建数据库脚本：DROP DATABASE IF EXISTS mldn_1 ;CREATE DATABASE mldn_1 CHARACTER SET UTF8 ;USE mldn_1 ;CREATE TABLE dept ( deptno BIGINT AUTO_INCREMENT , dname VARCHAR(50) , loc VARCHAR(50) , CONSTRAINT pk_deptno PRIMARY KEY(deptno)) ;INSERT INTO dept(dname,loc) VALUES ('开发部',database()) ;INSERT INTO dept(dname,loc) VALUES ('财务部',database()) ;INSERT INTO dept(dname,loc) VALUES ('市场部',database()) ;INSERT INTO dept(dname,loc) VALUES ('后勤部',database()) ;INSERT INTO dept(dname,loc) VALUES ('公关部',database()) ;

4、创建application.yml配置文件server: port: 8001mybat坡纠课柩is: config-loc锾攒揉敫ation: classpath:mybatis/mybatis.cfg.xml # mybatis配置文件所在路径 type-aliases-package: com.gwolf.vo # 定义所有操作类的别名所在包 mapper-locations: # 所有的mapper映射文件 - classpath:mybatis/mapper/**/*.xmlspring: datasource: type: com.alibaba.druid.pool.DruidDataSource # 配置当前要使用的数据源的操作类型 driver-class-name: com.mysql.cj.jdbc.Driver # 配置MySQL的驱动程序类 url: jdbc:mysql://localhost:3306/mldn_1?serverTimezone=UTC # 数据库连接地址 username: root # 数据库用户名 password: root # 数据库连接密码 dbcp2: # 进行数据库连接池的配置 min-idle: 5 # 数据库连接池的最小维持连接数 initial-size: 5 # 初始化提供的连接数 max-total: 5 # 最大的连接数 max-wait-millis: 200 # 等待连接获取的最大超时时间 application: name: microcloud-provider-deptsecurity: user: name: gwolf #用户名 password: gwolf #密码 role: #授权角色 - USER

6、创建mybatis配置文件：<?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>

7、创建dept.xml文件<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.gwolf.microcloud.dao.IDeptDAO"> <select id="findById" resultType="Dept" parameterType="long"> SELECT deptno,dname,loc FROM dept WHERE deptno=#{deptno} ; </select> <select id="findAll" resultType="Dept"> SELECT deptno,dname,loc FROM dept ; </select> <insert id="doCreate" parameterType="Dept"> INSERT INTO dept(dname,loc) VALUES (#{dname},database()) ; </insert></mapper>

9、创建DAO类：package com.gwolf.microcloud.dao;import com.gwolf.vo.Dept;import org.apache.ibatis.annotations.Mapper;import java.util.List;@Mapperpublic interface IDeptDAO { public boolean doCreate(Dept vo); public Dept findById(Long id); public List<Dept> findAll();}

11、编写项目测试类：package com.gwolf.microcloud.service;import com.gwolf.micro艘早祓胂cloud.Dept_8001_StartSpringCloudApplication;import com.gwolf.vo.Dept;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import org.springframework.test.context.web.WebAppConfiguration;import javax.annotation.Resource;@SpringBootTest(classes = Dept_8001_StartSpringCloudApplication.class)@RunWith(SpringJUnit4ClassRunner.class)@WebAppConfigurationpublic class IDeptServiceTest { @Resource private IDeptService deptService; @Test public void testGet() { System.out.println(this.deptService.get(1)); } @Test public void testAdd() { Dept dept = new Dept(); dept.setDname("测试部-" + System.currentTimeMillis()); System.out.println(this.deptService.add(dept)); } @Test public void testList() { System.out.println(this.deptService.list()); }}

声明：本网站引用、摘录或转载内容仅供网站访问者交流或参考，不代表本站立场，如存在版权或非法内容，请联系站长删除，联系邮箱：site.kefu@qq.com。