aspose file tools*
The moose likes JDBC and the fly likes creating objects Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "creating objects" Watch "creating objects" New topic
Author

creating objects

Antoine Waugh
Ranch Hand

Joined: Jan 24, 2004
Posts: 66
hey there, i have the following objective:
To search through an excel sheet, view the Field values for each line, and create objects based on their field value.
i can connect and call queries successfully from the excel file, and have the following issue:
the excel file is something like
SHOW NAME SHOW NUMBER STATE ...
IBM 509 NSW
now, what i thought of doing is going through each line of the excel file, and assigning Object Show the following values:
Show.addName(rs.getString( "SHOWNAME" ))
Show.addNumber(rs.getSring("No"))
etc.. (please note the above code is for example only.)
what i have done is tried to return these values using the system.out command, ranther than jump straight into object creation, and the following works and compiles, but throws:
"java.sql.SQLException: [Microsoft][ODBC Excel Driver] Numeric field overflow"


then i could replace the system.out calls to be instructions to add to my object. My sql is not very strong, and i was wondering what the best approach would be to achieve what i am hoping. I am aware that the scalability of this is rather large, as i am pre-loading a whole file into my applicatoin, however for the purpose of the application's gui and functionality, it is the best approach.
Thanks for your time, all suggetions and code appreciated
-twans
------
SCJP


B.C.S.T, SCJP, Hero
Antoine Waugh
Ranch Hand

Joined: Jan 24, 2004
Posts: 66
to be more specific, here is another working example of what i am trying to achieve. Is this method appropriate for reading in databases, and will it be possible with the use of an applet?

thanks in advance
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: creating objects