package mysql;


import java.sql.*;

public class DAO
{
    private final static String DB_URL = "jdbc:mysql://localhost:3306/bazad";
    private final static String DB_USR = "root";
    private final static String DB_PASS = "";


    private Connection connection;
    private Statement statement;
    private String query = "SELECT * FROM tbl;";


    public DAO()
    {

    }

    public ResultSet getFromDatabase(String query)
    {
        try
        {
            connection = DriverManager.getConnection(DB_URL, DB_USR, DB_PASS);
            statement = connection.createStatement();
            return statement.executeQuery(query);

        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }

        return null;
    }

    public void insertData(String query)
    {
        try
        {
            connection = DriverManager.getConnection(DB_URL, DB_USR, DB_PASS);
            statement = connection.createStatement();
            statement.execute(query);
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }

    }


}