|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object com.hardcode.gdbms.driver.mysql.MySQLDriver
public class MySQLDriver
MySQL driver
Field Summary |
---|
Fields inherited from interface com.hardcode.gdbms.engine.values.ValueWriter |
---|
internalValueWriter |
Constructor Summary | |
---|---|
MySQLDriver()
|
Method Summary | |
---|---|
java.lang.String |
check(Field field,
Value value)
Checks if a given value is suitable for the specified field |
void |
close()
Free any resource reserved in the open method |
void |
createSource(DBSource source,
DriverMetadata driverMetadata)
Creates a new table. |
void |
execute(java.sql.Connection con,
java.lang.String sql)
Executes an instruction against the server |
java.lang.String[] |
getAvailableTypes()
Gets a string identificator for each type a field can have |
java.sql.Connection |
getConnection(java.lang.String host,
int port,
java.lang.String dbName,
java.lang.String user,
java.lang.String password)
DOCUMENT ME! |
DriverMetadata |
getDriverMetadata()
Gets the driver specific metadata |
java.util.HashMap |
getDriverProperties()
|
int |
getFieldCount()
DOCUMENT ME! |
java.lang.String |
getFieldName(int fieldId)
DOCUMENT ME! |
int |
getFieldType(int i)
DOCUMENT ME! |
Value |
getFieldValue(long rowIndex,
int fieldId)
DOCUMENT ME! |
java.lang.String |
getName()
|
java.lang.String |
getNullStatementString()
Gets the string of the binary param as it would appear in a SQL statement |
java.lang.String[] |
getParameters(java.lang.String driverType)
Gets the parameters used in creating the type |
long |
getRowCount()
DOCUMENT ME! |
java.lang.String |
getStatementString(boolean b)
Gets the string of the binary param as it would appear in a SQL statement |
java.lang.String |
getStatementString(byte[] binary)
Gets the string of the binary param as it would appear in a SQL statement |
java.lang.String |
getStatementString(java.sql.Date d)
Gets the string of the param as it would appear in a SQL statement |
java.lang.String |
getStatementString(double d,
int sqlType)
Gets the string of the d param as it would appear in a SQL statement |
java.lang.String |
getStatementString(Geometry g)
Gets the string representation of the geometry as it would appear in a SQL statement |
java.lang.String |
getStatementString(int i,
int sqlType)
Gets the string of the i param as it would appear in a SQL statement |
java.lang.String |
getStatementString(long i)
Gets the string of the i param as it would appear in a SQL statement |
java.lang.String |
getStatementString(java.lang.String str,
int sqlType)
Gets the string of the str param as it would appear in a SQL statement |
java.lang.String |
getStatementString(java.sql.Time t)
Gets the string of the param as it would appear in a SQL statement |
java.lang.String |
getStatementString(java.sql.Timestamp ts)
Gets the string of the param as it would appear in a SQL statement |
int |
getType(java.lang.String driverType)
Gets the suitable GDBMS type for the given driver specific type |
java.lang.String |
getTypeInAddColumnStatement(java.lang.String driverType,
java.util.HashMap<java.lang.String,java.lang.String> params)
Gets a statement to create the specified field on the given table |
boolean |
isReadOnly(int i)
Returns true if the specified field is read only |
boolean |
isValidParameter(java.lang.String driverType,
java.lang.String paramName,
java.lang.String paramValue)
Returns if the given value (paramValue) for the parameter called paramName of the given driver specific type is valid or not |
void |
open(java.sql.Connection con,
java.lang.String tableName,
java.lang.String orderFieldName)
Connects to the data source and reads the specified table in the specified order |
void |
setDataSourceFactory(DataSourceFactory dsf)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public MySQLDriver()
Method Detail |
---|
public java.sql.Connection getConnection(java.lang.String host, int port, java.lang.String dbName, java.lang.String user, java.lang.String password) throws java.sql.SQLException
getConnection
in interface DBDriver
host
- DOCUMENT ME!port
- DOCUMENT ME!dbName
- DOCUMENT ME!user
- DOCUMENT ME!password
- DOCUMENT ME!
java.sql.SQLException
java.lang.RuntimeException
- DOCUMENT ME!com.hardcode.gdbms.engine.data.driver.DBDriver#connect(java.lang.String)
public java.lang.String getName()
getName
in interface com.hardcode.driverManager.Driver
Driver.getName()
public void open(java.sql.Connection con, java.lang.String tableName, java.lang.String orderFieldName) throws DriverException
AlphanumericDBDriver
open
in interface AlphanumericDBDriver
con
- Connection to usetableName
- Name of the table where the data is inorderFieldName
- Name of the order field. Can be null
DriverException
com.hardcode.gdbms.engine.data.driver.DBDriver#executeSQL(java.sql.Connection,
java.lang.String)
public int getFieldCount() throws DriverException
DriverException
- DOCUMENT ME!public java.lang.String getFieldName(int fieldId) throws DriverException
fieldId
- DOCUMENT ME!
DriverException
- DOCUMENT ME!public int getFieldType(int i) throws DriverException
i
- DOCUMENT ME!
DriverException
- DOCUMENT ME!public Value getFieldValue(long rowIndex, int fieldId) throws DriverException
getFieldValue
in interface ReadAccess
rowIndex
- DOCUMENT ME!fieldId
- DOCUMENT ME!
DriverException
- DOCUMENT ME!public long getRowCount() throws DriverException
getRowCount
in interface ReadAccess
DriverException
- DOCUMENT ME!public void close() throws DriverException
DBDriver
close
in interface DBDriver
DriverException
DBDriver.close()
public java.util.HashMap getDriverProperties()
com.hardcode.gdbms.engine.data.driver.DriverCommons#getDriverProperties()
public void setDataSourceFactory(DataSourceFactory dsf)
setDataSourceFactory
in interface GDBMSDriver
com.hardcode.gdbms.engine.data.driver.DriverCommons#setDataSourceFactory(com.hardcode.gdbms.engine.data.DataSourceFactory)
public void execute(java.sql.Connection con, java.lang.String sql) throws java.sql.SQLException
DBDriver
execute
in interface DBDriver
con
- Connection used to execute the instructionsql
- Instruction to execute
java.sql.SQLException
- If the execution failscom.hardcode.gdbms.engine.data.driver.DBDriver#execute(java.sql.Connection,
java.lang.String, com.hardcode.gdbms.engine.data.HasProperties)
public java.lang.String getStatementString(long i)
ValueWriter
getStatementString
in interface ValueWriter
i
- long to format
ValueWriter.getStatementString(long)
public java.lang.String getStatementString(int i, int sqlType)
ValueWriter
getStatementString
in interface ValueWriter
i
- integer to formatsqlType
- SQL type of the parameter. Any of the following
java.sql.Types constants: INTEGER, SMALLINT, TINYINT
ValueWriter.getStatementString(int,
int)
public java.lang.String getStatementString(double d, int sqlType)
ValueWriter
getStatementString
in interface ValueWriter
d
- double to formatsqlType
- SQL type of the parameter. Any of the following
java.sql.Types constants: DOUBLE, FLOAT, REAL, NUMERIC, DECIMAL
ValueWriter.getStatementString(double,
int)
public java.lang.String getStatementString(java.lang.String str, int sqlType)
ValueWriter
getStatementString
in interface ValueWriter
str
- string to formatsqlType
- SQL type of the parameter. Any of the following
java.sql.Types constants: CHAR, VARCHAR, LONGVARCHAR
ValueWriter.getStatementString(java.lang.String,
int)
public java.lang.String getStatementString(java.sql.Date d)
ValueWriter
getStatementString
in interface ValueWriter
d
- Date to format
ValueWriter.getStatementString(java.sql.Date)
public java.lang.String getStatementString(java.sql.Time t)
ValueWriter
getStatementString
in interface ValueWriter
t
- Time to format
ValueWriter.getStatementString(java.sql.Time)
public java.lang.String getStatementString(java.sql.Timestamp ts)
ValueWriter
getStatementString
in interface ValueWriter
ts
- timestamp to format
ValueWriter.getStatementString(java.sql.Timestamp)
public java.lang.String getStatementString(byte[] binary)
ValueWriter
getStatementString
in interface ValueWriter
binary
- byte array to format
ValueWriter.getStatementString(byte[])
public java.lang.String getStatementString(boolean b)
ValueWriter
getStatementString
in interface ValueWriter
b
- byte array to format
ValueWriter.getStatementString(boolean)
public java.lang.String getNullStatementString()
ValueWriter
getNullStatementString
in interface ValueWriter
ValueWriter.getNullStatementString()
public java.lang.String getStatementString(Geometry g)
ValueWriter
getStatementString
in interface ValueWriter
g
- Geometry
ValueWriter.getStatementString(com.hardcode.gdbms.engine.spatial.Geometry)
public DriverMetadata getDriverMetadata() throws DriverException
GDBMSDriver
getDriverMetadata
in interface GDBMSDriver
DriverException
GDBMSDriver.getDriverMetadata()
public int getType(java.lang.String driverType)
TypeConverter
getType
in interface TypeConverter
TypeConverter.getType(java.lang.String)
public java.lang.String getTypeInAddColumnStatement(java.lang.String driverType, java.util.HashMap<java.lang.String,java.lang.String> params)
DBDriver
getTypeInAddColumnStatement
in interface DBDriver
public java.lang.String[] getAvailableTypes() throws DriverException
GDBMSDriver
getAvailableTypes
in interface GDBMSDriver
DriverException
public java.lang.String[] getParameters(java.lang.String driverType) throws DriverException
GDBMSDriver
getParameters
in interface GDBMSDriver
DriverException
public void createSource(DBSource source, DriverMetadata driverMetadata) throws DriverException
AlphanumericDBDriver
createSource
in interface AlphanumericDBDriver
DriverException
- TODOpublic java.lang.String check(Field field, Value value) throws DriverException
GDBMSDriver
check
in interface GDBMSDriver
DriverException
public boolean isReadOnly(int i) throws DriverException
GDBMSDriver
isReadOnly
in interface GDBMSDriver
DriverException
public boolean isValidParameter(java.lang.String driverType, java.lang.String paramName, java.lang.String paramValue)
GDBMSDriver
isValidParameter
in interface GDBMSDriver
paramValue
- null if the parameter is not specified
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |