【Spring Boot 9，Java中级高级面试题及答案

import life.majiang.community.bean.User;

import life.majiang.community.mapper.UserMapper;

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

import org.springframework.stereotype.Controller;

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

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

@Controller

public class UserController {

@Autowired

UserMapper userMapper;

@Autowired

User user;



@GetMapping("/getUserById")

public String getUserById(@RequestParam(name="id") String id){

    System.out.println(userMapper.getUserById(id).name);

    return "index";

}



@GetMapping("/getUsers")

public String getUsers(){

    return "index";

}



@GetMapping("/insertUser")

public String insertUser(@RequestParam(name="id") String id,@RequestParam(name="name") String name,@RequestParam(name="password") String password){

    user.setId(id);

    user.setName(name);

    user.setPassword(password);

    userMapper.insertUser(user);

    return "index";

}

}

2、UserMapper

------------

package life.majiang.community.mapper;

import life.majiang.community.bean.User;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Select;

public interface UserMapper {

@Select("select * from user where id=#{id}")

public User getUserById(String id);



@Insert("insert into user(ID,name,password) values (#{id},#{name},#{password})")

public void insertUser(User user);



@Select("select * from user")

public User getUsers();

}

3、测试

----



  

![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0L3VwLTM4ZjcxYTVhYWQ5N2IwMDIwNzBmMjU0NjE2MmIxMjEzOWYyLnBuZw?x-oss-process=image/format,png)



五、配置实现增删改查

==========

package life.majiang.community.controller;

import life.majiang.community.bean.User;

import life.majiang.community.mapper.UserMapper;

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

import org.springframework.stereotype.Controller;

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

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

@Controller

public class UserController {

@Autowired

UserMapper userMapper;

@Autowired

User user;



@GetMapping("/getUserById2")

public String getUserById2(@RequestParam(name="id") String id){

    System.out.println(userMapper.getUserById2(id).name);

    return "index";

}



@GetMapping("/insertUser2")

public String insertUser2(@RequestParam(name="id") String id,@RequestParam(name="name") String name,@RequestParam(name="password") String password){

    user.setId(id);

    user.setName(name);

    user.setPassword(password);

    userMapper.insertUser2(user);

    return "index";

}



@GetMapping("/deleteUserById")

public String deleteUserById(@RequestParam(name="id") String id){

    userMapper.deleteUserById(id);

    return "index";

}

}

1、UserMapper

------------

package life.majiang.community.mapper;

import life.majiang.community.bean.User;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Select;

public interface UserMapper {

public User getUserById2(String id);

public void insertUser2(User user);

public void deleteUserById(String id);

}

2、UserMapper.xml

----------------

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

<select id="getUserById2" resultType="life.majiang.community.bean.User">

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

</select>

  insert into user(ID,name,password) values (#{id},#{name},#{password});

最后

这次要给大家分享总结的东西就是这些了

资料全都放在——***我的学习笔记：大厂面试真题+微服务+MySQL+Java+Redis+算法+网络+Linux+Spring全家桶+JVM+学习笔记图***

最后再分享一份终极手撕架构的大礼包(学习笔记)：分布式+微服务+开源框架+性能优化

2">

  insert into user(ID,name,password) values (#{id},#{name},#{password});

最后

这次要给大家分享总结的东西就是这些了

资料全都放在——***我的学习笔记：大厂面试真题+微服务+MySQL+Java+Redis+算法+网络+Linux+Spring全家桶+JVM+学习笔记图***

最后再分享一份终极手撕架构的大礼包(学习笔记)：分布式+微服务+开源框架+性能优化