• 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
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

web interface to search database

 
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Currently I need to implement a web interface for search & enquiry of databases.
The senario is there is a page to provide search criterion, the criterion may comes from column A from Table 1, column B from table 2 (all thse tables can be joined). After speicified these criterion, the search result can display fields from various columns of various table.
Is there any framework does it?
 
Ranch Hand
Posts: 995
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you are asking for DB querying frameworks you have plenty of them: ranging from simple JDBC frameworks, more complex ones iBatis, Hibernate and a full specification: JDO.

--
:alex |.::the_mindstorm::.
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Your description might even match a reporting tool. Jasper Reports is one ... I know little more about it than the name, tho.
 
Ranch Hand
Posts: 580
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You cross posted this in the servlets forum also. Which one do you want people to use to answer your question?
 
Daoyue Ming
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by James Carman:
You cross posted this in the servlets forum also. Which one do you want people to use to answer your question?



sorry about that, since I don't know where I should post to, it can be related to servlet, but after I post it, I think it should be a general question, not specific to servlet, so I post here.
 
Daoyue Ming
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Ali Pope:
If you are asking for DB querying frameworks you have plenty of them: ranging from simple JDBC frameworks, more complex ones iBatis, Hibernate and a full specification: JDO.

--
:alex |.::the_mindstorm::.



I didn't use Hibernate or JDO, but I wonder can they achieve this: if a column is specified in the search criterion, then I should inner join the table the column resided in, if a column is displayed in search result, and not specified in any search criterion, then I should outer join this table.
 
Daoyue Ming
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
another complicated thing for my problem is our customer want to display the search result as following:
if table A has 0-many relationship with table B, and B has 0-many relationship to C, here is the requirement
__________________________________
A.value_1___B.value_1___C.value_1
______________________C.value_2
__________________________________
____________B.value_2___C.value_3
_______________________C.value_4
__________________________________
A.value_2___B.value_3___C.value_5
___________B.value_4___C.value_6
__________________________________
A.value_3___B.value_5
(sorry for this ugly layout, but i want to display it as a table, whole line of ____ means seperator of row in the HTML, and rest __ means spance

Means I need to do sth in the presentation layer to merge the repeated values at column level, instead of display the raw data from the resultset
[ March 17, 2005: Message edited by: Daoyue Ming ]
 
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Try using Jasper. I have seen it briefly and I think it has the potential to to give you SQL-report like output
 
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've been tinkering with JSP/Servlet lately-- that's in the front of my mind-- so I did it by using a servlet to create a list of plain Java beans (each of which contain other lists). So using the jstl <c:forEach>, and an html table, I'm able to put things in columns. And thanks to ${EL}, it's scriptless, quite readable, and tidy. But if you find some really easy way to do this using some pre-built thing, I'd be interested to know too.

--Dale--
 
Daoyue Ming
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Gerome Kawa:
Try using Jasper. I have seen it briefly and I think it has the potential to to give you SQL-report like output



I am totally new for Jasper, what I need to do is build a framework so that my colleagues can build search and enquiry from my framework. So this framework must be flexible enough to allow dynamic columns and tables, can Jasper do it?
 
Daoyue Ming
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Dale Seng:
I've been tinkering with JSP/Servlet lately-- that's in the front of my mind-- so I did it by using a servlet to create a list of plain Java beans (each of which contain other lists). So using the jstl <c:forEach>, and an html table, I'm able to put things in columns. And thanks to ${EL}, it's scriptless, quite readable, and tidy. But if you find some really easy way to do this using some pre-built thing, I'd be interested to know too.

--Dale--



referring the search result output? I can't visualize it
[ July 17, 2008: Message edited by: Daoyue Ming ]
 
Evacuate the building! Here, take this tiny ad with you:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic