All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class twz1.jdbc.mysql.jdbcMysqlRSet 

java.lang.Object
   |
   +----twz1.jdbc.mysql.jdbcMysqlRSet
public final class jdbcMysqlRSet
extends Object
implements ResultSet
This class implements Result Set to return SQL data to the application. Since MySQL returns all numeric data as text strings, we treat all columns as such regardless of their defined type and parse that string into the requested type, only throwing an exception if the parse is impossible. At a later time I may validate conversions strictly according to the API, but for now, let it fly.

Variable Index

o cached
o columnCount
localize column count
o currentRow
Current row
o errs
o FINDCOLUMN
o GETASCIISTREAM
o GETBIGDECIMAL
o GETBINARYSTREAM
o GETBOOLEAN
o GETBYTE
o GETBYTES
o GETDATE
o GETDOUBLE
o GETFLOAT
o GETINT
o GETLONG
o GETMETADATA
o GETOBJECT
o GETSHORT
o GETSTRING
o gettable
o GETTIME
o GETTIMESTAMP
o GETUNICODESTREAM
o inBag
Access to the input
o isClosed
Have we been closed
o isDone
Have we exhaused data
o isStarted
Have we even started yet
o lastNull
A bit of API silliness
o lTimeout
o maxRows
o mcache
o mcacheSize
o metadata
Access to the mapping
o myOID
My object id
o nameIt
o noMoreData
Are we done
o result
Access the result
o retrieved
Has this RS been retrieved
o rsDateXcept
Do we throw exception in getDate before 1900?
o rsLock
do we lock before answering inquiries ?
o statement
Access the statement
o WASNULL
o xRow

Constructor Index

o jdbcMysqlRSet(jdbcMysqlResult)

Method Index

o clearWarnings()
I said we don't support warnings!
o close()
See API.
o errHandlerE(int, Exception)
o errHandlerE2(int, int, String, Exception)
o errHandlerE2b(int, int, String, Exception)
o errHandlerM(int, String)
o errHandlerNM(int, int, String)
o fByName(String)
o findColumn(String)
Return the ordinal column
o getAsciiStream(int)
See API.
o getAsciiStream(String)
See API.
o getBigDecimal(int, int)
See API
o getBigDecimal(String, int)
See API
o getBinaryStream(int)
See API.
o getBinaryStream(String)
See API.
o getBoolean(int)
See the API.
o getBoolean(String)
See the API.
o getByte(int)
See API.
o getByte(String)
See API.
o getBytes(int)
See API
o getBytes(String)
See API
o getCursorName()
MySQL doesn't do cursors.
o getDate(int)
See API
o getDate(String)
See API
o getDouble(int)
See the API
o getDouble(String)
See the API
o getFloat(int)
See API
o getFloat(String)
See API
o getInt(int)
See API.
o getInt(String)
See API.
o getIt(int, int, String, int)
o getLong(int)
See API.
o getLong(String)
See API.
o getMetaData()
o getObject(int)
getObject returns a byte array as an object
o getObject(String)
getObject returns a byte array as an object
o getShort(int)
See API.
o getShort(String)
See API.
o getString(int)
See the API
o getString(String)
See the API
o getTime(int)
See API
o getTime(String)
See API
o getTimestamp(int)
See API
o getTimestamp(String)
See API
o getUnicodeStream(int)
See API.
o getUnicodeStream(String)
See API.
o getWarnings()
We don't support warnings at this time.
o iClose()
We be closed!
o isRetrieved()
o myID()
Tell others who I am.
o next()
See API.
o nopSynch(String)
o nParse(String, int)
o retrieved(boolean)
o testBool(String)
o testStatus(String)
o wasNull()
A thoughtless API request.

Variables

o myOID 
 int myOID
My object id

o result 
 jdbcMysqlResult result
Access the result

o statement 
 jdbcMysqlStmt statement
Access the statement

o retrieved 
 boolean retrieved
Has this RS been retrieved

o inBag 
 jdbcMysqlBag inBag
Access to the input

o metadata 
 RSMd metadata
Access to the mapping

o currentRow 
 int currentRow
Current row

o isClosed 
 boolean isClosed
Have we been closed

o isDone 
 boolean isDone
Have we exhaused data

o isStarted 
 boolean isStarted
Have we even started yet

o noMoreData 
 boolean noMoreData
Are we done

o lastNull 
 boolean lastNull
A bit of API silliness

o rsLock 
 boolean rsLock
do we lock before answering inquiries ?

o gettable 
 boolean gettable
o rsDateXcept 
 boolean rsDateXcept
Do we throw exception in getDate before 1900?

o columnCount 
 int columnCount
localize column count

o cached 
 boolean cached
o lTimeout 
 int lTimeout
o maxRows 
 int maxRows
o xRow 
 Row xRow
o mcache 
 Vector mcache
o mcacheSize 
 int mcacheSize
o GETSTRING 
 static final int GETSTRING
o GETBOOLEAN 
 static final int GETBOOLEAN
o GETBYTE 
 static final int GETBYTE
o GETSHORT 
 static final int GETSHORT
o GETINT 
 static final int GETINT
o GETLONG 
 static final int GETLONG
o GETFLOAT 
 static final int GETFLOAT
o GETDOUBLE 
 static final int GETDOUBLE
o GETBIGDECIMAL 
 static final int GETBIGDECIMAL
o GETBYTES 
 static final int GETBYTES
o GETDATE 
 static final int GETDATE
o GETTIME 
 static final int GETTIME
o GETTIMESTAMP 
 static final int GETTIMESTAMP
o GETASCIISTREAM 
 static final int GETASCIISTREAM
o GETBINARYSTREAM 
 static final int GETBINARYSTREAM
o GETUNICODESTREAM 
 static final int GETUNICODESTREAM
o GETOBJECT 
 static final int GETOBJECT
o FINDCOLUMN 
 static final int FINDCOLUMN
o GETMETADATA 
 static final int GETMETADATA
o WASNULL 
 static final int WASNULL
o nameIt 
 static final String nameIt[]
o errs 
 static final String errs[]

Constructors

o jdbcMysqlRSet 
 jdbcMysqlRSet(jdbcMysqlResult mresult) throws SQLException

Methods

o iClose 
 void iClose() throws SQLException
We be closed!

o myID 
 int myID()
Tell others who I am.

o next 
 public boolean next() throws SQLException
See API. Get next row

o close 
 public void close() throws SQLException
See API.

o getWarnings 
 public SQLWarning getWarnings() throws SQLException
We don't support warnings at this time. Do the sync just to stay kosher

o clearWarnings 
 public void clearWarnings() throws SQLException
I said we don't support warnings!

o getCursorName 
 public String getCursorName() throws SQLException
MySQL doesn't do cursors. Puke as required by the API.

o wasNull 
 public boolean wasNull() throws SQLException
A thoughtless API request. There is no way to make this threadsafe!

o getMetaData 
 public ResultSetMetaData getMetaData() throws SQLException
o findColumn 
 public int findColumn(String name) throws SQLException
Return the ordinal column

o getString 
 public String getString(int c) throws SQLException
See the API

o getString 
 public String getString(String c) throws SQLException
See the API

o getBoolean 
 public boolean getBoolean(int c) throws SQLException
See the API. Nominally MySQL does not support booleans, but I will interpret "true", "false", "yes", "no", "y", "n", "0" or "1" as boolean data.

o getBoolean 
 public boolean getBoolean(String c) throws SQLException
See the API. Nominally MySQL does not support booleans, but I will interpret "true", "false", "yes", "no", "y", "n", "0" or "1" as boolean data.

o getByte 
 public byte getByte(int c) throws SQLException
See API.

o getByte 
 public byte getByte(String c) throws SQLException
See API.

o getShort 
 public short getShort(int c) throws SQLException
See API.

o getShort 
 public short getShort(String c) throws SQLException
See API.

o getInt 
 public int getInt(int c) throws SQLException
See API.

o getInt 
 public int getInt(String c) throws SQLException
See API.

o getLong 
 public long getLong(int c) throws SQLException
See API.

o getLong 
 public long getLong(String c) throws SQLException
See API.

o getFloat 
 public float getFloat(int c) throws SQLException
See API

o getFloat 
 public float getFloat(String c) throws SQLException
See API

o getDouble 
 public double getDouble(int c) throws SQLException
See the API

o getDouble 
 public double getDouble(String c) throws SQLException
See the API

o getBigDecimal 
 public BigDecimal getBigDecimal(int c,
                                 int s) throws SQLException
See API

o getBigDecimal 
 public BigDecimal getBigDecimal(String c,
                                 int s) throws SQLException
See API

o getBytes 
 public byte[] getBytes(int c) throws SQLException
See API

o getBytes 
 public byte[] getBytes(String c) throws SQLException
See API

o getDate 
 public Date getDate(int c) throws SQLException
See API

o getDate 
 public Date getDate(String c) throws SQLException
See API

o getTime 
 public Time getTime(int c) throws SQLException
See API

o getTime 
 public Time getTime(String c) throws SQLException
See API

o getTimestamp 
 public Timestamp getTimestamp(int c) throws SQLException
See API

o getTimestamp 
 public Timestamp getTimestamp(String c) throws SQLException
See API

o getAsciiStream 
 public InputStream getAsciiStream(int c) throws SQLException
See API. Because MySQL does not distinguish non-ASCII characters getAsciiInputStream and getBinaryInputStream are treated the same.

o getAsciiStream 
 public InputStream getAsciiStream(String c) throws SQLException
See API. Because MySQL does not distinguish non-ASCII characters getAsciiInputStream and getBinaryInputStream are treated the same.

o getBinaryStream 
 public InputStream getBinaryStream(int c) throws SQLException
See API. Because MySQL does not distinguish non-ASCII characters getAsciiInputStream and getBinaryInputStream are treated the same.

o getBinaryStream 
 public InputStream getBinaryStream(String c) throws SQLException
See API. Because MySQL does not distinguish non-ASCII characters getAsciiInputStream and getBinaryInputStream are treated the same.

o getUnicodeStream 
 public InputStream getUnicodeStream(int c) throws SQLException
See API. As implemented here this really does assume that String is unicode and that getBytes() returns a byte representation of the unicode string. Will fix this when/if Sun gets their act together re encoding and if/when someone complains (they will!).

o getUnicodeStream 
 public InputStream getUnicodeStream(String c) throws SQLException
See API. As implemented here this really does assume that String is unicode and that getBytes() returns a byte representation of the unicode string. Will fix this when/if Sun gets their act together re encoding and if/when someone complains (they will!).

o getObject 
 public Object getObject(int c) throws SQLException
getObject returns a byte array as an object

o getObject 
 public Object getObject(String c) throws SQLException
getObject returns a byte array as an object

o getIt 
 private Object getIt(int huh,
                      int cnum,
                      String cnam,
                      int tflag) throws SQLException
o nParse 
 private int[] nParse(String s,
                      int tt) throws SQLException
o testBool 
 private boolean testBool(String work) throws SQLException
o nopSynch 
 private void nopSynch(String n) throws SQLException
o fByName 
 private jdbcMysqlField fByName(String cnam) throws SQLException
o retrieved 
 void retrieved(boolean r)
o isRetrieved 
 boolean isRetrieved()
o testStatus 
 private void testStatus(String s) throws SQLException
o errHandlerE 
 private void errHandlerE(int n,
                          Exception e) throws SQLException
o errHandlerE2 
 private void errHandlerE2(int n,
                           int where,
                           String how,
                           Exception e) throws SQLException
o errHandlerE2b 
 private void errHandlerE2b(int n,
                            int where,
                            String how,
                            Exception e) throws SQLException
o errHandlerM 
 private void errHandlerM(int n,
                          String s) throws SQLException
o errHandlerNM 
 private void errHandlerNM(int n,
                           int u,
                           String s) throws SQLException

All Packages  Class Hierarchy  This Package  Previous  Next  Index