Results 1 to 6 of 6
- 03-31-2011, 05:01 AM #1
Member
- Join Date
- Mar 2011
- Posts
- 5
- Rep Power
- 0
Java DAO create query please help
I am not sure whether i posted this thread at the right place. Anyway my problem at below
Java Code:public class Student() private String name; private String id; private int marks; private Date issueOn; ...... ...... } public class StudentDaoImpl extends HibernateDaoSupport implements StudentnDao{ public ArrayList<Student> getSumMarkl(String dayStart, String dayEnd)throws DataAccessException{ Session session = this.getSession(); ArrayList<Student> stdList = new ArrayList<Student>(); try{ Query query = session.createQuery("select s.name, s.id, SUM(ms.marks) from Student s where TO_CHAR(TRUNC(s.issueOn),'YYYYMMDD') between '"+dayStart+"' AND '"+dayEnd+"' GROUP BY s.name, s.id ORDER BY ms.id ASC"); ..................................................... System.out.println("List size: " + query.list().size()); ................................................ // the list contains value //how do i get the result into my ArrayList? ................................................... ............................................. }
- 03-31-2011, 06:06 AM #2
Senior Member
- Join Date
- Aug 2009
- Posts
- 2,388
- Rep Power
- 14
Is Student an entity? The usual thing is to use entities and execute the query on an EntityManager that you create or lookup.
- 03-31-2011, 07:17 AM #3
Member
- Join Date
- Mar 2011
- Posts
- 5
- Rep Power
- 0
- 03-31-2011, 07:45 AM #4
Senior Member
- Join Date
- Aug 2009
- Posts
- 2,388
- Rep Power
- 14
Elaborate which part? The key thing you are missing in your code is the EntityManager which you use to communicate with the datastore.
- 03-31-2011, 07:59 AM #5
Member
- Join Date
- Mar 2011
- Posts
- 5
- Rep Power
- 0
- 03-31-2011, 08:05 AM #6
Senior Member
- Join Date
- Aug 2009
- Posts
- 2,388
- Rep Power
- 14
Similar Threads
-
Java and appengine query?
By Emeljats in forum New To JavaReplies: 0Last Post: 12-12-2010, 11:06 PM -
java servlet/Query
By KumbhaniMehul in forum Java ServletReplies: 0Last Post: 04-06-2010, 09:19 PM -
Help with query (new to java!)
By gpittingale in forum New To JavaReplies: 3Last Post: 02-15-2009, 10:14 AM -
query on core java
By venkatallu in forum New To JavaReplies: 1Last Post: 09-01-2008, 03:23 PM -
How to create a xml file from oracle sql query
By boy22 in forum XMLReplies: 1Last Post: 07-24-2007, 01:15 AM
Bookmarks