Eclipse Community Forums: Standard Widget Toolkit (SWT)

Help

Home

Home » Eclipse Projects » Standard Widget Toolkit (SWT) » How to set a TableColumn-type?!?

Show: Today's Messages :: Show Polls :: Message Navigator

How to set a TableColumn-type?!? [message #446708]

Wed, 01 December 2004 09:20

Eclipse User

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

Report message to a moderator

Re: How to set a TableColumn-type?!? [message #446744 is a reply to message #446708]

Thu, 02 December 2004 09:31

Henrik Skovgaard

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
>
>

Report message to a moderator

Previous Topic:	Disposing of resources
Next Topic:	initial size of a tableviewer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 01:56:33 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter