SpringBoot(八)SpringBoot集成jdbc

╰半橙微兮° 2022-01-21 11:25 334阅读 0赞

## 项目结构如下 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L09ubHlvbmVGcmlzdA_size_16_color_FFFFFF_t_70]

## 第一步在pom中引入相应的jar包 ##

<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.2.RELEASE</version>
    	</parent>
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-jdbc</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.21</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    	</dependencies>

## 第二步application.properties配置如下 ##

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

### 注：这里需要注意一个问题启动不同module的时候会出现端口被占用的情况。可以使用server.port=9090改变端口 ###

## 第三步service代码 ##

package com.zuojie.service;
    
    public interface StudentService {
        public void createJdbcUser();
    }

### serviceImpl代码 ###

package com.zuojie.service.impl;
    
    import com.zuojie.service.StudentService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Service;
    
    @Service
    public class StudentServiceImpl  implements StudentService {
        @Autowired
        private JdbcTemplate jdbcTemplate;
        @Override
        public void createJdbcUser() {
            jdbcTemplate.update("insert into student values(null,?,?);","lisi",18);
    
        }
    }

### controller代码 ###

package com.zuojie.controller;
    
    import com.zuojie.service.StudentService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class StudentController {
        @Autowired
        private StudentService studentService;
        @RequestMapping("/index")
       public String index(){
           return "add success";
       }
    
    }

### 启动类代码 ###

package com.zuojie;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
    import org.springframework.context.annotation.ComponentScan;
    
    
    @ComponentScan(basePackages = "com.zuojie")
    @EnableAutoConfiguration
    public class AppConroller
    {
        public static void main( String[] args )
        {
            SpringApplication.run(AppConroller.class, args);
        }
    }

## 第四步访问 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L09ubHlvbmVGcmlzdA_size_16_color_FFFFFF_t_70 1]

## 如图访问成功 到这里集成就成功了 可以编写增删查改了。 ##

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L09ubHlvbmVGcmlzdA_size_16_color_FFFFFF_t_70]: /images/20220121/b93e53dd97a94dd3a7c20977005c752b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L09ubHlvbmVGcmlzdA_size_16_color_FFFFFF_t_70 1]: /images/20220121/625ca85ae0094a199921317adcc2df31.png