Mailing-List: contact user-help@struts.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
Received-SPF: pass (hermes.apache.org: domain of jak-struts-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: user@struts.apache.org
From: Vic <vin@friendvu.com>
Subject: Re: which tier?
Date: Sun, 13 Feb 2005 09:50:34 -0600
Lines: 51
Message-ID: <cunss2$spj$1@sea.gmane.org>
References: <420F6B76.5010702@localhost.nu>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
In-Reply-To: <420F6B76.5010702@localhost.nu>
Sender: news <news@sea.gmane.org>

You need to write object/class that you can unit test outside of 
Stuts.Lets call it Calc.java.
It would call a DAO (such as iBatis, there are tutorials to iBatis all 
over the place, try Rick Reuman (spelling?)).
That would call SQL.

So in Calc you might have private methods:
private long getStartTime(Interger userID);
private long getEndTime(Integer userID);
....
or just
private Map  getTimes(Integer userID) to get all the times at once.
Unit test that.

Then write method to compute. Unit test.
Then place in Struts.

(But before I would implement above, I would create a JSP /Struts mock 
up with fake data displayed (no db, just hard code), just to get the 
look and feel right, navigation, etc. That is allways the hard part but 
it ensurse sucess. Once you know that's what you want, then do above impl.)

.V

Robin Ericsson wrote:

> Hi,
>
> I'm doing a small timesheet app with struts using PostgreSQL as 
> backend and as I'm new to struts and also somewhat new to Java I'm 
> trying to decide where I should put the logic.
>
> Each row contains a day, start time, end time and break time. Now, I 
> want the business layer to calculate the duration between start time, 
> end time minus the break.
>
> Should this be placed in the SQL-side using a special query, or should 
> I do this in Java? If so, is it possible to calculate durations and 
> intervals in Java without using third-party packages?
>
> I know the question is pretty vague but I'm on thin ice at the moment 
> and not really knowing what I'm doing :)
>
>
> regards,
>     Robin


-- 
Forums, Boards, Blogs and News in RiA <http://www.boardVU.com>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org