package Connectivity;

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

public class BaseConnection {
    private Connection connection;

    public BaseConnection() {
        getConnection();
    }

    public Connection getConnection() {
        String dbname = "ExpensesApp";
        String username= "root";
        String password= "";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:8080/"+dbname+username);
        }
        catch(Exception e) {
            e.printStackTrace();
        }
        return connection;
    }

    public void addToBase(String date, String category, String price, String description){
        try{
            Statement statement = connection.createStatement();
            String sql = "INSERT INTO EXPENSESBOARD VALUES('"+date+","+category+","+price+","+description+"')";
            statement.executeUpdate(sql);
        }
        catch (Exception e) {
            e.printStackTrace();
        }

    }


}