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;
}
}
|