springboot项目的创建和使用

创建项目

1.用idea创建一个Spring Initializr项目

2.设置springboot项目的内部包结构

3.选择springboot的版本以及选择需要的jar包

4.设置创建项目的位置

配置application.yml文件

server:
  port: 8080

# jdbc 的配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/db_gm?useSSL=true&characterEncoding=utf-8&serverTimezone=UTC
    username: root
    password:

  # 视图解析器
  mvc:
    view:
      prefix: /
      suffix: .html

# Mybatis
mybatis:
  type-aliases-package: it.gm.springboot.pojo

编写实体类.Service.Controller.Dao

实体类

package it.gm.springboot.pojo;

public class User {
    private Integer id;
    private String username;
    private String password;


    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

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

    public String getPassword() {
        return password;
    }

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

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

Dao层文件

在抽象方法上面用注释的方式编写sql语句

package it.gm.springboot.dao;

import it.gm.springboot.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface UserDao {

@Insert("insert into tb_user(username,password) values(#{username},#{password})")
int addUser(User user);


@Delete("delete from tb_user where id=#{id}")
int delUser(int id);

@Update("update tb_user set username=#{username},password=#{password} where id=#{id}")
int updUser(User user);

@Select("select * from tb_user")
List<User> findUserAll();

}

Service层文件

package it.gm.springboot.service;

import it.gm.springboot.pojo.User;

import java.util.List;

public interface UserService {

    int addUser(User user);

    int delUser(int id);

    int updUser(User user);

    List findUserAll();
    

}

package it.gm.springboot.service.impl;

import it.gm.springboot.dao.UserDao;
import it.gm.springboot.pojo.User;
import it.gm.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

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


    @Override
    public int addUser(User user) {
        return this.userDao.addUser(user);
    }

    @Override
    public int delUser(int id) {
        return this.userDao.delUser(id);
    }

    @Override
    public int updUser(User user) {
        return this.userDao.updUser(user);
    }

    @Override
    public List<User> findUserAll() {
        return this.userDao.findUserAll();
    }
}

Controller层

package it.gm.springboot.controller;

import it.gm.springboot.pojo.User;
import it.gm.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;


    @RequestMapping("/addUser")
    public String addUser(User user){
        int i = this.userService.addUser(user);
        if (i > 0) {
            System.out.println("增加成功！");
            return "success";
        }else {
            System.out.println("增加失败");
            return "error";
        }
    }

    @RequestMapping("/delUser")
    public String delUser(int id){
        int result=this.userService.delUser(id);
        if (result > 0) {
            System.out.println("删除成功");
            return "success";
        }else{
            System.out.println("删除失败");
            return "error";
        }
    }

    @RequestMapping("/updUser")
    public String updUser(User user){
        int result=this.userService.updUser(user);
        if (result>0){
            System.out.println("修改成功");
            return "success";
        }else {
            System.out.println("修改失败");
            return "error";
        }
    }


    @ResponseBody
    @RequestMapping("/findUserAll")
    public ModelAndView findUserAll(){
        List<User> list=this.userService.findUserAll();
        for (User user:list
             ) {
            System.out.println(user.toString());

        }

        ModelAndView mv = new ModelAndView("select");
        mv.addObject("list",list);
        return mv;
    }
}

在SpringBootApplication.java文件上添加注解来设置dao层 @MapperScan(“it.gm.springboot.dao”)

前端html页面遍历 list集合

thymeleaf标签