SpringBoot+Mybatis 用户登陆+增删改查

在官网或者编译器创建一个SpringBoot项目,在这里示范的是编译器（IDEA）

• 在idea创建一个Springboot项目
  

• 配置

• 添加依赖
  

• 项目创建完成
  
  5.运行报错
  加上就可以了

	server:
	  port: 8080
	
	spring:
	  datasource:
	    url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=true
	    username: root
	    password: 123456
	    driver-class-name: com.mysql.cj.jdbc.Driver
	
	mybatis:
	  mapper-locations: classpath:mapper/*Mapper.xml
	  type-aliases-package: com.sh.springbootdemo.entity

6.给他分层

7.编写代码，数据库自己创建(id,name,password)

• entity层

package com.sh.springbootdemo.entity;

public class User {
   
    private Integer id;
    private String name;
    private String password;
    private String role;

    public Integer getId() {
   
        return id;
    }

    public void setId(Integer id) {
   
        this.id = id;
    }

    public String getName() {
   
        return name;
    }

    public void setName(String name) {
   
        this.name = name;
    }

    public String getPassword() {
   
        return password;
    }

    public void setPassword(String password) {
   
        this.password = password;
    }

    public String getRole() {
   
        return role;
    }

    public void setRole(String role) {
   
        this.role = role;
    }

    @Override
    public String toString() {
   
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", role='" + role + '\'' +
                '}';
    }
}

• mapper层

package com.sh.springbootdemo.mapper;

import com.sh.springbootdemo.entity.User;

import java.util.List;

public interface UserMapper {
   
    //登录时信息核对
    User getInfo(String name, String password);

    //根据ID查询用户信息
    User selectUserById(String id);

    //插入新的用户
    int insertUser(User user);

    //删除用户
    int deleteUser(String id);

    //修改用户
    int updateUser(User user);

    //查询所有用户
    List<User> getAllUser();
}

mapper.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.sh.springbootdemo.mapper.UserMapper">

    <!--验证用户账号和密码-->
    <select id="getInfo" parameterType="String" resultType="com.sh.springbootdemo.entity.User">
        SELECT * FROM user
        WHERE name = #{
   name}
        AND password = #{
   password};
    </select>

    <!--根据ID查询用户信息-->
    <select id="selectUserById" parameterType="String" resultType="com.sh.springbootdemo.entity.User">
        SELECT * FROM user
        WHERE id = #{
   id};
    </select>

    <!--插入新用户信息，ID是自动生成的,返回数据库操作影响行数，为0则是失败-->
    <insert id="insertUser" parameterType="com.sh.springbootdemo.entity.User">
        INSERT InTO
            user(name,password,role)
        values
            (#{
   name},#{
   password},#{
   role});
    </insert>

    <!--根据ID删除用户，返回数据库操作影响行数，为0则是失败-->
    <delete id="deleteUser" parameterType="String">
        DELETE FROM user
        WHERE id = #{
   id};
    </delete>

    <!--根据ID修改用户信息，返回数据库操作影响行数，为0则是失败-->
    <update id="updateUser" parameterType="com.sh.springbootdemo.entity.User">
        UPDATE user
        SET password = #{
   password},
            name = #{
   name},
            role = #{
   role}
        WHERE id = #{
   id};
    </update>

    <!--查询所有用户信息，返回一个List<Bean>-->
    <select id="getAllUser" resultType="com.sh.springbootdemo.entity.User">
        SELECT * FROM user ;
    </select>

</mapper>

• service层

package com.sh.springbootdemo.service;

import com.sh.springbootdemo.entity.User;

import java.util.List;

public interface UserService {
   
  //登录时信息核对
  User loginIn(String name, String password);

  //根据ID查询用户信息
  User queryUserById(String id);

  //插入新的用户
  int addUser(User user);

  //删除用户
  int dropUser(String id);

  //修改用户
  int modifyUser(User user);

  //查询所有用户
  List<User> queryAllUser(