使用Mybatis实现基本的CRUD

一、向数据库插入数据

1.1、在UserDAO中添加addUser方法

 

1.2、在UserMapp.xml中匹配addUser方法，并维护sql语句

<insert id="addUser">
    insert into t_user (id, user_name, passwd) values (#{id}, #{name}, #{passwd})
</insert>

1.3、在controller中测试

@RequestMapping("/t8")
public int t8(){
    int count = dao.addUser(new User(1001L, "mike", "321"));
    return count;
}

二、从数据库查询数据

 

2.2、在UserMapp.xml中匹配login方法，并维护sql语句

<select id="login" resultType="demo.entity.User">
    select * from t_user where user_name=#{userName} and passwd=#{passwd}
</select>

2.3、在controller中测试

@RequestMapping("/login")
public String login(String userName, String passwd){
    User u = dao.login(userName, passwd);
    if(u != null){
        return "登录成功";
    } else {
        return "登录失败";
    }
}

三、根据id修改数据

3.1、在UserDAO中添加updateUser方法

 

3.2、在UserMapp.xml中匹配updateUser方\法，并维护sql语句

<update id="updateUser">
    update t_user set user_name=#{name} , passwd=#{passwd} where id=#{id}
</update>

3.3、在controller中测试

@RequestMapping("/t9")
public int t9(){
    int count = dao.updateUser(new User(1001L, "tom10", "123"));
    return count;
}

四、根据id删除数据

4.1、在UserDAO中添加deleteUser方法

 

4.2、在UserMapp.xml中匹配deleteUser方法，并维护sql语句

<delete id="deleteUser">
    delete from t_user where id=#{id}
</delete>

4.3、在controller中测试

@RequestMapping("/t10")
public int t10(){
    int count = dao.deleteUser(1001L);
    return count;
}

五、完整的代码

5.1、UserDAO

package com.example.democl.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.democl.entity.TUser;

public interface TUserDao extends BaseMapper<TUser> {

    public TUser login(String acc,String pwd);


    public int addUser(TUser user);


    public int updateUser(TUser user);


    public int deleteUser(Long id);
}

5.2、UserMapper.xml

<?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.democl.dao.TUserDao">
    <select id="login" resultType="com.example.democl.entity.TUser">
        select * from t_user where acc=#{acc} and pwd=#{pwd}
    </select>

    <insert id="addUser">
        insert into t_user values(#{id},#{acc},#{pwd})
    </insert>


    <update id="updateUser">
        update t_user set acc=#{acc},pwd=#{pwd} where id=#{id}
    </update>


    <delete id="deleteUser">
        delete  from t_user where id=#{id}
    </delete>
</mapper>

5.3、User.java

package com.example.democl.entity;

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/**
 * (TUser)实体类
 *
 * @author makejava
 * @since 2022-11-15 14:16:05
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("t_user")
public class TUser implements Serializable {
    private static final long serialVersionUID = -49828035127674074L;
    @TableId
    private Long id;
    /**
     * 账号
     */
    private String acc;
    /**
     * 密码
     */
    private String pwd;
}