All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class twz1.jdbc.mysql.RSMd

java.lang.Object
   |
   +----twz1.jdbc.mysql.RSMd

public final class RSMd

extends Object

implements ResultSetMetaData

cc

Column count

cnames

Hashtable of column names

cols

vector of column descriptors

errs

GETCATALOGNAME

GETCOLUMNCOUNT

GETCOLUMNDISPLAYSIZE

GETCOLUMNLABEL

GETCOLUMNNAME

GETCOLUMNTYPE

GETCOLUMNTYPENAME

GETPRECISION

GETSCALE

GETSCHEMANAME

GETTABLENAME

ISAUTOINCREMENT

ISCASESENSITIVE

ISCURRENCY

ISDEFINITELYWRITABLE

ISNULLABLE

ISREADONLY

ISSEARCHABLE

ISSIGNED

ISWRITABLE

pmethods

stmt

The parent statement.

RSMd()

RSMd(jdbcMysqlStmt)

addField(jdbcMysqlField)

Removed close to make it reusable and remove need for locks

copy()

for our purposes the vector and hashtable can be shared

errHandlerE(int, Exception)

getCatalogName(int)

See API.

getColumnCount()

See API docs

getColumnDisplaySize(int)

See API.

getColumnLabel(int)

See the API.

getColumnName(int)

See API

getColumnType(int)

See API.

getColumnTypeName(int)

See API.

getField(int)

getField(String)

getField(String, String)

getPrecision(int)

See API.

getScale(int)

See API

getSchemaName(int)

See API, returns ""

getTableName(int)

See API

iReq(int, int)

isAutoIncrement(int)

This should be testable, but the flags do not return this information from a standard query.

isCaseSensitive(int)

See API and mysql docs.

isCurrency(int)

Nothing in MySQL describes currency, per se

isDefinitelyWritable(int)

isNullable(int)

See API

isReadOnly(int)

All cols are writable.

isSearchable(int)

See API -- all MySQL fields are searchable.

isSigned(int)

See API, but true only for numeric types with unsigned not set

isTypeNumeric(int)

isWritable(int)

All cols are writable.

mapMySQLtypes(int, jdbcMysqlField)

sqlTypeNames(int)

sReq(int, int)

typeXcept(int, int)

Throw a bad type exception if rsmdXcept, else return r value.

 jdbcMysqlStmt stmt

The parent statement.

 Vector cols

vector of column descriptors

 int cc

Column count

 Hashtable cnames

Hashtable of column names

 static final String errs[]

 static final int GETCOLUMNCOUNT

 static final int ISAUTOINCREMENT

 static final int ISCASESENSITIVE

 static final int ISSEARCHABLE

 static final int ISCURRENCY

 static final int ISNULLABLE

 static final int ISSIGNED

 static final int GETCOLUMNDISPLAYSIZE

 static final int GETCOLUMNLABEL

 static final int GETCOLUMNNAME

 static final int GETSCHEMANAME

 static final int GETPRECISION

 static final int GETSCALE

 static final int GETTABLENAME

 static final int GETCATALOGNAME

 static final int GETCOLUMNTYPE

 static final int GETCOLUMNTYPENAME

 static final int ISREADONLY

 static final int ISWRITABLE

 static final int ISDEFINITELYWRITABLE

 static final String pmethods[]

 RSMd(jdbcMysqlStmt st)

 RSMd()

 RSMd copy()

for our purposes the vector and hashtable can be shared

 void addField(jdbcMysqlField f) throws SQLException

Removed close to make it reusable and remove need for locks

 jdbcMysqlField getField(int column) throws SQLException

 jdbcMysqlField getField(String cname) throws SQLException

 jdbcMysqlField getField(String tname,
                         String cname) throws SQLException

 public int getColumnCount() throws SQLException

See API docs

 public boolean isAutoIncrement(int column) throws SQLException

This should be testable, but the flags do not return this information from a standard query. Currently returns false. Future implementations may conduct a more extensive investigation to recover this information via a call to describe.

 public boolean isCaseSensitive(int column) throws SQLException

See API and mysql docs. Char, text and varchar fields are text insensitive in where clauses according to MySQL docs. Otherwise true.

 public boolean isSearchable(int column) throws SQLException

See API -- all MySQL fields are searchable.

 public boolean isCurrency(int column) throws SQLException

Nothing in MySQL describes currency, per se

 public int isNullable(int column) throws SQLException

See API

 public boolean isSigned(int column) throws SQLException

See API, but true only for numeric types with unsigned not set

 public int getColumnDisplaySize(int column) throws SQLException

See API. this result could be very large for blobs.

 public String getColumnLabel(int column) throws SQLException

See the API. Returns the column name if it is unique and the catenated table name and column otherwise.

 public String getColumnName(int column) throws SQLException

See API

 public String getSchemaName(int column) throws SQLException

See API, returns ""

 public int getPrecision(int column) throws SQLException

See API. For Mysql this is column size for numerics; non-numerics are exceptional. Future releases may take cognizance that signs and decimals lessen the mathematical precision of returned values.

 public int getScale(int column) throws SQLException

See API

 public String getTableName(int column) throws SQLException

See API

 public String getCatalogName(int column) throws SQLException

See API. For MySQL this is the name of the "database" to which the connection is currently maintained.

 public int getColumnType(int column) throws SQLException

See API. This is somewhat problematic as MySQL types do not map precisely to jdbc types.

 public String getColumnTypeName(int column) throws SQLException

See API. Possible problems mapping MySQL to jdbc types.

 public boolean isReadOnly(int column) throws SQLException

All cols are writable.

 public boolean isWritable(int column) throws SQLException

All cols are writable.

 public boolean isDefinitelyWritable(int column) throws SQLException

 private int iReq(int req,
                  int c) throws SQLException

 int typeXcept(int n,
               int r) throws SQLException

Throw a bad type exception if rsmdXcept, else return r value.

Parameters:

n - method name number.

r - value to return if we are not taking an exception.

 private String sReq(int req,
                     int c) throws SQLException

 static int mapMySQLtypes(int i,
                          jdbcMysqlField f)

 static String sqlTypeNames(int type)

 private boolean isTypeNumeric(int i)

 void errHandlerE(int n,
                  Exception e) throws SQLException

All Packages  Class Hierarchy  This Package  Previous  Next  Index