Saturday, October 25, 2008
Today, i was getting data of more than 10 lakh records from mah database & filling up a grid of 10 records, but it was taking immense time so, i wrote a procedure that returns custom paging for a grid......Njoy the code....if ne queries, reply me :)
alter PROCEDURE sp_PagedItems
-- We don't want to return the # of rows inserted
-- into our temporary table, so turn NOCOUNT ON
SET NOCOUNT ON
--Create a temporary table
CREATE TABLE #TempItems
ID INT IDENTITY,
-- Insert the rows from tblItems into the temp. table
INSERT INTO #TempItems (carid, title)
SELECT carid, title FROM carregister
-- Find out the first and last record we want
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)
-- Now, return the set of paged records, plus, an indiciation of we
-- have more records or not!
FROM #TempItems TI
WHERE TI.ID >= @LastRec
WHERE ID > @FirstRec AND ID < @LastRec
-- Turn NOCOUNT back OFF
SET NOCOUNT OFF
Ujjwal B Soni
Tuesday, October 14, 2008
- No need of Home Interface (EJBHome),but it is needed in EJB2.0
- No more confusions to make an EJB remote or local,it's the client which would decide and cast to appropriate.
- Just write SINGLE simple Java class and annotate it to be Stateless/Stateful/Entity/MessageDriven.Container
- No Deployment Descriptors , MetaData Annotations are explored which is introduced in J2SE5.0
- Forget all EJB life cycles.For example Entity bean life cycle in 3.0 is new,managed,detached,removed.
- Ejb 3.0 siplifies the developement of the application
Ready to develop complex query,inner/outer join with EJB3.0.
The main difference lies in the persistence In case of EJB 3.0 there is JPA Java persistence API which makes the mapping of EntityBeans with the database easy with the help of a service called as EntityManager.
Mapping is done with the help of annotations unlike in EJB2.0.
Home interfaces are eliminated.
Deployment descriptors are an option in EJB 3.0.
EJB3.0 also supports webservice client through SOAP and WSDl.
Finally, concluding this topic I think the main difference is that EJB 3.0 is moved towards annotations based programming model and dependency injection to make our life easy .
For more information please visit http://javaknowledgestorm.blogspot.com/2009/04/differences-between-ejb20-and-ejb30.html
Abstraction is virtual class design.
Before actually defining class, developer will think about what all properties,methods and event will be there in my class.
Whereas,encapsulation is data hiding.
At the time of class defenation,developer will think about which should display to end user and which should not.
In Short Abstraction is "Collection of data" and Encapsulation is "Exposure (or grouping) of data in appropriate access specifier".
There is a little tool called JSPExecutor that allows you to do just that. The developers (Hendrik Schreiber
Ujjwal B Soni