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