四、jdbctemplate使用

这里使用mysql数据库，省略数据库创建过程

1、添加依赖

        <!--jdbc-->

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-jdbc</artifactId>

        </dependency>

        <!--mysql-->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>6.0.6</version>

        </dependency>    

2、添加数据库配置

#数据库

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

3、编写代码

@Repository

public class UserDao {

    @Autowired

    private JdbcTemplate jt;

    public List<Map<String, Object>> listUser(){

        StringBuilder sql = new StringBuilder();

        sql.append("SELECT * FROM t_sp_user");

        return jt.queryForList(sql.toString());

    }

}

@Service

public class UserService {

    @Autowired

    private UserDao userDao;

    public List<Map<String, Object>> listUser(){

        return userDao.listUser();

    }

}

@RestController

@RequestMapping(value = "user")

public class UserController {

    @Autowired

    private UserService userService;

    @GetMapping(value = "list")

    public List<Map<String, Object>> listUser(){

        return userService.listUser();

    }

}