Newbie User Question

[Jim Knoll <jk...@indy.rr.com>]

Hello,

    I am completely new to turbine, and I am trying to teach myself database
    design and java servlets.  I had written a servlet that would request a
    user login and then allow the user to enter status report data into a
    form which my servlet would then store in a mysql database.  This seems
    like a simple job in turbine.  

    My status report database was one table with the following fields:
    first name, last name, task, status, and date.  The status field was an
    enumerated type, and the date was a TIMESTAMP.  I was thinking I should
    have a user table in addition to the status table, and the user_id could be
    the foreign key in my status table.  Is it possible to get the user_id from
    the TURBINE_USER table and store it in my status table as a foreign key 
    along with the data I would receive from a status report form velocity
    page.  Is it possible to use the ENUM and TIMESTAMP data types?

    Does anybody have any suggestions on any of this project?  Also, I would
    like to be able to query the status database by date as well as user
    name.  Is there a simple way to get the date information validated and
    passed to my app to query the database.  I saw there was a DateSelector
    object, but I am not quite sure how to use it.

    I really appreciate any advice or suggestions.

    Thanks,
    
    Jim

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>