package dailySchool;

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

import javax.swing.JOptionPane;

public class Mysql
{
    private final String host =  "jdbc:mysql://localhost:3306/diary";
    private final String username = "root";
    private final String password ="";
    private Statement mysts;
    private ResultSet myRs;

    public void connection()
    {
        try
        {
            Connection connect = DriverManager.getConnection(host,username,password);
            mysts= connect.createStatement();

            //System.out.println("połaczono z baza danych");
        }
        catch(Exception error)
        {
            error.printStackTrace();
        }
    }

    public void addUser(String login, String password, int rang)
    {
        boolean isName = false;
        try
        {
            myRs= mysts.executeQuery("SELECT * from users ");

            while(myRs.next())
            {
                if(myRs.getString("login").equals(login)){
                    isName = true;
                    JOptionPane.showMessageDialog(null, "Login jest zajety");
                }
            }
            if(isName == false)
            {
                mysts.executeUpdate("INSERT INTO users(login,password,rang,accept) VALUES ("+""+login+","+ password+","+rang+",0)");
                JOptionPane.showMessageDialog(null, "Pomyslnie zarejestrowano użytkownika");
            }
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
    }

}