import java.sql.*;

public class Database {

private Connection conn = null; // <--- obiekt polaczenia
private static final String USER = "root";
private static final String PASS = "root";


private static final String DB_URL = "jdbc:mysql://localhost/lab5";
//   jdbc <--- sterownik
//   mysql <--- dialekt sql / typ bazy
//   ://localhost/nowy"


public void connect(){
    sout("Connecting to database...");
    conn = DriverManager.getConnection(DB_URL,USER,PASS); // <---
    sout("Connected");
}

public void sendDoctorToDatabase(Doctor doctor){

try{
    Statement statement = conn.createStatement();
    String sql = "insert into doctors (name, surname) values "+
        + "('" + doctor.getName + "','" + doctors.getSurname() + "');";
    statement.execute(sql);
}
}


public ArrayList<Doctor> getDoctorList(){
    ArrayList<Doctor> doctors = new ArrayList<>();
    try{
        Statement statement = conn.createStatement();
        String sql = "select * from doctors;"; // zapytanie
        ResultSet resultSet = statement.executeQuery(sql);
        while(resultSet.next()){



        }


}