springboot-demo

Springboot web基础框架

源码地址 https://gitee.com/lsy1213/springboot-demo

1. 目录结构
   
2. Controller

package com.example.controller;

import com.example.bean.ExampleEntity;
import com.example.service.IExampleService;
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 java.util.List;

@Controller
public class ExampleController {
    @Autowired
    private IExampleService exampleService;

    @RequestMapping("/")
    public String index() {
        return "index";
    }

    @ResponseBody
    @RequestMapping("insert")
    public String insert() {
        exampleService.insertData();
        return "插入成功";
    }

    @ResponseBody
    @RequestMapping("list")
    public List<ExampleEntity> list() {
        return exampleService.list();
    }
}

3. Service

/*
 * Copyright (c) 2021 李思远
 */

package com.example.service.impl;

import com.example.bean.ExampleEntity;
import com.example.mapper.impl.ExampleMapper;
import com.example.service.IExampleService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


/**
 * 例子
 */
@Slf4j
@Service
public class ExampleService implements IExampleService {

    @Autowired
    private ExampleMapper exampleMapper;

    @Override
    public void initTable() {
        exampleMapper.initTestData();
    }

    @Override
    public void insertData() {
        exampleMapper.insertData();
    }

    @Override
    public List<ExampleEntity> list() {
        return exampleMapper.list();
    }
}

4. mapper

package com.example.mapper.impl;

import com.example.bean.ExampleEntity;
import com.example.mapper.IExampleMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class ExampleMapper implements IExampleMapper {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void initTestData() {
        jdbcTemplate.execute(
                "create table if not exists test (" +
                        " id varchar primary key," +
                        " name varchar," +
                        " value varchar " +
                        ")"
        );
    }

    @Override
    public void insertData() {
        long millis = System.currentTimeMillis();
        jdbcTemplate.update(
                "insert into test (id,name,value) values (?,?,?)",
                millis,
                "测试名称" + millis,
                "测试值" + millis
        );
    }

    @Override
    public List<ExampleEntity> list() {
        return jdbcTemplate.query(
                "select * from test ",
                (resultSet, i) ->
                        new ExampleEntity(
                                resultSet.getString("id"),
                                resultSet.getString("name"),
                                resultSet.getString("value")
                        )
        );
    }
}

https://gitee.com/lsy1213/springboot-demo
https://codechina.csdn.net/qq_40602449/springboot-demo