Idea创建Springboot项目并链接数据库

可视化部分

 

 pom.xml

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.3.0</version>
        </dependency>

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

连接数据库

三种配置文件,properties,yml,yaml

此处用yml做演示

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/elife
    username: root
    password: root

 

 连接数据库实现简单的增删改查

database处连接数据库

 例：对该数据库进行操作

 首先定义entity实体类

package com.example.mybatist.entity;

import com.fasterxml.jackson.annotation.JsonFormat;

import java.sql.Timestamp;

public class Building {
    private int idbuilding;
    private String name;
    private boolean delflag;
    private Timestamp createtime;
    private Timestamp updatetime;

    public int getIdbuilding() {
        return idbuilding;
    }

    public void setIdbuilding(int idbuilding) {
        this.idbuilding = idbuilding;
    }

    public String getName() {
        return name;
    }

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

    public boolean isDelflag() {
        return delflag;
    }

    public void setDelflag(boolean delflag) {
        this.delflag = delflag;
    }
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    public Timestamp getCreatetime() {
        return createtime;
    }

    public void setCreatetime(Timestamp createtime) {
        this.createtime = createtime;
    }
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    public Timestamp getUpdatetime() {
        return updatetime;
    }

    public void setUpdatetime(Timestamp updatetime) {
        this.updatetime = updatetime;
    }
}

 此例中时间戳并且格式化语句

 定义BuildingDao接口-->利用注解编写sql语句

package com.example.mybatist.Dao;

import com.example.mybatist.entity.Building;
import com.example.mybatist.entity.User;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface BuildingDao {
    //查id
    @Select("select * from building where idbuilding = #{idbuilding}")
    public Building getBuildingId(int idbuilding);
    //    查全表
    @Select("select * from building")
    public List<Building> selectAll();
    //插入数据
    @Insert("insert into building( idbuilding, name ) values (#{building.idbuilding},#{building.name})")
    public int insert(@Param("building") Building building);
    //删除数据
    @Delete("delete from building where idbuilding = #{idbuilding}")
    public int delete(@Param("idbuilding") int idbuilding);
    //更新数据
    @Update("update building set name =#{building.name},updatetime = NOW() where idbuilding=#{building.idbuilding}")
    public int update(@Param("building")Building building);
}

 定义BuildingMapper

 注意@Autowired自动装配的前提是要在Dao接口上添加@Mapper

package com.example.mybatist.mapper;

import com.example.mybatist.Dao.BuildingDao;
import com.example.mybatist.Dao.UserBuilldingDao;
import com.example.mybatist.entity.Building;
import com.example.mybatist.entity.UserBuilding;
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("/userbuilding")
public class UserBuildingMapper {
    @Autowired
    private UserBuilldingDao userBuilldingDao;
    //查询全部数据
    @GetMapping("/list")
    public List<UserBuilding> getAll(){
        List<UserBuilding> ans=userBuilldingDao.selectAll();
        return ans;
    }
    //插入新的数据
    @PostMapping("")
    public int insert(UserBuilding userbuilding){
        int ans=userBuilldingDao.insert(userbuilding);
        return ans;
    }
    //删除数据
    @GetMapping("/delete")
    public int delete(int id){
        int ans= userBuilldingDao.delete(id);
        return ans;
    }
    //更新某一条数据
    @PostMapping("/update")
    public int update(UserBuilding userbuilding){
        int ans= userBuilldingDao.update(userbuilding);
        return ans;
    }
}

利用postman进行访问

 

 

 

 

 

 以上springboot进行简单的增删改查