java eureka spring boot 008SpringBoot--整合MyBatis

目录

1.导入包

2.配置文件

3.mybatis配置

        User

        UserMapper

 application.properties

 application.yml

4.编写sql   UserMapper.xml

5.service层调用dao层

6.controller调用service层

1.导入包

org.mybatis.spring.boot

mybatis-spring-boot-starter

2.1.4

2.配置文件

server.port=8080

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.name=defaultDataSource

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.url=jdbc:mysql://localhost:3306/mapper?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC

3.mybatis配置

        User

@Data

@AllArgsConstructor

@NoArgsConstructor

public class User implements Serializable {

private Integer id;

private String name;

private String pwd;

}

        UserMapper

@Mapper

@Repository

public interface UserMapper {

List queryUserList();

User queryUserById(int id);

int addUser(User user);

int updateUser(User user);

int deleteUser(int id);

}

 application.properties

mybatis.type-aliases-package=com.gh.pojo

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

 application.yml

mybatis:

type-aliases-package: com.gh.pojo

mapper-locations: classpath:mapper/*.xml

4.编写sql   UserMapper.xml

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT * FROM `user`

SELECT * FROM `user` WHERE `id` = #{id}

INSERT INTO `user`(`id`,`name`,`pwd`) VALUES(#{id},#{name},#{pwd})

UPDATE `user` SET `name` = #{name} ,`pwd` = #{pwd} WHERE `id` = #{id}

DELETE FROM `user` WHERE `id` = #{id}

5.service层调用dao层

UserService

public interface UserService {

List queryUserList();

User queryUserById(int id);

int addUser(User user);

int updateUser(User user);

int deleteUser(int id);

}

 UserServiceImpl

@Service

public class UserServiceImpl implements UserService {

@Autowired

UserMapper userMapper;

@Override

public List queryUserList() {

List userList = userMapper.queryUserList();

return userList;

}

@Override

public User queryUserById(int id) {

return userMapper.queryUserById(id);

}

@Override

public int addUser(User user) {

return userMapper.addUser(user);

}

@Override

public int updateUser(User user) {

return userMapper.updateUser(user);

}

@Override

public int deleteUser(int id) {

return userMapper.deleteUser(id);

}

}

6.controller调用service层

@RestController

public class UserController {

@Autowired

private UserService userService;

@GetMapping("/queryUserList")

public List getUserList() {

List userList = userService.queryUserList();

return userList;

}

@GetMapping("/queryUserById/{id}")

public User getUserById(@PathVariable("id") Integer id) {

User user = userService.queryUserById(id);

return user;

}

@GetMapping("/addUser")

public String addUser() {

User user = new User(7, "王五", "654321");

userService.addUser(user);

return "新增成功!!!";

}

@GetMapping("/updateUser")

public String updUser(){

User user = new User(7, "赵六", "123456");

userService.updateUser(user);

return "修改成功!!!";

}

@GetMapping("/deleteUser/{id}")

public String delUser(@PathVariable("id")Integer id){

userService.deleteUser(id);

return "删除成功!!!";

}

}

查看原文