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+学习笔记图***
最后再分享一份终极手撕架构的大礼包(学习笔记):分布式+微服务+开源框架+性能优化