14-整合Mybaits数据库

3.UserMapper

---

package com.tian.mapper;

import com.tian.pojo.User;

import org.apache.ibatis.annotations.Mapper;

import org.springframework.stereotype.Repository;

import java.util.List;

//也可以在启动类用@MapperScan(“com.tian.mapper”)

@Mapper

@Repository //把他放在spring

public interface UserMapper {

List queryList();

User queryUserById(int id);

int addUser(User user);

int updateUser(User user);

int deleteUser(int id);

}

4.UserMapper.xml

---

<?xml version="1.0" encoding="UTF-8" ?>

select * from user

select * from user where id=#{id}

<inse

必看视频！获取2024年最新Java开发全套学习资料 备注Java

rt id=“addUser” parameterType=“User”>

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.serivce层调用dao层 (略过)

---

6.controller层调用service层

---

package com.tian.controller;

import com.tian.mapper.UserMapper;

import com.tian.pojo.User;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController

public class UserController {

@Autowired

private UserMapper userMapper;

@GetMapping(“queryList”)

public List queryList(){

List userList=userMapper.queryList();

// for (User user:

// userList) {

// System.out.println(user);

// }

return userList;

}

//添加一个用户

@GetMapping(“/addUser”)

public String addUser(){

userMapper.addUser(new User(6,“阿毛”,“456465”));

return “ok”;

}

//修改一个用户

@GetMapping(“/updateUser”)

public String updateUser(){

userMapper.updateUser(new User(6,“小阿毛”,“456465”));

写在最后

还有一份JAVA核心知识点整理（PDF）：JVM，JAVA集合，JAVA多线程并发，JAVA基础，Spring原理，微服务，Netty与RPC，网络，日志，Zookeeper，Kafka，RabbitMQ，Hbase，MongoDB，Cassandra，设计模式，负载均衡，数据库，一致性哈希，JAVA算法，数据结构，加密算法，分布式缓存，Hadoop，Spark，Storm，YARN，机器学习，云计算…

A集合，JAVA多线程并发，JAVA基础，Spring原理，微服务，Netty与RPC**，网络，日志，Zookeeper，Kafka，RabbitMQ，Hbase，MongoDB，Cassandra，设计模式，负载均衡，数据库，一致性哈希，JAVA算法，数据结构，加密算法，分布式缓存，Hadoop，Spark，Storm，YARN，机器学习，云计算…

[外链图片转存中…(img-M5TlWWsC-1716379042158)]