springboot+mybatis实现登录注册增删改查/postman测试

并不是CH

已于 2023-08-08 10:59:17 修改

阅读量1.2k

点赞数 1

文章标签： mybatis spring boot postman

于 2022-08-03 17:26:44 首次发布

原文链接：https://blog.csdn.net/handsomezls/article/details/110367853?spm=1001.2101.3001.6650.2&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-2-110367853-blog-117989131.pc_relevant_multi_platform_featuressortv2dupreplace&depth_1-u

版权

1、JDK1.8以上都行，目前不会出现版本问题

在这里插入图片描述

2、选择依赖，web里面选Spring web，sql里面选Mybatis Framework和MySQL Driver

在这里插入图片描述

3、目录结构

4、pom.xml文件，可能提示找不到啥插件，不用管。

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.0</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.zls</groupId>
    <artifactId>zzz</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>zzz</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>


    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>2.4.0</version>
            </plugin>
        </plugins>
    </build>

</project>

5、新建数据库和表，只建表结构无数据。手动在Navicat里面创建也行。

CREATE DATABASE 你的数据库名 CHARACTER 
SET 'utf8mb4' COLLATE 'utf8mb4_general_ci';

CREATE TABLE user(id int(10) unsigned NOT NULL
AUTO_INCREMENT,name varchar(50) NOT NULL,age int(10)
NOT NULL, PRIMARY KEY (id) ) 
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

6、新建application.yml和application-dev.yml文件。

application.yml

spring:
  profiles:
    active: dev

  thymeleaf:
    view-names: /*
    cache: false
    prefix: /WEB-INF/html

application-dev.yml

server:
  port: 8888

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/你的数据库名?
    useUnicode=true
    &characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver

mybatis:
  mapper-locations: classpath:mappers/*Mapper.xml
  type-aliases-package: com.zls.zzz.entity

#showSql
logging:
  level:
    com:
      example:
        mapper : debug

7、user类

package com.zls.zzz.entity;

/**
 * @author zls
 */
public class User {

    private Integer id;
    private String username;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    private Integer age;

    private String password;

    public String getPassword() {
        return password;
    }

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

    public Integer getId() {
        return id;
    }

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



    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

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

8、UserMapper.java接口

package com.zls.zzz.mapper;

import com.zls.zzz.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

/**
 * @author zls
 */
@Mapper
@Component
public interface UserMapper {

    /**
     * 新增
     *
     * @param user
     * @return
     */
    Boolean add(User user);

    /**
     * 删除
     *
     * @param id
     * @return
     */
    Boolean del(int id);

    /**
     * 修改
     *
     * @param user
     * @return
     */
    Boolean edit(User user);

    /**
     * 查询所有
     *
     * @return
     */
    List<User> findAll();

    /**
     * 查询单条
     *
     * @param id
     * @return
     */
    User findOne(int id);

    ///
    //通过账号密码来查询信息
    List<User> queryUserByUp(@RequestParam("username") String username, @RequestParam("password") String password);
    //查询所有用户
    List<User> queryUserList();
    //增加用户
    int addUser(@RequestParam("user") User user);
    //通过用户名来进行查询
    List<User> queryUserByUserName(@RequestParam("username") String username);


}

9、UserService.java

package com.zls.zzz.service;

import com.zls.zzz.entity.User;
import com.zls.zzz.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author zls
 */
@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;

    /**
     * 新增
     *
     * @param user
     * @return
     */
    public Boolean add(User user) {
        return userMapper.add(user);
    }

    /**
     * 删除
     *
     * @param id
     * @return
     */
    public Boolean del(int id) {
        return userMapper.del(id);
    }

    /**
     * 修改
     *
     * @param user
     * @return
     */
    public Boolean edit(User user) {
        return userMapper.edit(user);
    }

    /**
     * 查询所有
     *
     * @return
     */
    public List<User> findAll() {
        return userMapper.findAll();
    }

    /**
     * 查询单条
     *
     * @param id
     * @return
     */
    public User findOne(int id) {
        return userMapper.findOne(id);
    }

}

10、UserController

package com.zls.zzz.controller;

import com.zls.zzz.entity.User;
import com.zls.zzz.mapper.UserMapper;
import com.zls.zzz.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpSession;
import java.sql.Time;
import java.util.List;

/**
 * @author zls
 */
@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    /**
     * 新增
     *
     * @param user
     * @return boolean
     */
    @PostMapping("/add")
    public Boolean add(User user) {
        return userService.add(user);
    }

    /**
     * 删除
     *
     * @param id
     * @return
     */
    @GetMapping("/del/{id}")
    public Boolean del(@PathVariable int id) {
        return userService.del(id);
    }

    /**
     * 修改
     *
     * @param user
     * @return
     */
    @PostMapping("/edit")
    public Boolean edit(User user) {
        return userService.edit(user);
    }

    /**
     * 查询所有
     *
     * @return
     */
    @GetMapping("/findAll")
    public List<User> findAll() {
        return userService.findAll();
    }

    /**
     * 查询单条
     *
     * @param id
     * @return
     */
    @GetMapping("/findOne/{id}")
    public User findOne(@PathVariable int id) {
        return userService.findOne(id);
    }




    
    @Autowired
    UserMapper userMapper;
    
    @RequestMapping("/login")
    public String login(@RequestParam("username") String username,
                        @RequestParam("password") String password,
                        Model model, HttpSession session){
        //用从前端获取的username、password进行查询
        List<User> user1 = userMapper.queryUserByUp(username,password);

        if (!user1.isEmpty()){
            session.setAttribute("loginUser",username);
            return "登录成功";
        }
        else {
            model.addAttribute("msg","用户名或者密码错误");
            return "用户名或者密码错误";
        }

    }

    @RequestMapping("/regis")
    public String regis(@RequestParam("username") String username,
                        @RequestParam("password") String password,
                        @RequestParam("age") int age,
                        Model model,HttpSession session){

        User user = new User();

        List<User> user1 = userMapper.queryUserByUserName(username);

        if (!user1.isEmpty()){
            model.addAttribute("msg","用户名存在");
            return "用户名存在";
        } else {
            //保存输入的用户名和密码
            user.setUsername(username);
            user.setPassword(password);
            user.setAge(age);
            userMapper.addUser(user);
            session.setAttribute("loginUser",username);
            return "注册成功";
        }
    }


}

11、在resource下新建mappers文件夹，底下建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.zls.zzz.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.zls.zzz.entity.User">
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="username" jdbcType="VARCHAR" property="username" />
        <result column="age" jdbcType="INTEGER" property="age" />
        <result column="password" jdbcType="VARCHAR" property="password" />
    </resultMap>

    <!--新增-->
    <insert id="add" parameterType="com.zls.zzz.entity.User">

        insert into user (username,age,password) values (#{username},#{age},#{password});

    </insert>

    <!--删除-->
    <delete id="del" parameterType="java.lang.Integer">

        delete from user where id = #{id};

    </delete>

    <!--修改-->
    <update id="edit">

        update user set username = #{username},age=#{age},password=#{password} where id = #{id};

    </update>

    <!--查询所有-->
    <select id="findAll" resultType="com.zls.zzz.entity.User">
        select * from user;
    </select>

    <!--查询单条-->
    <select id="findOne"  resultType="com.zls.zzz.entity.User" >

        select  * from user where  id = #{id};

    </select>




    <select id="queryUserByUp" resultType="User">
        select * from user where username = #{username} AND password = #{password}
    </select>

    <select id="queryUserList" resultType="User">
        select * from user
    </select>

    <select id="queryUserByUserName" resultType="User">
        select * from user where username = #{username}
    </select>

    <insert id="addUser" parameterType="User">
        insert into user (username,password,age) values (#{username},#{password},#{age})
    </insert>


</mapper>

12、最后编写application启动文件

package com.zls.zzz;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * @author zls
 */
@SpringBootApplication
@MapperScan("com.zls.zzz.mapper")
public class ZzzApplication {

    public static void main(String[] args) {
        SpringApplication.run(ZzzApplication.class, args);
    }

}

13、postman测试

localhost:8080/user/add 新增传参数name和age post 方式
localhost:8080/user/del/1 删除id为1的数据 get 方式
localhost:8080/user/edit 修改 post 方式记得传id
localhost:8080/user/findOne/1 查询id为1的数据 get 方式
localhost:8080/user/findAll 查询所有 get 方式
localhost:8080/user/login 传参数username和password
localhost:8080/user/regis 传参数账号密码之外还要age