一、添加Mybatis环境
在创建项目时,添加以下依赖:
2.设置项目配置文件
配置数据库、mybatis xml保存路径和端口
二、基于Mybatis环境操作数据库
1.添加用户实体类
@Data
public class UserInfo {
private int uid;
private String username;
private String password;
private String nickname;
private String img;
private String git;
private int state;
}
2.添加接口
@Mapper
public interface UserMapper {
public UserInfo getUserById(Integer uid);
public Integer addUser(UserInfo userInfo);
}
3.添加mybatis的配置文件(基于自己要实现的功能灵活使用sql语句)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.first_mybits.mapper.UserMapper">
<select id="getUserById" resultType="com.example.first_mybits.model.UserInfo">
select * from userinfo where uid=#{uid} <!--uid为getUserById这个方法的参数-->
</select>
<insert id="addUser">
insert into userinfo(uid,username,password,nickname,img,git,state)
values(#{uid},#{username},#{password},#{nickname},#{img},#{git},1)
</insert>
</mapper>
4.添加service
@Service
public class UserService {
@Resource
private UserMapper userMapper;//可以注入接口
public UserInfo getUserById(Integer uid){
return userMapper.getUserById(uid);//接口中的方法已经在mapper.xml中实现了,可以正常使用
}
public Integer addUser(UserInfo userInfo){
return userMapper.addUser(userInfo);
}
}
6.添加controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;//注入
@RequestMapping("/getuserbyid")
public UserInfo getUserById(Integer uid){
if(uid!=null && uid>0){
//参数有效
return userService.getUserById(uid);//注入,调用
}else {
return new UserInfo();//返回空的UserInfo
}
}
@RequestMapping("adduser")
public Integer add(UserInfo userInfo){
return userService.addUser(userInfo);
}
}
结构