MySQL Developing And Programming Blog

Using JDBC with Java Applications and Applets 84 Byte getByte(int columnIndex); Byte getByte(String columnName); byte[] getBytes(int columnIndex); byte[] getBytes(String columnName); In most cases, these methods will not throw an exception because nearly all values in a MySQL column can be returned as bytes. Double If the value in a MySQL column is a double or a value that can be converted to a double, then you can use the following two methods to pull that value: double getDouble(int columnIndex); double getDouble(String columnName); If the value in the MySQL column cannot be converted to a double, a SQLException exception will be thrown with an error value of S1009. Float Real or floating-point values can be returned from the MySQL database using these methods: float getFloat(int columnIndex); float getFloat(String columnName); If the value in the MySQL column cannot be converted to a float, a SQLException exception will be thrown with an error value of S1009. If the strictFloatingPoint property supplied to the Connection object has a value of true, then Connector/J attempts to compensate the returned value for rounding errors that might have occurred in the server. Int The MySQL server can handle integer values, and you can use the following two methods to pull their associated value from the database: int getInt(int columnIndex); int getInt(String columnName); If the strictFloatingPoint property has been set to true in the Connection object, the Connector/J driver attempts to handle rounding errors in the integer values stored on the database. Values that cannot be converted to an integer will throw the SQLException exception. Long Longs can be pulled from the database using these methods: long getLong(int columnIndex); long getLong(String columnName);

Note: If you are looking for good and affordable webspace to host and run your servlet application check Sandzak servlet hosting services