SpringBoot中使用JdbcTemplate持久化数据库

1、引入依赖

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

2、代码示例

@Repository
public class ProductDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    public void add(String name){
        String sql="insert into t_product(pname) values('"+name+"')";
        jdbcTemplate.execute(sql);
    }
}

3、调用演示

@SpringBootApplication
public class App {

　　public static void main(String[] args) {
        ConfigurableApplicationContext context=SpringApplication.run(App.class, args);
        context.getBean(ProductDao.class).add("测试1");
        context.close();
    }
}