MyFirstDB

package BankAccount;

import java.sql.*;
/**
 * Created by Bogdan on 10.02.2017.
 */
public class DataBase {
    private final String url = "jdbc:mysql://localhost:3306/accountdb";
    private Statement stmt = null;
    private Connection conn = null;
    private ResultSet rs = null;
    private PreparedStatement ps = null;

    public void connect(){
        try {
            conn = DriverManager.getConnection(url,"root","root");
        }
        catch (Exception e){
            System.err.println(e.getMessage());
        }
    }
    public void addAccount(String name, String lastname, String email, String password) {
        try {
            connect();
            String query = " insert into account (name, lastname, email, password, balance)" + " values (?, ?, ?, ?, ?)";
            ps = conn.prepareStatement(query);
            ps.setString(1, name);
            ps.setString(2, lastname);
            ps.setString(3, email);
            ps.setString(4, password);
            ps.setInt(5,0);

            ps.execute();
            conn.close();
        }
        catch (Exception e){
            System.err.println(e.getMessage());
        }

    }

    public boolean getAccount(String email, String password){
        String query = "select email,password from account where email=?";
        try {
            connect();
            ps = conn.prepareStatement(query);
            ps.setString(1,email);
            rs = ps.executeQuery();
                while(rs.next()) {
                    if (rs.getString(1).equals(email) && rs.getString(2).equals(password)) {
                        System.out.println("Авторизация прошла успешно...");
                        conn.close();
                        return true;
                    } else {
                        return false;
                    }
                }
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        }
        return false;
    }
}