Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Standard Widget Toolkit (SWT) » How to set a TableColumn-type?!?
How to set a TableColumn-type?!? [message #446708] Wed, 01 December 2004 09:20 Go to next message
Eclipse UserFriend
Originally posted by: melko.gmx.at

hello!

I have a problem: I select items from a database to a table and it works
fine.

I do it on this way:

ResultSet resSet = stmt.executeQuery(text);
ResultSetMetaData result = resSet.getMetaData();
int col = result.getColumnCount();
TableColumn[] tableColumn = new TableColumn[col];
for(int i=1; i<=col;i++){
tableColumn[i-1] = new TableColumn(table, SWT.LEFT, i-1);
tableColumn[i-1].setText(result.getColumnName(i));

And I get the results in the table and so on. But I want to set the Column
type to DATE or CHAR or INTEGER depending on the
result.getColumnType(i)!?!?! so I can, if there is a DATE-Column in the
databse show it right!?

Example:

In the DB there is a Column "Birthday" DATE and it should show only the
Date without time, but it shows follow: 1983-05-01 00:00:00.000000

or other example:

"user_jahr" is a DECIMAL and it should show 25 but I get
25.0000000000000000

Is it possible to do something there or not?!

Thank you for your help!!

Nice greetings from austria!

Have a nice day
Re: How to set a TableColumn-type?!? [message #446744 is a reply to message #446708] Thu, 02 December 2004 09:31 Go to previous message
Henrik Skovgaard is currently offline Henrik SkovgaardFriend
Messages: 84
Registered: July 2009
Member
There are no column types available in SWT. You have to cast/convert the
datatypes from the db to whatever format you want to display.

For example:

tableItem.setText(DateFormat.getDateInstance().format(myDate ));
- will display the date "1983-05-01 00:00:00.000000" like this: "01-05-1983"
(dependent of your locale).

If I was you, I would consider a single row in my table as an object, so I'd
create a class containing all the different columns as properties. In this
way you wouldn't have to think about datatypes in the gui part of your
project.



"melko" <melko@gmx.at> wrote in message news:cok2cj$v1m$1@www.eclipse.org...
> hello!
>
> I have a problem: I select items from a database to a table and it works
> fine.
> I do it on this way:
>
> ResultSet resSet = stmt.executeQuery(text);
> ResultSetMetaData result = resSet.getMetaData();
> int col = result.getColumnCount();
> TableColumn[] tableColumn = new TableColumn[col]; for(int i=1;
> i<=col;i++){
> tableColumn[i-1] = new TableColumn(table, SWT.LEFT, i-1);
> tableColumn[i-1].setText(result.getColumnName(i));
>
> And I get the results in the table and so on. But I want to set the Column
> type to DATE or CHAR or INTEGER depending on the
> result.getColumnType(i)!?!?! so I can, if there is a DATE-Column in the
> databse show it right!?
> Example:
> In the DB there is a Column "Birthday" DATE and it should show only the
> Date without time, but it shows follow: 1983-05-01 00:00:00.000000
> or other example:
>
> "user_jahr" is a DECIMAL and it should show 25 but I get
> 25.0000000000000000
>
> Is it possible to do something there or not?!
> Thank you for your help!!
>
> Nice greetings from austria!
>
> Have a nice day
>
>
Previous Topic:Disposing of resources
Next Topic:initial size of a tableviewer
Goto Forum:
  


Current Time: Tue Oct 27 22:39:11 GMT 2020

Powered by FUDForum. Page generated in 0.02143 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top