Spring Boot---(12)Spring Boot使用JdbcTemplate访问数据库

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

# mysql
spring.datasource.url=jdbc:mysql://22.22.22.22/ss
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

public interface EntFileService {

    List<EntFile> getEntFileList();
    /**查询企业数量*/
    Integer getCount();
    /**添加企业*/
    void insertEntFile(String name,String address);
}

@Service
public class EntFileServiceImpl implements EntFileService{

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public Integer getCount() {
        return jdbcTemplate.queryForObject("select count(1) from ent_file",Integer.class);
    }

    @Override
    public void insertEntFile(String name, String address) {
        jdbcTemplate.update("INSERT  INTO ent_file(NAME,address)VALUES (?,?)",name,address);
    }

}