package vaannila;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class SignUp {

	private String signupUsername;
	private String signupPassword;
	private Connection connection;
	private PreparedStatement addContactsList;

	public SignUp(){}

	public String execute(){
		setSignupUsername(getSignupUsername());
		return "SUCCESS";
		}

	public String signup(){
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			connection =  DriverManager.getConnection( "jdbc:odbc:lottoDatabase");
			addContactsList = connection.prepareStatement("INSERT INTO Users(username, password) "+" VALUES(?, ?)");
			addContactsList.setString(1, getSignupUsername());
			addContactsList.setString(2, getSignupPassword());
			addContactsList.execute();
			return "SUCCESS";
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
			return "FAILURE";
		}
	}

	public void setSignupUsername(String signupUsername) {
		this.signupUsername = signupUsername;
	}

	public String getSignupUsername() {
		return signupUsername;
	}

	public void setSignupPassword(String signupPassword) {
		this.signupPassword = signupPassword;
	}

	public String getSignupPassword() {
		return signupPassword;
	}



}