package com.example.demo.config;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class SQLConfig {

	@Value("${spring.datasource.url}")
	private String sqlDburl;

	@Value("${spring.datasource.username}")
	private String sqlDbUsername;

	@Value("${spring.datasource.password}")
	private String sqlDbPassword;

	@Bean
	public Statement SQLStatement() throws SQLException, ClassNotFoundException {
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection mySqlconn = DriverManager.getConnection(sqlDburl, sqlDbUsername, sqlDbPassword);
		Statement mySqlstmt = mySqlconn.createStatement();
		return mySqlstmt;
	}

}