ssm整合mybatis文件

简化了JDBC

spring整合了mybatis

#语法: 1.key:(空格)value结构
server:
  port: 8080

#整合1.数据源
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/jtadmin?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
    username: root
    password: root

#SpringBoot整合mybatis
mybatis:
  #指定别名包
  type-aliases-package: com.jt.pojo
  #加载指定的xml映射文件
  mapper-locations: classpath:/mybatis/mappers
    @RequestMapping("/getUser")
    public List findUser(){
        return userService.findAll();
    }

    
    @GetMapping("findById")//只能接口Get请求类型
    public User findUserById(Integer id){
        return userService.findUserById(id);
    }

    @GetMapping("findByNA")
    public Object findUserByNA(Integer id,String name,Integer age,String sex){
        return userService.findUserByNA(id,name, age,sex);
    }


    //可以利用MVC可以直接将参数写到方法中,通过URL获取
    @GetMapping("/MVCCC")
    public String demo(String name){
        return "值"+name;
    }



}

pojo层,封装数据类型

service层,  @service    @Autowired

package com.jt.service;

import com.jt.mapper.UserMapper;
import com.jt.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service   //将该类交给spring容器管理
public class UserServiceImpl implements UserService{
    @Autowired
    private UserMapper userMapper;//代理对象,JDK动态代理

    @Override
    public List findAll(){
//        List userList = userMapper.findAll();
//        return userList;
        return userMapper.findAll();
    }
    @Override
    public User findUserById(Integer id){
        return userMapper.findUserById(id);
    }
    @Override
    public User findUserByNA(Integer id, String name,Integer age,String sex){
        Map m = new HashMap();
        m.put("id", id);
        m.put("name", name);
        m.put("age", age);
        m.put("sex", sex);
        return userMapper.findUserByNA(m);
    }



}

mapper层 写接口,可以自动生成

package com.jt.mapper;

import com.jt.pojo.User;

import java.util.List;
import java.util.Map;

public interface UserMapper {
    //查询demo_user表中的所有数据
    List findAll();
    //根据ID查询数据
    User findUserById(Integer id);

    User findUserByNA(Map map);
}