package server;

import ch.makery.address.model.Dogovor;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.io.Serializable;
import java.net.InetAddress;
import java.net.Socket;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class Database {

    Connection db;

    public Database() {
        try {
            db = DriverManager.getConnection("jdbc:mysql://localhost:3306/dogovora?serverTimezone=UTC", "root", "123456");

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

    public List<Dogovor> getAll() {
        try {

            Statement sql = db.createStatement();

            ResultSet rs = sql.executeQuery("SELECT * FROM dogovora");

            List<Dogovor> list = new ArrayList<>();

            while (rs.next()) {

                Dogovor d = new Dogovor();

                d.setTip(rs.getString("tip"));

                name = rs.getString("Name");
                type = rs.getString("Type");
                firma = rs.getString("Firma");
                price = rs.getString("Price");
                date = rs.getString("Date");

                x.append(st);
            }

            return list;

        } catch (SQLException e) {
            return null;
        }
    }

    public void deleteOne(Dogovor d) {
        try {
            Statement sql = db.createStatement();
            ResultSet rs = sql.executeQuery("DELETE from dogovora WHERE nomer = ?");
        }
    }

    public boolean addOne(Dogovor d) {
        return true;
    }

    public boolean editOne(Dogovor d) {
        return true;
    }

}