感谢大坏蛋的鼎力相助!!!MyBatisPlus

一、添加依赖

​
<!-- MyBatisPlus依赖-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>
<!--LomBok依赖-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId> <optional>true</optional>
</dependency>
<!--mysql依赖-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>


​

二、配置数据源

spring:
    # 配置数据源信息 spring顶格写
    datasource:
        # 配置数据源类型
        type: com.zaxxer.hikari.HikariDataSource
        # 配置连接数据库信息
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/mybatis_plus?characterEncoding=utf-8&useSSL=false
        username: root
        password: 123456

三、在启动类上扫描dao的路径

 四、创建实体并与数据库表关联

package demo.entity;

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

@Data //生成Get和Set方法，重写toString
@AllArgsConstructor //生成有参构造器
@NoArgsConstructor //生成无参构造器
@TableName("t_user") //设置表名
public class User {
    @TableId //指定主键id
    private Long id;

    private String userName;
    private String passwd;
}

五、创建dao继承自BaseMapper

package demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import demo.entity.User;

public interface UserDAO extends BaseMapper<User> {

}

六、在controller中测试

第1步：通过AutoWired注解实例化dao对象

 @Autowired(required = false)
    private UserDAO dao;

第2步：调用dao方法实现增删改查

@RequestMapping("/t2")
public int insertUser(){
    int count = dao.insert(new User(null, "tom", "123"));
    return count;
}

运行效果

接下来使用MyBatisPlus实现基本的CRUD操作 

第1步：实例化UserDAO对象

@Autowired(required = false)
    private UserDAO dao;

第2步：使用MyBatisPlus实现基本的CRUD

/**
 * 测试向数据库中插入数据
 * @return
 */
@RequestMapping("/t2")
public int insertUser(){
    int count = dao.insert(new User(null, "tom", "123"));
    return count;
}
​
/**
 * 测试查询全部数据库中的数据
 * @return
 */
@RequestMapping("/t3")
public List<User> t3(){
    //查询全部
    List<User> users = dao.selectList(null);
    return users;
}
​
/**
 * 测试根据ID查询数据
 * @return
 */
@RequestMapping("/t4")
public User t4(){
    //根据id查询
    User u = dao.selectById(1001l);
    return u;
}
​
/**
 * 测试根据id修改数据
 * @return
 */
@RequestMapping("/t5")
public int t5(){
    //根据id修改
    int count = dao.updateById(new User(1592405843226775554L, "mike", "321"));
    return count;
}
​
/**
 * 测试根据id删除数据
 * @return
 */
@RequestMapping("/t6")
public int t6(){
    int count = dao.deleteById(1001l);
    return count;
}
​
/**
 * 测试根据id批量删除数据
 * @return
 */
@RequestMapping("/t7")
public int t7(){
    int count = dao.deleteBatchIds(Arrays.asList(1592419001718865921L, 1592419001144246274L));
    return count;
}

MyBatis的处理流程图(区别于上面的处理方式,接下来是用sql语句实现相同的功能)

 1、在resources文件夹下创建mappers文件夹

 2、在application.yml配置文件中配置mapper文件夹

#mybatisPlus相关配置
mybatis-plus:
  mapper-locations: classpath:mappers/*.xml

3、在mapper中添加登录的方法

 4、在mappers文件夹中创建UserMapper.xml文件并且通过namespace指定DAO接口的路径

<?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="demo.dao.UserDAO">
​
</mapper>

5、维护login方法的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="demo.dao.UserDAO">
​
    <select id="login" resultType="demo.entity.User">
        select * from t_user where user_name=#{userName} and passwd=#{passwd}
    </select>
</mapper>

6、在controller中测试

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

按照上面的列子接下来使用MyBatis实现基本CRUD

(在UserDAO中添加相应的方法--->在UserMapp.xml中匹配对应的方法，并维护sql语句--->在controller中测试)

完整的代码如下

UserDAO

package demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import demo.entity.User;

public interface UserDAO extends BaseMapper<User> {

    public User login(String userName, String passwd);

    public int addUser(User user);

    public int updateUser(User user);

    public int deleteUser(Long id);
}

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="demo.dao.UserDAO">
<select id="login" resultType="demo.entity.User">
    select * from t_user where user_name=#{userName} and passwd=#{passwd}
</select>
    <insert id="addUser">
        insert into t_user(id,user_name,passwd) values (#{id},#{userName},#{passwd})
    </insert>
    <update id="updateUser">
        update t_user set user_name=#{userName} , passwd=#{passwd} where id=#{id}
    </update>
    <delete id="deleteUser">
        delete from t_user where id=#{id}
    </delete>

</mapper>

User.java

package demo.entity;

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

@Data//生成get set和tostring
@AllArgsConstructor//生成有参构造方法
@NoArgsConstructor//生成无参构造方法
@TableName("t_user")//设置表名
public class User {
    @TableId //指定主键id
    private Long id;

    private String userName;
    private String passwd;
}