JAVA模板

 

application.yml

spring:
  profiles:
    active: dev

 

application-dev.yml

server:
  port: 8088

spring:
  datasource:
    username: root
    password: Chen6218
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
  type-aliases-package: com.chentemplate.entity

#showSql
logging:
  level:
    com:
      example:
        mapper : debug

 

 UserMapper.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.register.dao.IUserDao">
    <!--查询所有用户-->
    <select id="queryAll" resultType="com.register.entity.User">
        select * from user
    </select>

    <select id="queryById" resultType="User" parameterType="Integer">
        select * from user where id=#{id}
    </select>



    <insert id="addUser" parameterType="com.register.entity.User">
        insert into User (id,name,age) values(
            #{id},#{name},#{age},)
    </insert>

    <delete id="delUser" parameterType="com.register.entity.User">
        delete from User where id=#{id}
    </delete>


</mapper>

 

 IUserDao

package com.chentemplate.dao;

import com.chentemplate.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
@Mapper
@Repository
public interface IUserDao{
    List<User> findAll();
}

 

 controller

@RestController
public class Test {
    @Resource
    IUserDao iUserDao;
    @GetMapping("/say")
    public List<User> say() {
        return iUserDao.findAll();
    }
}