|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectgame.gamestorage.texas.db.SQLHandler
public class SQLHandler
This class handles the communication to the database offers different kinds of returnable datatypes
Field Summary | |
---|---|
private ConnectionManager |
cm
|
Constructor Summary | |
---|---|
SQLHandler()
Constructor default initializes ConnectionManager |
|
SQLHandler(java.lang.String driver,
java.lang.String databaseUrl,
java.lang.String username,
java.lang.String password,
int maxPoolSize)
Constructor with specific database params probably only need for test cases |
Method Summary | |
---|---|
boolean |
connectionSuccess()
|
private java.sql.Statement |
getStatement(java.sql.Connection con)
getStatement: |
java.util.HashMap<java.lang.Integer,java.lang.String> |
sqlGetHashMapIntString(java.lang.String sql)
sqlGetHashMapStringInt: SELECT |
java.util.HashMap<java.lang.String,java.lang.Integer> |
sqlGetHashMapStringInt(java.lang.String sql)
sqlGetHashMapStringInt: SELECT |
int |
sqlGetInt(java.lang.String sql)
sqlGetInt: SELECT |
java.util.ArrayList<int[]> |
sqlGetIntArrayListMultiPerRow(java.lang.String sql,
int numCols)
sqlGetIntArrayListMultiPerRow: SELECT |
int[][] |
sqlGetIntArrayMultiPerRow(java.lang.String sql,
int numCols)
sqlGetIntArrayMultiPerRow: SELECT |
int[] |
sqlGetIntArrayOnePerRow(java.lang.String sql)
sqlGetIntArrayOnePerRow: SELECT |
java.util.ArrayList<long[]> |
sqlGetLongArrayListMultiPerRow(java.lang.String sql,
int numCols)
sqlGetLongArrayListMultiPerRow: SELECT |
long[] |
sqlGetLongArrayOnePerRow(java.lang.String sql)
sqlGetIntArrayOnePerRow: SELECT |
java.sql.ResultSet |
sqlGetResultSet(java.lang.String sql)
sqlGetResultSet: SELECT |
protected boolean |
sqlSet(java.lang.String sql)
sqlSet: INSERT, UPDATE, DELETE |
protected int |
sqlSetReturnID(java.lang.String sql)
sqlSetReturnID: INSERT, UPDATE, DELETE |
protected int[] |
sqlSetReturnIDs(java.lang.String sql)
sqlSetReturnIDs: INSERT, UPDATE, DELETE |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
private ConnectionManager cm
Constructor Detail |
---|
public SQLHandler()
public SQLHandler(java.lang.String driver, java.lang.String databaseUrl, java.lang.String username, java.lang.String password, int maxPoolSize)
driver
- which dbc driverdatabaseUrl
- -username
- -password
- -maxPoolSize
- - how many db-connection should the ConnectionManager allocateMethod Detail |
---|
protected boolean sqlSet(java.lang.String sql)
sql
- query
protected int[] sqlSetReturnIDs(java.lang.String sql)
sql
- query
protected int sqlSetReturnID(java.lang.String sql)
sql
- query
public java.sql.ResultSet sqlGetResultSet(java.lang.String sql)
sql
- query
public java.util.HashMap<java.lang.String,java.lang.Integer> sqlGetHashMapStringInt(java.lang.String sql)
sql
- query
public java.util.HashMap<java.lang.Integer,java.lang.String> sqlGetHashMapIntString(java.lang.String sql)
sql
- query
public int sqlGetInt(java.lang.String sql)
sql
- query
public int[] sqlGetIntArrayOnePerRow(java.lang.String sql)
sql
- query
public long[] sqlGetLongArrayOnePerRow(java.lang.String sql)
sql
- query
public int[][] sqlGetIntArrayMultiPerRow(java.lang.String sql, int numCols)
sql
- querynumCols
- length
public java.util.ArrayList<int[]> sqlGetIntArrayListMultiPerRow(java.lang.String sql, int numCols)
sql
- querynumCols
- length
public java.util.ArrayList<long[]> sqlGetLongArrayListMultiPerRow(java.lang.String sql, int numCols)
sql
- querynumCols
- length
private java.sql.Statement getStatement(java.sql.Connection con)
con
-
public boolean connectionSuccess()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |