ky2yc

#include <iostream>
#include <iomanip>
#include <string>
#include "kz9yc.h"

namespace jsf2demo
{

	AddressRegistrationJSFBean::AddressRegistrationJSFBean()
	{
	  initializeJdbc();
	}

	std::wstring AddressRegistrationJSFBean::getLastName()
	{
	  return lastName;
	}

	void AddressRegistrationJSFBean::setLastName(const std::wstring &lastName)
	{
	  this->lastName = lastName;
	}

	std::wstring AddressRegistrationJSFBean::getFirstName()
	{
	  return firstName;
	}

	void AddressRegistrationJSFBean::setFirstName(const std::wstring &firstName)
	{
	  this->firstName = firstName;
	}

	std::wstring AddressRegistrationJSFBean::getMi()
	{
	  return mi;
	}

	void AddressRegistrationJSFBean::setMi(const std::wstring &mi)
	{
	  this->mi = mi;
	}

	std::wstring AddressRegistrationJSFBean::getTelephone()
	{
	  return telephone;
	}

	void AddressRegistrationJSFBean::setTelephone(const std::wstring &telephone)
	{
	  this->telephone = telephone;
	}

	std::wstring AddressRegistrationJSFBean::getEmail()
	{
	  return email;
	}

	void AddressRegistrationJSFBean::setEmail(const std::wstring &email)
	{
	  this->email = email;
	}

	std::wstring AddressRegistrationJSFBean::getStreet()
	{
	  return street;
	}

	void AddressRegistrationJSFBean::setStreet(const std::wstring &street)
	{
	  this->street = street;
	}

	std::wstring AddressRegistrationJSFBean::getCity()
	{
	  return city;
	}

	void AddressRegistrationJSFBean::setCity(const std::wstring &city)
	{
	  this->city = city;
	}

	std::wstring AddressRegistrationJSFBean::getState()
	{
	  return state;
	}

	void AddressRegistrationJSFBean::setState(const std::wstring &state)
	{
	  this->state = state;
	}

	std::wstring AddressRegistrationJSFBean::getZip()
	{
	  return zip;
	}

	void AddressRegistrationJSFBean::setZip(const std::wstring &zip)
	{
	  this->zip = zip;
	}

	bool AddressRegistrationJSFBean::isRquiredFieldsFilled()
	{
	  return !(lastName == L"" || firstName == L"" || StringHelper::trim(lastName)->length() == 0 || StringHelper::trim(firstName)->length() == 0);
	}

	std::wstring AddressRegistrationJSFBean::processSubmit()
	{
	  if (isRquiredFieldsFilled())
	  {
		return L"ConfirmAddress";
	  }
	  else
	  {
		return L"";
	  }
	}

	std::wstring AddressRegistrationJSFBean::getRequiredFields()
	{
	  if (isRquiredFieldsFilled())
	  {
		return L"";
	  }
	  else
	  {
		return L"Last Name and First Name are required";
	  }
	}

	std::wstring AddressRegistrationJSFBean::getInput()
	{
	  return std::wstring(L"<p style=\"color:red\">You entered <br />")
			  + L"Last Name: " + lastName + L"<br />"
			  + L"First Name: " + firstName + L"<br />"
			  + L"MI: " + mi + L"<br />"
			  + L"Telephone: " + telephone + L"<br />"
			  + L"Email: " + email + L"<br />"
			  + L"Street: " + street + L"<br />"
			  + L"City: " + city + L"<br />"
			  + L"Street: " + street + L"<br />"
			  + L"City: " + city + L"<br />"
			  + L"State: " + state + L"<br />"
			  + L"Zip: " + zip + L"</p>";
	}

	void AddressRegistrationJSFBean::initializeJdbc()
	{
	  try
	  {
		// Explicitly load a MySQL driver
		std::type_info::forName(L"com.mysql.jdbc.Driver");
		std::wcout << L"Driver loaded" << std::endl;

		// Establish a connection
		Connection *conn = DriverManager::getConnection(L"jdbc:mysql://localhost/javabook", L"scott", L"tiger");

		// Create a Statement
		pstmt = conn->prepareStatement(std::wstring(L"insert into Address (lastName,") + L" firstName, mi, telephone, email, street, city, " + L"state, zip) values (?, ?, ?, ?, ?, ?, ?, ?, ?)");
	  }
	  catch (const std::exception &ex)
	  {
		std::wcout << ex << std::endl;
	  }
	}

	std::wstring AddressRegistrationJSFBean::storeStudent()
	{
	  try
	  {
		pstmt->setString(1, lastName);
		pstmt->setString(2, firstName);
		pstmt->setString(3, mi);
		pstmt->setString(4, telephone);
		pstmt->setString(5, email);
		pstmt->setString(6, street);
		pstmt->setString(7, city);
		pstmt->setString(8, state);
		pstmt->setString(9, zip);
		pstmt->executeUpdate();
		status = firstName + L" " + lastName + L" is now registered in the database.";
	  }
	  catch (const std::exception &ex)
	  {
		status = ex.what();
	  }

	  return L"AddressStoredStatus";
	}

	std::wstring AddressRegistrationJSFBean::getStatus()
	{
	  return status;
	}
}