如何通過idea實現(xiàn)springboot集成mybatis

更新時間：2023年09月07日 09:39:41 作者：西安未央

這篇文章主要介紹了如何通過idea實現(xiàn)springboot集成mybatis,使用springboot 集成 mybatis后,通過http請求接口,使得通過http請求可以直接操作數(shù)據(jù)庫,本文結(jié)合實例代碼給大家介紹的非常詳細,需要的朋友可以參考下

概述

使用springboot 集成 mybatis后，通過http請求接口，使得通過http請求可以直接直接操作數(shù)據(jù)庫；完成后端功能框架；前端是準(zhǔn)備上小程序，調(diào)用https的請求接口用。簡單實現(xiàn)后端框架；

詳細

springboot 集成 mybatis項目demo

通過idea實現(xiàn)springboot集成mybatis；通過http請求操作mysql數(shù)據(jù)庫

先將science.zip導(dǎo)入idea；

在mysql中運行test.sql;創(chuàng)建測試用數(shù)據(jù)庫；數(shù)據(jù)庫test用戶名密碼root/root

項目中只實現(xiàn)了一個對象User；通過controller接受http請求實現(xiàn)對user的操作；

實現(xiàn)過程：

編輯application.properties

spring.datasource.url = jdbc:mysql://127.0.0.1:3306/test
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

實現(xiàn)springboot啟動類

package com.liji.science;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
@SpringBootApplication
public class ScienceApplication {
    public static void main(String[] args) {
        SpringApplication.run(ScienceApplication.class, args);
    }
}

實現(xiàn)controller

package com.liji.science.controller;
import com.liji.science.bean.User;
import com.liji.science.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class UserController {
    @Autowired
    private UserService userService;
    @RequestMapping("/listUser")
    public  List<User> listUser(Model model) {
        List<User> users = userService.findAll();
        model.addAttribute("users", users);
        return users;
    }
    /*@RequestMapping("/toAdd")
    public String toAdd() {
        return "/addUser";
    }
    @RequestMapping("/add")
    public String addUser(User user) {
        userService.addUser(user);
        return "redirect:/listUser";
    }
    @RequestMapping("/toUpdate")
    public String toUpdate(Model model, int id) {
        User user = userService.findById(id);
        model.addAttribute("user", user);
        return "/updateUser";
    }
    @RequestMapping("/update")
    public String updateUser(User user) {
        userService.updateUser(user);
        return "redirect:/listUser";
    }
    @RequestMapping("/delete")
    public String deleteUser(int id) {
        userService.deleteUser(id);
        return "redirect:/listUser";
    }*/
}

service實現(xiàn)

package com.liji.science.mapper;
import com.liji.science.bean.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface UserMapper {
    /**
     * 全部用戶查詢
     * @return
     */
    @Select("SELECT ID,NAME,PASSWORD,AGE FROM USER")
    List<User> findAll();
    /**
     * 新增用戶
     */
    @Insert("INSERT INTO USER(NAME,PASSWORD,AGE)VALUES(#{name}, #{password}, #{age})")
    void addUser(User user);
    /**
     * 修改用戶
     */
    @Update("UPDATE USER SET NAME=#{name}, PASSWORD=#{password}, AGE=#{age} WHERE ID=#{id}")
    void updateUser(User user);
    /**
     * 刪除用戶
     */
    @Delete("DELETE FROM USER WHERE ID=#{id}")
    void deleteUser(int id);
    @Select("SELECT ID,NAME,PASSWORD,AGE FROM USER WHERE ID=#{id}")
    User findById(@Param("id")int id);
}

創(chuàng)建實體類
package com.liji.science.bean;
public class User {
    private int id;
    private String name;
    private String password;
    private int age;
    public int getId() {
        return id;
    }
    public void setId(int 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 int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
}

idea啟動成功；