arcade.lobby.model
Class MySqlAdapter

java.lang.Object
  arcade.lobby.model.MySqlAdapter

All Implemented Interfaces:

DatabaseAdapter

public class MySqlAdapter
extends java.lang.Object
implements DatabaseAdapter

Constructor Summary

MySqlAdapter(java.lang.String host, java.lang.String dbName, java.lang.String user, java.lang.String pass)

Method Summary

java.util.List<java.lang.String>	getColumn(java.lang.String tableName, java.lang.String columnName) Gets a column from a database table as a list of strings.
java.util.List<java.util.Map<java.lang.String,java.lang.String>>	getRows(java.lang.String tableName, java.lang.String field, java.lang.String value)
boolean	insert(java.lang.String tableName, java.util.Map<java.lang.String,java.lang.String> row)
boolean	update(java.lang.String tableName, java.lang.String pkName, java.util.Map<java.lang.String,java.lang.String> row)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySqlAdapter

public MySqlAdapter(java.lang.String host,
                    java.lang.String dbName,
                    java.lang.String user,
                    java.lang.String pass)

Method Detail

getColumn

public java.util.List<java.lang.String> getColumn(java.lang.String tableName,
                                                  java.lang.String columnName)

Description copied from interface: DatabaseAdapter

Gets a column from a database table as a list of strings.

Specified by:

getColumn in interface DatabaseAdapter

Parameters:

tableName - Name of table

columnName - Name of field

Returns:

List of strings containing value of specified field for all rows in table

getRows

public java.util.List<java.util.Map<java.lang.String,java.lang.String>> getRows(java.lang.String tableName,
                                                                                java.lang.String field,
                                                                                java.lang.String value)

Specified by:

getRows in interface DatabaseAdapter

insert

public boolean insert(java.lang.String tableName,
                      java.util.Map<java.lang.String,java.lang.String> row)

Specified by:

insert in interface DatabaseAdapter

update

public boolean update(java.lang.String tableName,
                      java.lang.String pkName,
                      java.util.Map<java.lang.String,java.lang.String> row)

Specified by:

update in interface DatabaseAdapter