I seek for months of research alone and only found partially solution of the problem below
...anyone faced this problem before ,please don't feel shy to reply....
I am start looking for solution since i have read this article -- http://www.itworld.com/nl/java_tut/03202002/
The first paragraph should tell you what i am looking for,
Please copy and paste all the document below to notepad or wordpad for better view ... :>
1)A form registration of pc information (username ,serial number ,location ,processor type ) ,information
will input into database (microsoft access) .A auto generated database id for each time user submit the form to keep track the record.
2)View/Modift/Delete form of information entered above for maintenance purpose .For Example ,view form will
show all value entered from senario above.
total of forms.
1.1)User input form
1.2)Validate user input form
1.3)Database processing form with SQL insert statement of user input
2.1)Query from database by selecting a database id(auto-generated and unique).
2.2)Display all information on selected database id (username ,serial number..etc)
2.3)Validate user input form
2.4)Database processing form with SQL update statement of user input
3.1)Query from database by selecting a database id(auto-generated and unique).
3.2)Database processing form with SQL delete statement on selected databse id.
1.Database information not dynamic
Database information like 'database name' ,'database driver' ,etc are hardcoded on 1.3
,2.1,2.2,2.3,2.4,3.1,3.2 form .So if the database name ,table name or driver change ...all forms contained the database name/table/driver name have
to change and test and re test.
2.Field name are static and hard coded
Field name like serial number ,location name ,etc ae hard coded to the form
1.1,1.2,1.3,2.2,2.3,2.4 .Example ,when 1.2 want to validate 1.1 form ,then have to ""re-declare""!!!
request.parameter to get the all the field name again and same to form 2.2 and 2.3.
Also insert SQL statement form 1.3 will be very messy if too much field need to insert to
database .I got 30-50 fields to add from the form.Worst case when need to change or add the field
name ,all form are effected and have to retest the whole stuff...too much of duplicate
3.User input form not dynamic
Input like location should remains default value to restrict user input .It should be a combo box
for user input to input. When too many combo box <option>blah</option> is very difficult to
maintain when need to add/delete combo box value .So i have used database to store the combo box
value and use custom tag to solve this.
4.Give flexibility to modify homepage
Solution to the problem 1 and 2 should not give a limitataion on level of customization of the
presentation form especially the HTML file .
NOte: i have research some of the solution that i have found but only partially solve the issue above .
Solve validation issue - www.javaworld.com/javaworld/jw-10-2001/
Solve dynamic form issue - www.javaworld.com/javaworld/jw-03-2000/
Solve problem 1 - www.javaworld.com/javaworld/jw-02-2002/
I looking a solution to solve the problem 1 and 2 .I believe some one have definately faced this problem b4 and got some solutions ..pls point out...
Best regards ,