• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

Problem in Bean Design

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am developing a project as Task Tracking System.One of the entities used in my project are Client and Task.So i build the bean for Client and Task.
The Client Bean consists:Client Id,ClientName,ClientStatus.The Task bean consists of TaskId,TaskName,Description,CreateDate,TaskStatus etc.The Relation between client and task is of one to many relation.So I include Clientid in Task Bean.Now i want to show the list of task with their client as

ClientName ClientStatus TaskName CreateDate TaskStatus....

For this i am getting the above data from the database .Now i want to set the bean properties after getting the resultset from the database.Now the problem is that which bean property should i set.If i set the Task property,i will do as follows....
Task task=new task();
task.setTaskName(rs.getString(1))
task.setClentId(rs.setClientId(rs.getInt(2))....etc

Now how will i set the property for ClientName and Client Status properties.
And i want the total records in a bean so that i can print the bean value using get method on JSP.So how should i set the bean value and store that in ArrayList so that i can print all the information.Please resolve the above problem and also new ideas to solve the above problem in another way is most welcome.If you can provide some code then it will be very useful to me.But any way i will stick to setting bean properties.
Thanks in advance
 
Ranch Hand
Posts: 171
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
So, one client has many tasks, right?


now, get the client and all the tasks associated to him

After filling the Client object, close the record set and open a new one to get all the tasks associated,


hope it helps!
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic