Retrieving Last_IP Field from accounts table

[leomade]

Hello everyone, is there anyway to retreive last_Ip from account table in java?

i'm working on some code and in it i need to compare some IPs, but if using the getClient().getConnection().. method it doesnt always go smoothly, as it needs alot addational checks in my case..

 

Can someone tell me how can i get that last_ip field with java?

thanks

[B1ggBoss]

import javolution.util.FastMap;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.l2jserver.L2DatabaseFactory;

public final class LastIPTable
{
public static FastMap<String, String> cachedLastIPs = new FastMap<String, String>();

static 
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
		PreparedStatement st = con.prepareStatement("SELECT login, lastIP FROM accounts");
		ResultSet rset = st.executeQuery();
		while(rset.next())
		{
			cachedLastIPs.put(rset.getString("login"), rset.getString("lastIP"));
		}
		rset.close();
		st.close();
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{
		L2DatabaseFactory.close(con);
	}
}

public static String getLastIP(final String account)
{
	return cachedLastIPs.get(account);
}

// Should be called on player's log out
public static void updateLastIP(final String account, final String lastIp)
{
	cachedLastIPs.put(account, lastIP);
}
}