/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package javaapplication3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;

/**
 *
 * @author usuario
 */
public class Funcoes {

    private static final String DB_URL = "jdbc:mysql://localhost/devweb2";
    private static final String DB_USER = "root";
    private static final String DB_PASSWD = "root";

    // Busca se login ja existe na base de dados, e se existir retorna com a id da linha onde esta alocado.
    public int retornaIDdeLogin(String login) throws SQLException {

        Connection conexao = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWD);

        Statement sts = conexao.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        ResultSet rsr = sts.executeQuery("SELECT * FROM usuario WHERE login = '" + login + "'");

        rsr.next();
        int id = rsr.getInt("id");
        return id;

    }

    //   public ResultSet selectGeral() throws SQLException {
    //     Connection conexao = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWD);
    //   Statement st = conexao.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    // ResultSet rs = st.executeQuery("SELECT * FROM usuario");
    // return rs;
    // }
    public String validaSenha() {
        String senha1 = "";
        String erro = null;
        int tmp = 0;

        while (tmp == 0) {
            senha1 = JOptionPane.showInputDialog("Digite a sua nova senha:");
            String senha2 = JOptionPane.showInputDialog("Digite novamente a sua nova senha para confirmar:");

            if (senha1.equals(senha2)) {
                tmp = 1;
                return senha1;
            }
        }
        return erro;
    }
}