springboot练习

1.准备表

CREATE TABLE `tb_user` (
   `id` BIGINT(20) NOT NULL auto_increment,
   `user_name` VARCHAR(100) DEFAULT NULL COMMENT '用户名',
   `password` VARCHAR(100) DEFAULT NULL COMMENT '密码',
   `name` VARCHAR(100) DEFAULT NULL COMMENT '姓名',
   `age` int(100) DEFAULT NULL COMMENT '年龄',
   `sex` TINYINT(1) DEFAULT NULL COMMENT '性别，1男性，2女性',
   `birthday` date DEFAULT NULL COMMENT '出生日期',
   `note` VARCHAR(100) DEFAULT NULL COMMENT '备注',
   `created` datetime DEFAULT NULL COMMENT '创建时间',
   `updated` datetime DEFAULT NULL COMMENT '更新时间',
   PRIMARY KEY (`id`),
   UNIQUE key `username` (`user_name`)
) ENGINE=INNODB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

---

2.整合SpringMVC

• 修改端口
• 访问静态资源
• 添加拦截器
• 日志级别控制

server:
  port: 80
  servlet:
    path: "*.do"
logging:
  level:
    cn.itcast: debug
    org.springframework: debug

静态资源

拦截器：

import lombok.extern.slf4j.Slf4j;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.lang.Nullable;
import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@Slf4j
public class MyInterceptor implements HandlerInterceptor {
    //private  static  final Logger log = LoggerFactory.getLogger(MyInterceptor.class);
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        log.debug("preHandle method is running");
        return true;
    }

    @Override
    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, @Nullable ModelAndView modelAndView) throws Exception {
        log.debug("postHandle method is running");
    }

    @Override
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, @Nullable Exception ex) throws Exception {
        log.debug("afterCompletion method is running");
    }
}

import cn.itcast.interceptor.MyInterceptor;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class MvcConfig implements WebMvcConfigurer {
    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new MyInterceptor()).addPathPatterns("/**");
    }
}

---

3.整合jdbc与连接池

添加依赖

        <!-- 连接池-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!-- 数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

配置文件

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

4.整合Mybatis

配置文件

mybatis:
  type-aliases-package: cn.itcast.pojo
  #mapper-locations: mapper/*.xml

依赖 （由于通用Mapper含有mybatis与jdbc包，删除多余的）

        <!-- 数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- 通用Mapper-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.0.3</version>
        </dependency>

Mapper类

import cn.itcast.pojo.User;
import tk.mybatis.mapper.common.Mapper;

public interface UserMapper extends Mapper<User>{

}

启动类（Mapper扫描）

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

@SpringBootApplication
@MapperScan("cn.itcast.mapper")
public class BootDemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(BootDemoApplication.class);
    }
}

pojo类

import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;

import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Transient;
import java.util.Date;
@Data
@Table(name = "tb_user")
public class User {
    @Id
    @KeySql(useGeneratedKeys = true) //主键自增
    private Long id;
    private String userName;
    private String password;
    private String name;
    private Integer  age;
    private Integer sex;
    private Date birthday;
    private  Date created;
    private  Date updated;
    @Transient //不会持久化数据库中
    private String note;
}

Service类

import cn.itcast.mapper.UserMapper;
import cn.itcast.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
    public User queryByid(Long id){
       return userMapper.selectByPrimaryKey(id);
    }
}

Controller类

import cn.itcast.pojo.User;
import cn.itcast.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@RestController
@RequestMapping("user")
public class HelloController {
    @Autowired
    private UserService userService;
    @GetMapping("{id}")
    public User hello(@PathVariable("id") Long id){
        User user = userService.queryByid(id);
        return user;
    }
}

结果：