package loginProject;

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

import loginProject.Connects;

public class NewAccount {
	public static void createAccount(String u, String p) {
		Connection con = (Connection) new Connects().connect();
		try {
			Statement statement = (Statement) con.createStatement();  // executeUpdate will update or insert
			((java.sql.Statement) statement).executeUpdate("INSERT INTO accounts (username, password) "
					+ "VALUES(" + u + "," + p + ");");
		}catch(Exception e) {
			System.out.println(e + " (exception from createAccount)");
		}
	}
	
	public static boolean verifyAccount(String u, String p) {
		Connection con = (Connection) new Connects().connect();
		boolean exists = false;
		try {
			Statement statement = (Statement) con.createStatement();
			ResultSet rs = ((java.sql.Statement) statement).executeQuery("SELECT * FROM Accounts WHERE "
					+ "(Username=" + u + ", Password=" + p + ");");
			// if not in table, what is the return?
			if (rs != null) {
				exists = true;
			}
		}catch(Exception e) {
			System.out.println(e);
		}
		return exists;
	}
}