Spring Boot2.0之 整合JDBC

Spring Boot2.0之 整合JDBC

 

 

 

很入门的知识，大家了解下就OK

maven配置文件pom：

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

service层

package com.toov5.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

@Service   //注册到Spring 容器中去 
public class UserServiceImpl  {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    public  String createUser(String name, Integer age) {
        jdbcTemplate.update("insert into users values(null,?,?);", name, age);
        return "success";
        
    }
}

controller

package com.toov5.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.toov5.service.UserServiceImpl;

@RestController
public class IndexController{

    @Autowired
    private UserServiceImpl u;
    
    @RequestMapping("/index")
    public String index(String name, Integer age){
        u.createUser(name, age);
        return "ok";
    }
    
}

启动类：

package com.toov5.service;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication(scanBasePackages={"com.toov5.*"})
public class App {

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

}

访问结果：

数据库：

 

posted @ 2018-10-20 16:10 toov5 阅读(...) 评论(...) 编辑 收藏