一、配置文件增加数据库相关配置:
spring.datasource.url=jdbc:mysql://1xx.xxx.xxx.xxx/test
spring.datasource.username=root
spring.datasource.password=xxxxxx
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
二、配置JdbcTemplate Bean
package cn.edu.tju.config;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
@Component
public class MyJdbcTemplateBean {
private final JdbcTemplate jdbcTemplate;
public MyJdbcTemplateBean(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
}
三、使用JdbcTemplate
package cn.edu.tju.controller;
import cn.edu.tju.config.MyJdbcTemplateBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RequestMapping()
@RestController
public class JdbcController {
@Autowired
private MyJdbcTemplateBean jdbcTemplateBean;
@RequestMapping("/jdbc")
public String getInfo(){
String sql = "select item from rate where id=1 limit 1";
String result =jdbcTemplateBean.getJdbcTemplate().queryForObject(sql, String.class);
return result;
}
}