package com.missiondata.dbtest.container;

import com.missiondata.dbtest.model.User;
import java.sql.*;

public class UserContainer
{

  private static User getFromResultSet (ResultSet r)
  throws SQLException
  {
    User user = new User();
    user.setUsername( r.getString("username") );
    user.setPassword( r.getString("password") );
    user.setEmail( r.getString("email") );
    return user;
  }

  public static User getUserByName (Connection conn, String username)
  throws SQLException
  {
    User user = null;
    String query = "SELECT username,password,email FROM user"
                 + " WHERE username = '"
                 + username + "'";

    Statement st = conn.createStatement();
    ResultSet r = st.executeQuery(query);
    if ( r.next() )
    {
      user = getFromResultSet(r);
    }
    return user;
  }
}