mybatis基本操作

灵琴304

已于 2022-03-13 23:40:35 修改

阅读量86

点赞数

文章标签： java 开发语言后端

于 2021-10-28 14:18:00 首次发布

本文链接：https://blog.csdn.net/mjlq_/article/details/121013357

版权

controller

package com.zj.beihai.controller;

import com.zj.beihai.pojo.TiMu;
import com.zj.beihai.service.TiMuService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@CrossOrigin
@RequestMapping("/TiMu")
public class TiMuController {
    @Autowired
    private TiMuService tiMuService;
@GetMapping("chaxun")
public List<TiMu> chaxun() {
    return tiMuService.chaxun();
}
}

service

package com.zj.beihai.service;

import com.zj.beihai.pojo.TiMu;

import java.util.List;

public interface TiMuService {

    List<TiMu> chaxun();
}

servicelmpl

package com.zj.beihai.service.servicelmpl;

import com.zj.beihai.mapper.TiMuMapper;
import com.zj.beihai.pojo.TiMu;
import com.zj.beihai.service.TiMuService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class TiMuServiceImpl implements TiMuService {
    @Autowired
    private TiMuMapper tiMuMapper;
    @Override
    public List<TiMu> chaxun() {
return tiMuMapper.selectList();

    }
}

TiMumapper.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.zj.beihai.mapper.TiMuMapper">
    <select id="selectList" resultType="TiMu">
        select * from tiMu
    </select>
</mapper>

application.yml

server:
  port: 8091
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/beihai?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
    username: root
    password: root

mybatis-plus:
  type-aliases-package: com.zj.beihai.pojo
  mapper-locations: classpath:/mappers/*.xml
  configuration:
    map-underscore-to-camel-case: true
logging:
  level:
    com.jt.mapper: debug

debug: false

http://localhost:8091/TiMu//chaxun