edu.usc.ict.iago.utils

Class DatabaseUtils

java.lang.Object

edu.usc.ict.iago.utils.DatabaseUtils

public class DatabaseUtils
extends java.lang.Object

Database utility functions

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	USER_DB

Constructor Summary

Constructors

Constructor and Description
DatabaseUtils()

Method Summary

Modifier and Type	Method and Description
static void	connect() Provides a connection to a mySQL database for storing user information and logs.
static int	createUser() Deprecated.
static int	insert(java.lang.String table, java.util.Map<java.lang.String,java.lang.String> column_value_map) Convinience method for multiple String inserts.
static java.sql.ResultSet	query(java.lang.String sql, java.lang.Object... params) Generic, sanitized query.
static void	setDBCredentials(java.lang.String dbUrl, java.lang.String dbSchema, java.lang.String dbUser, java.lang.String dbPass)
static void	update(java.lang.String sql, java.lang.Object... params) Sanitize method for updates (and inserts)

Methods inherited from class java.lang.Object

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

Field Detail

USER_DB

public static final java.lang.String USER_DB

See Also:

Constant Field Values

Constructor Detail

DatabaseUtils

public DatabaseUtils()

Method Detail

connect

public static void connect()

Provides a connection to a mySQL database for storing user information and logs. Currently DISABLED in the Game_Edition

query

public static java.sql.ResultSet query(java.lang.String sql,
                                       java.lang.Object... params)

Generic, sanitized query.

Parameters:

sql -

params -

Returns:

a ResultSet

update

public static void update(java.lang.String sql,
                          java.lang.Object... params)

Sanitize method for updates (and inserts)

Parameters:

sql -

params -

insert

public static int insert(java.lang.String table,
                         java.util.Map<java.lang.String,java.lang.String> column_value_map)
                  throws java.sql.SQLException

Convinience method for multiple String inserts.

Parameters:

table -

column_value_map -

Returns:

0 on success or -1 on failure

Throws:

java.sql.SQLException

createUser

@Deprecated
public static int createUser()

Deprecated.

setDBCredentials

public static void setDBCredentials(java.lang.String dbUrl,
                                    java.lang.String dbSchema,
                                    java.lang.String dbUser,
                                    java.lang.String dbPass)