Prepared Statement to DB setting variable type handling


This question already has an answer here:


Standard JDBC accepts date/time only as instances of

java.sql.Date       (date only)
java.sql.Time       (date/time with 1 second resolution)
java.sql.Timestamp  (date/time with fractional second resolution)

You must convert your Joda objects into one of these, and use the correct method (setDate, setTime or setTimestamp) on PreparedStatement.

Need Your Help

Storing arrays in database using ActiveRecord

ruby-on-rails ruby activerecord

I am on rails 2.3.8 &amp; I am using mysql as db adapter.

Codeigniter Global Array Declaration

php codeigniter

I have a sequence of number like follows