package sample;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public  class DatabaseHandler extends Configs {
     Connection dbConnection;
    public  Connection getDbConnection() throws ClassNotFoundException, SQLException {
        String connectionString = "jdbc:mysql://"+ dbHost + ":" + dbPort + "/" + dbName + "?" + "useUnicode=true&useSSL=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
        Class.forName("com.mysql.cj.jdbc.Driver");
        try {
            if (!dbConnection.isClosed()) {
                System.out.println("Соединение с БД установлено");
                dbConnection = DriverManager.getConnection(connectionString,"root", "1234");
            }
            }
            catch (Exception e)
            {System.out.println("Не  установлено");}
        return dbConnection;
    }


    public   void signUpUser(String firstname,String lasttname,String username,String password,String location,String pol)
    {
            String insert = "INSERT INTO "+ Const.USER_TABLE +"("+ Const.USERS_FIRSTNAME + "," + Const.USERS_LASTNAME +
        "," + Const.USERS_USERNAME + "," + Const.USERS_PASSWORD + "," + Const.USERS_LOCATION + "," + Const.USERS_POL+")"
                    +"values (?,?,?,?,?,?)";


        PreparedStatement prSt= null;
        try {
            prSt = getDbConnection().prepareStatement(insert);
            prSt.setString(1,firstname);
            prSt.setString(2,lasttname);
            prSt.setString(3,username);
            prSt.setString(4,password);
            prSt.setString(5,location);
            prSt.setString(6,pol);

            prSt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
                                           }
          }
        }