欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

SpringBoot整合數(shù)據(jù)庫訪問層的實(shí)戰(zhàn)

 更新時(shí)間：2022年03月23日 11:03:10   作者：無休止符  
本文主要介紹了SpringBoot整合數(shù)據(jù)庫訪問層的實(shí)戰(zhàn)，主要包含JdbcTemplate和mybatis框架的整合應(yīng)用，具有一定的參考價(jià)值，感興趣的可以了解一下

一、springboot整合使用JdbcTemplate

1.pom依賴

        <!--SpringBoot整合jdbc模板框架-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--SpringBoot整合mysql驅(qū)動(dòng)類-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.21</version>
        </dependency>

2.application.yml新增配置

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

3.建表sql

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '用戶名稱',
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

4.UserService

@RestController
public class UserService {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @RequestMapping("/insertUser")
    public String insertUser(String name,Integer age){
        int update = jdbcTemplate.update("insert into users values(null,?,?);", name, age);
        return update > 0 ? "success" : "false";
    }
}

5.瀏覽器訪問

http://127.0.0.1:8080/insertUser?name=你好&age=21

在這里插入圖片描述

在這里插入圖片描述

二、整合mybatis框架查詢

1.pom依賴

    <!-- springboot 整合mybatis -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.1.1</version>
    </dependency>

2.實(shí)體類UserEntity

public class UserEntity {
    private String userName;
    private Integer age;
    private Integer id;
	//GET...SET...省略
}

3.UserMapper接口

public interface UserMapper {
    @Select("select id as id,name as userName,age as age from users where id = #{id};")
    UserEntity selectByUserId(@Param("id") Integer id);
}

4.UserService

@RestController
public class UserService {
    @Autowired
    private UserMapper userMapper;
    @RequestMapping("/mybatisFindById")
    public UserEntity mybatisFindById(Integer id){
        return userMapper.selectByUserId(id);
    }
}

5.app啟動(dòng)

注意：這里需要加注解@MapperScan("com.sjyl.mapper")來告訴spring接口mapper的掃包范圍

@SpringBootApplication
@MapperScan("com.sjyl.mapper")
public class App {
    public static void main(String[] args) {
        SpringApplication.run(App.class);
    }
}

測(cè)試連接：http://127.0.0.1:8080/mybatisFindById?id=3

在這里插入圖片描述

三、整合mybatis框架插入

1.UserMapper添加insertUser

public interface UserMapper {

    @Insert("Insert into users values (null,#{userName},#{age});")
    int insertUser(@Param("userName") String userName,@Param("age") Integer age);

    @Select("select id as id,name as userName,age as age from users where id = #{id};")
    UserEntity selectByUserId(@Param("id") Integer id);
}

2.UserService添加insertUserMybatis

@RestController
public class UserService {
    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/mybatisFindById")
    public UserEntity mybatisFindById(Integer id){
        return userMapper.selectByUserId(id);
    }

    @RequestMapping("/insertUserMybatis")
    public String insertUserMybatis(String userName,Integer age){
        int insert = userMapper.insertUser(userName,age);
        return insert > 0 ? "success" : "false";
    }
}

測(cè)試連接：http://127.0.0.1:8080/insertUserMybatis?userName=%E5%BC%A0%E4%B8%89&age=21

在這里插入圖片描述

 到此這篇關(guān)于SpringBoot整合數(shù)據(jù)庫訪問層的實(shí)戰(zhàn)的文章就介紹到這了,更多相關(guān)SpringBoot 數(shù)據(jù)庫訪問層內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

相關(guān)文章

最新評(píng)論