Spring Boot使用JDBCTemplate

Spring Boot 使用JDBCTemplate

1、加入相关依赖

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

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

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

2、 User实体类

import lombok.Data;

@Data
public class User {
    private Long id;
    private String name;
    private int age;
    private int sex;
}

3、Dao接口和实现类

public interface UserDao {
    User get(Long id);
}

-------------------------------------------------------------------------------------------
@Repository
public class UserDaoImpl implements UserDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public User get(Long id) {
        return jdbcTemplate.queryForObject("select * from t_user where id = ?",new Object[]{id},new BeanPropertyRowMapper<>(User.class));
    }
}

注意Dao实现类使用@Respository注解，表明为持久层；

注入JdbcTemplate，至于JdbcTemplate具体使用方法，可自行研究，本博文主要简单介绍如何使用

4 、Service及实现类

public interface UserService {
    User get(Long id);
}

-------------------------------------------------------------------------------------------

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserDao userDao;

    @Override
    public User get(Long id) {
        return userDao.get(id);
    }
}

5、Controller

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

    @GetMapping(value = "/getUser")
    public String getUserInfo(){
        return userService.get(1L).toString();
    }
}

浏览器访问：localhost:8080/getUser