Tutorial Home
Hibernate
-
Advantage of Hibernate over JDBC
- Hibernate Setup with an web Application
- First Hibernate Application
- Hibernate mapping with Database TABLE
- Hibernate Data Type-Java Data Type - SQL Data Type mapping
- One to Many Relation in Hibernate
- One to Many Relation in Hibernate bi-directional
- Many to Many Relation in Hibernate
- HQL: The Hibernate Query Language
- Criteria Queries
- Criteria Queries : Equal (eq), Not Equal(ne), Less than (le), greater than (gt),greater than or equal(ge) and Ordering the results
- Criteria Queries: And OR conditions
- Hibernate generator to generate id (primary key)
- prevent concurrent update in Hibernate,slate object updatation in Hibernate,version checking in Hibernate
Struts
- Model View Controller (MVC)
- Model View Controller (MVC)
- Struts Flow-How Struts Works?
- Struts Tutorial - Struts Setup- First Struts Action class setup
- Message Resources
- Validation Framework
- Validation Framework-client side
- ForwardAction
- IncludeAction
- DispatchAction
- LookupDispatchAction
- DynaActionForm
- DynaActionForm
- Struts Tutorial - Mutli-click prevention using struts tokens-Prevent Duplicate Submission
- Logic Iterate Map and List
JSP
- JSP Tutorial
- Introduction to JSP
- JSP Comments
- JSP Syntax
- JSP Scripting Elements :Scriptlet, expression, declaration
- JSP Directives
- implicit objects in JSP
- JSP Actions
- Introduction to JSP
- jsp:useBean
- The jsp:setProperty Action
- The jsp:getProperty Action
- Introduction to JSP
Spring
- Spring Tutorial
- Introduction to Spring
- Benefits of Using Spring Framework
- Inversion of Control in Spring
- Introduction to BeanFactory
- Dependency Injection in Spring
- Collections Setter Injection
- Bean Scopes in Spring
- Spring IOC Setup Step by Step
- Bean Lifecycle in Spring
- ApplicationContext
- MessageSources in Spring
- Web Spring MVC framework
- Developing Your First Spring Web Application
- Developing Your Second Spring Web Application with Spring Form
- Developing Your First Spring Web Application with Spring Validation Framework with Code Example
- Spring integration with Hibernate
|
Hibernate Tutorial Step by Step -- Code Examples
HQL: The Hibernate Query Language
The Hibernate Query Language is executed using session.createQuery().
This tutorial includes from clause,Associations and joins, Aggregate functions,The order by clause,The group by clause,Subqueries.
The from clause
from Employee // Employee is class name mapped to EMPLOYEE TABLE
or
from Employee as e
or
from Employee e where e.empId = 3;
List empList = session.createQuery("from Employee").list();
|
Associations and joins
from Employee e where e.scopeModFlag = 1 and pc.isDeleted != 1
List empList = session.createQuery("from Employee e where e.scopeModFlag = 1 and pc.isDeleted != 1").list();
|
Aggregate functions
select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat) from Cat cat
ScrollableResults rs = session.createQuery("select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat) from Cat cat").scroll();
if(rs.next()){
System.out.println(rs.get(0));
System.out.println(rs.get(1));
System.out.println(rs.get(2));
System.out.println(rs.get(3));
}
|
The order by clause
from Employee e order by e.name desc
List empList = session.createQuery("from Employee e order by e.name desc").list();
asc or desc indicate ascending or descending order respectively.
|
The group by clause
select e.dept, sum(e.salary), count(e) Employee e group by cat.dept
|
Subqueries
from Employee as e
where e.name = some (
select name.nickName from Name as name
)
|
|
|
SCJP 5.0 Simulator 642+ Questions With Explanations 