使用spring boot + mybatis 开发简单的增删改查服务

使用spring boot + mybatis 开发简单的增删改查服务

整体文件目录结构：

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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0modelVersion>

    <groupId>org.xingroupId>
    <artifactId>20220621artifactId>
    <version>1.0-SNAPSHOTversion>
    <parent>
        <artifactId>spring-boot-starter-parentartifactId>
        <groupId>org.springframework.bootgroupId>
        <version>2.2.1.RELEASEversion>
    parent>

    <dependencies>
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starterartifactId>
        dependency>

        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-testartifactId>
            <scope>testscope>
        dependency>

        <dependency>
            <groupId>org.mybatis.spring.bootgroupId>
            <artifactId>mybatis-spring-boot-starterartifactId>
            <version>2.1.3version>
        dependency>

        <dependency>
            <groupId>mysqlgroupId>
            <artifactId>mysql-connector-javaartifactId>
            <scope>runtimescope>
        dependency>
        <dependency>
            <groupId>com.alibabagroupId>
            <artifactId>druidartifactId>
            <version>1.2.5version>
        dependency>
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-webartifactId>
        dependency>
        <dependency>
            <groupId>org.projectlombokgroupId>
            <artifactId>lombokartifactId>
            <version>1.16.18version>
        dependency>

    dependencies>

    <properties>
        <maven.compiler.source>8maven.compiler.source>
        <maven.compiler.target>8maven.compiler.target>
    properties>

project>

application.yml内容：

server:
  port: 8002

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
    username: demo_user
    password: demo12356
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.demo.model

User.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.demo.dao.UserDao">
    <resultMap id="BaseResultMap" type="com.demo.model.User">
        <id column="userid" jdbcType="INTEGER" property="userid"/>
        <result column="username" jdbcType="VARCHAR" property="username"/>
        <result column="password" jdbcType="VARCHAR" property="password"/>
    resultMap>
    <select id="getlist" resultMap="BaseResultMap">
        select userid, username,password  from userlogin
    select>
    <insert id="add" parameterType="com.demo.model.User">
        insert into userlogin(username,password) values(#{username},#{password})
    insert>
    <update id="update" parameterType="com.demo.model.User">
        update userlogin
            set username = #{username},password = #{password}
        where userid = #{userid}
    update>
    <select id="queryById" resultMap="BaseResultMap">
        select userid, username,password  from userlogin
        where userid = #{userid}
    select>
mapper>

主入口启动文件：AppMain.java

package com.demo;

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

@SpringBootApplication
//@MapperScan("com.demo.dao")
public class AppMain {
    public static void main(String[] args) {
        SpringApplication.run(AppMain.class, args);
    }
}

接口文件：IUserService

package com.demo.service;

import com.demo.model.User;

import java.util.List;

public interface IUserService {
    User queryById(Integer id);
    boolean add(User user);
    boolean update(User user);
    List getlist();
}

服务文件：UserService.java

package com.demo.service.impl;

import com.demo.dao.UserDao;
import com.demo.model.User;
import com.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService implements IUserService {
    @Autowired
    private UserDao userDao;

    public User queryById(Integer id) {
        return userDao.queryById(id);
    }
    public  boolean add(User user){
        return userDao.add(user);
    }
    public boolean update(User user){
        return  userDao.update(user);
    }
    public List getlist(){
        return userDao.getlist();
    }
}

User实体类：User

package com.demo.model;

import lombok.Data;

import java.util.Date;

@Data
public class User {
    private Integer userid;
    private String password;
    private String username;


}

DAO:UserDao

package com.demo.dao;

import com.demo.model.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserDao {
    User queryById(Integer userid);
    boolean add(User user);
    boolean update(User user);
    List getlist();
}

API接口：UserController

package com.demo.controller;

import com.demo.model.User;
import com.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;


@RestController
@RequestMapping(value="/user")
public class UserController {
    @Autowired
    private IUserService userService;

    @GetMapping(value = "/queryById")
    public User queryById(int userid) {

        return userService.queryById(userid);
    }

    @GetMapping(value="getlist")
    public List getlist(){
        return userService.getlist();
    }

    @PostMapping(value = "/add")
    public boolean addUser(User user){
        return userService.add(user);
    }

    @PostMapping(value = "update")
    public  boolean updateUser(User user){
        return  userService.update(user);
    }
}