Springboot中数据库连接

一.jdbc的方式连接

1.配置jdbc连接文件

spring:datasource:username: rootpassword:123123url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8driver-class-name: com.mysql.jdbc.Driver

2.直接controller操作crud

packagecom.springboot.controller;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.jdbc.core.JdbcTemplate;importorg.springframework.stereotype.Controller;importorg.springframework.web.bind.annotation.*;importjava.util.List;importjava.util.Map;/**
 * @author panglili
 * @create 2022-07-10-10:27
 */@ControllerpublicclassJdbcController{@Autowired(required=false)JdbcTemplate jdbcTemplate;@GetMapping("/sql")@ResponseBodypublicList<Map<String,Object>>mapList(){String sql="select * from user";List<Map<String,Object>> queryForList= jdbcTemplate.queryForList(sql);return queryForList;}}

二.mybatis连接

1.导入依赖

<dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.2.2</version></dependency>

2.数据库连接文件

与jdbc中的配置文件相同，使用jdbc方式中的即可！

3.pojo实体类

packagecom.springboot.pojo;importlombok.AllArgsConstructor;importlombok.Data;importlombok.NoArgsConstructor;/**
 * @author panglili
 * @create 2022-07-10-11:23
 */@Data@AllArgsConstructor@NoArgsConstructorpublicclass user{privateint  id;privateString name;privateString pwd;}

4.controller操作修改

packagecom.springboot.controller;importcom.springboot.mapper.UserMapper;importcom.springboot.pojo.user;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Repository;importorg.springframework.web.bind.annotation.PathVariable;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RestController;importjava.util.List;/**
 * @author panglili
 * @create 2022-07-10-11:46
 */@RestControllerpublicclassMybatisController{@AutowiredprivateUserMapper userMapper;@RequestMapping("/queryAll")publicList<user>queryAll(){List<user> users= userMapper.queryAll();return users;}@RequestMapping("/queryById/{id}")public userqueryById(@PathVariable("id")int id){
        user user= userMapper.queryById(id);return user;}}

5.在配置文件中配置