Springboot框架学习2-整合mybatis

目录

1.添加maven依赖

2.properties文件添加连接数据库配置

3.准备数据

4.mapper类

5.service,serviceimpl

6.controller

7.mapper.xml方式实现

8.佛祖保佑永无bug

1.添加maven依赖

 <dependency>  
            <groupId>mysql</groupId>  
            <artifactId>mysql-connector-java</artifactId>  
    </dependency>  
        
    <dependency>  
            <groupId>org.mybatis.spring.boot</groupId>  
            <artifactId>mybatis-spring-boot-starter</artifactId>  
            <version>1.3.0</version>  
    </dependency>  

2.properties文件添加连接数据库配置

server.port=8080
spring.datasource.username=root
spring.datasource.password=talent
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
mybatis.configuration.log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mybatis.mapper-locations=classpath:mapping/*Mapping.xml

3.准备数据

数据库

user bean对象

package com.demo.springlearn.entity;

public class User {
    int id;
    String userName;
    String passWord;
    String realName;

    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 String getRealName() {
        return realName;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", passWord='" + passWord + '\'' +
                ", realName='" + realName + '\'' +
                '}';
    }
}

4.mapper类

注意：1.该类是接口2.添加@Mapper3.sql参数是#{id}形式

package com.demo.springlearn.mapper;
import org.apache.ibatis.annotations.Mapper;
import com.demo.springlearn.entity.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
public interface UserMapper {

    //根据用户id获取用户信息
    @Select("select * from user where id=#{id}")
    User getUserById(@Param("id")int id);
}

5.service,serviceimpl

注意：service类不用加注解，实现类加@Service注解2.

@Autowire引入mapper

package com.demo.springlearn.service;

import com.demo.springlearn.entity.User;

public interface IUserService {
    User getUser(int id);
}

import com.demo.springlearn.entity.User;
import com.demo.springlearn.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements IUserService {
    @Autowired
    UserMapper userMapper;

    @Override
    public User getUser(int id) {
        System.out.println("服务实现类"+id);
        User name = userMapper.getUserById(id);
        return name;
    }
}

6.controller

controller调用service类方法，入口类加mapper扫描

@MapperScan(basePackages = "com.demo.springlearn.mapper")

package com.demo.springlearn.controller;

import com.demo.springlearn.entity.User;
import com.demo.springlearn.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

//RestController是responsebody+Controller两个注解的合体，一般就拿来直接传json数据。
// 为什么可以直接传个对象过去呢？这是因为springboot内置了jackson模块
@RestController
public class UserController {
    @Autowired
    IUserService userService;
    @GetMapping("/getUser")
    public User getUser(@RequestParam int id){
        System.out.println(id);
        return userService.getUser(id);
    }
}

package com.demo.springlearn;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.ComponentScan;
import org.mybatis.spring.annotation.MapperScan;
@SpringBootApplication

//@ComponentScan("com.demo.springlearn")//控制器扫包范围，不加spring不知道控制器范围
//@EnableAutoConfiguration
@MapperScan(basePackages = "com.demo.springlearn.mapper")
public class SpringlearnApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringlearnApplication.class, args);
    }

}

7.mapper.xml方式实现

resource包下创建mapping文件夹，下边建UserMapping.xml

id:对应mapper方法名，parameterType :参数类型，resultType:结果类型

第三行的namespace，它是指定这个xml所对应的是哪个dao（mapper）接口

resultMap是做个pojo

POJO（Plain Ordinary Java Object）简单的Java对象

和数据库表的对应（这里只写个Librarian不用写全路径是因为做了设置，下面会说）

select标签的id对应的就是mapper接口中的方法名，parameterType就是传进来的参数类型

<?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.demo.springlearn.mapper.UserMapper">

    <select id="getUserById" parameterType="INTEGER"
            resultType="com.demo.springlearn.entity.User">
        select * from user where id=#{id}
    </select>


</mapper>

mybatis.mapper-locations=classpath:mapping/*Mapping.xml

配置文件定义xml路径

mybatis.type-aliases-package=com.demo.springlearn.entity设置基本包,设置后xml文件种不用写全路径了

8.佛祖保佑永无bug

创建banner.txt文件，讲文件拷贝到resources目录下

${AnsiColor.BRIGHT_RED}


                           _ooOoo_
                          o8888888o
                          88" . "88
                          (| -_- |)
                          O\  =  /O
                       ____/`---'\____
                     .'  \\|     |//  `.
                    /  \\|||  :  |||//  \
                   /  _||||| -:- |||||-  \
                   |   | \\\  -  /// |   |
                   | \_|  ''\---/''  |   |
                   \  .-\__  `-`  ___/-. /
                 ___`. .'  /--.--\  `. . __
              ."" '<  `.___\_<|>_/___.'  >'"".
             | | :  `- \`.;`\ _ /`;.`/ - ` : | |
             \  \ `-.   \_ __\ /__ _/   .-` /  /
        ======`-.____`-.___\_____/___.-`____.-'======
                           `=---='
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
               // 佛祖保佑 永不宕机 永无BUG //