Java-Gaming.org    
Featured games (91)
games approved by the League of Dukes
Games in Showcase (581)
games submitted by our members
Games in WIP (500)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
 
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  reports from databases solution in java?  (Read 1379 times)
0 Members and 1 Guest are viewing this topic.
Offline zulo

Junior Member




Java games rock!


« Posted 2005-01-20 21:30:01 »

hi
we have started our main project for the last year at university, and we are going to create a database. We really want to use java ofcourse../ I want to use java:)

So I have made some tests and figured out how to use access and jtables etc.. Now theres only one last problem, this application has to be able to make lots of lots of reports on the data that the user put in the database. The business we are doing this for have been using excel as a database and excel actually crashed because they had too much in it Huh

And they used word templates i think as the reports..

Now, doed anyone here have a tip for how we can solve this problem.. Is it possible for java to create a .doc file based on a word template? I really hope so, cause else i think we have to go do the whole project
in access:-[ and do the coding in VB Embarrassed
Cry

Would be really nice if Java could read word templates and fill in the data and print it Smiley Iknow theres alot of programs that are made for this that you can plug in to java but we want to know if its possible to solve with the jdk first.
Offline jbanes

JGO Coder


Projects: 1


"Java Games? Incredible! Mr. Incredible, that is!"


« Reply #1 - Posted 2005-01-21 00:57:48 »

Quote

Now, doed anyone here have a tip for how we can solve this problem.. Is it possible for java to create a .doc file based on a word template? I really hope so, cause else i think we have to go do the whole project  
in accessEmbarassed and do the coding in VB Embarassed


Access? Excel? How quaint. Real men access the OLE2 docuemnt structure directly and create the documents themselves! ;-)

Other options include this, or just generating a pdf like a real man! No wusy Word documents! Bah! I could recite the precise PDF data structures from memory! What kind of MCSE weenie do you know that can do that with Word documents?

Tell me at least you're using custom ISAM files for your database?

Now if you'll excuse me, I need to go curl up in a corner. It's scary out here. ;-) Tongue Grin  Cheesy

Java Game Console Project
Last Journal Entry: 12/17/04
Offline zulo

Junior Member




Java games rock!


« Reply #2 - Posted 2005-01-21 04:42:08 »

1. Cheesy
2. Were not using access and excel, the corporation that needs our help have been using it thats why they need our help and we want to do it in java NOT plastic-programminglanguage vb..
3.i once created a word doc from vb code and i wanted to know if thats possible in java (to create a text document from a template, were talking about alot of templates here..and 1 or their customer reports that they want to create can be up to thousands of pages with info about the data in the database..
4.We havent even started thinking about making e/r diagrams yet,were using the pmi model
5.Just to make sure you dont think im a mcse weenie, I HATE vb,access,and love Java..the one were working for have been using office and were supposed to fix their troubles with Java..
6.You answered all my questions
7.Thank you  Cool
Games published by our own members! Check 'em out!
Legends of Yore - The Casual Retro Roguelike
Offline blahblahblahh

JGO Coder


Medals: 1


http://t-machine.org


« Reply #3 - Posted 2005-01-21 06:49:46 »

You have two choices:

- find an API that does all the work for you
- write an API to do all the work for you

Since many many groups have tried and failed to do the latter, I suggest you don't bother. You would need to reverse engineer the file-formats, including all their bugs (IIRC MS still hasn't released spec documents for their file formats, and keeps them "secret").

There are plenty of attempts to make API's to create word docs, edit them, alter them, etc, but - as noted above - most don't work. Good luck; you need it.

PS what you're probably looking for is an API that presents a DOM (document-object model) of word docs + some useful utitilies (like "instantiate new doc from template").

Off the top of my head, surprisingly most of the API's have java versions. Although a higher percentage are Python  (or some mangling language like Perl) IIRC.

malloc will be first against the wall when the revolution comes...
Offline zulo

Junior Member




Java games rock!


« Reply #4 - Posted 2005-01-21 08:12:54 »

The corporation were doing this for said that they dont care about what language we use,what database we use, because its all going to be new for them anyway, and anyway its a lastyear school project so we can choose to not use word.. I mean, we can use openoffice docuements as templates if that makes it easier..

What we need to be able to do is to fill out parameters in template documents and print them out from the java program. And I think maybe that apache jakarta project is the solution, but i havent tested that yet..I will test if its possible to read a docuement..for example a open office document template and fill in the data.
Offline nonnus29

Senior Member




Giving Java a second chance after ludumdare fiasco


« Reply #5 - Posted 2005-01-21 10:45:39 »

Sounds like what you need is a 4gl report generation language implemented in java.

Are these report templates they're using especially complex?  Because if its just a page heading, column headings, and totals then that simplifies things greatly.  Also, a .txt file is almost always sufficient for these reports in my experience.

A 4gl of this nature can more straight to implement than a BASIC varient.  With java it could access files over networks and on multiple architectures.  I've not done it myself though  Tongue .
Offline Argoyle

Senior Newbie





« Reply #6 - Posted 2005-01-21 12:03:52 »

JasperReports seems quite good.

http://jasperreports.sourceforge.net

I guess the documentation could be a bit better though.
Offline zulo

Junior Member




Java games rock!


« Reply #7 - Posted 2005-01-21 15:00:47 »

its not just totals we need to insert lists..its not just a text file, i dont think that will be good enough these reports are what they send to the customer for analysis etc..theyr bending pipes by induction and they send test results etc and offers...they showed us 1 offer for 1 customer and it was 3 "books" with paper...basically theres a heading etc and a list of items that can vary from 1 page to manymany pages
Offline jbanes

JGO Coder


Projects: 1


"Java Games? Incredible! Mr. Incredible, that is!"


« Reply #8 - Posted 2005-01-21 15:20:17 »

Quote
its not just totals we need to insert lists..its not just a text file, i dont think that will be good enough these reports are what they send to the customer for analysis etc..theyr bending pipes by induction and they send test results etc and offers...they showed us 1 offer for 1 customer and it was 3 "books" with paper...basically theres a heading etc and a list of items that can vary from 1 page to manymany pages


I highly recommend ditching the Word idea and going for PDFs. You'll produce nicer looking reports, and you won't have to deal with bugs in the format implementation. Not to mention that PDFs are far better supported by third party tools, portable across platforms, and can't be edited by the end user. :-)

Java Game Console Project
Last Journal Entry: 12/17/04
Offline zulo

Junior Member




Java games rock!


« Reply #9 - Posted 2005-01-23 07:06:55 »

yes hmm, maybe theres something for open office format?

do you remember the name of the DOM model apis?

some times they have to edit the report manually because its a very complicated thing..theyr following some standards but some of their clients have their own standard etc..
Pages: [1]
  ignore  |  Print  
 
 
You cannot reply to this message, because it is very, very old.

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

xsi3rr4x (55 views)
2014-04-15 18:08:23

BurntPizza (53 views)
2014-04-15 03:46:01

UprightPath (66 views)
2014-04-14 17:39:50

UprightPath (49 views)
2014-04-14 17:35:47

Porlus (66 views)
2014-04-14 15:48:38

tom_mai78101 (90 views)
2014-04-10 04:04:31

BurntPizza (151 views)
2014-04-08 23:06:04

tom_mai78101 (246 views)
2014-04-05 13:34:39

trollwarrior1 (204 views)
2014-04-04 12:06:45

CJLetsGame (211 views)
2014-04-01 02:16:10
List of Learning Resources
by SHC
2014-04-18 03:17:39

List of Learning Resources
by Longarmx
2014-04-08 03:14:44

Good Examples
by matheus23
2014-04-05 13:51:37

Good Examples
by Grunnt
2014-04-03 15:48:46

Good Examples
by Grunnt
2014-04-03 15:48:37

Good Examples
by matheus23
2014-04-01 18:40:51

Good Examples
by matheus23
2014-04-01 18:40:34

Anonymous/Local/Inner class gotchas
by Roquen
2014-03-11 15:22:30
java-gaming.org is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑gaming.org
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!