Is it possible to create a [size=125]Simple form [/size]in alfresco that contains some fields to collect data from the user and this gets stored in the database..
The next time i want to view the data, i can show it in a jsp page by retreiving the data from the database..
Absolutely. The simplest approach I can think of is:
1. Create a new dashlet - and build this simple form you need. 2. Create a webscript or java-backed webscript to update the database or store this info somewhere. 3. Have the dashlet use this webscript when the user clicks "Save" or something. 4. Retrieve your info from wherever you have placed it.
I don't see why not. From the example, you can see how your share dashlet can interact with alfresco webscripts.
For example: share dashlet has a server side javascript that's executed before sending the response to the client. also, there is a client-side javascript that can call another webscript or webscripts - depending on how you design it.