欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

程序员文章站 2023-12-10 19:40:22
最详细,最易懂,一步一步执行搭建的框架~话不多说,直接开始搭建吧~目录一、创建项目二、修改结构以及创建具体内容三、连接数据库,使用mybatis,以写上传用户信息的接口为例。四、调用接口,上传数据​一、创建项目 1.点击创建新项目 2.选择Spring Initializr 3.填写好项目的相关信息 4.选择用到的依赖(也可以后期在pom.xml中添加) 5.选择项目存放位置和设置项目名称 ......

最详细,最易懂,一步一步执行搭建的框架~

话不多说,直接开始搭建吧~

目录

 

一、创建项目 

二、修改结构以及创建具体内容

三、连接数据库,使用mybatis,以写上传用户信息的接口为例。

四、调用接口,上传数据


一、创建项目 

  1.点击创建新项目

      IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  2.选择Spring Initializr     IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

   3.填写好项目的相关信息IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  4.选择用到的依赖(也可以后期在pom.xml中添加)

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  5.选择项目存放位置和设置项目名称

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  6.创建成功后项目的初步结构

      IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

   7.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.3.1.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>demo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>demo</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-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.3</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>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.2.35</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
			<version>2.3.1.RELEASE</version>
		</dependency>

	</dependencies>

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


		<resources>
			<resource>
				<directory>src/main/</directory>
				<includes>
					<include>**/*.xml</include>
				</includes>
			</resource>
			<resource>
				<directory>src/main/resources</directory>
				<includes>
					<include>**/*.*</include>
				</includes>
			</resource>
		</resources>
	</build>

</project>

二、修改结构以及创建具体内容

   1.点击File -->  Project Structure..

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  2.将main中java文件设为Sources,resources设为Resources,test中java设为Tests。

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  3.创建controller、service、dao、entity包

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  4.在resources中创建Mapper文件来存放mapper.xml配置文件

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  5.创建mapper.xml配置文件:右键 --> New --> File

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  6.填入配置文件名称 例如:UserMapper.xml

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  8.默认的springboot配置文件application是.properties格式,我习惯用.yml格式,所以修改一下

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  9.将properties替换为yml

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  10.配置application.yml

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)


spring:
       datasource:
         url: jdbc:mysql://localhost:3306/seven?characterEncoding=utf8&useSSL=true&serverTimezone=Asia/Shanghai
         username: root
         password: root
         driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  mapper-locations: classpath:/resources/mappers/*.xml
  type-aliases-package: com.example.demo.dao
server:
    port: 8080
    servlet:
          context-path: /demo

    11. 配置DemoApplication运行文件

package com.example.demo;

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

@SpringBootApplication

@MapperScan("com.example.demo.dao")
//加上这句,运行项目时候要去扫描mybatis的接口文件
public class DemoApplication {

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

}

三、连接数据库,使用mybatis,以写上传用户信息的接口为例。

  1.数据库中创建user表。

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

  2.entity包中创建User实体类

package com.example.demo.entity;

public class User {
    private int    userID;     //用户ID
    private String userName;   //用户名
    private int    userAge;    //用户年龄

    public User() {
    }

    public User(int userID, String userName, int userAge) {
        this.userID = userID;
        this.userName = userName;
        this.userAge = userAge;
    }

    public int getUserID() {
        return userID;
    }

    public void setUserID(int userID) {
        this.userID = userID;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public int getUserAge() {
        return userAge;
    }

    public void setUserAge(int userAge) {
        this.userAge = userAge;
    }

    @Override
    public String toString() {
        return "User{" +
                "userID=" + userID +
                ", userName='" + userName + '\'' +
                ", userAge=" + userAge +
                '}';
    }
}

  3.配置文件UserMapper.xml中

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

<?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.example.demo.dao.UserMapper">

    <insert id="insertUserInfo" parameterType="com.example.demo.entity.User">
        INSERT  INTO user VALUES
        (#{userID,jdbcType=INTEGER},#{userName,jdbcType=VARCHAR},
		#{userAge,jdbcType=INTEGER})
    </insert>
</mapper>

  4.dao包中的UserMapper

package com.example.demo.dao;

import com.example.demo.entity.User;


public interface UserMapper {

    int insertUserInfo(User user);

}

  5.service中的UserService

package com.example.demo.service;
 
import com.example.demo.dao.UserMapper;
import com.example.demo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service
public class UserService {

    @Autowired(required = false)
    private UserMapper userMapper;

    public int AddUserInfo(int ID,String name,int age) {
        User user = new User();
        user.setUserID(ID);
        user.setUserName(name);
        user.setUserAge(age);
        int res = userMapper.insertUserInfo(user);
        if(res>0)return 1;  //上传成功
        else return 0;   //上传失败
    }
}

  6.controller中的UserController

package com.example.demo.controller;

import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

@Controller
public class UserController {
    @Autowired
    private UserService userService;

    //上传用户信息
    @GetMapping("/AddUserInfo")
    @ResponseBody
    public int AddUserInfo(@RequestParam("userID")int userID,
                           @RequestParam("userName")String userName,
                           @RequestParam("userAge")int userAge){
        int res = userService.AddUserInfo(userID,userName,userAge);
        return res;
    }

}

四、调用接口,上传数据

http://localhost:8080/demo/AddUserInfo?userID=2016207158&userName=张玲玲&userAge=22

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

查看数据库user表中,数据也插入了。

IDEA搭建Springboot+SpringMVC+Mybatis+Mysql(详细、易懂)

本文地址:https://blog.csdn.net/SEVENY_/article/details/107074648