springboot-集成springjdbc

使用springboot集成jdbc

pom文件配置:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.anlysqx</groupId>
  <artifactId>springboot-jdbc</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
  
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>1.5.6.RELEASE</version>
  </parent>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		
		<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		
		<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-test</artifactId>
		    <scope>test</scope>
		</dependency>
		
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>8.0.14</version>
		</dependency>
		
		
		
		
	</dependencies>
  
</project>

在application.properties中配置数据源:

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/vedio?useSSL=true&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=helloanlysqx
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

App.java

package com.anlysqx.app;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.ComponentScan;

@ComponentScan(basePackages={"com.anlysqx.controller","com.anlysqx.service"})
@EnableAutoConfiguration
public class App {

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

Controller.java

package com.anlysqx.controller;

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.RestController;

import com.anlysqx.service.UserService;

@RestController
public class InserController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping("/insert")
	public String index(){
		userService.inserUser();
		return "add success";
	}
	
}

 

service.java

package com.anlysqx.service;

import javax.annotation.Resource;

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

@Service
public class UserService {
	
	@Autowired
	private JdbcTemplate jdbcTemplate;
	
	public void inserUser(){
		String sql = "insert into user (uname,age,password) values(?,?,?)";
		jdbcTemplate.update(sql,"燎原",23,"password");
		
	}
	
}