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); 
    } 
 
}

访问结果：

数据库：

原创文章，作者：奋斗，如若转载，请注明出处：https://blog.ytso.com/16160.html

Spring Boot2.0之 整合JDBC详解编程语言

相关推荐

发表回复

Spring Boot2.0之整合JDBC详解编程语言