SpringBoot整合JdbcTemplate

最新推荐文章于 2023-08-09 08:39:36 发布

清风醉晚霞

最新推荐文章于 2023-08-09 08:39:36 发布

阅读量125

点赞数

分类专栏： Java springBoot

本文链接：https://blog.csdn.net/zhengchanmin/article/details/103080047

版权

Java 同时被 2 个专栏收录

42 篇文章 0 订阅

订阅专栏

springBoot

10 篇文章 0 订阅

订阅专栏

pom.xml文件引入

<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.0.RELEASE</version>
	</parent>
	<dependencies>
		<!-- jdbcTemplate 依赖 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<!-- mysql 依赖 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!-- 测试 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<!-- springboot-web组件 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
	</dependencies>

application.yml配置文件代码

 ###springboot2.0名称url在多数据源的情况下变成jdbc-url,否则出现debug
 spring:
   datasource:
      url: jdbc:mysql://localhost:3306/test
      username: root
      password: 123123
      driver-class-name: com.mysql.jdbc.Driver

controller控制器代码

package com.xyt.springboot.controller;

import com.xyt.springboot.service.UserService;
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;

@RestController
public class IndexController {
    @Autowired
    private UserService userService;

    @RequestMapping("/addUser")
    public String addUser(String name, int age) {

        return userService.addUser(name, age) ? "success" : "fail";
    }
}

service接口代码

package com.xyt.springboot.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

@Service
public class UserService {

    @Autowired
    private JdbcTemplate template;

    public Boolean addUser(String name, int age) {
        return template.update("insert into users values(null,?,?);", name, age) > 0 ? true : false;
    }
}

@SpringBootApplication启动代码

package com.xyt.springboot;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class AppSpringBoot {

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

mysql数据库表结构代码

/*
Navicat MySQL Data Transfer

Source Server         : 我的本地测试库
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2019-11-15 14:25:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;